Position: Postgre SQL DBA
Location: Jacksonville, FL
Duration: Long Term
Position type: W2 and 1099
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