Database Administrator

Axiom Technologies Group; City of Melbourne; On-site; AUD 120,000 - 180,000; Full time

Job summary

Axiom Technologies Group is seeking a professional Oracle DBA to administer a large, complex production DB environment across global Oracle databases including production, testing and staging. The role requires guidance on system-level solutions and strong production RAC (ASM) experience.

The ideal candidate will design, implement and maintain core Oracle applications, manage capacity and performance, and collaborate with development and infrastructure teams while ensuring robust backup,

Qualifications

• OC???P certified Oracle DBA with 3+ years of Oracle DB experience including design, capacity planning, performance tuning, storage management, backup/recovery, schemas, reports and clustering.

Responsibilities

• Design, develop, implement and maintain core Oracle applications.
• Maintain SQL/PLSQL processes.
• Ensure DB availability.
• Proactively manage security standards and controls.
• Optimize and simplify architecture.
• Own performance and capacity monitoring.
• Execute data migration jobs and scripts.
• Assist infrastructure in sizing hardware.
• Support and collaborate with product developers.
• Contribute to disaster recovery plans creation/maintenance.
• Create and exercise reliable backups and restore testing.
• Document DB policies, procedures, and standards.
• Performance testing to ensure data security, privacy and integrity.

Skills

Self-starter

Attention to detail

Problem solving

Education

Oracle Certified DB Professional (OCP)

Tools

Oracle

Data Guard

RMAN

Data Pump

Partitioning

Oracle RAC / ASM

Linux

Job description

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 centralized 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, are 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 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 the 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 SLAs & operational KPIs are met, working as necessary with internal

and external support functions when major incidents occur.

Required skills

• Ideally Oracle Certified DB Professional (OCP) with more than 3 years of experience with Oracle. Experience should include DB design (modeling and normalization), 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 the 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 with ORACLE in a production RAC (ASM) environment (11gR2).

Must be a self-starter with strong attention to detail.