04] FirstRand Services pvt ltd (FRSPL)
Momentum Metropolitan Insurance (MMI) South Africa
2nd April 2020 – Current
Being a Lead Consultant, Leading a team and Providing DB support with Postgres on Linux and windows servers.
Responsible for all DB Administration and user management
Installation of Postgresql Database using all techniques on Linux and windows as well.
Handling Databases upto 5 TB.
Provide L3 and L2 support to the project.
Handled performance issue using pg_stat_activity, vacuuming, Explain analyze.
Using ticketing tool ARCON.
Maintaining the database Scheduled Backup and Restore procedures.
Maintaining Postgresql streaming replication including Installation & configuration
Managing Upgradation of the Db in Major and Minor in both the form.
Monitoring server characteristics (Disk, CPU, and memory usage, Load Average etc
Attending daily and weekly business status meetings with senior management and providing status reports and resolutions.
• Providing support for 47 Postgres Servers
• Creating MIS reports for senior management and client.
Postgresql 9.x, 10.x and 11.x