SQL Server Replication DBA

Govserviceshub; Woodbridge (CT); On-site; USD 110,000 - 150,000; Full time

Job summary

Govserviceshub in Woodbridge, CT is seeking a seasoned SQL Server Replication DBA with strong experience in replication, performance tuning, and cross-platform administration including Oracle and AWS.

The role involves troubleshooting, server optimization, patch management, and managing data replication across distributed environments. Proficiency in Python scripting and Grafana for monitoring is required.

Qualifications

• 5+ years experience as a SQL Server DBA (SQL Server 2016+).
• Strong knowledge of SQL Server Replication & troubleshooting.
• Proficiency in index management, query optimization, and server performance tuning.
• Experience creating/managing SQL Server schema objects including tables and indexes.
• Patching and upgrades in SQL Server and Oracle environments.
• Python scripting for automation and admin tasks.
• Experience with Grafana dashboards for monitoring databases.
• AWS experience with RDS, DMS, CloudWatch, S3, etc.
• Exposure to Oracle DB administration and SQL/PLSQL.

Responsibilities

• Administer, monitor, and optimize SQL Server performance (CPU, memory, I/O, queries).
• Configure and troubleshoot SQL Server Replication (transactional, snapshot, merge, peer-to-peer).
• Identify and resolve replication latency, conflicts, and sync errors.
• Perform index analysis and tuning for performance optimization.
• Design, implement, and manage database schema objects (tables, indexes, constraints, stored procedures).
• Perform regular patching/upgrades of SQL Server and Oracle environments.
• Analyze and troubleshoot query performance using execution plans, SQL Profiler, and DMVs.
• Implement and manage cross-platform data replication between SQL Server and Oracle.
• Develop Python scripts to automate maintenance, reporting, or monitoring tasks.
• Configure Grafana dashboards to monitor key database metrics and replication health.
• Manage AWS-hosted databases using RDS, DMS, EC2, CloudWatch.
• Support Oracle DB environments including performance tuning, backup/recovery, patching.
• Participate in disaster recovery planning and testing.
• Collaborate with development/DevOps/infrastructure on database requirements.

Skills

SQL Server

Replication

Performance tuning

Cross-platform administration

Python scripting

Grafana

AWS

Oracle

T-SQL

PL/SQL

Tools

Grafana

AWS (RDS/DMS/EC2)

Oracle

SQL Server tools

Job description

Woodbridge, United States | Posted on 10/07/2025

Job Description:

SQL ServerReplication DBA (with Oracle, AWS, Python & Grafana)

Looking for a seasoned SQL Server ReplicationDBA with experience in database performance tuning, replication, andcross-platform administration including Oracle and AWS. The ideal candidate will also havescripting experience in Python, and familiarity with Grafana for monitoring and alerting.

This role will involve troubleshooting, serveroptimization, patch management, and managing data replication across complex,distributed environments.

Requirements

Key Responsibilities:

• Administer,monitor, and optimize SQL Server performance, including CPU, memory, I/O, andquery execution.
• Configure andtroubleshoot SQL Server Replication (transactional, snapshot, merge,peer-to-peer).
• Identify andresolve issues with replication latency, conflicts, and synchronization errors.
• Perform indexanalysis and tuning for performance optimization.
• Design,implement, and manage database schema objects including new tables, indexes,constraints, and stored procedures.
• Performregular patching and upgrades of SQL Server and Oracle environments.
• Analyze andtroubleshoot query performance using execution plans, SQL Profiler, and DMVs.
• Implement andmanage cross-platform data replication between SQL Server and Oracle databases.
• Develop Pythonscripts to automate database maintenance, reporting, or monitoring tasks.
• Integrate andconfigure Grafana dashboards to monitor key database metrics and replicationhealth.
• ManageAWS-hosted databases using services like RDS, DMS, EC2, and CloudWatch.
• Support OracleDB environments including performance tuning, backup/recovery, and patching.
• Participate indisaster recovery planning and testing.
• Collaboratewith development, DevOps, and infrastructure teams on database requirements andoptimization.

Required Skills & Qualifications:

• 5+ years ofexperience as a SQL Server DBA (SQL Server 2016 or newer).
• Strongknowledge of SQL Server Replication and related troubleshooting techniques.
• Proficiency inindex management, query optimization, and server performance tuning.
• Experiencecreating and managing SQL Server schema objects, including new tables andindexes.
• Hands-onexperience in patching SQL Server and Oracle environments.
• Solid workingknowledge of Python scripting for automation.
• Experiencewith Grafana for creating and managing database monitoring dashboards.
• Exposure toOracle DB administration and SQL/PLSQL.
• AWSexperience: working with RDS, DMS, CloudWatch, S3, etc.
• Strongexperience in T-SQL, PL/SQL, and shell scripting.

Preferred Qualifications:

• AWScertification (e.g., AWS Certified Database - Specialty, Solutions ArchitectAssociate).
• Experiencewith Oracle GoldenGate or third-party replication tools.
• Familiaritywith DevOps tools and practices, CI/CD pipelines.
• Experiencewith infrastructure as code (e.g., Terraform or CloudFormation).
• Knowledge ofmonitoring and alerting tools beyond Grafana (e.g., Prometheus, Nagios)