RESPEC

SQL Server Database Administrator

RESPEC

full-time

Posted on:

Location Type: Remote

Location: Albuquerque • New Mexico • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

SeniorLead

Tech Stack

SQL

About the role

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

Requirements

  • 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.
Benefits
  • Flexible Work Schedules
  • Paid Parental Leave
  • 401(k) & ESOP (with company match up to 4%)
  • Professional Development and Training
  • Tuition Reimbursement
  • Employee Assistance Program
  • Medical/Dental/Vision Insurance Plans
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
T-SQLSQL Serverstored proceduresquery tuningperformance optimizationSSRSindexingdatabase designexecution plan analysisreport deployment
Soft Skills
consulting orientationcommunicationprioritizationstatus reportingrisk managementcollaborationbusiness requirements elicitationdocumentationchange managementproblem-solving