Job
Description
Role Overview: You are being offered a position as a PL/SQL Lead at ValueLabs in Hyderabad. The company is seeking candidates with a minimum of 6 years of experience in PL/SQL programming and database development. Immediate joiners are preferred for this role. Key Responsibilities: - 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. - Lead a team of developers to design, develop, and implement complex database applications using PL/SQL. - Provide technical leadership and guidance to the team on PL/SQL programming, database design, and development methodologies. - Share knowledge and expertise with team members to improve their skills and knowledge in PL/SQL programming and database development. - Mentor junior developers to help them grow in their careers and develop their skills in PL/SQL programming and database development. - Identify areas for process improvement and implement changes to improve the team's efficiency and productivity. - Communicate effectively with stakeholders, including business leaders, project managers, and team members, to ensure that project requirements and expectations are met. Qualifications Required: - Minimum 6+ years of experience in PL/SQL programming and database development. - Proficiency in writing complex SQL queries using various functions and techniques. - Experience in optimizing query performance through indexing, partitioning, and other methods. - Strong knowledge of Oracle's Automatic Workload Repository (AWR) and Active Session History (ASH) for monitoring and optimizing database performance. - Excellent communication skills to effectively interact with stakeholders and team members. (Note: The additional details of the company were not provided in the job description.) Role Overview: You are being offered a position as a PL/SQL Lead at ValueLabs in Hyderabad. The company is seeking candidates with a minimum of 6 years of experience in PL/SQL programming and database development. Immediate joiners are preferred for this role. Key Responsibilities: - 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. - Lead a team of developers to design, develop, and implement complex database applications using PL/SQL. - Provide technical leadership and guidance to the team on PL/SQL programming, database design, and development methodologies. - Share knowledge and expertise with team members to improve their skills and knowledge in PL/SQL programming and database development. - Mentor junior developers to help them grow in their careers and develop their skills in PL/SQL programming and database development. - Identify areas for process improvement and implement changes to improve the team's efficiency and productivity. - Communicate effectively with stakeholders, including business leaders, project managers, and team members, to ensure that project requirements and expectations are met. Qualifications Required: - Minimum 6+ years of experience in PL/SQL programming and database development. - Proficiency in writing complex SQL queries using various functions and techniques. - Experience in optimizing query performance through indexing, partitioning, and other methods. - Strong knowledge of Oracle's Automatic Workload Repository (AWR) and Active Session History (ASH) for monitoring and optimizing database performance. - Excellent communication skills to effectively interact with stakeholders and team members. (Note: The additional details of the company were not provided in the job description.)
