Postgres DBA
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
Postgres DBA
Posted on Jan 24, 2025 by Infoplus Technologies UK Ltd
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

Alert me to jobs like this:
Amplify your job search:
Expert career advice
Increase interview chances with our downloads and specialist services.
Visit Blog