PL/SQL Lead ValueLabs
ValueLabs
Office Location
Full Time
Experience: 6 - 6 years required
Pay:
Salary Information not included
Type: Full Time
Location: Hyderabad
Skills: Database Development, sql queries, indexing, Debugging, Performance optimization, Team Leadership, Knowledge sharing, Process Improvement, Communication, Plsql Programming, Partitioning, Bulk collect, Bulk binding, technical expertise, Mentorship
About ValueLabs
Job Description
Dear Aspirants, We at ValueLabs have an Opening for PL/SQL Lead role. Below is the JD for the same. Role : PL/SQL Lead Experience 6+ Years Location: Hyderabad Preferable Immediate Joiners only 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. Interested candidates please share your profile with imranmohammed.1@valuelabs.com,