**Role: Postgre SQL DBA****Location: Mexico City, Mexico (100% Remote job)****Duration: Fulltime****Salary: MXN 30000-80000/Month****Languages: English Mandatory****Openings: 50+ positions****Responsibilities**:- Planning, Installation and Configuration of PostgreSQL 9.4 / 9.6/ 10/ 11/ 12/13- Experience in PostgreSQL Installations, Upgradation, Migration.- Experienced in PostgreSQL DB administration, Query tuning and DB designing- Experience in Database user roles and Security related permission.- Used pg_dump, pg_restore, pg_basebackup and other PostgreSQL built-in packages.- Up-gradation of PostgreSQL servers- Configuration of streaming replication using replication slots.- Check the load Balancing and Replication and connection.- Experience in Creating and Managing PostgreSQL Databases- Experience in Backup, Recovery and PITR- Experience in Moving Transaction Logs- Experience in Reliability and WAL- Experience in High Availability Fail over Replication.- Experience in DR Replication monitoring and configuration.- Experience in Database Performance tuning.- 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.- Experience in Installation and creating Hot Streaming Replication (Master and Slave).- Ability to detect and troubleshoot database-related CPU, memory, IO, disk space, and other resource contention issues- Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.**Salary**: $30,000.00 - $80,000.00 per monthApplication Question(s):- Have you worked with TCS in past experience? Yes/No- Are you located in Mexico? Are you a citizen of Mexico?- what is your current salary and how much is your expected salary?**Experience**:- PostgreSQL: 4 years (required)**Language**:- English (required)