Job title: postgresql dba
job location: mexico city, mexico
job description:
a postgresql dba is an expert in managing the postgresql database system.
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