PostgreSQL DBA Derivco Isle of Man

https://www.linkedin.com/jobs/view/2838460541
About the job

As a PostgreSQL Engineer / DBA you will be heavily involved in day-to-day
technical delivery and solution design of our relational data systems,
together with a small team of architects and software engineers.

Responsibilities:

- Support the full project life cycle - to include any of consulting,
discovery, analysis, architecture, design, documentation, building,
migration, automation and production-readiness activities
- Support project engagements, work collaboratively with other team
members, communicate effectively, and foster team success
- Maintain platforms (Postgres)
- Maintaining and creating new scripts to automate daily tasks
- Produces automation and tooling solutions which includes scripting and
automation of production deployments and tools
- Environment support and maintenance
- Trouble shooting performance issues
- Technical documentation
- Maintaining standard operating procedures
- Hot-seat Support
- Capacity Reporting and maintenance include dashboard creation
- Driving Operational efficiency
- Creating internal project to improve process or operations

Training and/or Certification:

Certified in any one of the following:

- Splunk basic training
- PostgreSQL 11 Associate Certification

**Experience in the technology in a similar role

Preferred Skills:

· Experience with NoSQL databases (e.g. Apache Cassandra) and NoSQL support
in PostgreSQL

· PSQL experience, including stored procedures, functions, triggers, and
views.

· Familiarity with PostgreSQL support for JSON

· Demonstrable experience working with huge, interdependent, complex
datasets and data structures.

· Experience in Azure

· Working knowledge of both Red Hat Enterprise Linux and Windows

· Experience with operating system scripting languages (e.g.: Ansible,
PowerShell)

· Worked on large complex projects

· Good Documentation

· Knowledge on Splunk, Elastic, Grafana

· Tools: DBeaver, MobaXterm, PgAdmin

Duties:

· Postgres Administration ensure jobs are running optimal

· Error log reporting and investigations

· Metric Monitoring

· Daily Administration of emails and attending meetings

· Postgres optimizations

· Postgres future improvements are documented including compiling of
runbooks

· Capacity planning

· Extraction of Non PII data to assist development & Support teams

· Assist in Test Centre Database troubleshooting (TC’s)

· Support, Hot Seat, Standby and walk in investigations

· Ensure 30% of allocated hours are focused on Reboot Initiatives.

(Reboot being departmental improvements & enhancements.)

*Don't know all of the above, don't worry! We have a healthy training
budget to get you up to speed!*

Derivco offers employees a great range of benefits including free lunches
daily, health insurance, gym membership, social events and many more. Not
only do we offer these benefits but also a great work environment.