Aashish Pandey
Navi mumbai
Summary
Accomplished Senior Product Support Engineer with a proven track record at EnterpriseDB Software Services , specializing in PostgreSQL and MSSQL database administration holding expertrise of more than 5 years. Expert in performance tuning, replication management, and high availability solutions, demonstrating strong analytical skills and a commitment to achieving customer satisfaction. Skilled in collaborating with development teams to enhance database security and efficiency. Including Cloud native technologies, Kubernetes engine and docker platform.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Senior Product Support Engineer
Enterprisedb software PVT LTD
Pune
07.2022 - Current
- Postgres Experience Includes:
Installation, Upgrades, Maintenance and Administration PostgreSQL from 9.5 to 16.x. - Experience of PostgreSQL administration on Linux and Windows.
Managing replication and failover in a cluster of PostgreSQL servers using EDB EFM tool. - Administering large PostgreSQL databases ability to do performance tuning.
Experience of backing up and restoring PostgreSQL database. - Monitoring databases to optimize database performance and diagnosing any issue. Performing vacuum and analyze on the high volume tables and databases which will remove the bloats.
- Proactive managing replication like Streaming replication and logical replication using xDB. Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by deadtuples.
- Monitoring the bloat report on every table and performing maintenance with minimal downtime.
- Administering the database security, creating users, granting roles, privileges to users.
- Hands-on experience with Database schema creation and performance tuning and ongoing support. Work experience in migration from Oracle/MySQL to PostgreSQL using EDB MTK.
- Deploying different extensions on database server
Deployment of external tools on the top of PostgreSQL-Server (pgpool,pgbouncer,pgbadger). - Hands-on experience with EDB Backup & Recovery Tools like Barman,Bart,Pgbackrest
- Hands-on experience with EDB Postgres Enterprise Manager [ PEM ] Tool PGADMIN
- Hands-on experience with streaming replication, PostgreSQL logical replication. Experience on Patroni etcd high availability tool
Configured Patroni using etcd to achieve high availability.
Manage & Monitor Patroni. - Closely working with customer and EDB development teams to find the root cause of DB crash using dump.
MSSQL DBA
Capgemini technology IND LTD
Navi Mumbai
07.2019 - 06.2022
- Manage SQL Server databases
- Configure and maintain database servers and processes
- Monitor system's health and performance
- Ensure high levels of performance, availability, sustainability and security
- Analyze, solve, and correct issues in real time
- Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Provide 24x7 support for critical production systems
- Perform scheduled maintenance and support release deployment activities after hours
- Handled customer complaints calmly and professionally, resolving customer issues in a timely manner
Education
Bachelor of Science - Computer Science And Programming
Ramniranjan Jhunjhunwala College ( Mumbai Uni.)
Mumbai 05-2019
Skills
- RDBMS- EDB & Postgresql , MSSQL , ORALCE
- MongoDB, MariaDB
- Tools - BMC remedy, SDM 129, ServiceNow, SalesForce tool
AWS,Azure,Oracle Cloud,GCP [Learning]
- DEVOPS- Git,JIRA,Docker, Kubernetes,CNP,CNPG
- Scripting - Shell, Yml for Ansible,
Certification
- PostgreSQL PRO 14,15,16.
- OCI - oracle cloud
- CNPG kubernetes - A cloud guru
Languages
Hindi
First Language
English
Proficient (C2)
C2
Marathi
Proficient (C2)
C2
Timeline
Senior Product Support Engineer
Enterprisedb software PVT LTD
07.2022 - Current
MSSQL DBA
Capgemini technology IND LTD
07.2019 - 06.2022
Bachelor of Science - Computer Science And Programming
Ramniranjan Jhunjhunwala College ( Mumbai Uni.)
- PostgreSQL PRO 14,15,16.
- OCI - oracle cloud
- CNPG kubernetes - A cloud guru
Similar Profiles
Juhi UbnareJuhi Ubnare
Senior HR Generalist at EnterpriseDB Software India Pvt LtdSenior HR Generalist at EnterpriseDB Software India Pvt Ltd
Ranjeeta MuleyRanjeeta Muley
AP Manager Global at EnterpriseDB Software India Pvt Ltd.AP Manager Global at EnterpriseDB Software India Pvt Ltd.
Mangesh KolurwarMangesh Kolurwar
Senior Commission Analyst at EnterpriseDB Software India Private LimitedSenior Commission Analyst at EnterpriseDB Software India Private Limited