Responsibilities
- Implement, optimize and automate database technologies (e.g. Oracle Database, Oracle Real
- Application Cluster (Oracle RAC), Postgres, SQL sever, Teradata & etc.) on-prem and in the Public Cloud
- Implement, optimize Oracle Golden Gate (OGG) technologies for real time change data capture (CDC)
- on-prem and in the Public Cloud
- Implement and maintain robust solutions for enterprise database technologies to meet business
- demands including performance tuning, upgrades, clustering, redundancy and disaster recovery
- Provide subject matter expertise and represents the highest level of technical escalation for Database
- technologies on prem and in the Public Cloud.
- Consult with and serve as liaison for end users and application developers in the support of mission
- critical applications.
- Ensure appropriate standards and procedures are adhered to, and develop and implement standards
- for installation, maintenance and enhancement of database platforms to support quality deliverables
- Clearly articulate design trade-offs of availability, performance,
interoperability and costs to both
- technical and executive audiences in regard to database technologies
- Provide guidance and cross training to other members on the team.
Qualifications
Experience:
- Hands-on experience setting up and optimizing Oracle RAC, OGG, Postgres, SQL server.
- Hands-on experience fine-tuning SQL query and optimizing indexes and plan management to speed up SQL query performance.
- Experience in executing projects, including planning and implementing a short and long term work plans and successfully completing projects on schedule.
- Experience in implementing enterprise database and Cloud technologies
- Minimum 3 years’ experience of any of the following Linux / Unix platforms: RHEL / Solaris / AIX
- Experience with application and database performance tuning, capacity planning and reporting.
- Practical experience troubleshooting database problems.
- Experience in man