Senior Microsoft Windows SQL Server DBA

1 month 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

Oracle Middleware Adminstrator - DOE Enterprise IT Support

Significance 51-250 Professional Services

Significance Inc. is seeking a remote Oracle Middleware Administrator to support the Department of Energy’s enterprise IT operations by administering, securing, and maintaining its Oracle Fusion Middleware environment.

Agile Encryption
1 day, 18 hours ago

[Job - 31308] AWS Database, Brasil

CI&T 5K-10K Internet Software & Services

A CI&T busca uma referência em dados para apoiar a modernização de um core bancário, garantindo integridade, equivalência e reconciliação entre sistemas legados e uma nova plataforma.

AWS MongoDB MySQL PostgreSQL
3 days, 17 hours ago

Staff Database Engineer

Multi Media 51-250 Internet Software & Services

Multi Media, LLC is seeking a Staff Database Engineer to own the reliability, availability, performance, and recoverability of Chaturbate’s large-scale PostgreSQL infrastructure supporting millions of real-time users.

Django Linux PostgreSQL Python
3 days, 18 hours ago

Database Administrator - SAP HANA / SAP Basis

TWO95 International 51-250 Internet Software & Services

Remote Database Administrator on a 1+ year contract supporting enterprise SAP HANA, SAP S/4HANA, SAP Basis, and cloud-connected SAP environments to maintain availability, security, integrations, and operational reliability.

DNS
3 days, 18 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