Database Administrator

CoolPeople Technology; Stockholms kommun; On-site; SEK 900,000 - 1,300,000; Full time

Job summary

CoolPeople Technology is seeking a Senior PostgreSQL Database Engineer / PostgreSQL DBA to lead hands-on Oracle-to-PostgreSQL migrations. The role emphasizes building a stable, scalable PostgreSQL environment and working with development teams to translate requirements into robust database designs.

You will focus ~80% on migration activities and 20% on review and optimization, with attention to internal performance, indexing, and operational reliability.

Qualifications

• Extensive production experience with PostgreSQL as a DBA/Database Engineer.
• Proven hands-on Oracle→PostgreSQL migration experience is essential.
• Strong knowledge of PostgreSQL internals, indexing, query planning, and performance tuning.

Responsibilities

• Migrate existing Oracle database services to PostgreSQL with minimal downtime.
• Handle schema conversion, datatype mapping, and functional equivalence.
• Review indexing strategies and tune PostgreSQL configuration and queries.
• Collaborate with application teams to design PostgreSQL schemas.
• Explain differences between Oracle and PostgreSQL and document learnings.

Skills

PostgreSQL

Oracle migration

Database migration

Query tuning

Indexing

Liquibase

Tools

Liquibase

Job description

You are looking for a Senior PostgreSQL Database Engineer / PostgreSQL DBA whose key specialization is Oracle-to-PostgreSQL migration.

This is not an AWS-focused role. The primary technology and correct label should be PostgreSQL / Database Engineering.

The ideal candidate is not just a database administrator. They need to be able to execute migrations hands-on, understand the differences between Oracle and PostgreSQL, and assess whether the resulting PostgreSQL environment is properly designed, stable, and performant.

The role is approximately 80% hands-on Oracle → PostgreSQL migration and 20% PostgreSQL review, optimization, and recommendations.

What he will do:

• The candidate will work on migrating existing Oracle database services to PostgreSQL.
• Their responsibilities will include schema conversion, datatype mapping, ensuring functional compatibility, reviewing indexing strategies, PostgreSQL configuration, query performance, and performance tuning.
• They will also work closely with application/development teams to translate application requirements into appropriate PostgreSQL database designs.
• An important point: PL/SQL-to-PL/pgSQL code conversion is NOT part of the assignment, as the applications do not contain PL/SQL code. However, the candidate should still understand the differences between Oracle and PostgreSQL.

What is the project about?

This is a large-scale database modernization and migration project, specifically:

• The goal is not simply to move the databases. The client wants to ensure that the PostgreSQL environment after migration is stable, correctly designed, reliable, and performant.
• The consultant will also document migration learnings, best practices, and repeatable processes that can be used in future database modernization initiatives.
• There is some broader application/integration context involving Java, Kafka, and Solace, but these are secondary technologies rather than the main focus of the role.

Must have skills

The most important combination is strong hands-on PostgreSQL expertise + proven Oracle → PostgreSQL migration experience.

The candidate should have:

• Extensive production experience with PostgreSQL, ideally as a PostgreSQL DBA, Database Engineer, or PostgreSQL Developer.
• Proven hands-on Oracle → PostgreSQL migration experience — I would treat this as one of the main knockout criteria.
• Strong PostgreSQL knowledge covering internals, indexing, query planning, performance tuning, monitoring, and operational reliability.
• Good knowledge of Oracle and the differences between Oracle and PostgreSQL.
• Experience with datatype mapping, schema conversion, functional equivalence, and performance adaptation.
• Ability to review and optimize PostgreSQL schemas, indexes, queries, and configurations.
• Ability to work autonomously within an established migration framework.
• Experience with Liquibase or a similar database schema versioning/change management tool.
• Strong communication and collaboration skills when working with development and database engineering teams.

Nice to have skills

Additional advantages include:

• Experience with Java applications using PostgreSQL.
• Experience with Kafka or Solace.
• Exposure to distributed systems / event-driven architectures.
• Experience migrating high-traffic database services with low-downtime requirements.
• Familiarity with AI-assisted development tools such as Cursor or Claude agents.

These should not outweigh genuine Oracle → PostgreSQL migration experience.