PostgreSQL Database Administrator

Title: PostgreSQL DBA Duration: 12+ Months Location: Springfield, GA (onsite) Job Description: Should possess more than 5+ years of experience as a dedicated PostgreSQL DBA and Developers. Designing and developing PostgreSQL Schema user and role with user security management Design and develop stored procedures, functions, views and triggers  Debug and tune PostgreSQL query and PostgreSQL SQL Performance engineering Design, implement and maintain database objects (tables, views, indexes, and database security Experience working with Pg_dump/PSQL/Pg_Ctl/Pg_repack/Vacuum and Analyse process/Index and partition implementation Experience Monitoring Database with PgAdmin Experience Monitoring PostgreSQL Jobs and fixing the Job failure if any Experience in PostgreSQL Performance Improvement by tuning stored procedures, functions or Jobs or tune postgresql.conf configuration parameter setting to improve overall DB performance tuning. Monitor and administration of PostgreSQL Db server in Linux and windows platforms Knowledge on PostgreSQL DB Installation and Upgrades of DBs Analyze and develop strategies and approaches to import and transfer data between source, staging, and destinations server Test and prepare ETL processes for deployment to production and non-production environments Job Type: Contract Pay: $55.00 - $60.00 per hour Expected hours: 40 per week Experience: PostgreSQL: 6 years (Required) Database administration: 6 years (Required) Oracle: 6 years (Preferred) Work Location: On the road