We are seeking a talented Senior PL/SQL Developer to join our dynamic team. This role will primarily focus on architecting and developing advanced PL/SQL modules while ensuring that all solutions meet business requirements efficiently and effectively. The ideal candidate will have a deep understanding of Oracle technologies and database management, along with the ability to mentor junior developers and guide them toward best practices and coding standards.

Key Responsibilities

1. Architect and Develop Advanced PL/SQL Modules. You will be responsible for designing and developing robust PL/SQL modules that meet business requirements, ensuring that solutions are scalable, optimized, and of the highest quality.
2. Mentorship and Guidance. As a senior developer, you will mentor junior developers, provide them with guidance, and establish clear coding standards. You will play a key role in shaping the development team's culture by instilling best practices and encouraging continuous learning.
3. Database Optimization. You will implement complex data models, optimize database structures, and enhance performance at both the query and system levels. Your expertise will contribute to overall database efficiency, ensuring smooth and fast data retrieval.
4. ETL Integration. You will be involved in the integration of PL/SQL with various systems, including ETL (Extract, Transform, Load) processes. This will require a strong understanding of data migration, transformation, and loading techniques.
5. Database Performance Tuning. A crucial part of your role will be working on database performance tuning. You will identify bottlenecks, optimize queries, and implement best practices to ensure the database operates at peak performance.
6. Strategic Planning. Participate in long-term planning for database architecture and upgrades. You will help ensure that the database systems remain scalable, secure, and able to handle future business needs.
7. Code Reviews & Data Governance Compliance. Conduct thorough code reviews to ensure that all code is efficient, maintainable, and compliant with data governance policies. Your reviews will help maintain high standards of quality and ensure that our solutions comply with industry regulations.

Preferred Skills

1. Oracle Apps Technical Expertise. You should have experience with Oracle Apps PL/SQL, which will allow you to develop solutions tailored to Oracle Applications.
2. Oracle Database Administration (DBA). A deep understanding of DBA concepts is essential. You should be comfortable working with Oracle databases and have experience with high availability solutions, such as Oracle RMAN and Data Guard.
3. Advanced PL/SQL Programming Skills. Proficiency in dynamic SQL and bulk operations will be critical to your success. Your ability to write complex PL/SQL code will ensure efficient data processing and manipulation.
4. Oracle APEX or Development Tools. Experience with Oracle APEX or similar development tools for creating application interfaces will be an added advantage.
5. Complex Query Writing. You should be proficient in writing complex SQL queries, joins, and subqueries, especially for data analysis and reporting purposes.
6. High Availability & Replication. Familiarity with Oracle’s high availability solutions, including replication, partitioning, and data warehousing concepts, is a key skill for this role.
7. Error Handling & Transaction Control. Strong knowledge of error handling, transaction control, and concurrency management will be necessary to build stable and reliable PL/SQL applications.

Qualifications

1. Educational Background. A Bachelor’s or Master’s degree in Computer Applications (MCA, BCA), Science (BSc, MSc), Engineering (BEng, MTech), or a related field is required. A solid educational foundation will support your understanding of programming and database concepts.
2. Relevant Experience. You should have extensive experience in PL/SQL development, with a proven track record of successfully delivering high-performance database solutions. Experience with Oracle database technologies is essential for this position.

This job offers an exciting opportunity to be part of a high-performing team and work with cutting-edge Oracle technologies. You will have the chance to contribute to critical projects, mentor junior talent, and shape the future of our database solutions. If you're looking for a challenging role where you can leverage your PL/SQL expertise and make an impact, we'd love to hear from you.