PL/SQL Developer

Location : Bengaluru

Experience : 4- 7 Years

Joining : Immediate

About the Role :

We are seeking a highly skilled PL/SQL Developer to join our dynamic team at a leading MNC. The ideal candidate will have strong expertise in PL/SQL development, hands-on experience with ATP (Autonomous Transaction Processing), and proficiency in creating and managing packages. This role involves working on complex, high-performance applications in a fast-paced environment, contributing to mission-critical projects.

Key Responsibilities :

Database Development :

- Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and scripts.

- Optimize SQL queries for performance and scalability.

- Implement best practices for database coding standards and security.

Application Integration :

- Collaborate with application teams to integrate PL/SQL components into enterprise applications.

- Support application deployments and troubleshoot database-related issues.

Performance Tuning :

- Analyze and resolve performance bottlenecks in PL/SQL code and queries.

- Conduct query optimization and indexing strategies.

ATP & Advanced Features :

- Work with Oracle Autonomous Transaction Processing (ATP) for database automation and optimization.

- Leverage advanced Oracle features for high availability and reliability.

Documentation & Compliance :

- Prepare technical documentation for developed components.

- Ensure compliance with coding standards and security guidelines.

Required Skills :

Core Expertise :

- Strong hands-on experience in PL/SQL development (packages, procedures, triggers).

- Proficiency in Oracle Database concepts and architecture.

- Experience with ATP and advanced Oracle features.

Additional Skills :

- Knowledge of application integration (preferred but not mandatory).

- Familiarity with performance tuning and query optimization techniques.

Certifications :

- Oracle PL/SQL Developer Certified Associate or equivalent certification (mandatory).

Who Were Looking For :

- Professionals with 4- 7 years of proven PL/SQL development experience.

- Immediate joiners who can hit the ground running.

- Strong problem-solving skills and ability to work in a fast-paced environment.

- Excellent communication and collaboration skills.