postgresSQL DBA - Migration Specialist

postgresSQL DBA - Migration Specialist

Posted 2 weeks ago by Lorien

Apply
Negotiable
Undetermined
Undetermined
Edinburgh, UK
Apply
Amazon Web Services (AWS) Automation Bash (Scripting Language) Continuous Integration and Continuous Delivery Database Administration Data Infrastructure Datamodel Data Modeling DevOps DMS Software Reengineering Toolkits Financial Services Infrastructure as Code (IaC) Microsoft Azure Oracle Database Administration (DBA) Payment Systems PostgreSQL Python (Programming Language) Scalability Scripting Stakeholder Communications Stakeholder Management

Summary: We are looking for a PostgreSQL Database Administrator (DBA) Migration Specialist to lead the migration of 34 business-critical applications to PostgreSQL. This role involves planning and executing migration strategies while ensuring database integrity and performance. The DBA will collaborate with various teams and contribute to the long-term optimization of PostgreSQL environments. This position is critical for modernizing our data infrastructure and transitioning from legacy platforms.

Key Responsibilities:

  • Lead the end-to-end migration of databases for 34 business-critical applications to PostgreSQL.
  • Plan, coordinate, and execute migration strategies with minimal downtime and risk.
  • Ensure the integrity, security, and performance of databases throughout the migration lifecycle.
  • Collaborate with development, infrastructure, and payments teams to align data models and application requirements.
  • Troubleshoot and resolve database issues, performance bottlenecks, and replication challenges.
  • Develop documentation, migration runbooks, and operational procedures.
  • Contribute to the long-term optimisation, automation, and scalability of our PostgreSQL environments.

Key Skills:

  • Proven experience as a PostgreSQL DBA, particularly in large-scale migration projects.
  • Deep understanding of PostgreSQL architecture, configuration, tuning, and security best practices.
  • Experience with payment systems, transactional data, and high-availability requirements.
  • Familiarity with legacy-to-PostgreSQL migration tools and processes (eg, AWS DMS, pg_dump/pg_restore, logical replication).
  • Strong Scripting skills (eg, Bash, Python) and familiarity with CI/CD pipelines.
  • Ability to manage complex dependencies and stakeholder communication across multiple applications.
  • Desirable: Experience with cloud-based PostgreSQL (eg, AWS RDS, Azure Database for PostgreSQL).
  • Knowledge of PCI-DSS compliance or other financial services regulations.
  • Exposure to DevOps or Infrastructure-as-Code (IaC) environments.

Salary (Rate): undetermined

City: Edinburgh

Country: UK

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job Title: PostgreSQL DBA - Migration Specialist
Location: Edinburgh or London
Type: 6 month contract with extensions up to a further 12 months

About the Role:
We are seeking a highly skilled PostgreSQL Database Administrator (DBA) to join our team and lead critical migration initiatives involving high volume number of applications, including complex payments systems. This is a key role in a high-impact project aimed at modernising our data infrastructure and ensuring seamless transition from Legacy platforms to PostgreSQL.

Key Responsibilities:

-Lead the end-to-end migration of databases for 34 business-critical applications to PostgreSQL.
-Plan, coordinate, and execute migration strategies with minimal downtime and risk.
-Ensure the integrity, security, and performance of databases throughout the migration lifecycle.
-Collaborate with development, infrastructure, and payments teams to align data models and application requirements.
-Troubleshoot and resolve database issues, performance bottlenecks, and replication challenges.
-Develop documentation, migration runbooks, and operational procedures.
-Contribute to the long-term optimisation, automation, and scalability of our PostgreSQL environments.

Required Skills & Experience:

Proven experience as a PostgreSQL DBA, particularly in large-scale migration projects.
Deep understanding of PostgreSQL architecture, configuration, tuning, and security best practices.
Experience with payment systems, transactional data, and high-availability requirements.
Familiarity with legacy-to-PostgreSQL migration tools and processes (eg, AWS DMS, pg_dump/pg_restore, logical replication).
Strong Scripting skills (eg, Bash, Python) and familiarity with CI/CD pipelines.
Ability to manage complex dependencies and stakeholder communication across multiple applications.

Desirable:
Experience with cloud-based PostgreSQL (eg, AWS RDS, Azure Database for PostgreSQL).
Knowledge of PCI-DSS compliance or other financial services regulations.
Exposure to DevOps or Infrastructure-as-Code (IaC) environments.

Carbon60, Lorien & SRG - The Impellam Group STEM Portfolio are acting as an Employment Business in relation to this vacancy.

Apply
Similar Jobs
Loading data...