Description :

Role : Technical Lead - Database Engineering

Location : Hyderabad / Ahmedabad

Experience : 7 - 10 Years

Employment Type : Full-Time, Permanent

Industry : IT Services / Data Engineering / Cloud & Analytics

Job Summary :

We are looking for an experienced Technical Lead Database Engineering to lead the architecture, development, modernization, and optimization of enterprise-scale database platforms and data solutions. The ideal candidate should possess strong expertise in database engineering, data modeling, performance optimization, cloud data platforms, and modern data architecture practices.

This role requires a combination of deep technical expertise and leadership capabilities to drive scalable, secure, and high-performance data solutions while mentoring teams and collaborating with cross-functional stakeholders.

The candidate will play a key role in designing enterprise-grade database systems, implementing data engineering best practices, driving cloud modernization initiatives, and ensuring efficient data delivery across business-critical platforms.

Key Responsibilities :

Database Architecture & Engineering :

- Lead database architecture design, standards, governance, and best practices

- Design scalable, secure, and high-performance database solutions for enterprise applications

- Build and optimize relational, dimensional, and hybrid data models

- Define database schema design, normalization strategies, and storage optimization techniques

- Drive database modernization and cloud migration initiatives

- Ensure scalability, reliability, security, and maintainability of database platforms

Performance Optimization & Tuning :

- Perform advanced query optimization, indexing, and execution plan analysis

- Optimize database performance for large-scale transactional and analytical workloads

- Implement partitioning, indexing strategies, and performance engineering best practices

- Troubleshoot and resolve complex database performance bottlenecks

- Monitor database health, scalability, and availability metrics

Data Engineering & ETL/ELT :

- Design, develop, and optimize ETL/ELT pipelines and reporting layers

- Work with structured, semi-structured, and large-scale datasets

- Build scalable data ingestion and transformation frameworks

- Support data integration and real-time data processing initiatives

- Collaborate with analytics and reporting teams to enable data-driven decision making

Cloud & Modern Data Platforms :

- Work with modern cloud data platforms including :

1. Azure SQL

2. Azure Synapse Analytics

3. Snowflake

4. Amazon Redshift

- Drive cloud migration, modernization, and optimization initiatives

- Support hybrid and cloud-native data architecture strategies

- Collaborate on Lakehouse and real-time data platform implementations

Leadership & Governance :

- Lead technical design discussions, code reviews, and architecture governance

- Mentor database engineers and guide teams on best practices

- Define standards for database development, deployment, and operations

- Collaborate with cross-functional engineering, DevOps, analytics, and product teams

- Ensure adherence to security, compliance, and governance standards

DevOps & Automation :

- Implement CI/CD pipelines for database deployments using :

1. DACPAC

2. Flyway

3. Liquibase

- Automate database deployments, schema migrations, and release processes

- Support infrastructure automation and DevOps initiatives

- Participate in production support, troubleshooting, and incident management

Required Technical Skills :

- Strong expertise in :

1. T-SQL / PL-SQL

2. SQL Server

3. PostgreSQL

4. Database Performance Engineering

- Advanced skills in :

1. Query Optimization

2. Indexing

3. Partitioning

4. Execution Plan Analysis

- Strong experience in :

1. Data Modeling

2. Relational & Dimensional Modeling

3. Slowly Changing Dimensions (SCD)

4. ETL/ELT Pipelines

- Hands-on experience with :

1. Azure SQL

2. Synapse

3. Snowflake

4. Redshift

- Strong understanding of database security, governance, and scalability

- Experience implementing CI/CD for database environments

Good to Have Skills :

- Experience with :

1. Azure Data Factory

2. SSIS

3. Databricks

- Exposure to NoSQL technologies :

1. MongoDB

2. Cosmos DB

3. Cassandra

- Familiarity with :

1. Lakehouse Architecture

2. CDC (Change Data Capture)

3. Kafka

4. Real-Time Data Pipelines

- Exposure to Power BI and reporting ecosystems

- Understanding of data lineage, governance, and metadata management tools

Soft Skills :

- Strong leadership and mentoring capabilities

- Excellent analytical and problem-solving skills

- Strong stakeholder management and communication abilities

- Ability to manage multiple priorities in fast-paced environments

- Strong ownership and execution mindset

Eligibility Criteria :

- Experience : 7- 10 Years

- Leadership Experience : 2+ Years in technical lead or senior engineering role

Qualification :

- Bachelors or Masters Degree in Computer Science, IT, Data Engineering, or related field

Why Join Us ?

- Opportunity to work on enterprise-scale cloud and data modernization initiatives

- Exposure to modern data engineering and analytics ecosystems

- Collaborative and growth-oriented engineering environment

- Opportunity to lead strategic database transformation programs