Our Client, a global leader in delivering diverse Technologies is seeking a SQL Server DBA to maintain and enhance a legacy, stored-procedure-centric OPMS application environment without heavy use of modern ORMs. This is a Hybrid role with the ability to work onsite 3-days per week in Albuquerque, NM.
Core Mission of the Role :
- Maintain and enhance a legacy, stored-procedure-centric OPMS application environment without heavy use of modern ORMs. ((Object-Relational Mappers) need to be able to writing raw SQL queries)
- Ensure performant, reliable data operations including SQL tuning, stored procedure development, and SSRS reporting.
- Translate stakeholder and client requirements into actionable technical tasks; handle triaged tickets and support multi-module database design / implementation.
- Serve as a steady, senior presence capable of thriving in legacy tech with a measured learning curve.
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 systemsPragmatic approach to enhancement vs. rebuild; comfort without modern ORMsAbility to learn nuanced legacy domain quicklyHas an independence and consulting mindset