Database Engineer

Anytime Diesel; Hyderabad; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Anytime Diesel is seeking a hands-on Database Engineer to lead the performance, reliability, security and design of the databases behind our PHP, Java and mobile applications. You will optimize MySQL production systems, build scalable transactional and analytical data models, and support dependable reporting without disrupting live operations.

Join a fast-growing energy tech company in Hyderabad to establish robust data infrastructure, security controls, and disaster recovery while collaborating

Qualifications

• 4+ years of relevant experience in database engineering or data engineering.
• Advanced MySQL and SQL expertise with query tuning.
• Experience in dimensional modelling and OLTP/OLAP design.
• Hands-on AWS RDS/Aurora, S3, and analytics tools like Redshift/Athena/Glue.
• ETL/ELT development using Python, SQL, Airflow or AWS Glue.
• Strong HA, backups, recovery, and security practices.

Responsibilities

• Design, optimize and maintain MySQL databases on AWS RDS/Aurora for high availability.
• Create schemas for OLTP and analytics, including star/snowflake models.
• Build and maintain ETL/ELT pipelines from apps/databases to analytics stores.
• Tune slow queries, indexing, partitioning and configuration with developers.
• Implement backup, replication, failover and disaster-recovery processes.
• Enforce data security, access controls, encryption and auditing.
• Manage migrations and schema versioning with DevOps.
• Provide clean datasets for dashboards and reporting.

Skills

MySQL optimization

SQL analysis

Dimensional modelling

ETL/ELT development

Python

Airflow

Data modeling

Education

Bachelor’s degree in Computer Science / Engineering

Tools

AWS RDS/Aurora

S3

Redshift/Athena/Glue

Python/Airflow

SQL tuning / EXPLAIN

CI/CD / IaC (Flyway/Liquibase)

BI tools (Metabase/Tableau/Power BI)

Job description

Anytime Diesel (ATD) is a technology-driven energy company transforming India’s fuel delivery ecosystem. As South India’s largest on-demand fuel delivery company and India’s first tech-driven, direct-to-consumer diesel delivery platform, ATD is building a new category in fuel distribution by bringing together technology, logistics and dependable energy delivery.

We help businesses across industries receive diesel directly at their premises through a technology-led delivery model. Our mission is to make energy access smarter, faster, more reliable, transparent and efficient. As we scale, robust data infrastructure is central to the applications, operations and business intelligence that power our growth.

Role Overview

We are seeking a hands-on Database Engineer to lead the performance, reliability, security and design of the databases behind our PHP, Java and mobile applications. You will optimize MySQL production systems, build scalable transactional and analytical data models, and support dependable reporting without disrupting live operations.

Key Responsibilities

• Design, optimize and maintain MySQL databases on AWS RDS / Aurora for high availability and performance.
• Build schemas for transactional (OLTP) and analytics workloads, including star / snowflake schemas and fact / dimension tables.
• Develop and maintain ETL / ELT pipelines from application databases and Firebase to analytical data stores.
• Investigate and tune slow queries, indexing, partitioning and configuration; partner with developers on efficient SQL.
• Implement and routinely validate backup, restore, replication, failover and disaster-recovery processes.
• Apply data security controls covering permissions, encryption and audit logging.
• Own schema changes, migrations and version control in coordination with development and DevOps teams.
• Deliver trustworthy, documented datasets for dashboards, reporting and business decision-making.
• Own MySQL database performance, monitoring, capacity planning and optimization across production environments.
• Establish database health dashboards covering query latency, replication lag, storage, connections and database resource utilization.
• Implement automated data validation and reconciliation to ensure accurate order, customer, delivery and transaction records.
• Define and regularly test database recovery procedures with agreed Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO).
• Manage safe database migrations, schema versioning and deployment coordination to minimize application disruption.
• Develop reliable ETL/ELT pipelines with scheduled execution, incremental loading, error handling and monitoring.
• Collaborate with engineering and business stakeholders to support reporting, operational dashboards and analytical requirements.
• Implement role-based permissions, sensitive-data protection, data retention and database auditing practices.

Required Skills & Experience

• 4+ years of relevant experience in database engineering, DBA or data engineering.
• Advanced MySQL and SQL expertise, including query tuning and execution-plan analysis.
• Experience in dimensional modelling and choosing appropriate normalization / denormalization patterns.
• Hands-on AWS RDS, Aurora and S3, plus at least one of Redshift, Athena or Glue.
• ETL / ELT development using Python, SQL, Airflow or AWS Glue.
• Strong foundation in replication, high availability, backups and recovery.
• Ability to explain design decisions to engineers and business stakeholders.

Preferred Skills

• BI tools: Metabase, Tableau, Power BI or Amazon QuickSight.
• Firebase / NoSQL: Firestore and Realtime Database.
• Data warehousing: Redshift, Snowflake or BigQuery.
• Database CI/CD, Infrastructure as Code and migration tools such as Flyway or Liquibase.
• Relevant AWS data or database certifications.

Qualifications

Bachelor’s degree in Computer Science, Engineering or a related discipline, or equivalent practical experience.

Help build the critical data foundation for a fast-growing, technology-enabled fuel delivery business. Work closely with product, engineering and business teams on meaningful scale, resilience and analytics challenges.