MOHAMMAD ALI KHAN PATAN
Database Admin
KOLKATA
Summary
- Experienced and results-driven Database Administrator with over 3 years of hands-on experience in PostgreSQL and SQL Server database administration.Proficient in database architecture, maintenance, and performance tuning, with a proven track record of effectively managing production environments. Skilled in monitoring, troubleshooting, and optimizing database systems to ensure optimal performance and reliability. Strong analytical and problem-solving abilities, coupled with excellent communication and interpersonal skills.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
Postgres DBA
Genex Corporate Services Pvt. Ltd
08.2023
- Provide 24x7 support for production PostgreSQL Server databases.
- Perform database maintenance operations, backups, and restorations.
- Implement and maintain database security measures.
- Identified issues, analyzed information and provided solutions to problems
Database Administrator
Diamond Infotech Pvt Ltd
12.2022 - 08.2023
- Optimized database performance by monitoring health and implementing tuning recommendations.
- Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
- Provide 24x7 support for production PostgreSQL Server databases.
- Perform database maintenance operations, backups, and restorations.
- Implement and maintain database security measures.
Database Administrator
Delfi Infotec systems
12.2020 - 11.2022
- Managed database administration tasks using MS SQL Server.
- Created, tested, and executed data management languages.
- Conducted regular database health checks and proactive measures.
Education
Bachelor of Science - CSE
Narayana Engineering College
Gudur,AP 06.2015 - 02.2020
Skills
RDBMS: PostgreSQL-13 (Certified), MS SQL Server 2016/2019
Operating System: Windows, Linux (RedHat-8, CentOS)
Programming Languages: PL/pgSQL, T-SQL
Backups: pg_dump,pg_dumpall, pg_basebackup
Tools: SSMS, Pg Admin, PEM
Other Tools: pgbench, pgbadger, pgbouncer
Roles And Responsibilities
- Database Administration using PostgreSQL-v13, MS SQL Server
- Monitoring Disk spaces on all the servers.
- General Health of the servers to identify Bottlenecks.
- Performing Database maintenance activities like Backups, Restoring, Re-indexing etc.
- Automation of alerts by configuring Database Mail.
- DB health checks & proactive measures.
- Creating customized jobs to track database growth, blockings & long running queries.
- Managing Windows/SQL Cluster environment.
- Configuring, maintenance and troubleshooting Database.
- Configuring, maintenance and troubleshooting Log shipping.
- Creating Monthly reports to the customer about the status of the databases.
- Performed regular DBA jobs like Backups, Restores, Point in time Recovery, Database Consistency Check, Index Maintenance.
- Supported 24
- Creating users and giving appropriate permissions.
- Monitor the status of maintenance Jobs.
Projects
- Disney, USA (Dec 2020 - Nov 2022): Managed PostgreSQL and SQL Server databases.
- Beltron (Bihar, Patna) & WBSDC (Kolkata) (Dec 2022 - Aug 2023): Conducted database administration tasks and maintenance activities.
- DXC, UCO Bank (Kolkata) (Aug 2023 - Present): Provide ongoing support for PostgreSQL databases.
Certification
PostgreSQL-v13 Associate Certification
Timeline
Postgres DBA
Genex Corporate Services Pvt. Ltd
08.2023
PostgreSQL-v13 Associate Certification
01-2023
Database Administrator
Diamond Infotech Pvt Ltd
12.2022 - 08.2023
Database Administrator
Delfi Infotec systems
12.2020 - 11.2022
Bachelor of Science - CSE
Narayana Engineering College
06.2015 - 02.2020