PL/SQL Developer

Role Overview: As a Database Lead, you will be responsible for leading and managing a team of 10+ resources to deliver high-quality outcomes. You will work with large datasets, writing efficient SQL queries for data manipulation, transformation, and reporting. Your role will involve query optimization and performance tuning using Explain Plan, SQL Trace, TKPROF, and AWR reports. Additionally, you will participate in requirement gathering, impact analysis, and technical design discussions with stakeholders to ensure adherence to RDBMS concepts and best practices. Collaboration with business users, DBAs, developers, and testers will be essential to build scalable database solutions. Your hands-on experience with PL/SQL and strong technical documentation skills will be valuable in documenting technical designs, data flows, and process logic for long-term support and maintenance. Key Responsibilities: - Lead and manage a team of 10+ resources - Work with large datasets and write efficient SQL queries - Perform query optimization and performance tuning - Participate in requirement gathering and technical design discussions - Ensure adherence to RDBMS concepts, indexing, partitioning, and data modeling best practices - Collaborate with business users, DBAs, developers, and testers - Document technical designs, data flows, and process logic Qualifications Required: - Strong expertise in SQL and database management - Hands-on experience with PL/SQL - Familiarity with MIS reporting requirements and life insurance life cycle (Note: No additional details about the company were provided in the job description.) Role Overview: As a Database Lead, you will be responsible for leading and managing a team of 10+ resources to deliver high-quality outcomes. You will work with large datasets, writing efficient SQL queries for data manipulation, transformation, and reporting. Your role will involve query optimization and performance tuning using Explain Plan, SQL Trace, TKPROF, and AWR reports. Additionally, you will participate in requirement gathering, impact analysis, and technical design discussions with stakeholders to ensure adherence to RDBMS concepts and best practices. Collaboration with business users, DBAs, developers, and testers will be essential to build scalable database solutions. Your hands-on experience with PL/SQL and strong technical documentation skills will be valuable in documenting technical designs, data flows, and process logic for long-term support and maintenance. Key Responsibilities: - Lead and manage a team of 10+ resources - Work with large datasets and write efficient SQL queries - Perform query optimization and performance tuning - Participate in requirement gathering and technical design discussions - Ensure adherence to RDBMS concepts, indexing, partitioning, and data modeling best practices - Collaborate with business users, DBAs, developers, and testers - Document technical designs, data flows, and process logic Qualifications Required: - Strong expertise in SQL and database management - Hands-on experience with PL/SQL - Familiarity with MIS reporting requirements and life insurance life cycle (Note: No additional details about the company were provided in the job description.)