RESPEC seeks an experienced SQL Server DBA that will maintain, enhance, and further develop a long-lifespan, stored-procedure鈥揷entric application. This role ensures performant and reliable data operations through expert query tuning, stored procedure development, SSRS reporting, and robust database design. You will translate complex client requirements into actionable technical tasks while supporting a normalized, multi-module environment.
- T-SQL Codebase Ownership: Maintain, develop, refactor, and optimize a T-SQL codebase (queries, views, stored procedures, functions) across all OBMS modules.
- Performance Engineering: Perform query tuning, indexing, and performance diagnostics as needed and as appropriate for a large and complex database.
- SSRS Reporting: Design, develop, maintain and deploy SSRS reports, ensuring high standards for data accuracy and presentation to non-technical clients.
- Stakeholder Engagement: Partner with the client and other RESPEC consultants on the OBMS team to elicit business requirements and transform them into database design.
- Help Desk Tickets: Work tickets triaged by a help desk; manage priorities and communicate status/risks clearly.
- Design and Implementation: Contribute to database design patterns for new/enhanced modules, looking for opportunities to evolve or leverage the system's existing architecture where appropriate.
- Governance and Quality: Document changes, follow proper change management processes, and uphold best practices for multi-environment migrations.