Lead SQL/PLSQL Developer and Architect

Overview:

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.