PostgreSQL DBA

Job Title:PostgreSQL DBA

Location:Cincinnati, OH

Duration:Full Time

Skills Required:

Candidate should be able to Installing PostgreSQL on Linux / Unix and Windows OS platforms. Must be able to complete the hardening of the instance installed with post installation setup

Candidate should have experience to setup, initialize cluster and managing the cluster platform for PostgreSQL environment.

Must be able to fix the routine issues like Startup failures, client connection failures

Must have experience to manage the security setup for the entire PostgreSQL environment and have end to end knowledge on access management

Must implement the industry best practices to comply company security policy in line with the PostgreSQL environment.

Having knowledge on EFM and PEM will be added advantage

Working on EDB Postgres will have preference.

Must have understanding of end to end PostgreSQL architecture

Understanding on Database, catalogs, table space, File layout and Physical storage

Must have complete understanding on setup, maintenance of replication at PostgreSQL.

Should have complete understanding on Backup and recovery process also must have experience on Performing an SQL Dump and Restore.

Must have Performance Tuning experience.

Must be able to manage and setup Warm Standby Servers for High Availability.

Must be dynamic and should be able to manage engagement from application team.