Senior Database Engineer at YO It Consulting in Pune

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