Enhancesys - Database Administrator - PostgreSQL (3-4 yrs)

Job Description :

We are looking for a PostgresSQL DBA with proven experience in database administration of huge databases.

The candidate should have 4-5 years of experience in administration and performance tuning of PostgresSQL databases. Experience on MongoDB administration will be an added advantage

Responsibilities :

- Installation and setting up the PostgresSQL database in the customer environments.

- DR Replication monitoring and configuration

- Implementing security practices and policies as per the organization guidelines and customer recommendations

- Setting up processes to monitor the database metrics and trigger alerts.

- Immediate act on the alerts with minimal business impact

- Design recovery strategies to handle unforeseen database crashes and implement them when required

- Periodical audits on database objects and propose recommendations

- Set up regular backups as per the backup policies and participate in mock restoration activities.

- Installation and setting up the PostgresSQL databases in the in-house development environments.

- Writing shell script for PostgreSQL

- Database Performance tuning

- Checking alert logs

- Should be available on demand to solve unforeseen database issues at odd hours.

Requirements :

- Graduate/Post-Graduate, preferably in computer science.

- Should be articulate, resourceful and keen listener.

- Should have good communication skills.

- Should have managed huge PostgresSQL databases

- Preferable to have working experience in managing MongoDB