PostgreSQL Admin

  • Anywhere
  • Posted 1 year ago

Position: Postgre SQL DBA

Location: Jacksonville, FL

Duration: Long Term

Client: BCBS

Position type: W2 and 1099



Job description:


Minimum 5 years of hands on experience as a PostgreSQL Production Database Administrator.

Expertise in database installations, upgrades, database patching and troubleshooting on both OSS PostgreSQL and EDB AS PostgreSQL

Hands-on in performance tuning, optimization and monitoring instances along with managing database & schema consolidations.

Should be able to develop , refine and monitor recurring database jobs scripts.

Should have decent knowledge in SQL and PL/PGSQL programming.

Experience in setting up of PostgreSQL for High Availability and Replication using tools available and inbuilt options like Streaming Replication, WAL Replication, EFM, etc…

Hands-on experience in building and managing replications and failover scenarios. Good understanding on Query analysis and optimization Good knowledge and experience in building and defining security level

role privileges and access concepts of PostgreSQL .

Hands on experience in writing Shell scripts. Good knowledge in PostgreSQL backup and restore mechanisms.

Knowledge on Database load, stress, performance testing is desirable. Knowledge on database designing is desirable Good to have exposure on migrating databases from Oracle or MSSQL to PostgreSQL