PLSQL Lead

Job Description

Job Description: We are seeking an experienced and highly skilled PL SQL Lead to join our dynamic development team The ideal candidate will have 5 8 years of hands on experience in designing developing and optimizing high performance PL SQL solutions This role requires strong leadership abilities a deep understanding of Oracle database architecture and a proven track record of delivering robust and scalable data driven applications The PL SQL Lead will be responsible for guiding a team of developers ensuring best practices are followed and contributing to the overall success of our database centric projects Key Responsibilities: Roles and Responsibilities Technical Leadership Mentorship Lead a team of PL SQL developers providing technical guidance mentorship and code reviews Foster a collaborative environment and promote knowledge sharing within the team Define and enforce PL SQL coding standards best practices and performance optimization techniques Assist in the professional development of team members Design Development Design develop and implement complex PL SQL packages procedures functions triggers and views Create and optimize SQL queries for various database operations and reporting needs Develop and maintain database schemas tables and indexes Work closely with architects and business analysts to translate business requirements into technical specifications Participate in all phases of the software development lifecycle SDLC including requirements gathering design development testing deployment and support Performance Tuning Optimization Identify and resolve performance bottlenecks in existing PL SQL code and SQL queries Utilize Oracle performance tuning tools e g AWR ADDM Explain Plan SQL Trace to analyze and optimize database performance Implement efficient data loading transformation and extraction strategies Database Management Support Collaborate with database administrators DBAs for schema design capacity planning and database maintenance activities Provide production support for PL SQL applications troubleshooting issues and implementing timely solutions Ensure data integrity and security within the database environment Documentation Reporting Create and maintain comprehensive technical documentation for PL SQL code database designs and processes Generate reports and provide insights on database performance and development progress Collaboration Communication Effectively communicate technical concepts to both technical and non technical stakeholders Collaborate with cross functional teams e g Java developers QA Business Analysts to ensure seamless integration and delivery Technical Requirements: 5 8 years of extensive experience in Oracle PL SQL development including strong proficiency in writing complex stored procedures functions packages and triggers Expertise in SQL tuning and optimization for high volume high performance applications Solid understanding of Oracle database architecture data modeling and relational database concepts Experience with various Oracle features such as Analytical Functions Materialized Views Partitions and Indexes Proficiency in using SQL Developer Toad or similar Oracle development tools Experience with version control systems e g Git SVN Additional Responsibilities: Education Bachelor s degree in Computer Science Information Technology or a related field Certifications Oracle Certified Professional OCP in PL SQL or Database Administration is a plus Preferred Skills: Technology->Oracle Cloud->Oracle Knowledge