SQL Server Data Engineer
3B Staffing LLC, Albuquerque, NM, United States
Key Responsibilities:
Legacy Platform Ownership:
- Maintain, refactor, and optimize T-SQL codebase (queries, stored procedures, functions) across OBMS modules.
- Perform query tuning, indexing, and performance diagnostics for large/complex databases.
Reporting:
- Design, develop, and deploy SSRS reports; ensure data accuracy, integrity, and security.
- Troubleshoot reporting issues; document processes and provide user support for reporting tools.
Stakeholder Engagement:
- Partner with internal client managers, operations, and finance to capture requirements and convert to technical solutions.
- Work tickets triaged by lead; manage priorities and communicate status/risks clearly.
Design & Implementation:
- Contribute to database design patterns for new/enhanced modules; support ETL/data integration where applicable.
Governance & Quality:
- Document changes, follow change management, and uphold best practices for legacy environments.
If you would like to learn more, please reach out to Elite technical.
Required Skills
Required Skills:
- 7-10+ years hands-on SQL Server in production environments with heavy stored procedure usage.
- Demonstrated success in query tuning and performance optimization for large databases.
- Solid SSRS development lifecycle experience.
- T-SQL proficiency (queries, stored procedures, functions)
- Query tuning and performance optimization (indexes, execution plans)
- Demonstrated success in legacy, stored-procedure-centric systems
- Pragmatic approach to enhancement vs. rebuild; comfort without modern ORMs
- Ability to learn nuanced legacy domain quickly
- Has an independence and consulting mindset
Legacy Platform Ownership:
- Maintain, refactor, and optimize T-SQL codebase (queries, stored procedures, functions) across OBMS modules.
- Perform query tuning, indexing, and performance diagnostics for large/complex databases.
Reporting:
- Design, develop, and deploy SSRS reports; ensure data accuracy, integrity, and security.
- Troubleshoot reporting issues; document processes and provide user support for reporting tools.
Stakeholder Engagement:
- Partner with internal client managers, operations, and finance to capture requirements and convert to technical solutions.
- Work tickets triaged by lead; manage priorities and communicate status/risks clearly.
Design & Implementation:
- Contribute to database design patterns for new/enhanced modules; support ETL/data integration where applicable.
Governance & Quality:
- Document changes, follow change management, and uphold best practices for legacy environments.
If you would like to learn more, please reach out to Elite technical.
Required Skills
Required Skills:
- 7-10+ years hands-on SQL Server in production environments with heavy stored procedure usage.
- Demonstrated success in query tuning and performance optimization for large databases.
- Solid SSRS development lifecycle experience.
- T-SQL proficiency (queries, stored procedures, functions)
- Query tuning and performance optimization (indexes, execution plans)
- Demonstrated success in legacy, stored-procedure-centric systems
- Pragmatic approach to enhancement vs. rebuild; comfort without modern ORMs
- Ability to learn nuanced legacy domain quickly
- Has an independence and consulting mindset