Desired Competencies (Technical/Behavioral Competency)Must-HavePostgreSQL Replication, Cluster, Performance tuning, Pgadmin utilityGood-to-HaveMigration experience, Basic knowledge in Oracle, SQL, Mongo DB, Cloud Platform (GCP, Alibaba)SNRole descriptions / Expectations from the Role 1Able to handle mission critical production environment in Linux and windows platform, implementing and provisioning the databases in Postgres 11, 12 on 24X7 shifts2Extensive experience in PostgreSQL Replication Cluster, Performance tuning, PEM, Patching, pg dump and CRUD operations3Experience in POSTGRESQL Installation and Configuration, Database Backup and Recovery, SQL Tuning, User maintenance, Tablespace management, Hot Standby and Replication, PITR and Upgradation4Handling database with client expectation with High-availability knowledge, able to implement Service improvement plan and automation
