Lead SQL/PLSQL Developer and Architect

Job Description

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.

Qualifications

Qualification:

- 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 Information

Required 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.