PostgreSQL Database Administrator

PostgreSQL Database Administrator will be providing technical and operational support for activities of Database Servers including installation troubleshooting performance monitoring tuning and optimizing
Three 3 years of experience with PostgreSQL version 9 up till latest version hosted on Azure Postgre SQL platforms Three 3 years of experience migrating MS SQL Serer databases to PostgreSQL deploying databases in containers Install monitor and maintain PostgreSQL implement monitoring and alerting implement backup and recovery processes provide system and SQL performance tuning Two 2 years of experience as a PostgreSQL database administrator deploying PostgreSQL databases on Cloud platforms such as Azure Cloud Environment Programming languages such as UNIX shell scripting PLpgSQL Python or Perl experience Two 2 years of experience with PostgreSQL native tools like pgAdmin pgAudit pgBadger pgPool pSQL Estimate PostgreSQL database capacities develop methods for monitoring database capacity and usage Must have experience in PostgreSQL database architecture logical and physical design automation documentation installs shell scripting PL SQL programming catalog navigation query tuning system tuning resource contention analysis backup and recovery standby replication etc Must have strong understanding of command line and server administration Participate in application development projects and be responsible for the database architecture design and deployment Participate in the creation of development staging and production database instances and the migration from one environment to another Responsible for regular backups and recovery of databases Responsible for regular maintenance on databases eg Vacuum Reindexing Archiving Responsible for proactive remediation of database operational problems Responsible for Query tuning and preventative maintenance Ability to proactively identify troubleshoot and resolve live database systems issues