SQL Server Replication DBA
Job
Title: SQL Server Replication DBA
SQL Server Replication DBA (with Oracle, AWS, Python & Grafana)
Looking for a seasoned SQL Server Replication DBA with experience in database
performance tuning, replication, and cross-platform administration including Oracle and
AWS. The ideal candidate will also have scripting experience in Python, and familiarity with
Grafana for monitoring and alerting.
This role will involve troubleshooting, server optimization, 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, and
query execution.
· Configure and
troubleshoot SQL Server Replication (transactional, snapshot, merge,
peer-to-peer).
· Identify and
resolve issues with replication latency, conflicts, and synchronization errors.
· Perform index
analysis and tuning for performance optimization.
· Design,
implement, and manage database schema objects including new tables, indexes,
constraints, and stored procedures.
· Perform
regular patching and 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 databases.
· Develop Python
scripts to automate database maintenance, reporting, or monitoring tasks.
· Integrate and
configure Grafana dashboards to monitor key database metrics and replication
health.
· Manage
AWS-hosted databases using services like RDS, DMS, EC2, and CloudWatch.
· Support Oracle
DB environments including performance tuning, backup/recovery, and patching.
· Participate in
disaster recovery planning and testing.
· Collaborate
with development, DevOps, and infrastructure teams on database requirements and
optimization.
Required Skills & Qualifications:
· 5+ years of
experience as a SQL Server DBA (SQL Server 2016 or newer).
· Strong
knowledge of SQL Server Replication and related troubleshooting techniques.
· Proficiency in
index management, query optimization, and server performance tuning.
· Experience
creating and managing SQL Server schema objects, including new tables and
indexes.
· Hands-on
experience in patching SQL Server and Oracle environments.
· Solid working
knowledge of Python scripting for automation.
· Experience
with Grafana for creating and managing database monitoring dashboards.
· Exposure to
Oracle DB administration and SQL/PLSQL.
· AWS
experience: working with RDS, DMS, CloudWatch, S3, etc.
· Strong
experience in T-SQL, PL/SQL, and shell scripting.
Preferred Qualifications:
· AWS
certification (e.g., AWS Certified Database – Specialty, Solutions Architect
Associate).
· Experience
with Oracle GoldenGate or third-party replication tools.
· Familiarity
with DevOps tools and practices, CI/CD pipelines.
· Experience
with infrastructure as code (e.g., Terraform or CloudFormation).
· Knowledge of
monitoring and alerting tools beyond Grafana (e.g., Prometheus, Nagios)