Senior Database Engineer (Oracle/AWS/GoldenGate)

Role Summary

Hands-on Senior Database Engineer to design, deploy, and support mission-critical databases across on-prem and AWS. The ideal candidate is an Oracle DBA with deep GoldenGate expertise, strong AWS RDS/Aurora experience, and solid PL/SQL skills who can own performance, reliability, and migrations in a quick-paced workplace.

Key Responsibilities
Operate & Optimize: Install, configure, patch, upgrade, and support production Oracle databases; perform performance tuning at DB/OS/query layers.
Replication (Priority): Design, install, configure, upgrade, monitor, and troubleshoot Oracle GoldenGate for high availability, migration, and real-time data movement.
AWS Data Platforms: Deploy and administer AWS RDS (Oracle/MySQL/Postgres), Aurora MySQL/Aurora PostgreSQL, EC2-hosted databases; manage S3, DMS, AWS Backup; implement IAM, networking, and security best practices.
Migrations: Lead on-prem AWS migrations using GoldenGate/DMS; execute zero/minimal-downtime cutovers.
Backup/Recovery: Implement and test RMAN and Data Pump strategies; ensure RPO/RTO compliance.
Scripting & Automation: Build operational automation and diagnostics using SQL, PL/SQL, and shell scripting (UNIX/Linux).
Reliability & RCA:



Own incident response, root-cause analysis, and preventive actions; publish runbooks and SOPs.
Agile Delivery: Work within Scrum teams (Jira/Confluence), partner cross-functionally across multiple workstreams.

Required Qualifications
810+ years total experience in database engineering/administration, with 8+ years Oracle DBA in production.
5+ years Oracle GoldenGate (install, configure, upgrade, monitor, troubleshoot) – must-have.
3+ years AWS hands-on with RDS, Aurora, EC2, S3, DMS, AWS Backup, DynamoDB (nice to have).
Proven performance tuning (AWR/ASH, execution plans, indexing, OS metrics) on UNIX/Linux.
Robust PL/SQL, SQL, and shell scripting.
Demonstrated success migrating databases from on-prem to AWS using GoldenGate/DMS.
Experience with Agile/Scrum ceremonies and tools (Jira, Confluence).
Excellent verbal/written communication; able to juggle multiple projects and deadlines independently.
PostgreSQL/MySQL tuning and operations.

Nice to Have
AMI design and hardened images for database workloads.
Experience with infrastructure-as-code or automation (Terraform/CloudFormation/Ansible).

📌 Senior Oracle /postgresql/goldengate Must Good Salary Nightshift Tamil Nadu (India)
🏢 Sragvin Data Technologies
📍 India