Job Description
Oracle Database Administrator
The Position
Professional DBA with the technical skills and knowledge that
extends across Application/ Server/ Storage/ Network technologies to administer
Oracle and SQL 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 and SQL Servers for production, testing, and staging environments across the company.
This opportunity will suit an 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 enterprise applications.
Maintain our SQL / PLSQL processes.
Ensure Oracle and SQL Server 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 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.
Perform Environment refresh independently
Hands on experience on Exa data hosted databases
Job Description
Required skills
Ideally Oracle Certified DB Professional (OCP) with more than 10+ years’
experience with Oracle and SQL Server, 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 (11gR2).
Must be a self-starter with a strong attention to detail.
Oracle Apps DBA