Job Opportunity
We are seeking an experienced database professional to lead the optimisation and design of our Oracle databases in Western Australia.
About the role:
You'll analyse existing database procedures, develop new database objects, and ensure efficient query performance across large datasets.
* Oversight of PL/SQL and SQL scripts for performance and stability.
* Analyse and redesign existing database procedures.
* Development of new database objects aligned with business requirements.
* Application of plan stability techniques, profiles, and hints to tune queries.
* Troubleshooting of database issues and ensuring reliable performance.
Key Responsibilities:
Requirements
* Proven expertise in PL/SQL and SQL optimisation.
* Strong understanding of query tuning and plan stability.
* Experience designing and developing Oracle database objects.
* Ability to troubleshoot and resolve complex database issues.
Benefits:
This is a long-term contract opportunity based in Perth, WA.