Senior SQL Server Database Administrator

The Senior SQL Server Database Administrator leads administration of the client's Microsoft SQL Server environment, including stand‑alone instances and clustered deployments, along with MariaDB, MySQL, PostgreSQL, and Microsoft Access databases. This role establishes technical standards, leads high availability and disaster recovery strategy, and serves as the escalation point for the Mid-Level SQL DBA.

• Lead troubleshooting, setup, configuration, and error resolution for on-premises and cloud SQL Server instances and clusters.
• Manage Service Now requests through closure and handle escalated database incidents.
• Lead capacity planning and health monitoring using Idera and Solar Winds; define alert thresholds, dashboards, and service-level objectives.
• Coordinate response to major database outages and lead root‑cause analysis and prevention.
• Plan and execute requests for change, SQL Server upgrades, cumulative updates, and security patches.
• Establish patch schedules and risk controls and coordinate planned after‑hours maintenance with the client.
• Meet operational service-level agreements for Service Now tickets.
• Design, build, and configure SQL Server, MariaDB, MySQL, and PostgreSQL databases.
• Troubleshoot database and application integrations, including supported SharePoint Server content and configuration databases and Microsoft Access front ends.
• Tune query plans, indexing, statistics, tempdb, storage, and memory.
• Design and maintain Always On availability groups, failover cluster instances, log shipping, and replication.
• Own backup and restore strategy, point‑in‑time recovery, and disaster recovery exercises.
• Manage database security, including logins, roles, Transparent Data Encryption, auditing, and compliance reviews.
• Develop and govern T‑SQL and Power Shell automation standards and runbooks.
• Mentor the Mid‑Level SQL DBA and deliver weekly activity reports.

At least eight years of hands‑on database administration experience, including at least five years with Microsoft SQL Server in production.

Expert T‑SQL and SQL scripting skills and working knowledge of PL/SQL.

Proven experience designing and supporting SQL Server clustering, Always On availability groups, Windows Server Failover Clustering, and failover cluster instances.

Hands‑on PostgreSQL, MySQL, MariaDB, and Microsoft Access administration or support.

Experience creating and managing stand‑alone SQL databases, server maintenance, installations, and patching.

Experience with Idera and/or Solar Winds Database Performance Analyzer and Service Now ticketing.

Ability to work independently, collaborate across teams, and brief staff and management at all levels.

Microsoft Certified:
Azure Database Administrator Associate or relevant database administration credentials; previously earned MCSA or MCSE Data Management credentials are also valued.

Cloud database experience with Azure SQL, Amazon RDS, or Oracle Cloud Infrastructure.

Experience in regulated enterprise environments and familiarity with NIST SP 800‑53 controls.

Bachelor's degree in computer science, information systems, or a related field.

Vanguard Management Solutions is an equal opportunity employer committed to building a diverse and inclusive team. We provide equal employment opportunities to all employees and applicants without regard to race, color, religion, sex, national origin, age, disability, genetics, or any other protected characteristic. We are proud to be a Minority‑Owned Small Business.

For accommodation requests, please contact