• 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.