Job
Description
As an experienced PL/SQL Developer with 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. About the Company: 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. (ref:hirist.tech) As an experienced PL/SQL Developer with 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. About the Company: 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. (ref:hirist.tech)
