PL/SQL Developer

ALOIS UK; Perth; On-site; AUD 120,000 - 160,000; Full time

Job summary

ALOIS UK in Australia seeks an expert SQL/PLSQL Developer to optimize Oracle databases and build scalable data extraction solutions. You will implement batch processes, DB jobs, and high-performance queries while translating business needs into robust technical designs.

The role requires hands-on work with packages, procedures, external tables, functions and triggers, delivering timely, quality results for complex data workflows.

Qualifications

• Strong SQL/PLSQL skills with Oracle 12c/19c expertise.
• Ability to translate business requirements into technical solutions.
• Experience with batch processing, DB jobs and data extraction.
• Hands-on with packages, procedures, external tables, functions and triggers.

Responsibilities

• Develop data extraction programs for large-volume databases.
• Write and optimize batch processing and scheduled jobs.
• Design high-performance PL/SQL queries and routines.

Skills

SQL

PL/SQL

Oracle 12c/19c

Performance tuning

Data extraction

Batch processing

External Tables

Triggers

Large-volume databases

Job description

• Minimum 7-9 Years experience in SQL and PL/SQL programming with Advanced SQL concepts
• Good knowledge in Oracle 12c / 19c, very good and fast PL/SQL programmer.
• Must be able to quickly understand and convert business requirements into technical solution.
• Good hands-on experience in Writing Packages, Procedure, External Tables, Functions, Trigger, etc., and performance optimization of database
• Experience in handling large volume database and develop data extraction programs with Quality and minimal turn-around time.
• Experience in writing Batch processing programs, DB jobs, flat file & excel file Report generations using PL/SQL. Good knowledge in performance tuning and writing high-performance queries/programs.