PSQL Database Administrator

Brief DescriptionWe are looking for experienced individuals who would like to join a dynamic team of IT service providers. Currently we are looking for experienced candidates in providing L2 support in incident management and problem management.  Job Description Level 2 support on Incident and problem managementPostgreSQL DB/SQL Performance Analysis and TuningManaging PostgreSQL Database Security Audit violations & resolving themUser maintenance, Tablespace managementMonitoring and optimizing the performance of the PostgreSQL database.Patch management and highlight teams regarding future enhancements & releases pg_dump/pg_dumpallandpg_restoreExpertise : 3- 5 years of DBA (IT) experience  Preferred SkillsOn subject Line “Please mention the Post you are applying with Experience / Current Location Preferred SkillsInstallation and Configuration, perform maintenance activity in databaseDatabase upgradations and migrationDatabase reconciliation mechanismsDatabase Migration, Upgrades to be compliant with organization standardsMonitoring and optimizing the performance of the PostgreSQL database.Database Installation and Configuration, Database Backup and RecoveryBackup and Recovery, Hot Standby and Replication, PITR and UpgradationExperience in Installation and creating Hot Streaming Replication (Master and Slave)Problem solving and good analytical skills. Communication, teamwork, and negotiation skillsCluster configuration, Master-SlaveBackup configuration using Veeam and/or by BarmanDR Replica, by Barman or otherPhysical streaming replication and Logical replicationData masking and encryptionUnderstand the RTO/RPO requirements for the application & databases to define the database backup and restore policySQL TuningHot Standby and ReplicationPostgreSQL Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards.