Oracle DBA – Postgres SQL/Hybrid – Leeds/6 months

Leeds, Yorkshire
iBSC

My customer is searching the market for a Oracle DBA Admin professional with strong Postgres SQL experience, also must have experience in the GCP environment, knowledge of using the Postgres SQL database/instance in GCP ( Google Cloud Platform) This role is a hybrid with 3 days per week onste in Leeds, for a 6 months rolling contract inside IR35.

• Job Title: Oracle DBA Admin
• Location: Leeds x3 days per week
• Duration: 6 months
• Inside IR35

Required Skills:

Experience in the GCP environment, knowledge of using the Postgres database/instance in GCP ( Google Cloud Platform).
Database Backup and Restore process using both PSQL and GUI tools like PgAdmin and DBeaver etc
Understanding about PITR ( Point n Time Recovery) and HA ( High Availability) and experience in using tools like PgAdmin and/or DBeaver
Writing DB objects (function, trigger, procedures etc.) using PL/PgSQL.

Understanding Postgres database architecture, database, schemas, roles, users, datafiles, logfiles, config files etc

Knowledge about creating and managing database roles, users, grants and permissions and creating and managing databases, schema, and schema objects like tables, views, triggers, functions etc
need to have experience in using the tools like Gitlab, JIRA, Confluence, Miro etc
Helping developers with performance tuning.

Some Oracle knowledge is also required as data migration is from Oracle to Postgres
Knowledge about DMS(Data Migrations Services) like migration workspace, DB connections profiles and DMS tasks etc. processes in GCP

Good to have knowledge about DVT (data Validation tool) but not mandatory and good practice in documentation of processes using confluence.