Freelance - Oracle DBA Application Support

Job Description

• The Position We are seeking a professional DBA with the technical skills and knowledge that extends across Application/ Server/ Storage/ Network technologies to administer a large, complex production DB environment and troubleshoot and provide system level guidance/ solutions.
• The role also performs effective centralised database administration for multiple databases globally. This includes Oracle databases for production, testing, and staging environments across the company.
• This opportunity will suit an Oracle DBA who enjoys providing technical guidance and who can play a key role in supporting and driving forward our database developments. We are a passionate, forward-thinking, innovative company where things are always happening. We’re looking for people who work quickly, are competitive self-starters, smart and do what is needed. 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 optimise 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 bottlenecks 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 Requirements

• Ideally Oracle Certified DB Professional (OCP) with more than 3 years’ experience with Oracle, preferably in a lead role.
• Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, backup 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 (12C).
• Must be a self-starter with a strong attention to detail.
• Experience with an organisation with a key reliance on 24x7 reliability on its database.