Maintain, develop, refactor, and optimize a T-SQL codebase (queries, views, stored procedures, functions) across all OBMS modules.
Perform query tuning, indexing, and performance diagnostics as needed and as appropriate for a large and complex database.
Design, develop, maintain and deploy SSRS reports, ensuring high standards for data accuracy and presentation to non-technical clients.
Partner with the client and other RESPEC consultants on the OBMS team to elicit business requirements and transform them into database design.
Work tickets triaged by a help desk; manage priorities and communicate status/risks clearly.
Contribute to database design patterns for new/enhanced modules, looking for opportunities to evolve or leverage the system's existing architecture where appropriate.
Document changes, follow proper change management processes, and uphold best practices for multi-environment migrations.

7-10+ years with hands-on SQL Server experience in production environments with a heavy emphasis on stored procedure usage.
Proven expertise in query tuning and performance optimization for large, complex databases (e.g. execution plan analysis, indexing strategies).
Experience in the full SSRS development lifecycle, from design of the queries used, to the report, to deployment.
Strong consulting orientation with the ability to effectively communicate to both technical team members and non-technical clients/stakeholders.
A seasoned professional capable of navigating a large codebase and dealing with a steep learning curve.

SQL Server Database Administrator

Key skills