Description:
We are seeking a Senior PL/SQL Developer with a minimum of three years of experience to join our talented team. The ideal candidate will have extensive expertise in PL/SQL programming, with a deep understanding of advanced concepts such as collections, bulk collect, performance tuning, and complex package and procedure development. They will play a key role in designing, developing, and maintaining high-quality PL/SQL code for our US-based projects.
Responsibilities:
- Design, develop, and maintain complex PL/SQL code for US-based client projects.
- Utilize advanced PL/SQL features such as collections and bulk collect for optimal performance and scalability.
- Perform performance tuning and optimization of SQL queries to meet project requirements.
- Design and implement complex database objects such as packages, procedures, functions, triggers, and views.
- Collaborate with project managers, business analysts, and other stakeholders to gather and analyze requirements.
- Create and maintain technical documentation for developed solutions.
- Provide mentorship and guidance to junior developers on PL/SQL best practices.
- Troubleshoot and resolve complex database-related issues in a timely manner.
Requirements:
- Bachelor's degree in Computer Science, Engineering, or a related field.
- Minimum of three years of experience as a PL/SQL Developer or similar role.
- Strong proficiency in PL/SQL programming and Oracle database technologies.
- In-depth knowledge of advanced PL/SQL concepts such as collections, bulk collect, and performance tuning techniques.
- Experience with designing and implementing complex database objects including packages, procedures, functions, triggers, and views.
- Familiarity with version control systems (e.g., Git).
- Excellent problem-solving skills and attention to detail.
- Strong communication and interpersonal skills.
- Ability to work independently as well as part of a team.