SQL Developer

You are an experienced PL/SQL Developer with a strong expertise in Oracle database development and PL/SQL programming. Your role involves designing, developing, and maintaining high-performance database solutions while working closely with application teams to meet business requirements. - 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. **Preferred / Good To Have:** - Oracle certifications: PL/SQL Developer Certified Associate or Professional. - Knowledge of performance tuning, indexing, and partitioning strategies. - Experience with integration between PL/SQL and front-end applications. - Exposure to cloud-based Oracle databases (OCI, AWS RDS for Oracle). - Proficiency in PL/SQL programming concepts and Oracle database management systems. - Certifications like Oracle PL/SQL Developer Certified Associate or Professional are desirable. The PL/SQL language is procedural and incorporates SQL statements into its syntax. The Oracle Database server compiles PL/SQL program units and stores them inside the database. *(Reference: hirist.tech)*,