Senior SQL Server Database Administrator

Contractual
Atlanta, GA
Job ID: OOJ - 22213
Back to search results
Back to search results

On-Site role

Job Description:

  • Client Gas is seeking an experienced Senior SQL Server DBA for a short-term contract engagement primarily focused on upgrading and migrating SQL Server 2017 environments to SQL Server 2022 and newer supported platforms.
  • The ideal candidate will have 10+ years of enterprise SQL Server DBA experience with strong hands-on expertise in database upgrades, migrations, high availability, disaster recovery, replication, clustering, and the SQL Server BI stack.

Key Responsibilities:

  • Plan and execute SQL Server 2017 to SQL Server 2022 upgrades and migrations.
  • Perform upgrade readiness assessments and identify database, infrastructure, and application dependencies.
  • Develop migration plans, implementation procedures, validation steps, and rollback strategies.
  • Install, configure, upgrade, patch, and troubleshoot SQL Server environments.
  • Configure and support Always On Availability Groups, Windows Server Failover Clustering, replication, backup/recovery, and disaster recovery.
  • Install, configure, migrate, and troubleshoot SSIS, SSRS, and SSAS.
  • Validate SQL Agent jobs, linked servers, connectivity, security, and other database dependencies following migrations.
  • Troubleshoot SQL Server performance, availability, and migration-related issues.
  • Perform pre- and post-migration validation and performance checks.
  • Partner with application, infrastructure, project management, and other technology teams during migration planning and production cutovers.
  • Maintain migration documentation and provide knowledge transfer to the internal DBA team.

Required Qualifications:

  • 10+ years of hands-on Microsoft SQL Server DBA experience in enterprise production environments.
  • Extensive experience with SQL Server upgrades and database migrations, preferably SQL Server 2017 to SQL Server 2022.
  • Advanced knowledge of Always On Availability Groups, Windows Server Failover Clustering, replication, HA/DR, backup and recovery.
  • Proficiency in T-SQL, PowerShell scripting, and SQL Server monitoring and Data Management tools (e.g., SSMS, Profiler, Idera, Redgate).
  • Strong hands-on experience supporting SSIS, SSRS, SSAS, and Microsoft Power BI.
  • Strong SQL Server performance tuning and troubleshooting experience.
  • Ability to troubleshoot complex production issues and work effectively during scheduled migration and cutover activities.
  • Strong communication, documentation, and cross-functional collaboration skills.

Education:

  • BS degree in Computer Science, Information Technology, Engineering, or equivalent.

Preferred Qualifications:

  • Experience with large-scale SQL Server modernization initiatives.
  • Proficiency in diagnosing and resolving complex database configuration-related issues.
  • Ability to work independently and collaboratively.
  • Knowledge of Physical Database design, including but not restricted to table partitioning, indexing strategies, and database performance optimization techniques.
  • Experience migrating clustered and Always On environments.
  • Experience with SQL Server monitoring tools such as Redgate or Idera.
  • Energy utility (Natural Gas and Electricity) industry experience is a plus.
  • Familiarity with Azure SQL or SQL Server on Azure Virtual Machines.
  • Experience developing and executing migration runbooks, validation procedures, and rollback plans.

Engagement Focus:

  • This is a hands-on, execution-focused role. 
  • The successful candidate must be able to quickly assess existing environments and independently plan, execute, troubleshoot, and validate SQL Server upgrades and migrations with minimal business disruption.

About us:
At our organization, we take our mission and values to heart! We are on a mission to offer more and better jobs all over the world! Our goal is to care for you while you care for our clients and get you paid the highest pay possible. All our associates working with us are expected to embrace our RACE values: R - Results Matter, A- Approachable, C - Care, and E - Emergency i.e. work with a sense of urgency.

For more relevant job opportunities please visit our website: Denken Solutions Careers

Related Jobs

OOJ - 22184 Contractual

Administrative Assistant II

San Jose, CA, California, USA
View Job
OOJ - 22176 Contractual

Power System Coordinator

Gulfport, MS, Mississippi, USA
View Job
OOJ - 22164 Contractual

SharePoint & Digital Capability Specialist

ST LOUIS, Missouri, USA
View Job
OOJ - 21960 Contractual

Database Engineer

Foster City, CA, California, USA
View Job
OOJ - 22199 Contractual

Senior GitHub Enterprise Platform Engineer - DevOps

Atlanta, GA, Georgia, USA
View Job
OOJ - 22200 Contractual

GIS Analyst

Atlanta, GA, Georgia, USA
View Job
OOJ - 22175 Contractual

Test Engineer – Protection & Control (P&C)

Atlanta, GA, Georgia, USA
View Job
OOJ - 22041 Contractual

Logistics Operations Associate

Atlanta, GA, Georgia, USA
View Job
Scroll to Top