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).
The team requires an experienced Postgres DBA to assist the transfer of the Oracle database to the Cloud SQL. The DBA must be experienced with understanding how schemas are configured in Oracle, including stored procedures/functions or other proprietary features of Oracle RDBM system and ideally also experienced in either Postgres or MySQL. The DBA will also ideally be experienced with identifying and rectifying performance issues with SQL queries that we could encounter as part of the transition.
Mandatory Skills
- Oracle to Postgres DB migration
- Postgres DB activities like DB creation, schemas, user, roles, grant permissions
- Working experience with PL/PG SQL
- Postgres DBA to assist migrating the Oracle DB to Cloud
- Good to have experience in GCP environment
- AWS also will work
--> Knowledge about 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)
--> Work 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..
--> working knowledge about creating and managing database roles, users, grants and permissions
--> working knowledge about creating and managing databases, schema, and schema objects like tables, views, triggers, functions etc..
--> 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
--> working 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.
--> Good practice in documentation of processes using confluence.