Job Summary :

Looking for a strong Technical Lead with deep expertise in SQL Development, Database Migration, and Data Modelling.

The candidate will drive enterprise database architecture, migration initiatives, and database performance optimization.

Responsible for leading database engineering teams and designing scalable data solutions for large-scale applications.

Critical Skills to Possess :

- Strong expertise in advanced SQL development (complex queries, stored procedures, triggers, functions, views).

- Experience in query optimization and performance tuning.

- Expertise in indexing strategies and execution plan optimization.

- Experience working with large transactional and analytical databases.

- Hands-on experience in large-scale database migration projects.

- Experience in cross-platform migration or on-premise to cloud migration.

- Strong understanding of data validation, reconciliation, and migration testing.

- Experience implementing low downtime or zero-downtime migration strategies.

- Strong experience in conceptual, logical, and physical data modelling.

- Expertise in ER modelling and dimensional modelling (Star & Snowflake schema).

- Experience designing enterprise-level data models.

- Experience designing scalable, secure, and high-performance database architectures.

- Ability to define database design standards and best practices.

- Experience with data governance and data architecture frameworks.

- Exposure to cloud database platforms (Azure SQL / AWS RDS / GCP Cloud SQL).

- Understanding of data warehouse and modern data architecture.

- Experience in technical leadership and mentoring database teams.

- Ability to guide teams on database design and development best practices.

- Education : BE / B.Tech / MCA in Computer Science, Information Technology, or related discipline.

Roles & Responsibilities :

- Lead and mentor the database development team.

- Define and enforce database coding standards and best practices.

- Conduct technical design reviews and SQL code reviews.

- Design enterprise-scale database architecture and solutions.

- Define data modelling frameworks and database design strategies.

- Recommend database technologies, tools, and architectural improvements.

- Develop and review complex SQL queries, stored procedures, triggers, and functions.

- Ensure database scalability, reliability, and maintainability.

- Lead database migration and modernization initiatives.

- Plan data migration strategies, mapping, transformation, and validation.

- Ensure data integrity and minimal downtime during migrations.

- Create and maintain logical and physical data models.

- Translate business requirements into scalable data structures.

- Maintain data dictionaries and metadata documentation.

- Monitor and improve database performance and query efficiency.

- Implement indexing strategies, partitioning, and performance tuning techniques.

- Work closely with application development, DevOps, BI, and analytics teams.

- Support data integration, reporting, and analytics solutions.

- Ensure data security, data quality, and compliance with governance standards.

- Implement data governance policies and best practices.

Preferred Skills :

- Experience in data warehouse modernization projects.

- Exposure to big data or distributed data systems.

- Experience working in Agile / DevOps environments.