Job Summary
The Oracle GoldenGate DBA is responsible for managing, maintaining, monitoring, and optimizing Oracle database environments across development, testing, and production systems. The role requires 10+ years of Oracle DBA experience, hands-on expertise with Oracle GoldenGate, cloud platform experience, and proven managerial capabilities. Responsibilities include performing daily database health checks, proactive monitoring, troubleshooting performance issues, executing SQL tuning, maintaining database integrity, and ensuring data recovery and availability. The DBA will collaborate with application owners, system administrators, technical managers, developers, and architects to maintain reliable database operations, support capacity planning, and establish database management standards and procedures. The role also participates in an on-call support rotation and may provide additional support for database migrations and upgrades as required.
Key Responsibilities
• Create, configure, and maintain databases for development, testing, and production environments.
• Perform daily database health checks and proactively monitor database performance, availability, and overall system health.
• Troubleshoot database issues, resolve performance bottlenecks, and perform SQL tuning as needed.
• Manage and support Oracle GoldenGate replication and related database operations.
• Ensure data recovery, database maintenance, data integrity, and storage requirements are met.
• Analyze, test, and implement physical database designs.
• Maintain database documentation, environment records, and current patches.
• Formulate, implement, and monitor database management policies, procedures, and standards.
• Audit existing database environments and conduct capacity planning for future development, testing, and production environments.
• Recommend and implement database best practices, standards, and procedures to improve reliability and operational efficiency.
• Conduct database performance assessments and tuning to maintain optimal system performance.
• Collaborate with application owners to identify operational requirements, address database issues, and prevent potential disruptions.
• Work with system administrators, technical managers, developers, and architects to resolve technical issues and support database operations.
• Provide managerial oversight and coordinate team activities to ensure accountability, operational efficiency, and timely issue resolution.
• Participate in a 6-week on-call support rotation to monitor alerts and respond to database issues. The rotation does not require night or weekend work.
• Support database migrations and upgrades when required, working with the teams responsible for these activities.
• Maintain clear and concise communication, demonstrate accountability, and remain focused and available during working hours.
Required Qualifications
• 10+ years of experience as an Oracle Database Administrator (DBA).
• Hands-on experience with Oracle GoldenGate.
• Experience working with at least one cloud platform.
• Proven managerial experience, including team coordination and operational oversight.
• Strong experience troubleshooting and resolving database performance issues.
• Experience performing routine Oracle DBA activities, daily health checks, proactive monitoring, and database health assessments.
• Experience with SQL tuning and database performance optimization.
• Knowledge of physical database design, database maintenance, data recovery, data integrity, and capacity planning.
• Experience managing database environments across development, testing, and production.
• Ability to maintain database documentation, patches, operational procedures, and technical standards.
• Strong analytical, troubleshooting, and problem-solving skills.
• Clear and concise communication skills and the ability to collaborate with technical and business stakeholders.
• Strong accountability, reliability, time management, and professional work habits.
• Ability to participate in the established on-call support rotation.
Preferred Qualifications
• Experience supporting database migrations and upgrades.
• Ability to support migration and upgrade initiatives alongside dedicated teams when required.
