*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)