Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in hyderabad
>
Foundation Ai
>
Lead Database Engineer

Lead Database Engineer

Foundation Ai

3 - 7 years

8 - 12 Lacs

hyderabad

Posted:1 hour ago| Platform:

Apply

Skills Required

performance tuning automation data modeling database design mysql cloud design management database performance monitoring aws

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Overview:

At Foundation AI, we are looking for a Lead Database Engineer to oversee database architecture, optimization, security, and scalability . This role requires expertise in relational and NoSQL databases, performance tuning, cloud-based database solutions, and DevOps automation . The ideal candidate will lead a team of database engineers , collaborate with cross-functional teams, and drive best practices in database design, management, and high availability

Key Responsibilities:

Database Architecture Design: Lead the design and implementation of scalable and high-performance database architectures . .
Performance Optimization: Identify, troubleshoot and automate performance monitoring , and resolve performance bottlenecks, slow queries, and indexing issues .
Database Administration: Manage, monitor, and optimize SQL and NoSQL databases (e.g., PostgreSQL)
Cloud Infrastructure: Design and implement multi-cloud database solutions across AWS/Azure/GCP, ensuring scalability and performance. Optimize cloud database performance, cost efficiency, and security
Backup Recovery: Establish and maintain backup, disaster recovery (DR), and failover strategies .
Security Compliance: Ensure database security, encryption, access control, and compliance with regulatory requirements (GDPR, HIPAA, SOC2).
Automation DevOps: Automate database provisioning, schema changes, and CI/CD pipelines using Terraform, Ansible, or Kubernetes .
Data Modeling: Design efficient database schemas and normalization strategies to support business needs .
High Availability Replication: Implement solutions for replication, clustering, and load balancing to ensure 99.99% uptime .
Monitoring Diagnostics: Utilize tools like Prometheus, Grafana, CloudWatch for proactive database monitoring.
Mentorship Leadership: Drives technical initiatives across teams, enabling teams to deliver complex solutions while fostering a culture of innovation, collaboration, knowledge sharing and Mentors engineers driving best practices and ensures technical alignment.,
Documentation: Maintain technical documentation for reference and future development

Note:

Responsibilities will be tailored based on the candidate s experience and expertise, aligning with Lead Database Engineer I, II, or III levels

Skills and Tools:

Database Design :

Can design small-to-medium-sized databases with clear relationships between entities.
Designs scalable databases and optimizes them for performance, ensuring the right level of normalization and denormalization.
Leads the database design process for mission-critical applications, ensuring scalability and high availability.
Works with leadership to set database strategy for the organization.

SQL Proficiency

Comfortable writing complex SQL queries to retrieve, manipulate, and aggregate data.
Reviews and optimizes team SQL queries for performance and scalability.
Leads the development of stored procedures and triggers.
Manages complex SQL development processes, ensuring that queries are optimized for large databases.
Reviews and improves the overall SQL architecture for better performance.

Performance Tuning

Familiar with tools for query analysis and performance monitoring.
Tunes queries, indexes, and configurations for optimal performance.
Leads performance audits and optimizes database infrastructure for mission-critical systems.

Database Systems Tools

Hands-on with installing, configuring, and using RDBMS and cloud database tools.
Leads teams in choosing and implementing appropriate database tools.
Oversees database system upgrades and transitions across teams.

Performance Tuning Optimization

Bench marking the performance threshold using the existing tools
Automates performance monitoring.
Coaches teams on query tuning best practices.
Oversees performance optimization for mission-critical applications.

Backup, Recovery, and Maintenance

Configures backups and recovery solutions.
Schedules automated maintenance jobs.
Ensures successful recovery testing.
Drives backup optimization and reduces recovery time objectives (RTO).

Scripting Programming Languages

Uses SQL, Bash, or PowerShell for automating repetitive tasks.
Writes advanced automation scripts integrating DB, OS, and cloud services.
Leads the development of scripting standards and contributes to internal tooling initiatives.

