Sharukh Shaikh
PostgreSQL DBA
Pune
Summary
PostgreSQL DBA with 5+ years of experience. Key Function includes Managing Postgres database for multiple clients. Handling and resolving client issues. Analyze system log and error message. Providing remote assistant to client via phone, email and team's call. Providing Step by Step instruction to problem solving. Installation of third-party Postgres tools. EDB Certified Essentials v14, v15 and Professional v16. Experience working with Community Postgres and EDB Postgres. tool. Providing 24x7 database support. Experience working on AWS Cloud.
Total Experience : 9 Years
Postgres DBA - 5 Years 6 Months
Tech Support - 3 Years 11 Months
Overview
10
10
years of professional experience
3
3
Certifications
Work History
Senior Technical Engineer - Postgres DBA
Hitachi Systems India Pvt Ltd
03.2023 - Current
- 5 + years of experience working as a PostgreSQL DBA.
- Managing, Maintaining, Configuring and Integrating PostgreSQL databases for Multiple Clients.
- Monitoring database to optimize performance issue.
- Good knowledge on PostgreSQL architectures. (Memory components, Physical Structure and Background Processes).
- Experience on community and EDB supported tools.
- Experience in different methods of Postgres installation.
- Hands-on experience with managing various HA implementations like streaming replication and logical replication.
- Working knowledge of PostgreSQL on Windows and Linux.
- Experience working on AWS Cloud.
- Interacting with customers on-site to address concerns and execute database-related tasks.
- Advise customers on hardware , performance and recommend best practices.
- Ensure that customers have appropriate maintenance in place including backups, index maintenance, consistency checks.
- Troubleshooting & solving complex performance problems.
- Experience with different types of backup and restores in Postgres.
- Works with DevOps and application team to solve recurring issues.
- Successfully performed major and minor upgrades of PostgreSQL databases, resulting in improved performance.
- Keep technical documentation up-to-date (installation, configuration, maintenance).
- Experience on DB patch activity, Timely patching as per patching schedules.
- Perform biweekly Database Backup and Restoration as per schedules and ensure data consistency.
- Perform Disaster Recovery (DR) drills to maintain database consistency across Linux and Windows platforms.
- Setting up pgbench for benchmarking and analyzing concurrent sessions and load.
- Experience working with log analyzer tools like Pgbadger.
- Installed and Configured PgBouncer for Connection Pooling.
- Installed and Configured Pgpool-II for Load Balancing, Connection Pooling and Automatic Failover.
- Installed and Configured HA tools like EFM and repmgr.
- Installed and Configured backup tools like BARMAN and PgBackrest.
- Experience working with Clients like DBeaver and PgAdmin 4.
- Sound knowledge of Databases like MongoDB and MySQL.
- Experience working with search engine like ELasticsearch.
Senior Associate - Postgres DBA
Automatic Data Processing, ADP
01.2019 - 03.2023
- Handling tickets within SLA.
- Good knowledge of PostgreSQL architecture.
- Set database parameters or specifications .
- Perform Day-to-Day regular Administration activities.
- Responsible for regular backups using logical and physical method.
- Experience with BARMAN tool for regular backup.
- Regular database maintenance activities.
- Performed major and minor up-gradation.
- Creating users and giving privileges as per business requirement.
- Providing support to application team for database related issues.
- Well versed with physical & logical replication.
- Diagnose and troubleshoot database errors.
- Re-indexing and vacuuming on database on timely manner.
- Performance tuning activity of basic level.
- Experience on open-source tools like pg-admin, BARMAN and repmgr.
- 24/7 production support for PostgreSQL environment.
Senior Associate - Tech Support
Automatic Data Processing, ADP
12.2016 - 12.2018
- Proving tech support for ADP employees.
- Password reset for internal application.
- Provides status and updates on tickets to authorized users.
- Reopens Ticket / Creates new ticket to follow up if the user indicates that the inquiry was not resolved to their satisfaction.
- Configuration of New Mail ID & Solving out problem related to users mail ID Microsoft Outlook.
- Working closely with Level 3 team for severity 1 issue.
- Interacting with user on voice call if required.
- Provided 24/7 support.
- Training new hire associate.
Associate - Tech Support
WNS
01.2015 - 11.2016
- Responsible for technical support to internal employees.
- Strong ability to problem-solve and thinking logically.
- Changing and Resetting user's password on request.
- Creating tickets for Hardware requirement.
- Coordinating with different level team.
- Ensuring all queries / issues are logged accurately on our ticketing system .
- Providing 24/7 support.
Education
Bachelor's Degree -
Pune University
04.2001 -
HSC
Pune University
06.2011
SSC
St' Patrick's High School
06.2009
Skills
EDB Advance Server
Community Postgres
Remote DBA Support
Query Tuning
PgAdmin 4
Understanding Client Requirements
Linux
AWS Cloud
Problem Solving
Database Monitoring
Database Maintenance
Hardware Tunning
Certification
PostgreSQL Advanced v16
Timeline
EDB Postgres v15 Essentials
05-2024
PostgreSQL Advanced v16
04-2024
PostgreSQL Essential v14
01-2024
Senior Technical Engineer - Postgres DBA
Hitachi Systems India Pvt Ltd
03.2023 - Current
Senior Associate - Postgres DBA
Automatic Data Processing, ADP
01.2019 - 03.2023
Senior Associate - Tech Support
Automatic Data Processing, ADP
12.2016 - 12.2018
Associate - Tech Support
WNS
01.2015 - 11.2016
Bachelor's Degree -
Pune University
04.2001 -
HSC
Pune University
SSC
St' Patrick's High School
Similar Profiles
Keval JoshiKeval Joshi
EDR & HIPS Project Engineer – Manufacture Industry at Hitachi Systems India Pvt LtdEDR & HIPS Project Engineer – Manufacture Industry at Hitachi Systems India Pvt Ltd
Faizaan Ali ShaikhFaizaan Ali Shaikh
Linux Technical Engineer at Hitachi Systems India Pvt LtdLinux Technical Engineer at Hitachi Systems India Pvt Ltd
AMAR KULKARNIAMAR KULKARNI
Senior Service Delivery Manager – Technical at Hitachi Systems India Pvt. Ltd.Senior Service Delivery Manager – Technical at Hitachi Systems India Pvt. Ltd.
Mayur PolekarMayur Polekar
Senior Technical Consultant at Hitachi Systems India Pvt LtdSenior Technical Consultant at Hitachi Systems India Pvt Ltd
Abhijeet KulkarniAbhijeet Kulkarni
Sr. Technical Leader at KPIT TechnologiesSr. Technical Leader at KPIT Technologies