Applications are now open for the position of Oracle Exadata and Oracle GoldenGate Database Administrator. Reporting to the Platform Engineering Manager, the purpose of this position will be to perform database backups and recovery procedures; manage database users, roles, and permissions; optimise database performance through tuning and indexing; monitor database health and performance using monitoring tools; facilitate database upgrades and migrations; install, configure, update and patch Oracle Exadata systems; monitor Exadata infrastructure and database performance; perform capacity planning and resource allocation for Exadata environments, and many other functions.
Duties and Responsibilities:
- Performing database backups and recovery procedures
- Managing database users, roles, and permissions
- Optimising database performance through tuning and indexing
- Monitoring database health and performance using monitoring tools
- Participating in database upgrades and migrations
- Installing, configuring, upgrading, and patching Oracle Exadata systems
- Monitoring and troubleshooting Exadata infrastructure and database performance
- Performing capacity planning and resource allocation for Exadata environments
- Managing Exadata storage and network components
- Ensuring the availability and performance of Oracle databases running on Exadata
- Designing, implementing, and managing Oracle GoldenGate replication environments
- Configuring and optimising Oracle GoldenGate capture and apply processes
- Troubleshooting and resolving issues related to Oracle GoldenGate replication
- Ensuring data consistency and integrity across replicated databases
- Managing Oracle GoldenGate security and access controls
- Developing and maintaining scripts for automating tasks
- Documenting procedures and configurations
- Collaborating with other IT teams, including Network and Storage
- Providing 24/7 support for critical systems, including on-call rotations
Minimum Requirements:
- At least 5 years of technical experience with Oracle technologies
- Degree or Diploma, as well as Oracle DBA certification
- Experience working with Oracle GoldenGate (OGG) and Exadata ESSENTIAL
- In-depth knowledge of Oracle Database 19c
- Experience with Oracle RAC, Grid Infrastructure, and ASM
- Proficiency in SQL, PL/SQL, and RMAN
- Experience with database replication technologies (Data Guard, GoldenGate)
- Experience in Oracle Linux administration
- Proficiency in scripting languages (Shell, Python, Perl)
- Experience with automation and configuration management tools (Ansible, Puppet)