PL/SQL Lead

Responsibilities

Minimum 6+ years of experience in PL/SQL programming and database development.
Design, develop, and test complex PL/SQL procedures, functions, packages, triggers, views, and materialized views.
Write complex SQL queries using joins, analytical functions, and aggregate functions.
Optimize query performance using indexing, partitioning, and other techniques.
Design and implement efficient collections-based solutions using PL/SQL.
Use bulk collect and bulk binding to improve performance and reduce memory usage.
Debug and troubleshoot complex PL/SQL code using tools like SQL Developer, TOAD, or SQL Plus.
Identify and resolve issues related to performance, syntax, and logical errors
Identify and address performance bottlenecks using hints, indexes, and other techniques.
Use Oracle's Automatic Workload Repository (AWR) and Active Session History (ASH) to monitor and optimize database performance
Team Leadership: Lead a team of developers to design, develop, and implement complex database applications using PL/SQL.
Technical Expertise: Provide technical leadership and guidance to the team on PL/SQL programming, database design, and development methodologies.
Knowledge Sharing: Share knowledge and expertise with team members to improve their skills and knowledge in PL/SQL programming and database development.
Mentorship: Mentor junior developers to help them grow in their careers and develop their skills in PL/SQL programming and database development.
Process Improvement: Identify areas for process improvement and implement changes to improve the team's efficiency and productivity.
Communication: Communicate effectively with stakeholders, including business leaders, project managers, and team members, to ensure that project requirements and expectations are met