Lead SQL/PLSQL Developer and Architect

Job DescriptionOverview:We are seeking an experienced Lead SQL/PLSQL Developer and Architect with 8-10 years of professional experience. The ideal candidate will lead a team of SQL/PLSQL developers, drive projects, and provide technical support and guidance as an architect. This role requires strong leadership skills, a deep understanding of SQL and PL/SQL development, ETL processes, and the ability to design and implement efficient database solutions. Additionally, the  experience with Hadoop or cloud platforms, particularly Azure Databricks is an added advantage.Key Responsibilities:Leadership & Team Management:  - Lead and manage a team of SQL/PLSQL developers, providing mentorship, guidance, and performance evaluations.  - Foster a collaborative and innovative team environment, encouraging continuous learning and development.  - Allocate tasks and manage team workload to ensure timely and high-quality project deliverables.Project Management:  - Lead and drive SQL/PLSQL projects from inception to completion, ensuring alignment with business goals and objectives.  - Develop project plans, timelines, and resource allocation strategies.  - Coordinate with stakeholders to gather requirements, provide regular updates, and address any issues or concerns.Technical Architecture:  - Design and architect robust, scalable, and efficient database solutions that meet business needs.  - Develop, review, and optimize SQL and PL/SQL code to ensure high performance and reliability.  - Implement best practices for database design, development, and maintenance.ETL and Data Integration:  - Design, develop, and maintain ETL processes to ensure accurate and timely data integration from various sources.  - Optimize ETL workflows for performance and reliability.  - Collaborate with data engineers to ensure seamless data flow and integration.Hadoop and Cloud Migration:  - Plan and execute the migration of existing technologies to a Hadoop or cloud backend.  - Develop and implement strategies for using Hadoop ecosystems and cloud platforms, specifically Azure Databricks.  - Ensure data integrity and security during migration processes.Technical Support:  - Provide technical support and guidance to the development & operations team, troubleshooting complex issues and ensuring best practices are followed.  - Conduct code reviews and ensure adherence to coding standards and guidelines.  - Stay up-to-date with the latest industry trends, technologies, and best practices to drive continuous improvement.Collaboration:  - Collaborate with cross-functional teams, including software engineers, data analysts, and business stakeholders, to deliver comprehensive solutions.  - Communicate effectively with both technical and non-technical stakeholders to ensure project success.QualificationsQualification:- Bachelor’s  degree in Computer Science, Information Technology, or a related field. A master’s degree is a plus.- Experience with Oracle, MySQL, or other relational database management systems.- Knowledge of data warehousing and ETL processes.- Familiarity with Agile development methodologies.Additional InformationRequired Skills and Qualifications:Experience:  - 8-10 years of professional experience in SQL and PL/SQL development, with a proven track record of leading and managing teams.  - Extensive experience in database design, development, and optimization.  - Demonstrated ability to lead and drive projects, from requirements gathering to delivery.  - Experience with ETL processes and tools.  - Hands-on experience with Hadoop ecosystems / cloud platforms, particularly Azure Databricks.Technical Skills:  - Proficiency in SQL and PL/SQL programming.  - Strong knowledge of database design principles, normalization, and indexing strategies.  - Experience with database performance tuning and optimization.  - Familiarity with data modeling tools and techniques.  - Proficiency with ETL tools and processes.  - Experience with Hadoop, Spark, and cloud platforms (Azure Databricks preferred).Soft Skills:  - Excellent leadership and team management skills.  - Strong analytical and problem-solving abilities.  - Effective communication and interpersonal skills.  - Ability to work in a fast-paced, dynamic environment.