Description

Core SQL Server DBA Responsibilities
• Minimum 8-10 years of experience as a SQL Server DBA in production environments
• Proficiency in SQL Server 2016/2019/2022 (T-SQL, SSMS, Agent Jobs, Maintenance Plans)
• Experience with backup and restore strategies, including full, differential, and transaction log backups
• Strong understanding of database recovery models and point-in-time recovery
• Ability to create and maintain database documentation and operational runbooks

Disaster Recovery & High Availability:
• Hands-on experience with Always On Availability Groups and/or SQL Server Failover Clustering
• Knowledge of Log Shipping and Database Mirroring
• Familiarity with backup encryption and offsite retention strategies
• Participated in and supported DR drills and contingency planning

SQL Monitoring & Performance Tuning:
• Skilled in performance troubleshooting using SQL Profiler, Extended Events, and DMVs
• Ability to identify and resolve deadlocks, blocking, and slow-running queries
• Experience tuning indexes, reviewing execution plans, and maintaining stats
• Familiar with SQL monitoring tools (e.g., Redgate, SolarWinds DPA, Sentry One)

Architecture & Design:
• Understanding of normalized and denormalized schema design
• Experience with table partitioning, filegroups, and database file I/O planning
• Participated in storage capacity planning and database lifecycle management
• Supports scalability and performance through smart database design decisions

DevOps for SQL Server:
• Familiar with CI/CD pipelines involving SQL deployments (e.g., Azure DevOps, GitLab, Octopus Deploy)
• Experience with version control for database objects (e.g., Git + SQL Source Control)
• Support for automated database deployments and schema changes
• Familiarity with Infrastructure as Code (IaC) concepts using PowerShell or ARM templates
Legacy SharePoint DBA Support
• Experience maintaining backend SQL databases for legacy SharePoint environments (2010/2013/2016)
• Familiar with SharePoint content databases, service application databases, and search indexing structures
• Able to support site migrations, database integrity checks, and performance tuning for SharePoint SQL backends
• Collaborated with SharePoint Admins on patching and upgrade activities
.NET Application Support on SQL Server
• Supported ASP.NET and .NET Core web applications with SQL Server backends
• Familiar with connection pooling, application-level query performance, and ORM frameworks like Entity Framework
• Ability to trace SQL calls from web apps and optimize database access patterns
• Worked with application developers to improve data access performance and scalability

General Requirements
• Strong documentation skills and adherence to ITSM/ITIL change control practices
• Basic PowerShell scripting experience for SQL and system task automation
• Effective communicator across DB, application, and infrastructure teams
• Willingness to support an on-call rotation and occasional after-hours work
• Works on high-visibility, or mission critical aspects of a given program, and performs all functional duties independently;
• Oversees the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job.

Preferred Qualifications:
• Exposure to cloud-based database solutions (e.g., Azure SQL, AWS RDS)
• Experience with hybrid cloud/on-prem SQL architecture
• Microsoft certifications such as Azure Database Administrator Associate or MCSE: Data Management and Analytics
• Works on high-visibility, or mission critical aspects of a given program, and performs all functional duties independently.
• Oversees the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job.

Education:
A minimum of thirteen (13) to twenty (20) years’ relevant experience and a minimum of 10 years of DBA experience
• A degree from an accredited College/University in the applicable field of services is preferred. four additional years of relevant experience in lieu of a college degree is required. If the individual's degree is not in the applicable field then four additional years of related experience is required

Key Skills

Education

Any Gradute