Senior Microsoft Windows SQL Server DBA

1 month, 1 week ago
Full-time
Senior
DevOps and Infrastructure
PartnerOne

PartnerOne

PartnerOne specializes in enterprise software solutions that manage extensive data environments through hyper automation, virtualized cloud storage, artificial intelligence, and metadata analytics, serving many of the world's largest corporations.

Media
51-250

Description

  • Architect, install, configure, and maintain Microsoft SQL Server instances across complex Windows server environments.
  • Lead application performance engineering by analyzing execution plans, identifying inefficient queries, and partnering with developers on code and schema optimization.
  • Monitor database and application performance using Extended Events, DMVs, Wait Statistics, Query Store, and third-party monitoring tools.
  • Design, implement, test, and validate backup, recovery, high availability, and disaster recovery strategies to meet RTO/RPO targets.
  • Maintain Always On Availability Groups, Log Shipping, and other HA/DR solutions across production and DR environments.
  • Design and govern database security controls, including role-based access, auditing, and encryption.
  • Own capacity planning and storage forecasting to ensure platforms scale with demand.
  • Review and approve database changes, including schema migrations, deployment scripts, and ORM-generated queries before production release.
  • Automate routine DBA tasks such as index maintenance, integrity checks, and job monitoring using PowerShell and SQL Agent.
  • Manage patching and upgrades through formal change management and perform pre- and post-upgrade validation.
  • Mentor junior and mid-level DBAs and contribute to documentation, knowledge bases, and runbooks.
  • Serve as the senior escalation point for Sev 1 incidents and lead post-incident reviews.

Requirements

  • 7+ years of hands-on SQL Server DBA experience in large-scale, mission-critical production environments.
  • Expert-level proficiency with Microsoft SQL Server 2019 and 2025 on Windows Server 2019 and 2022.
  • Advanced T-SQL skills, including query optimization, execution plan analysis, index design, partitioning, and performance troubleshooting.
  • Deep experience with application performance tuning, including ORM anti-patterns, N+1 queries, lock contention, and blocking chains.
  • Proven experience architecting and supporting Always On Availability Groups, WSFC, and disaster recovery failover in enterprise environments.
  • Strong command of Wait Statistics, DMVs, Extended Events, and Query Store for root-cause diagnosis.
  • Solid experience with point-in-time restores, high-availability failover, disaster recovery planning, and recovery testing.
  • Windows Server administration experience and knowledge of Active Directory and Kerberos authentication for SQL Server.
  • Demonstrated ability to lead technical projects and mentor junior team members.
  • Familiarity with ITIL change, incident, and problem management processes.
  • DP-300 (Azure Database Administrator Associate) or legacy MCSE Data Management & Analytics certification preferred.
  • Experience with Azure SQL Database or SQL Server on Azure VMs in hybrid configurations preferred.
  • Exposure to APM tools such as Dynatrace, AppDynamics, or New Relic preferred.
  • Proficiency with monitoring platforms such as Redgate SQL Monitor, SolarWinds DPA, SentryOne, or equivalent preferred.
  • PowerShell scripting experience for DBA automation, including dbatools, preferred.
  • Experience with SSIS in a data warehousing or reporting context preferred.
  • Knowledge of data governance and compliance frameworks such as GDPR, ISO 27001, or SOC 2 preferred.
  • Exposure to DevOps CI/CD database deployment tools such as Flyway, Liquibase, or Redgate Deployment Manager preferred.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Senior Migrations Engineer

Arbor 51-250 IT Services

Arbor Education is hiring a remote Senior Migrations Engineer to develop and support the Migrations Platform that helps onboard new schools reliably and at scale.

AWS Bash CI/CD Datadog MySQL PHP Prometheus Python SQL SQL Server Symfony
2 hours, 51 minutes ago

Data Governance / Data Manager

Blue Water Thinking 51-250 Professional Services

Blue Water Thinking is seeking a Data Governance / Data Manager to support the VA OAA Data Management Center by establishing enterprise data management practices and improving data consistency across its Microsoft-based environment.

Power BI SQL Server
2 hours, 51 minutes ago

Cloud Database Administrator

Jalasoft 1K-5K Internet Software & Services

Jalasoft is hiring a database administrator to support Azure-based database systems and cloud operations for high-traffic SaaS applications.

Azure Bash Cassandra Grafana PowerShell Prometheus Python SQL Server
3 hours, 6 minutes ago

Database Engineer

TechFlow 51-250 IT Services

TechFlow is hiring an experienced Database Engineer / Oracle Database Administrator to support a mission-critical DoD software modernization program in Montgomery, AL, focused on securing, maintaining, and optimizing enterprise Oracle databases for critical applications.

Agile AWS CI/CD DevSecOps Encryption Git
1 day, 2 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers