SQL Developer - Oracle DB

As an experienced PL/SQL Developer with strong expertise in Oracle database development and PL/SQL programming, your role will involve designing, developing, and maintaining high-performance database solutions. You will work closely with application teams to support business requirements.

Key Responsibilities:

• Develop, test, and maintain PL/SQL code, including stored procedures, functions, packages, triggers, and cursors.
• Design and implement efficient database structures to support applications and reporting requirements.
• Optimize SQL queries and PL/SQL code for performance and scalability.
• Collaborate with application developers, business analysts, and DBAs to understand business requirements and provide solutions.
• Troubleshoot database issues and perform root cause analysis to ensure high availability and reliability.
• Maintain data integrity, security, and backup/recovery procedures.
• Document PL/SQL code, database objects, and design specifications.
• Stay updated with new Oracle database features and best practices.

Qualifications Required:

• Strong experience with Oracle PL/SQL programming.
• Hands-on experience with Oracle database versions: 11g, 12c, 19c.
• Proficiency in writing and optimizing complex SQL queries.
• Experience with cursors, triggers, packages, stored procedures, and functions.
• Good problem-solving and analytical skills.
• Familiarity with database design, normalization, and relational modeling concepts.

Additional Company Details: PL/SQL is a procedural language that incorporates SQL statements into its syntax. The Oracle Database server compiles PL/SQL program units and stores them inside the database. As an experienced PL/SQL Developer with strong expertise in Oracle database development and PL/SQL programming, your role will involve designing, developing, and maintaining high-performance database solutions. You will work closely with application teams to support business requirements.

Key Responsibilities:

• Develop, test, and maintain PL/SQL code, including stored procedures, functions, packages, triggers, and cursors.
• Design and implement efficient database structures to support applications and reporting requirements.
• Optimize SQL queries and PL/SQL code for performance and scalability.
• Collaborate with application developers, business analysts, and DBAs to understand business requirements and provide solutions.
• Troubleshoot database issues and perform root cause analysis to ensure high availability and reliability.
• Maintain data integrity, security, and backup/recovery procedures.
• Document PL/SQL code, database objects, and design specifications.
• Stay updated with new Oracle database features and best practices.

Qualifications Required:

• Strong experience with Oracle PL/SQL programming.
• Hands-on experience with Oracle database versions: 11g, 12c, 19c.
• Proficiency in writing and optimizing complex SQL queries.
• Experience with cursors, triggers, packages, stored procedures, and functions.
• Good problem-solving and analytical skills.
• Familiarity with database design, normalization, and relational modeling concepts.

Additional Company Details: PL/SQL is a procedural language that incorporates SQL statements into its syntax. The Oracle Database server compiles PL/SQL program units and stores them inside the database.