Postgresql Database Administrator

PostgreSQL DBA Roles and Responsibilities:

• Monitor the performance of the database and ensure optimum performance.
• Identify potential issues in the database to solve them early.
• Maintain backups and perform disaster recovery in case a disaster destroys the database.
• Monitor security and prevent any unauthorized access to the database
• Schedule consistent maintenance on the server
• Maintain database schema & Create the objects in the database, such as triggers, indexes, etc.
• Manage database availability
• Give best practice guidance to the development team
• Resolve any production data issues
• Tablespace management
• Role management
• Develop automation technologies to accelerate the process of data loading.
• Develop relational databases
• Ensure data integrity
• Manage user access and permissions by adding and removing users as required
• Maintain the database using different utilities. This includes using like pg_ctl and psql.

Preferred:

• Good understanding on Telecom domain
• Extensive experience PostgreSQL administrator.
• PostgreSQL certified preferred 
• Automation (Powershell/Shell scripting)
• ITIL knowledge