Job Overview Responsible for the 8/5 support of Oracle/PostgreSQL production database services to ensure the highest standards of availability, resilience, integrity, security and performance required by the business systems.
Duties and Responsibilities
- Responsible for ensuring availability and performance of the databases that support the system
- Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance
- To proactively monitor the database systems to ensure secure services with minimum downtime
- Responsible for providing trend analysis to the service management team to enable them to make informed decisions regarding resource management
- Responsible for problem escalation to Oracle Support team and third parties as appropriate
- Responsible for improvement and maintenance of the databases to include backups, rollout and upgrades
- Responsible for implementation and release of database changes as submitted by the development team
Skills / Attributes Required
- Strong PostgreSQL Database Administration experience (5+ years)
- Strong Oracle Database Administration experience (7+ years)
- Strong Linux Administration experience
- Experience of managing multiple RDBMS on large systems
- Experience of working in a team that delivers a high availability service
- Practical experience in monitoring and tuning a database to provide a high availability service
- Experience in Oracle Data Guard, Oracle RAC
- Oracle Certification, preferably OCP is a plus
- Experience of MSSQL Server is desirable