Database Security

Configures roles, permissions, and encryption.
Monitors user activity and enforces security guidelines.
Leads security incident response related to databases.

Problem-solving

Diagnoses and fixes common bugs
Resolves integration and performance issues
Develops systemic solutions for recurring technical problems

Critical Thinking

Evaluates technical feasibility of tasks
Assesses architectural implications and trade-offs
Guides team decision-making aligned with long-term objectives

Effective Communication

Updates team on progress and blockers.
Suggest the enhancement based on the feedback.
Works within their team and with its business stakeholders to foster a culture of seeking out feedback and using it as a tool for growth. Actively demonstrates these behaviors.
Fosters a culture of delivering praise and constructive feedback within their team and teams respective business stakeholders. Actively demonstrates these behaviours.
Communicates design choices and technical challenges

Leadership

Leads a project or feature team, coordinating tasks and ensuring delivery.
Mentors engineers, promoting knowledge sharing , driving best practices and ensures technical alignment..
Drives technical initiatives across teams, enabling teams to deliver complex solutions while fostering a culture of innovation. collaboration and knowledge sharing.

Ownership

Takes ownership of a module or subsystem, ensuring quality delivery.
Ensures delivery of end-to-end features, managing risks and dependencies.
Owns the success of multiple features or systems, proactively driving improvements and ensuring long-term system health.

Technical Skills

Requirement Level

Relational Databases (SQL-based) - PostgreSQL

Must Have

NoSQL Databases Redis, MongoDB

Good to Have

AWS RDS, Aurora (Managed SQL databases on AWS)

Must Have

PgBouncer (Connection pooling for PostgreSQL)

Good to Have

Query Optimization (EXPLAIN ANALYZE, query hints, indexing strategies)

Must Have

Sharding Partitioning (For horizontal scaling )

Must Have

Load Balancers (HA Proxy, AWS ELB, or Azure Load Balancer)

Good to Have

Replication Failover Solutions (PostgreSQL Streaming Replication, MySQL GTID Replication)

Good to Have

Cloud-based Backup Tools (AWS Backup, Azure Site Recovery, Google Cloud Snapshots)

Good to Have

Disaster Recovery Planning (Automated backups, failover strategies)

Good to Have

Proficient in versioning systems like Git, or SVN

Good to Have

Docker and Kubernetes knowledge

Good to Have

Prometheus Grafana (Database performance monitoring)

Good to Have

Apache Airflow (Workflow orchestration for data pipelines)

Good to Have

Query Performance Tracking Tools (e.g., pg_stat_statements, SQL Profiler, EXPLAIN ANALYZE)

Must Have

Database Encryption (Transparent Data Encryption, Column-level Encryption)

Must Have

Working in Agile/Scrum

Must Have

Role-based Access Control (RBAC) (PostgreSQL roles, AWS IAM policies)

Must Have

Vulnerability Scanning Patching (Automated security updates)

Good to Have

SQL PL/pgSQL / T-SQL (Advanced SQL scripting)

Must Have

Bash / PowerShell (Database automation scripts)

Must Have

Graph Databases (Neo4j, Amazon Neptune) (For relationship-based queries)

Good to Have

More Jobs at Foundation Ai

Director Human Resources

Hyderabad

7.0 - 12.0 yrs

INR 9 - 14 Lacs

Senior Devops Engineer

Hyderabad

5.0 - 7.0 yrs

INR 5 - 8 Lacs

Lead DevOps Engineer

Hyderabad

7.0 - 10.0 yrs

INR 11 - 16 Lacs

Lead Software Engineer

Hyderabad

6.0 - 10.0 yrs

INR 45 - 50 Lacs

Senior Software Engineer

Hyderabad

5.0 - 6.0 yrs

INR 7 - 8 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Foundation Ai

Login to

Please Verify Your Phone or Email

Confirm Action

Lead Database Engineer