(Oracle + PostgreSQL + GCP + Migration)
Logistics Summary:
Location : Remote Working (onsite - maybe
once a month
or
once every 2 months ) Role Type : 6 months Rolling Contract Budget : £400 - £450 Per day all inclusive THIS PROJECT IS INSIDE IR35 Looking for someone who has hands-on experience in migrating the database from on-prem to cloud, hands-on experience in Oracle, Postgres DBA with GCP migration. Ideal Candidate Summary (All experience below is mandatory): Hands-on experience in migrating the database from on-prem to cloud. Hands-on experience in Oracle. Postgres DBA with GCP migration. Database Backup and Restore process using both psql and GUI tools like PgAdmin and DBeaver. Writing DB objects (function, trigger, procedures) using PL/PgSQL. Job Spec: 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. Understanding about PITR (Point in Time Recovery) and HA (High Availability). Work experience in using tools like PgAdmin and/or DBeaver. Writing DB objects (function, trigger, procedures) using PL/PgSQL. Understanding Postgres database architecture: Database, schemas, roles, users, datafiles, logfiles, config files. 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. Experience in using tools like Gitlab, JIRA, Confluence, Miro. Helping developers with performance tuning. Some Oracle knowledge is also required as data migration is from Oracle to Postgres. Working knowledge about DMS (Data Migration Services) like migration workspace, DB connections profiles, and DMS tasks processes in GCP. Good to have knowledge about DVT (Data Validation Tool) but not mandatory. Good practice in documentation of processes using Confluence. What We Are Trying to Do: 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 Oracle Application DBA to assist the transfer of the Oracle database to 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 RDBMS 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. The rest of the team includes a Business Analyst, an experienced Java engineer, and a QA. This will be one of the first of many similar re-platformings of Legacy applications to GCP.
#J-18808-Ljbffr
once a month
or
once every 2 months ) Role Type : 6 months Rolling Contract Budget : £400 - £450 Per day all inclusive THIS PROJECT IS INSIDE IR35 Looking for someone who has hands-on experience in migrating the database from on-prem to cloud, hands-on experience in Oracle, Postgres DBA with GCP migration. Ideal Candidate Summary (All experience below is mandatory): Hands-on experience in migrating the database from on-prem to cloud. Hands-on experience in Oracle. Postgres DBA with GCP migration. Database Backup and Restore process using both psql and GUI tools like PgAdmin and DBeaver. Writing DB objects (function, trigger, procedures) using PL/PgSQL. Job Spec: 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. Understanding about PITR (Point in Time Recovery) and HA (High Availability). Work experience in using tools like PgAdmin and/or DBeaver. Writing DB objects (function, trigger, procedures) using PL/PgSQL. Understanding Postgres database architecture: Database, schemas, roles, users, datafiles, logfiles, config files. 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. Experience in using tools like Gitlab, JIRA, Confluence, Miro. Helping developers with performance tuning. Some Oracle knowledge is also required as data migration is from Oracle to Postgres. Working knowledge about DMS (Data Migration Services) like migration workspace, DB connections profiles, and DMS tasks processes in GCP. Good to have knowledge about DVT (Data Validation Tool) but not mandatory. Good practice in documentation of processes using Confluence. What We Are Trying to Do: 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 Oracle Application DBA to assist the transfer of the Oracle database to 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 RDBMS 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. The rest of the team includes a Business Analyst, an experienced Java engineer, and a QA. This will be one of the first of many similar re-platformings of Legacy applications to GCP.
#J-18808-Ljbffr
