Logicsoft

PostgerSQL DBA (Code: 2022PSQL1)

Currently, we are having openings for PostgerSQL DBA experience in Installation and Configuration, Database Backup and Recovery, SQL Tuning, User maintenance, Tablespace management, Hot Standby and Replication, PITTR and Upgradation  to join our team. Job Location: Delhi & NCR Region, India.

Eligibility:

  • Experience: 3 + Year
  • Education: B.Tech (CS) / MCA Degree
  • Job Location: Gurugram/Delhi
  • Job Ref code: 2022PSQL1
  • Industry: IT/ Computers – Software

Job Description:

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 24×7 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 a 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.