Overview
Skills
Job Details
Please note that this is a 6 months contract position.
Position Requirements
Core SQL Server DBA Responsibilities
Minimum 5-7 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
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
Education:
Bachelor s Degree in Computer Science or associated discipline preferred and a minimum of 7 years of DBA experience.
Applicants must provide their phone number. Reference job number A4881.