SysMind LLC is a staffing and recruiting company.
Position: PostgreSQL DBA
: Cincinnati OH
: 12+ Months
s & Responsibilities
• 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.