Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our team to migrate Oracle databases to GCP using Postgres and optimize SQL performance.
- Company: We're a tech-driven company focused on modernizing legacy applications in the cloud.
- Benefits: Enjoy remote work flexibility with occasional travel, plus competitive pay at £350/day.
- Why this job: Be part of an exciting transition project that enhances your skills in cloud technologies and database management.
- Qualifications: Experience with Oracle to Postgres migration and strong knowledge of PL/PG SQL required.
- Other info: Familiarity with GCP and tools like PgAdmin, Gitlab, and JIRA is a plus.
The predicted salary is between 60000 - 84000 £ per year.
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.
PostgreSQL Database Administrator employer: Osmii
Contact Detail:
Osmii Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land PostgreSQL Database Administrator
✨Tip Number 1
Make sure to highlight your experience with Oracle to Postgres migrations in your conversations. This is a key requirement for the role, and demonstrating your hands-on experience will set you apart.
✨Tip Number 2
Familiarize yourself with GCP and its database services, especially Cloud SQL. Being able to discuss how you've used these tools in past projects will show that you're ready to hit the ground running.
✨Tip Number 3
Prepare to discuss specific performance tuning techniques you've applied in previous roles. The team is looking for someone who can help optimize SQL queries during the migration process.
✨Tip Number 4
Brush up on your knowledge of PL/PGSQL and be ready to share examples of database objects you've created. This will demonstrate your technical skills and understanding of Postgres architecture.
We think you need these skills to ace PostgreSQL Database Administrator
Some tips for your application 🫡
Highlight Relevant Experience: Make sure to emphasize your experience with Oracle to Postgres database migration. Detail any specific projects you've worked on that involved similar tasks, especially in a GCP environment.
Showcase Technical Skills: Clearly list your technical skills related to PostgreSQL, PL/pgSQL, and any tools like PgAdmin or DBeaver. Mention your familiarity with database architecture, roles, and permissions management.
Demonstrate Problem-Solving Abilities: Include examples of how you've identified and rectified performance issues with SQL queries in past roles. This will show your capability to handle challenges during the migration process.
Tailor Your Application: Customize your CV and cover letter to reflect the specific requirements mentioned in the job description. Use keywords from the listing to ensure your application stands out to recruiters.
How to prepare for a job interview at Osmii
✨Show Your Migration Experience
Be prepared to discuss your previous experiences with Oracle to Postgres migrations. Highlight specific challenges you faced and how you overcame them, as this will demonstrate your expertise in handling complex database transitions.
✨Demonstrate Your Knowledge of GCP
Since the role involves working with Google Cloud Platform, make sure to familiarize yourself with its features related to database management. Discuss any relevant projects you've worked on in GCP, especially those involving Cloud SQL.
✨Prepare for Performance Tuning Questions
Expect questions about performance tuning SQL queries. Be ready to share examples of how you've identified and resolved performance issues in past projects, particularly in a Postgres environment.
✨Familiarize Yourself with Tools
The job mentions tools like PgAdmin, DBeaver, Gitlab, and JIRA. Make sure you can speak confidently about your experience with these tools, including any specific functionalities you utilized that relate to database management and documentation.
