PL/SQL Developer

Nityo Infotech Limited; Sydney; Presencial; AUD 120.000 - 180.000; Jornada completa

Descripción de la vacante

Nityo Infotech Limited seeks a senior SQL/PL/SQL developer in Sydney to manage large-volume databases and deliver high-performance data solutions. You will design and optimize PL/SQL packages, procedures, and external tables, translating business needs into robust technical implementations.

The role requires hands-on experience with Oracle 12c/19c and batch processing, along with strong data extraction and reporting capabilities to ensure quick turnaround and data quality.

Formación

• Minimum 6+ 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.

Responsabilidades

• Write Packages, Procedures, External Tables, Functions, and Triggers with a focus on performance.
• Handle large-volume databases and develop data extraction programs with quality and quick turnaround.
• Develop batch processing programs, DB jobs, and reports from flat files and Excel files using PL/SQL.
• Optimize queries and tune performance for high-speed execution.

Conocimientos

Advanced SQL concepts

PL/SQL programming

Performance optimization

Understanding business requirements

Herramientas

Oracle 12c/19c

Descripción del empleo

• Minimum 6+ 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.