- Design, develop, implement and maintain our core Oracle applications.
- Maintain our SQL / PLSQL processes.
- Ensure DB availability.
- Proactively manage and maintain security standards and controls.
- Actively seek to optimize and simplify our architecture.
- Take ownership of performance and capacity monitoring aspects of the DB.
- Execution of data migration jobs and scripts as required.
- Assist the infrastructure team in sizing hardware used for the DB.
- Support and collaborate with product developers.
- Contribute to the creation and maintenance of disaster recovery plans.
- Create a reliable backup strategy. Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality.
- Determine and document DB policies, procedures and standards
- Performance testing and evaluation to ensure data security, privacy and integrity. Identification of bottle necks and deadlock issues.
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
Job Description Required skills
- Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.
- Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
- Operating system experience in Linux.
- Oracle management tools (Data Guard, RMAN, Data pump).
- Partitioning.
- Architecture design principles.
- Good problem solver, focused and dedicated developer with ability to work on your own as well as with a team.
- Hands on experience with DB standards and end user applications-translating capacity requirements into infrastructure deployment technology.
- Strong practical experience of ORACLE in a production RAC (ASM) environment.
- Must be a self-starter with a strong attention to detail.
- Experience with an organization with a key reliance on 24x7 reliability on its database.