Postgresql Database Administrator

Duration: 6 months initial

Rate: £350/day (inside IR35)

Location: Mainly remote. Occasional travel to Reading area.

The team is re-platforming a complex legacy Java application that uses an Oracle database running on premise to run in GCP using Cloud SQL storage provided by GCP (likely to be Postgres).

We require an experienced Postgres DBA to assist the transfer of the Oracle database to the Cloud SQL. The DBA must have expertise with understanding how schemas are configured in Oracle, including stored procedures/functions or other proprietary features of the Oracle RDBM system and ideally also experienced in either Postgres or MySQL. The DBA will also ideally have experience identifying and rectifying performance issues with SQL queries that we could encounter as part of the transition.

Mandatory Skills:

- Migrate from Oracle to Postgres

- Perform Postgres DB activities such as creating databases, configuring schemas, managing users, roles, and grant permissions

- Experience working with PL/PGSQL

- Assist in migrating the Oracle DB to Cloud SQL

- Familiarity with the GCP environment is preferred

- Knowledge of AWS is also beneficial

- Understanding of Point n Time Recovery (PITR) and High Availability (HA)

- Experience using tools like PgAdmin and/or DBeaver

- Write db objects (functions, triggers, procedures etc.) using PL/PgSQL

- Understanding of Postgres database architecture, including databases, schemas, roles, users, datafiles, logfiles, and configuration files

- Working knowledge of creating and managing database roles, users, grants, and permissions

- Experience creating and managing databases, schema, and schema objects like tables, views, triggers, functions etc.

- Familiarity with Gitlab, JIRA, Confluence, Miro, and similar collaboration tools

- Assist developers with performance tuning

- Some knowledge of Oracle is required for data migration from Oracle to Postgres

- Working knowledge of Data Migration Services (DMS) like migration workspace, db connections profiles, and DMS tasks processes in GCP

- Good practice in documentation of processes using Confluence is desired but not mandatory Read more