Job Title: SQL Server Replication DBA
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)