Senior Microsoft Windows SQL Server DBA

1 hour, 40 minutes 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 environments.
  • Lead application performance engineering by analyzing execution plans, identifying problematic queries, and partnering with developers on code and schema optimizations.
  • Monitor database and application performance using Extended Events, DMVs, Wait Statistics, and third-party tools.
  • Design, implement, test, and validate backup and recovery strategies to meet RTO/RPO targets.
  • Architect and maintain high availability and disaster recovery solutions, including Always On Availability Groups and Log Shipping.
  • Govern database security through role-based access controls, auditing, encryption, and least-privilege practices.
  • Own capacity planning and storage forecasting to ensure the platform scales with demand.
  • Review and approve 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 SQL Server patching and upgrades through formal change management processes and perform pre- and post-upgrade validation.
  • Mentor junior and mid-level DBAs and contribute to knowledge base and runbook documentation.
  • Serve as the senior escalation point for Severity 1 outages and lead incident response and 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 / 2025 on Windows Server 2019 / 2022.
  • Advanced T-SQL skills, including query optimization, execution plan analysis, index design, partitioning, and performance troubleshooting.
  • Deep expertise in application performance tuning and collaboration with developers to resolve ORM anti-patterns, N+1 queries, lock contention, and blocking chains.
  • Proven experience with Always On Availability Groups, Windows Server Failover Clustering (WSFC), and enterprise disaster recovery failover.
  • Strong command of Wait Statistics, DMVs, Extended Events, and Query Store for root-cause performance diagnosis.
  • Solid experience with point-in-time restores, high-availability failover, disaster recovery planning, and recovery testing.
  • Experience with Windows Server administration and Active Directory / 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.
  • Microsoft certification: DP-300 (Azure Database Administrator Associate) or legacy MCSE Data Management & Analytics (preferred).
  • Experience with Azure SQL Database or SQL Server on Azure Virtual Machines in hybrid environments (preferred).
  • Exposure to APM tools such as Dynatrace, AppDynamics, or New Relic (preferred).
  • Proficiency with database monitoring platforms such as Redgate SQL Monitor, SolarWinds DPA, SentryOne, or equivalent (preferred).
  • PowerShell scripting for DBA automation, including dbatools (preferred).
  • Experience with SQL Server Integration Services (SSIS) in data warehousing or reporting environments (preferred).
  • Knowledge of data governance and compliance frameworks, including GDPR, ISO 27001, or SOC 2 (preferred).
  • Exposure to DevOps CI/CD pipelines for database deployments using Flyway, Liquibase, or Redgate Deployment Manager (preferred).

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

IT Operations Analyst

Workana 1K-5K Internet Software & Services

Workana is hiring an IT Operations Analyst for Stride Autism Centers to execute HIPAA remediation and support secure, compliant IT operations across a distributed healthcare environment.

HIPAA
1 hour, 25 minutes ago

SQL Database Developer

ProArch 251-1K Internet Software & Services

A SQL Server Database Developer at an enterprise healthcare company will design, optimize, and secure databases that support clinical, operational, reporting, and integration workflows.

CI/CD Encryption HIPAA Power BI REST API SQL Server
1 hour, 40 minutes ago

Sr. SAP Basis Administrator - DOD /Top secret Clearance

TWO95 International 51-250 Internet Software & Services

Senior SAP Basis Administrator for a remote long-term contract supporting a secure, enterprise-level SAP landscape in a highly regulated environment.

AWS Azure GCP Linux Unix
1 hour, 55 minutes ago

Database Reliability Engineer

Alex Staff Agency 11-50 Professional Services

Senior Database Reliability Engineer for an infrastructure DBA team, responsible for keeping production database services reliable and automating operational work across a multi-database environment.

Ansible ClickHouse DNS Grafana Linux MongoDB OpsGenie PostgreSQL Redis Terraform TLS
1 hour, 55 minutes 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