Senior Database Consultant

Job Title

Senior Database Developer

Location

Bangalore

Employment Type

Full-Time

Experience Required

8+ years of relevant experience in Database Development, Data Engineering, ETL Modernization, Kafka-based Event Streaming, Cloud-Native Platforms, and Enterprise Application Development.

Job Summary

We are seeking a highly skilled Senior Database Developer / Data Engineering Lead to join our technology team and drive the design, development, modernization, and support of enterprise-scale data platforms and event-driven applications. The ideal candidate will possess deep expertise in SQL Server, ETL, Kafka, OpenShift/Kubernetes, DevOps, and enterprise data engineering practices.

This role requires strong hands-on technical leadership, architectural expertise, and the ability to collaborate across application, infrastructure, cloud, and database teams to deliver scalable, resilient, and high-performance solutions.

The successful candidate will play a key role in modernizing legacy systems, implementing cloud-native architectures, optimizing database performance, and enabling seamless data integration across the enterprise ecosystem.

Responsibilities

• Design, develop, and maintain enterprise-scale ETL and data integration solutions.
• Modernize legacy ETL applications and migrate workloads to Spark and Spring Batch frameworks.
• Design and implement high-performance Kafka-based event streaming and ingestion platforms.
• Lead SQL Server performance optimization, database modernization, migration, and scalability initiatives.
• Design, deploy, and support cloud-native applications on OpenShift and Kubernetes platforms.
• Develop resilient and scalable microservices using Spring Boot and REST APIs.
• Lead technical architecture discussions, design reviews, and solution governance activities.
• Establish development standards, best practices, and engineering frameworks.
• Mentor development teams and provide technical leadership across projects.
• Troubleshoot and resolve production issues across application, database, Kafka, middleware, and infrastructure layers.
• Drive DevOps adoption through automation, CI/CD implementation, and deployment optimization.
• Collaborate with DBAs, infrastructure teams, cloud architects, and business stakeholders to deliver enterprise solutions.
• Ensure platform reliability, security, scalability, and operational excellence.

Required Qualifications

• Bachelors or masters degree in computer science, Information Technology, Engineering, or a related field.

• 10+ years of experience in SQL Server development and enterprise database solutions.

• Strong expertise in SQL Server 2017/2022, including:

• Stored Procedures

• Functions

• Views

• Triggers

• Complex SQL Queries

• Extensive experience in:

• SSIS Development

• Complex ETL Design

• Data Integration Platforms

• Strong knowledge of:

• Query Optimization

• Index Optimization

• Database Partitioning

• Performance Tuning

• Hands-on experience with:

• SQL Server Always on Availability Groups

• Database Migration

• Data Archiving

• Data Retention Strategies

• Proven experience developing and supporting Kafka-based solutions, including:

• Kafka Producers and Consumers

• Kafka Performance Tuning

• Avro Schemas

• Schema Registry

• Strong experience with:

• OpenShift (OCP)

• Kubernetes

• Docker Containers

• Cloud Migration Initiatives

• Hands-on experience with DevOps practices and tools:

• GitHub Actions

• Harness

• Liquibase

• CI/CD Pipelines

• Experience with automation scripting using:

• PowerShell

• Autosys

• Experience in enterprise file integration technologies:

• NAS

• IBM NDM / Connect: Direct

• Object Storage

• Batch Processing

• Experience providing production support in large-scale enterprise environments.

• Strong analytical, troubleshooting, and problem-solving skills.

• Excellent stakeholder management and communication skills.

Desired Qualifications

• Experience with Java development using Spring Boot.

• Knowledge of REST API development and Microservices architecture.

• Exposure to Spark-based data engineering solutions.

• Experience with Service Mesh technologies such as Istio.

• Experience with API Management platforms including:

• APIGEE

• API Gateway

• Familiarity with Avi Load Balancer.

• Experience working in cloud transformation and modernization programs.

• Exposure to Agile and DevSecOps methodologies.

• Prior experience leading teams and mentoring engineers.

Primary Skillset

Data Engineering ETL

• SQL Server (2017/2022) Development.
• SSIS Development and complex ETL pipeline design.
• Development of database objects including Stored Procedures, Functions, Views, and Triggers.
• Database performance tuning, query optimization, partitioning, and indexing strategies.
• SQL Server Always on Availability Groups implementation and support.
• Database migration, data archival, and retention management.

Messaging Event Streaming

• Apache Kafka administration and development.
• Kafka Producer and Consumer application development.
• Kafka monitoring and performance optimization.
• Avro Schemas and Schema Registry.

Cloud Container Platforms

• OpenShift (OCP) Administration and Application Deployment.
• Kubernetes orchestration and container management.
• Docker containerization.
• Service Mesh (Istio).
• APIGEE and API Gateway implementations.
• Avi Load Balancer.
• Cloud migration and modernization initiatives.

DevOps

• GitHub Actions.
• Harness.
• Liquibase.
• CI/CD Pipeline implementation and automation.

Automation

• PowerShell scripting.
• Autosys job scheduling and automation.

File Integration

• NAS integrations.
• IBM NDM / Connect: Direct.
• Object Storage solutions.
• Enterprise batch processing platforms.

Observability Monitoring Tools

• Splunk.
• Grafana.
• Prometheus.
• AppDynamics.
• Dynatrace/Linborg (as applicable).

Secondary Skillset

• Java development using Spring Boot.