Pankaj Yadav

About Pankaj Yadav

Seasoned professional in database design, implementation, and administration with a strong focus on supporting critical business operations. Expertise in database architecture, performance optimization, and seamless migrations, ensuring robust and scalable solutions. Proficient in managing Oracle, PostgreSQL, and MongoDB databases across on-premises and cloud environments. Known for streamlining processes, enhancing system performance, and delivering operational efficiency. Proven leader in evaluating emerging technologies and implementing innovative solutions aligned with organizational goals.Extensive experience with cloud-based PostgreSQL platforms, including designing and operating highly available PostgreSQL architectures on AWS/Azure/GCP. Skilled in implementing managed PostgreSQL services, multi-AZ/region resilience, automated backups and point-in-time recovery (PITR), replication strategies, and disaster recovery planning. Strong focus on cloud cost optimization, performance tuning for cloud workloads, and secure database operations using encryption, IAM-based access controls, secrets management, and auditing/compliance best practices.

Experience

1. Senior Manager

   Merck Group

   Mar 2025 — Present

   As a Senior Manager – Database Operations at Merck Group, I lead global teams responsible for designing, implementing, and operating large-scale enterprise database environments with a strong focus on PostgreSQL and Oracle—across both on-premises and AWS cloud platforms.With 10+ years of experience in database architecture, engineering, and operations, I specialize in driving performance, scalability, availability, and operational excellence through PostgreSQL modernization, automation, and cloud-native delivery models. I’m passionate about building resilient platforms that support business-critical applications while ensuring security, compliance, and cost efficiency.I have successfully led strategic initiatives including:PostgreSQL migrations and modernization (on-prem to AWS, Oracle-to-PostgreSQL transformation)Cloud database operations on AWS RDS PostgreSQL / EC2-hosted PostgreSQLHigh Availability architecture, replication, and disaster recovery planning/testingDatabase observability, standardization, and automation to reduce operational overheadGovernance frameworks aligned to ITIL, audit readiness, and regulatory complianceCore Expertise PostgreSQL Administration & Engineering (Performance tuning, replication, HA/DR, upgrades) Oracle Database Administration AWS Cloud Databases (RDS, EC2, S3, IAM, backups, monitoring) Database Architecture & Design (Scalable + resilient patterns) SRE / DevOps Collaboration (Automation, CI/CD enablement, IaC mindset) Database Operations Leadership (Global delivery, process excellence, runbooks, KPIs) Capacity & Resource Planning | Cost Optimization Vendor & Stakeholder Management | Technology Roadmapping Internal Audits, Controls & ComplianceI believe in simplifying complex operations, enabling data agility, and building high-performing teams that deliver measurable business value through reliable and modern database services.

Education

• Takshshila Institute of Engineering and Technology

  Bachelor’s Degree, Electronics and Communications Engineering

  2006 — 2010

• Kendriya Vidyalaya

  Higher Seconady and Senior seconday education, Maths and Science

  1994 — 2006

Skills

• Datapump
• Data Guard
• Rman
• Goldengate
• Pl/Sql
• Capacity Planning
• Nosql
• Python
• Database Design
• High Availability
• Servers
• Oracle Rac
• Unix
• Toad
• Shell Scripting
• Cassandra
• Oracle Streams
• Performance Tuning
• Project Management
• Oracle Enterprise Manager
• Oracle Plsql
• Mysql
• Team Management
• Data Migration
• Visual Basic
• Disaster Recovery
• Oracle Database Administration
• Cluster
• Database Administration
• Sqlloader
• Oracle Asm
• Oracle