Senior Database Engineer

Job Title : Senior Database Engineer

Location : Pune

Experience : 7- 12 years

Work Mode : Hybrid (3 Days WFO)

Must Have"s :

• Cloud Database

• AWS, Postgres, Snowflake, Oracle RDS

• Medallion Architecture

• DBT

• AI/ML Solutions

• Python

• Database design

Role Overview :

Join our DevOps Engineering team as a Senior Database Engineer responsible for designing, optimizing, and automating cloud database solutions across AWS RDS, Postgres, and Snowflake. This role focuses on performance engineering, data integration, and automation - ensuring our data platforms are scalable, reliable, and efficient. Youll work closely with DevOps and Product Engineering to build high-performing data infrastructure that supports critical applications and analytics.

Key Responsibilities :

Modern Data Architecture & Platform Engineering :

• Architect and optimize scalable data platforms using Snowflake, PostgreSQL, and Oracle RDS.

• Design cloud-native lakehouse architectures on AWS using Medallion (Bronze/Silver/Gold) patterns.

• Build hybrid systems spanning operational databases and analytical warehouses.

• Develop performant data models, ELT pipelines, semantic layers, and reusable metrics.

• Manage schema evolution, replication, partitioning, and lifecycle strategies for scalability and resilience.

Advanced Data Pipelines & Orchestration :

• Engineer reliable batch and nearreal-time ELT pipelines using dbt and cloud-native services.

• Implement data quality, schema validation, lineage, and observability.

• Optimize performance, scalability, and cost across data workflows.

AI-Enabled Data Engineering :

• Apply AI/ML for anomaly detection, schema drift detection, and query optimization.

• Design AI-ready data foundations supporting feature stores and ML pipelines.

• Collaborate with Data Science teams to ensure reproducible, governed ML workflows.

Automation, DevOps & Governance :

• Manage infrastructure as code using Terraform with CI/CD-enabled data deployments.

• Automate provisioning and monitoring using Python, SQL, and APIs.

• Implement enterprise-grade security, governance, RBAC, encryption, and compliance controls.

Required Skills & Experience :

• 7+ years of experience in data engineering, database engineering, or data platform development in production environments.

• Strong hands-on experience with Snowflake, including performance tuning, security, and cost optimization.

• Deep expertise with PostgreSQL and AWS RDS in cloud-native architectures.

• Proven experience designing lakehouse or modern data warehouse architectures.

• Strong understanding of Medallion Architecture, semantic layers, and analytics engineering best practices.

• Experience building and operating advanced ELT pipelines using modern tooling (e.g., dbt, orchestration frameworks).

• Proficiency with SQL and Python for data transformation, automation, and tooling.

• Experience with Terraform and infrastructure-as-code for data platforms.

• Solid understanding of data governance, observability, and reliability engineering