We are looking for a skilled PL/SQL Developer to join our dynamic team. The ideal candidate should have a strong background in Oracle PL/SQL development, data warehousing, and performance optimization. As part of this role, you will be responsible for analyzing, designing, developing, troubleshooting, and debugging software applications. You will collaborate with cross-functional teams to develop high-quality, scalable solutions that meet business requirements.
Experience. 5 to 12 years
Key Responsibilities
- Develop and maintain PL/SQL packages, procedures, functions, triggers, views, and materialized views for handling complex datasets in Oracle databases.
- Write efficient and optimized SQL queries for data retrieval, transformation, and migration.
- Design and implement robust partitioning and indexing strategies to enhance database performance.
- Conduct SQL performance tuning and optimization using techniques such as explain plans and SQL trace files.
- Develop and schedule database jobs for automation and efficiency.
- Perform data migration tasks using SQL Loader, import/export utilities, and other ETL techniques.
- Work closely with stakeholders to understand business requirements and translate them into detailed ETL specifications, high-level, and low-level design documents.
- Ensure compliance with data security, integrity, and best practices in database development.
- Troubleshoot database issues, identify bottlenecks, and implement solutions for smooth operation.
- Collaborate with application developers to optimize database queries and improve system performance.
- Document database processes, workflows, and technical specifications for future reference.
Mandatory Skills
- Strong expertise in Oracle PL/SQL development.
- Hands-on experience in designing and coding for data warehousing projects.
- Deep understanding of partitioning, indexing strategies, and SQL tuning techniques.
- Proven experience in database development, including scheduling jobs and data migration.
- Solid understanding of HTML, CSS, and JavaScript for integrating front-end with database applications.
- Strong analytical and problem-solving skills.
- Excellent verbal and written communication skills in English.
- Ability to work independently and in a team-oriented environment under minimal supervision.
- Experience working in the financial services industry (preferred but not mandatory).
Why Join Us?
Oracle is a global leader in cloud solutions, with a legacy of over 40 years of innovation and integrity. We are committed to fostering an inclusive culture where diverse perspectives are valued, and employees are encouraged to bring their best ideas to the table. Our work environment is designed to promote career growth, work-life balance, and continuous learning.
Employee Benefits
- Competitive compensation and performance-based incentives.
- Comprehensive medical and life insurance coverage.
- Access to retirement planning and financial wellness programs.
- Opportunities for professional growth through training and development initiatives.
- A collaborative and inclusive work culture that values diversity and creativity.
- Employee engagement programs and community service initiatives.
Diversity & Inclusion at Oracle
At Oracle, we believe that innovation flourishes when everyone’s voice is heard. We are dedicated to creating a diverse and inclusive workplace where employees from various backgrounds, perspectives, and abilities can thrive. We ensure that individuals with disabilities receive reasonable accommodations during the hiring process and in their roles.
Equal Opportunity Employer Statement
Oracle is an Equal Employment Opportunity Employer. We consider all qualified applicants without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability status, veteran status, or any other characteristic protected by law. We also comply with applicable laws regarding arrest and conviction records.
If you require accommodation due to a disability during any stage of the hiring process, please contact us at +1 888 404 2494, option one.
Join us at Oracle and be part of a team that’s shaping the future of technology!
Apply Now!