SQL Server Replication DBA

Job
Title: SQL Server Replication DBA

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)