Responsibilities:

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

Package Consultant-SAP FIN FI

SAP ABAP HANA Consultant

Logistics Executive

Specialist

SAP PO

Servicenow Developer - SPM