Ajeet Pandey
New Delhi
Summary
Dedicated and seasoned Database Specialist with extensive expertise across multiple database technologies, showcasing expertise in AWS Database Platforms and leading cross-functional teams to innovate and streamline database migrations. Excelled in architecting cloud solutions and fostering professional growth among team members, demonstrating both technical mastery and exceptional leadership.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Senior Cloud Infrastructure Engineer II
McKinsey & Company
Gurgaon
09.2020 - Current
- As the Service Delivery Lead managing the database platforms team, leading a team of multi-skilled engineers (MS SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, AWS RDS/Aurora).
- Lead architecture design, development, testing, and support of database migrations (on-premises to cloud) and new product implementations.
- Optimized governance processes for lifecycle management of databases.
- Developed efficient cross-regional support services, addressing database platform needs of product teams.
- Lead Snowflake platform engineering, services delivery to deliver and meet firm cloud data platform requirements.
- Manages product teams and vendor relationships, and ensures influence on the vendor and product roadmap.
- Acts as a consultant for database platform best practices on reliability, resilience, and sizing, scaling.
- Organized data and dashboards to support stakeholder reporting.
- Guided teams in integrating knowledge of latest database trends and technologies.
- Guided colleagues in their professional development.
- Led the adoption and implementation of DevSecOps practices for cloud-native and on-premises platforms.
- Assess and plan database platform capacity and licensing requirements.
- Thought partnership with cross-functional product, infrastructure, and platforms teams reduces delivery time and develops innovative solutions.
Database Administrator
Gartner
Gurgaon
03.2018 - 09.2020
- PostgreSQL server setup on-prem and AWS RDS
- Creating and managing databases on PostgreSQL
- Configure PostgreSQL to accept connections
- Backup and restore for PostgreSQL using pg_dump utility
- Update statistics and Reclaim obsolete row space from tables
- Migrating Mongodb replica set to new Hosts/Datacenter
- Migrating Mongodb to AWS EC2 instance using mongodump
- Stetting up MongoDB replicaset
- Monitoring and maintenance of Mongodb
- Setting up DR for AWS oracle RDS instance in another region(using golden gate)
- Working with Developers on performance issue
- Enable encryption at rest and in transits for AWS databases
- Setup could watch metrics and alarms to monitor AWS resource
- Setup a AW lambda function using Python code to get alerts for database alert log
- Working with Developers to deploy jobs (Procedure, MViews )in production databases
- Database maintenance tasks (Tablespace, user access, DB mount points), acknowledging OEM alerts, working on Mview refresh failure issues
- Adding new targets to OEM
- Migrating Oracle database from one data center to another
- Setting up AWS RDS resources using terraform and jenkins jobs using Github repository
- Maintaining Oracle, MYsql RDS,Mongo instances on AWS
- Oracle database Migration from on-premise to EC2 instances and AWS RDS instances
- Setting up oracle standby database for DR
- Performing database refresh from production environments
- RMAN configuration for backup, restoring database on remote servers
- Applying Oracle recommended patches
- Oracle Binaries installation, database setup using DBCA
- Manage Mysql database users creation,granting access
- Restoring RDS on AWS from snapshot backup
Specialist
HCL Technologies (Project: Shared Services)
Noida
02.2013 - 03.2018
- Setup a RDS(Oracle and Mysql) instances on AWS
- Migrating Oracle Database (using export import )from on-premise servers to cloud (RDS or EC2 instances)
- Setup an EC2 instance and perform the server hardening for databases installation
- RMAN configuration and backup
- Creating and managing databases on PostgreSQL
- Database Backup (hot & cold)
- Managing basic scripts for Mount point housekeeping
- Investigating ORA errors checking the alert log/ Generating AWR report
- Database upgrade, applying Oracle recommended patches
- Managing inbound and outbound connection for the cloud resourses
- Managing cloud user and assigning correct roles to them
- Setup jump servers to limit inbound connection to database servers
- Performing Oracle database upgrade, patching
- Data Guard, make sure primary and secondary database are in Sync
- Access/Manage S3 bucket using CLI tool(Uploading and downloading data)
- Taking Snapshot backup
- Adding EBS volumes to EC2 instances
- Manage Mysql database creating users,granting access
- Mysql database backup using Mysqldump
- Setup Replication for Mysql database(master slave)
Database Administrator
HCL Technologies ( Project : Deutsche Bank)
02.2013 - 12.2016
- Export/Import of schema and full Database, schemas, tables
- Oracle Binaries installation, database setup using DBCA and response file
- Install Oracle grid binaries and setup ASM
- RMAN configuration and backup
- Database Backup (hot & cold)
- Managing basic scripts for Mount point housekeeping
- Investigating ORA errors checking the alert log/ Generating AWR report
- Database upgrade, applying Oracle recommended patches
- System administration functions like creating users, creating roles, profiles, creating roles, granting roles and privileges
- Data Guard, make sure primary and secondary database are in Sync
- Troubleshoot data guard related issue
- Database connectivity issue, Listener configuration
- Monitoring the Database growth and the Tablespace size, Undo and temp memory management
- Session related issue (Max sessions/processes limit Reaching/Reached session kill)
Education
B Tech - Electronics and Communication
Lovely professional University
Phagwara01.2012
Intermediate - 12th CBSE
DAV Centenary Public school
Delhi01.2008
Skills
- Oracle
- MYSQL
- AWS Database Platforms
- Backup and Restoration
- MongoDB
- GITHUB/GitHub actions
- Jenkins
- Terraform
- Capacity planning
- AWS expertise
- Database administration
- Disaster recovery
- PostgreSQL
- AWS RDS
- Database migration
- AWS DMS
- Snowflake
Certification
- AWS Certified Solutions Architect - Professional, 12/2020 to 12/2023
- AWS Certified Solutions Architect - Associate, 11/2017 to 11/2020
- AWS Certified Database - Specialty, 12/2019 to 03/2023
- AWS Certified SysOps Administrator - Associate, 03/2021 to 06/2024
- SnowPro Core Certification, 02/2024 to 01/2026
- SnowPro Advanced: Architect 02/24 to 01/26
Timeline
Senior Cloud Infrastructure Engineer II
McKinsey & Company
09.2020 - Current
Database Administrator
Gartner
03.2018 - 09.2020
Specialist
HCL Technologies (Project: Shared Services)
02.2013 - 03.2018
Database Administrator
HCL Technologies ( Project : Deutsche Bank)
02.2013 - 12.2016
B Tech - Electronics and Communication
Lovely professional University
Intermediate - 12th CBSE
DAV Centenary Public school
Similar Profiles
Tabassum KhanTabassum Khan
Assistant Manager at McKinsey & Company – McKinsey Knowledge CenterAssistant Manager at McKinsey & Company – McKinsey Knowledge Center
Rama RamaswamiRama Ramaswami
Senior Editor, Global Publishing at McKinsey & CompanySenior Editor, Global Publishing at McKinsey & Company
Piper WeinkaufPiper Weinkauf
Client Service Risk Americas S&OP Manager at McKinsey & CompanyClient Service Risk Americas S&OP Manager at McKinsey & Company
KOMAL CHITKARAKOMAL CHITKARA
Acting Team Lead/Senior HR Administrator at Mckinsey & CompanyActing Team Lead/Senior HR Administrator at Mckinsey & Company
Ankit MishraAnkit Mishra
Assistant Revenue Manager at JüSTa Hotels & ResortsAssistant Revenue Manager at JüSTa Hotels & Resorts