• Create the objects in the database, such as triggers, indexes, etc.

• Monitor the performance of the database and ensure optimum performance.

• Identify potential issues in the database to solve them early.

• Hands on in PostgreSQL migrations from other RDBMS

• Hands on in PostgreSQL Native replications

• Knowledge on Auto Vacuum jobs, and Customized VACUUM on certain tables and columns.

• 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.

• 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 pg_ctl and psql.

• Database Recovery

• Installation and Maintenance

• Database Administration (Backup's; Performance Tuning; Security; Data Modelling)

• Troubleshooting

• Knowledge and hands on with Sheel and Perl scripting

• Available for 24x7 support and able to handle the P1/P2 MI calls.

• Abiding to ITIL v4 framework