SQL Server Database Administrator

RE/SPEC Inc.•Albuquerque, NM

11h•Hybrid

About The Position

RESPEC seeks an experienced SQL Server DBA that will maintain, enhance, and further develop a long-lifespan, stored-procedure–centric 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.

Requirements

Experience: 7-10+ years with hands-on SQL Server experience in production environments with a heavy emphasis on stored procedure usage.
Technical Mastery: Proven expertise in query tuning and performance optimization for large, complex databases (e.g. execution plan analysis, indexing strategies).
Reporting Expertise: Experience in the full SSRS development lifecycle, from design of the queries used, to the report, to deployment.
Communication: Strong consulting orientation with the ability to effectively communicate to both technical team members and non-technical clients/stakeholders.
Seniority and Attitude: A seasoned professional capable of navigating a large codebase and dealing with a steep learning curve.
Logistics: Willingness and ability to work in the office in Albuquerque, NM or Richardson, TX at least three days a week.

Nice To Haves

Ecosystem Knowledge: Familiarity with or exposure to .NET or .NET Framework and frontend technologies (HTMl, CSS, JavaScript) or frameworks (Angular).
Domain Expertise: Experience working within budgeting systems, financial platforms, or fund-based accounting.
Multidimensional Database Knowledge: Familiarity with or exposure to OLAP/multidimensional models.

Responsibilities

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.