Senior Oracle PL/SQL Developer

HCL Technologies Limited; Sydney; On-site; AUD 120,000 - 160,000; Full time

Job summary

HCLTech is seeking an experienced Senior Oracle PL/SQL Developer to join our Sydney team. The ideal candidate will have strong expertise in Oracle database development, advanced SQL programming, performance tuning, and large-scale data processing.

This role requires an individual who can translate business requirements into efficient, scalable technical solutions. The role involves designing and maintaining Oracle database objects, tuning performance, and delivering robust data extraction and

Qualifications

• 7-9+ years of SQL and PL/SQL development experience.
• Strong expertise in advanced SQL concepts.
• Hands-on experience with Oracle Database 12c and 19c.
• Experience in database performance tuning and query optimization.
• Experience with large-volume transactional databases.
• Excellent communication and stakeholder management skills.

Responsibilities

• Design, develop, test, and maintain Oracle database solutions using SQL and PL/SQL.
• Analyze business requirements and convert them into technical designs and database solutions.
• Develop and maintain Packages, Procedures, Functions, Triggers, Cursors, External Tables, and other database objects.
• Create and optimize complex SQL queries for high performance and scalability.
• Develop data extraction, transformation, and reporting solutions.
• Create and manage batch processing jobs and database scheduling activities.
• Generate reports through flat files, Excel extracts, and automated database processes.
• Monitor and optimize database performance, troubleshoot bottlenecks, and implement tuning recommendations.
• Work with large-volume databases and ensure data integrity, quality, and reliability.
• Collaborate with business stakeholders, application teams, and support teams to deliver robust solutions.

Skills

SQL & PL/SQL development

Oracle Database 12c/19c

Performance tuning

Batch processing & jobs

Data extraction & reporting

Analytical problem solving

Stakeholder communication

Job description

We are HCLTech, one of the fastest-growing large tech companies in the world and home to 219,000+ people across 54 countries, supercharging progress through industry-leading capabilities centered around Digital, Engineering and Cloud. The driving force behind that work, our people, are diverse, creative, and passionate, raising the bar for excellence on a regular basis. We, in turn, work hard to bring out the best in them as we strive to help them find their spark and become the best version of themselves that they can be.

Role

Senior Oracle PL/SQL Developer

Location

Sydney

Contract Duration

6 Months FTC role

Job Summary

About the Role

HCLTech is seeking an experienced Senior Oracle PL/SQL Developer to join our team. The ideal candidate will have strong expertise in Oracle database development, advanced SQL programming, performance tuning, and large-scale data processing. This role requires an individual who can quickly understand business requirements and translate them into efficient and scalable technical solutions.

Key Responsibilities

• Design, develop, test, and maintain Oracle database solutions using SQL and PL/SQL.
• Analyze business requirements and convert them into technical designs and database solutions.
• Develop and maintain Packages, Procedures, Functions, Triggers, Cursors, External Tables, and other database objects.
• Create and optimize complex SQL queries for high performance and scalability.
• Develop data extraction, transformation, and reporting solutions.
• Create and manage batch processing jobs and database scheduling activities.
• Generate reports through flat files, Excel extracts, and automated database processes.
• Monitor and optimize database performance, troubleshoot bottlenecks, and implement tuning recommendations.
• Work with large-volume databases and ensure data integrity, quality, and reliability.
• Collaborate with business stakeholders, application teams, and support teams to deliver robust solutions.

Required Skills & Experience

• 7-9+ years of experience in SQL and PL/SQL development.
• Strong expertise in Advanced SQL concepts.
• Hands‑on experience with Oracle Database 12c and 19c.
• Strong PL/SQL programming skills with proven experience in:
• Packages
• Procedures
• Functions
• Triggers
• Views
• Cursors
• External Tables
• Experience in database performance tuning and query optimization.
• Strong knowledge of writing high‑performance SQL and PL/SQL programs.
• Experience working with large‑volume transactional databases.
• Expertise in batch processing, database jobs, and report generation.
• Ability to troubleshoot complex database issues and provide effective solutions.
• Strong analytical and problem‑solving skills.
• Excellent communication and stakeholder management skills.

Preferred Skills

• Exposure to ETL and data migration projects.
• Experience with database monitoring and administration activities.
• Knowledge of data warehousing concepts.
• Understanding of Agile delivery methodologies.

Why Us

We are one of the fastest-growing large tech companies in the world, with offices in 50+ countries across the globe and 219,000 employees. Our company is extremely diverse with 165 nationalities represented.

We offer the opportunity to work with colleagues across the globe. We offer a virtual first work environment, promoting a good work‑life integration and real flexibility. We offer comprehensive benefits for all employees. We are a certified great place to work and a top employer in 17 countries, offering a positive work environment that values employee recognition and respect.