Lead SQL Developer

We are seeking a skilled Database Developer (SQL) to design, develop, and maintain efficient database solutions. The ideal candidate will have expertise in SQL development, database optimization, and data integrity management. This role involves working closely with cross-functional teams to develop and support database applications, ensuring performance, security, and scalability.

Location:

Mode of Work: Work From Office

Key Responsibilities:

• Design, develop, and optimize SQL databases to support business applications.
• Write complex SQL queries, stored procedures, functions, and triggers for efficient data retrieval and processing.
• Ensure database performance tuning, indexing, and optimization techniques.
• Maintain database integrity, security, and compliance with industry standards.
• Collaborate with software developers and analysts to understand database requirements.
• Develop and maintain ETL processes for data extraction, transformation, and loading.
• Troubleshoot database-related issues and provide timely resolutions.
• Monitor database performance and conduct regular maintenance tasks.
• Document database designs, processes, and best practices.

Preferred Skills & Qualifications:

• Strong proficiency in SQL and relational database management systems (RDBMS) such as Microsoft SQL Server, MySQL, or PostgreSQL.
• Experience in writing and optimizing complex SQL queries and stored procedures.
• Knowledge of database indexing, normalization, and performance tuning techniques.
• Understanding of database security best practices.
• Familiarity with ETL tools and processes.
• Experience in data modeling and database design principles.
• Ability to work with large datasets and optimize query performance.
• Strong problem-solving and analytical skills.

Desired Skills:

• Experience with cloud-based database solutions (Azure SQL, AWS RDS, or Google Cloud SQL).
• Knowledge of NoSQL databases such as MongoDB or Cassandra.
• Exposure to database automation and DevOps practices.
• Experience with reporting and BI tools like Power BI, Tableau, or SSRS.
• Strong communication and collaboration skills to work effectively with development teams.
• Ability to adapt to fast-paced environments and manage multiple database projects.