20 Oct
|
HCL Australia Services
|
Sydney
20 Oct
HCL Australia Services
Sydney
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.
- Experience working in enterprise-scale production environments.
- 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 outstanding place to work and a top employer in 17 countries, offering a positive work environment that values employee
recognition and respect
Candidate Data Privacy Notice | HCL Technologies We are committed to respecting your privacy and for the protection of your personal data. Your personal data will be collected and processed in line with our candidate privacy notice: https://www.hcltech.com/candidate-privacy-notice. This privacy notice will help you to understand what personal data we collect about you, how we use this personal data, and what rights you have regarding your personal data. By replying to this email or submitting any personal data to HCL Tech, you acknowledge that you have read and understood the candidate privacy notice and have provided your consent to the processing of your data for recruitment purposes as described in the privacy notice”.
📌 Senior Oracle PL/SQL Developer (Sydney)
🏢 HCL Australia Services
📍 Sydney