PostgreSQL Database Administrator DBA

Recruiter
First Point Group Limited
Location
Guildford
Posted
04 Oct 2017
Closes
02 Nov 2017
Contract Type
Contract
Hours
Full Time
My client is looking for a senior hands on PostgreSQL Database Administrator (DBA) with experience in performance debugging and back up scrip preperation. The ideal PostgreSQL Database Administrator DBA will also analyze difference to DB structure based on the customer counter information document, as well as analysing segment Memory issues. The successful PostgreSQL Database Administrator DBA will also update meta-data, DB structure and ETL logic to load new counters, verify / unit test, support SIT / UAT / deployment / stability period support - ownership from development till signoff and provide Perl scripts for data requests based on 3rd party request. The main activities of the role are: 1. Analyze difference to DB structure based on the customer counter information document 2. DB related changes like performance debugging, Backup script creation. 3. Analyse the Master and Segment Memory issue 4. Provide Performance Improvement Suggestion 5. Perform DDL Changes as per the project requirement 6. Perform any DB upgrade and liaise with the Vendor teams proactively to find out the root cause of the issues 7. Capacity analysis for new data being introduced 8. Update meta-data, DB structure and ETL logic to load new counters 9. Verify / unit test, support SIT / UAT / deployment / stability period support - ownership from development till signoff on assigned ETL work 10. Perl scripts for data requests based on 3rd party request 11. Support L3 tickets 12. Answer customer questions on development design and provide additional information requested for sign-off 13. POC / implementation / support of new tools - ELK, Grafana 14. Support Operations team on DBA activities
This job was originally posted as www.jobsite.co.uk/job/959251057