Summary
Overview
Work History
Education
Skills
Languages
Certification
Disclaimer
Timeline
BusinessAnalyst

Munir Ahmed

New Delhi

Summary

An Oracle and PostgreSQL DBA with more then 7 years of experience in database administration, installation & configuration of PostgreSQL & Oracle databases, performance monitoring, architecture, connectivity.

Overview

8
8
years of professional experience
1
1
Certification

Work History

PostgreSQL DBA

NISG
New Delhi
10.2021 - Current
  • Coordinated with software development teams for fixing database related issues .
  • Assisted in designing and management of PostgreSQL database schemas and tables.
  • Conducted detailed analysis of business process and application requirements to prepare design documents.
  • Supported technical team members in installation, configuration and maintenance of PostgreSQL servers running on RHEL 7
  • Implemented High Availability via Streaming Replication.
  • Implemented Automatic Failover via REPMGR.
  • Generating monthly reports for business stakeholders to analyze.
  • Participated in planning and implementation of data backup, recovery and security procedures.
  • Backing up and restoration of database objects like tables.
  • PostgreSQL Cluster backup and restore.
  • Implemented connection pooling for production database setup via PGPool.
  • Implemented database job scheduling via PG_CRON utility.


PostgreSQL Database Administrator

Conneqt Business Solutions
New Delhi
04.2021 - 10.2022
  • Installation of PostgreSQL RDBMS software on Windows & Linux machines.
  • Refreshing the Testing environment with the latest data from production.
  • Provided database SQL query outputs to various stakeholders on demand.
  • Prepared monthly report for business heads.
  • Populated database tables with data from CSV files.
  • Backing up and restoration of database objects like tables and schemas.
  • Setup the entire database cluster afresh using data provided.
  • Proven skills to communicate effectively with all sorts of stakeholders.
  • Implemented PostgreSQL streaming replication for main production database.



Oracle and PostgreSQL Database Administrator

Impact InfoTech
NOIDA
10.2018 - 11.2020

  • Project: FINNONE and Lidha Didha
  • Client, , Religare Broking Services,Religare Enterprise Limited,Religare Finvest Ltd.
  • Created users & privileges with appropriate roles and levels of security
  • Maintaining backups of databases and their scheduling on crontab
  • Interaction with client/users on various issues
  • Tablespace administration including review and expansion
  • Created Authorizations and Profiles based on the Job Profile
  • Patching the application from back end on direction of application development team
  • Creation of database links
  • Performing backup of database and its subsets using DATAPUMP utility
  • Providing sign off on the various plan of actions provided by application development team
  • Patching the database in response to the suggestions made by global oracle support team
  • Coordinating with Oracle global Support Team in response to various Service requests raised in response to various issues plaguing the database
  • Executing and spooling the output of various queries provided by both business team and application development team, which needs to be run on the database in order to fulfill certain business requirements
  • Generating AWR reports and analyzing them
  • Running SQL tuning advisor to tune the performance of a query & accepting the recommendations made by the SQL TUNING ADVISOR
  • Running the End Of Day (EOD) & Beginning Of Day (BOD) process
  • Performing application patch deployment in response to the requirements of the Middleware team
  • Having limited knowledge of Oracle Middleware
  • Backing up of PostgreSQL database clusters and to send them to storage according to the retention policy.
  • Creating of PostgreSQL database tables and populating them with the data provided in CSV files.
  • Killing locks in PostgreSQL.
  • Implemented streaming replication in PostgreSQL.
  • Setup both Synchronous and Asynchronous replication in PostgreSQL.



Oracle & PostgreSQL DBA

Punjab National Bank Housing Finance
NOIDA
08.2018 - 09.2018
  • Handling both Oracle & PostgreSQL databases
  • Monitoring regular Oracle & PostgreSQL scheduled backups
  • Running database backups on failure
  • Applying application patch on request of application team after getting approval
  • Using Data Pump to carry out export backup of database or of a particular schema as demanded by client.
  • Using pg_dump & pg_restore TO BACKUP AND RESTORE PostgreSQL database objects
  • Creating a schema and granting it necessary privileges when demanded by client
  • I have taken part in database migration activity to transfer the main database of the organization from one server to another and did all the prerequisites to enable smooth transition of the database
  • Sending database performance report to the client at the end of each day.

Database Administrator

