Infios

Principal Database Administrator – Microsoft SQL Server

Infios

full-time

Posted on:

Location Type: Remote

Location: Colorado • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Lead

Tech Stack

CloudMS SQL ServerSQLVMware

About the role

  • Own the architecture, strategy, and long-term roadmap for SQL Server ecosystems (on-premises, multi-cloud).
  • Design and implement high-availability and disaster recovery solutions using Always On Availability Groups, Failover Clustering, and native HA/DR features.
  • Lead performance tuning at scale: query optimization, indexing strategies, statistics management, wait stats analysis, memory/CPU/I/O pressure resolution, and use of tools like Query Store, Extended Events, and DMVs.
  • Architect and automate backup/recovery strategies (full, differential, transaction log, point-in-time recovery, long-term retention) with encryption, compression, and validation testing.
  • Drive large-scale migrations, upgrades (e.g., SQL 2016/2019 → 2022/2025), consolidation projects, and cloud transitions while minimizing downtime.
  • Establish and enforce database security best practices: least-privilege access, auditing. (GDPR, HIPAA, SOC 2, etc.).
  • Proactively monitor and maintain hundreds of SQL Server instances using tools such as SQL Server Management Studio (SSMS), PowerShell, dbatools, and custom monitoring frameworks.
  • Automate repetitive DBA tasks via PowerShell, T-SQL, dbatools.
  • Serve as escalation point for critical production incidents; perform root-cause analysis and implement preventive measures.
  • Provide technical leadership: mentor senior and mid-level DBAs, conduct design reviews, author standards/guidelines, and present to executive stakeholders.
  • Evaluate emerging SQL Server features and third-party tools; recommend adoption strategies.
  • Collaborate on capacity planning, cost optimization, and disaster recovery drills.

Requirements

  • 10–15+ years of hands-on Microsoft SQL Server administration experience in large-scale, 24×7 production environments.
  • Deep expertise in SQL Server 2016 through current versions (2022/2025), including Always On, Query Store, intelligent performance features, and security enhancements.
  • Expert-level T-SQL development, query tuning, and indexing knowledge.
  • Strong scripting/automation skills in PowerShell (dbatools module highly desired) and familiarity with DevOps practices (Git, CI/CD for database changes).
  • Experience leading migrations, upgrades, and HA/DR implementations with near-zero downtime requirements.
  • Solid understanding of Windows Server, storage subsystems (SAN, NVMe), virtualization (VMware/Hyper-V), and networking impacts on SQL performance.
  • Excellent troubleshooting skills under pressure; ability to analyze complex issues using DMVs, XEvents, PerfMon, and trace flags.
  • Exceptional problem-solver with calm demeanor during outages.
  • Strong communicator — can explain technical concepts to non-technical stakeholders.
  • Proactive, self-directed, and passionate about database reliability and performance.
  • Team player who enjoys mentoring and knowledge sharing.
Benefits
  • Health insurance
  • 401(k) matching
  • Flexible work hours
  • Paid time off
  • Professional development opportunities
Applicant Tracking System Keywords

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

Hard Skills & Tools
SQL ServerT-SQLquery optimizationindexing strategieshigh-availability solutionsdisaster recovery solutionsperformance tuningbackup/recovery strategiesscriptingautomation
Soft Skills
technical leadershipmentoringproblem-solvingcommunicationtroubleshootingcollaborationself-directedproactivecalm under pressureteam player