PostgreSQL DBA

Title: Postgresql DBA

Exp: 4+ Years

Location: Hyderabad/Chennai/Mumbai/Bhuvneshwar



JD:

Experience in maintaining development, testing and production environments.

• Experience in POSTGRESQL Installation and Configuration, Database Backup and Recovery, SQL Tuning, User maintenance, Tablespace management, Hot Standby and Replication, PITTR and Upgradation.

• Implemented and Configured Postgresql Replication for more than one hot Standby and also handled concepts like transferring WAL to standby machines to make sure zero percent data loss.

• Experienced in Backup & Recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in time recovery.

• Monitoring and optimizing the performance of the database.

• Creation of Clone Database for Development/Testing Environments.

• Worked as a team member to provide 24x7 on-call production database support.

• Up-gradation to 9.4.12 to 9.6 and 9.6 to 10 and 11 versions changing environment server to server.

• Creating new cluster and upgrade to cluster to another Postgres sever.

• Installing and working tools & clients like pgadmin4, Putty and Mobaxterm.

• Basic knowledge in adding and deleting Database in a clone in Replication environment

• Experience in PostgreSQL Installation 9.4, 9.5, 9.6 and 10 Production support.

• Experience in Installation and creating Hot Streaming Replication (Master and Slave).

• Experience in PostgreSQL Installations, Upgradation, Migration.

• Managing cluster and more than 10 servers.