Jobs via Dice
Job Title: SQL Server Replication DBA
Location: Woodbridge, NJ (4 days/week schedule)
This role requires a seasoned SQL Server Replication DBA with experience in database performance tuning, replication, cross‑platform administration including Oracle and AWS, scripting in Python, and familiarity with Grafana for monitoring and alerting.
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 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).
#J-18808-Ljbffr
Location: Woodbridge, NJ (4 days/week schedule)
This role requires a seasoned SQL Server Replication DBA with experience in database performance tuning, replication, cross‑platform administration including Oracle and AWS, scripting in Python, and familiarity with Grafana for monitoring and alerting.
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 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).
#J-18808-Ljbffr