Oracle PLSQL Programmer

Elabs Infotech; Hyderabad, Chennai District; On-site; INR 2,200,000 - 3,800,000; Full time

Job summary

Elabs Infotech is seeking a Senior Specialist with 7–11 years of Oracle PL/SQL experience to design, develop and optimize high-performance database solutions within the Oracle DB environment. The role involves implementing scalable PL/SQL packages, procedures, functions and triggers to support critical applications, while ensuring data integrity and security.

You will collaborate with cross-functional teams, monitor and optimize existing code, participate in design reviews, and stay updated on

Qualifications

• 7–11 years of experience in Oracle PL/SQL development and optimization.
• Design and develop complex PL/SQL packages, procedures, functions and triggers.
• Strong focus on performance, data integrity and security.
• Mentor junior developers and promote coding standards.

Responsibilities

• Lead the development and maintenance of Oracle PL/SQL codebases.
• Perform code reviews and provide mentorship to teammates.
• Optimize ETL processes and ODI workflows in Oracle environments.
• Collaborate with DBAs for backups, recovery and object management.
• Conduct performance tuning, query optimization, and capacity planning.
• Work with analysts to align development with project goals and agile ceremonies.

Skills

Oracle PL/SQL

Performance tuning

Code reviews

Tools

Oracle Data Integrator (ODI)

Job description

Role & responsibilities

Seeking a Senior Specialist with 7 to 11 years of experience in Oracle PLSQL to design develop and optimize highperformance database solutions within the Oracle DBODIPLSQL skill cluster

Job Description

Design and develop complex PLSQL packages procedures functions and triggers to support critical business applications Implement efficient and scalable database solutions ensuring high performance data integrity and security Collaborate with crossfunctional teams to gather and analyze requirements and translate them into technical specifications Monitor and optimize existing PLSQL code and database objects to improve system performance and scalability Participate in database design reviews and recommend best practices aligned with organizational standards Stay updated on the latest Oracle database technologies and suggest enhancements to existing processes Assist in troubleshooting and resolving databaserelated issues in production and development environments

Roles and Responsibilities

Lead the development and maintenance of Oracle PLSQL codebases adhering to coding standards and best practices Perform code reviews and provide mentorship to junior developers to enhance PLSQL skills and knowledge Optimize ETL processes and database workflows within Oracle Data Integrator ODI environments Collaborate with DBAs to manage database objects backups and recovery procedures Conduct performance tuning query optimization and capacity planning to ensure system efficiency Work closely with business analysts and stakeholders to align development efforts with project goals Support production releases incident resolution and root cause analysis Document database designs development standards and operational procedures Participate actively in Agile ceremonies contributing to sprint planning and delivery commitments

Skills

Mandatory Skills : Oracle PL/SQL