Lead Database Engineer

Jobtailor; Bengaluru; On-site; INR 3,500,000 - 6,000,000; Full time

Job summary

Jobtailor in Bengaluru is seeking a senior Database Architect to design, implement, and optimize enterprise database systems. You will shape data models, define schemas, and ensure robust security, performance, and compliance across cloud and on‑premises environments.

The role requires 12+ years of experience, expertise in SQL Server and Oracle, and proficiency with cloud services (RDS/Azure SQL). Night shifts may be required, and relevant certifications are preferred.

Qualifications

• Expertise in database design, data modeling, and schema development.
• Strong experience with SQL Server, Oracle, and cloud database solutions such as Amazon RDS or Azure SQL Database.
• Proficiency in database performance tuning, query optimization, and indexing strategies.
• Experience with data replication, partitioning, and sharding techniques.
• Proficiency with AWS CloudFormation, Terraform, or Ansible.
• 12+ years of experience in database design, architecture, and administration.
• Willingness to work night shifts as required.
• AWS Certified Database – Specialty preferred.
• Microsoft Certified: Azure Solutions Architect Expert preferred.
• Oracle Certified Master preferred.
• Certified Data Management Professional preferred.

Responsibilities

• Design, implement, and maintain database solutions for business apps and data integration.
• Define database structures, schemas, indexing, and partitioning strategies.
• Develop data models and ensure data integrity.
• Establish database design, security, and performance-tuning standards.
• Develop and maintain stored procedures, functions, triggers, and views.
• Integrate database systems with data pipelines.
• Analyze performance metrics and implement indexing, caching, and partitioning strategies.
• Monitor and improve performance using SQL Server Profiler, Oracle AWR, and AWS Performance Insights.
• Implement encryption, access controls, and auditing measures.
• Ensure compliance with GDPR, HIPAA, and ISO standards.
• Collaborate with security teams on database vulnerabilities and risks.
• Develop backup, recovery, and failover strategies.
• Design high-availability solutions using SQL Server Always On, Oracle Data Guard, or AWS Multi-AZ.
• Gather business requirements and translate them into technical solutions.
• Maintain documentation for database designs, configurations, and performance benchmarks.
• Collaborate with developers, system administrators, business stakeholders, and security teams.

Skills

Database Design

Data Modeling

SQL Server

Oracle

Cloud DB Solutions

Partitioning

Indexing Strategies

Stored Procedures

Security & Compliance

Tools

SQL Server Profiler

Oracle AWR

AWS Performance Insights

Amazon RDS

Azure SQL Database

Terraform

Ansible

Job description

• Design, implement, and maintain database solutions supporting business applications and data integration requirements
• Define database structures, schemas, indexing strategies, and partitioning techniques
• Develop data models and ensure data integrity
• Establish database design, security, and performance-tuning standards
• Develop and maintain stored procedures, functions, triggers, and views
• Integrate database systems with data pipelines
• Analyze performance metrics and implement indexing, caching, and partitioning strategies
• Monitor and improve performance using SQL Server Profiler, Oracle AWR, and AWS Performance Insights
• Implement encryption, access controls, and auditing measures
• Ensure compliance with GDPR, HIPAA, and ISO standards
• Collaborate with security teams on database vulnerabilities and risks
• Develop backup, recovery, and failover strategies
• Design high-availability solutions using SQL Server Always On, Oracle Data Guard, or AWS Multi-AZ
• Gather business requirements and translate them into technical solutions
• Maintain documentation for database designs, configurations, and performance benchmarks
• Collaborate with developers, system administrators, business stakeholders, and security teams

Requirements

• Expertise in database design, data modeling, and schema development
• Strong experience with SQL Server, Oracle, and cloud database solutions such as Amazon RDS or Azure SQL Database
• Proficiency in database performance tuning, query optimization, and indexing strategies
• Experience with data replication, partitioning, and sharding techniques
• Proficiency with AWS CloudFormation, Terraform, or Ansible
• 12+ years of experience in database design, architecture, and administration
• Proven experience with cloud database solutions and large-scale data management projects
• Willingness to work night shifts as required
• AWS Certified Database – Specialty preferred
• Microsoft Certified: Azure Solutions Architect Expert preferred
• Oracle Certified Master preferred
• Certified Data Management Professional preferred

Core Competencies

Demonstrates expertise in database design, data modeling, and performance tuning, with a strong focus on compliance with GDPR, HIPAA, and ISO standards. Proficient in integrating cloud database solutions and implementing high‑availability strategies.

Highest-signal resume keywords

• Database Design
• SQL Server
• Oracle
• AWS CloudFormation
• Data Modeling

ATS Optimization Keywords

Hard Skills

• Database Design
• Data Modeling
• Schema Development
• Performance Tuning
• Query Optimization
• Indexing Strategies
• Data Replication
• Partitioning Techniques
• Stored Procedures
• Data Integrity

Soft Skills

• Collaboration
• Communication

Certifications & Qualifications

• AWS Certified Database – Specialty
• Microsoft Certified: Azure Solutions Architect Expert
• Oracle Certified Master
• Certified Data Management Professional

Industry Keywords

• GDPR
• HIPAA
• ISO Standards
• High‑Availability Solutions
• Data Integration

Tools & Technologies

• SQL Server Profiler
• Oracle AWR
• AWS Performance Insights
• Amazon RDS
• Azure SQL Database
• Terraform
• Ansible