3i-Infotech Pvt. Ltd.
Delhi
06.2017 - 06.2018
  • ICMS (Integrated Cargo Management System, Monitoring database in a 24x7 environment to meet client SLA
  • Prepare and send daily database check status and report as well
  • Database backup & recovery through RMAN
  • Backing up database through export and import utility
  • Maintenance and monitoring of Database and its listener
  • Creation ,allocation and reorganization of tablespaces
  • User creation and providing them with necessary roles and privileges & quota according to the requirement
  • Monitoring user sessions for locking and killing the locks whenever they arise
  • Schema refresh using imp/exp utility as per requirement
  • Creating redundant copies of database backups on a daily basis
  • Creating tables on demand and loading bulk amount of data into them using SQL loader
  • Loading bulk data into existing database tables using oracle sql loader at the end of every month.
  • Maintenance of One PostgreSQL database cluster.

Junior Database Administrator

Xperia technologies pvt.Ltd
06.2015 - 06.2017
  • Oracle 11g
  • Responsibilities
  • Installation of Oracle RDBMS on Linux(red hat) and windows OS
  • Taking backups of the database using RMAN
  • Escalating the database issues to the next level in hierarchy
  • Monitoring oracle alert logs for potential problems
  • Preparing and sending database check report on a daily basis
  • Movement of database backups in order to make redundant copies in case of failures
  • User creation and schema management
  • Manual database creation in response to requirement
  • Monitor the database operations and respond to queries from application team
  • Providing the users login rights and other credentials based on requirement.

Education

Bachelor of Technology - Computer science & engineering

Cochin University of Science & Technology
Kochi, Kerala
11.2015

12th - Physics, Chemistry, Maths, Biology, Mathematics

CBSE
New Delhi,India
05.2009

Matriculation -

St. Paul's School
New Delhi
05.2005

Skills

  • Operating system: LINUX , WINDOWS & IBM AIX
  • Database known: PostgreSQL(COMMUNITY VERSION), EnterpriseDB, Oracle 12c,Oracle 11g Enterprise Edition
  • Administration tools: Oracle Sqlplus ,toad ,putty ,Winscp , PGADMIN ,Linux & Unix CRONTAB, PostgreSQL PSQL
  • Utilities: PG_DUMP, PG_CRON,PG_DUMPALL ,PG_RESTORE ,EXP/IMP,DATAPUMP, Recovery Manager(RMAN),TFA,Oracle Data Guard, Oracle RAC
  • Languages: Oracle SQL, PostgreSQL SQL
  • Other: MS OFFICE, BMC, EMEditor

Languages

English
Elementary
A2
Hindi
Bilingual or Proficient (C2)
Japanese
Intermediate (B1)

Certification

Oracle Database 11g Certified Associate

Disclaimer

I hereby declare that the details and information given above are complete and true to the best of my knowledge.

Date: 15-Nov-2022

Place: New Delhi

Name: Munir Ahmed


Timeline

PostgreSQL DBA

NISG
10.2021 - Current

PostgreSQL Database Administrator

Conneqt Business Solutions
04.2021 - 10.2022

Oracle and PostgreSQL Database Administrator

Impact InfoTech
10.2018 - 11.2020

Oracle & PostgreSQL DBA

Punjab National Bank Housing Finance
08.2018 - 09.2018

Database Administrator

3i-Infotech Pvt. Ltd.
06.2017 - 06.2018

Junior Database Administrator

Xperia technologies pvt.Ltd
06.2015 - 06.2017

Bachelor of Technology - Computer science & engineering

Cochin University of Science & Technology

12th - Physics, Chemistry, Maths, Biology, Mathematics

CBSE

Matriculation -

St. Paul's School

Oracle Database 11g Certified Associate

Similar Profiles

  • Adarsh Shukla

    Adarsh ShuklaAdarsh Shukla

    Kubernetes Developer (DevOps Engineer) at National Institute of Smart Governance (NISG)Kubernetes Developer (DevOps Engineer) at National Institute of Smart Governance (NISG)

    View Profile
  • Karan Tandon

    Karan TandonKaran Tandon

    Senior Manager at National Institute of Smart Governance, NISGSenior Manager at National Institute of Smart Governance, NISG

    View Profile
  • Bikash Ranjan Swain

    Bikash Ranjan SwainBikash Ranjan Swain

    IT Manager at National Institute For Smart Government (NISG)IT Manager at National Institute For Smart Government (NISG)

    View Profile
Munir Ahmed