Postgres DBA

Posted on Jan 24, 2025 by Infoplus Technologies UK Ltd
London, United Kingdom
IT
Immediate Start
Annual Salary
Contract/Project

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.


Reference: 2886618960

https://jobs.careeraddict.com/post/99039583

This Job Vacancy has Expired!

Postgres DBA

Posted on Jan 24, 2025 by Infoplus Technologies UK Ltd

London, United Kingdom
IT
Immediate Start
Annual Salary
Contract/Project

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.

Reference: 2886618960

CareerAddict

Alert me to jobs like this:

Amplify your job search:

CV/résumé help

Increase interview chances with our downloads and specialist services.

CV Help

Expert career advice

Increase interview chances with our downloads and specialist services.

Visit Blog

Job compatibility

Increase interview chances with our downloads and specialist services.

Start Test