Oracle DBA Apps Role

Responsibilities

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

Required skills

Ideally Oracle Certified DB Professional, experience with Oracle, preferably in a lead role. Experience should include

DB design (modelling and normalization), 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, Golden Gate).

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.