DBA (Aurora PostgreSQL)

Aether Biomedical; Deutschland; Vor Ort; EUR 70.000 - 110.000; Vollzeit

Zusammenfassung

Aether Biomedical is seeking an experienced PostgreSQL DBA to own the database layer of a large migration. You will move from Azure SQL to Aurora PostgreSQL and run ongoing operations with a focus on performance, security, and reliability across the platform.

You will transform system-versioned data to a PostgreSQL history pattern, design schemas, and automate migrations with Flyway. The role includes encryption, access control, and Snowflake pipeline support.

Qualifikationen

• 5+ years of PostgreSQL experience.
• Hands-on Aurora PostgreSQL and AWS RDS expertise.
• Experience with Flyway and schema migration management.
• Knowledge of AWS RDS IAM authentication and KMS.
• Strong PL/pgSQL skills and pg_cron experience.
• Experience migrating from Azure SQL/SQL Server to PostgreSQL.
• Solid PostgreSQL schema design, indexing and tuning.
• Security best practices for cloud databases.

Aufgaben

• Design and support migration from Azure SQL to Aurora PostgreSQL.
• Transform system-versioned tables to PostgreSQL history pattern.
• Map legacy columns and load data into history tables.
• Validate data integrity post-migration.
• Develop normalized Aurora PostgreSQL schemas with UUID keys.
• Define naming conventions, audit columns, and soft-delete patterns.
• Maintain Flyway migrations and schema changes.
• Configure AWS RDS IAM authentication and passwordless access.
• Implement KMS at-rest encryption and TLS in-transit.
• Enforce least-privilege DB roles for write/read.
• Perform performance tuning, indexing and autovacuum tuning.
• Set up maintenance jobs with pg_cron and support Snowflake pipeline.
• Collaborate with engineering and data teams to ensure reliability.

Kenntnisse

PostgreSQL

Aurora PostgreSQL

PL/pgSQL

Flyway migrations

AWS RDS IAM

KMS encryption

Performance tuning

Data migration

Security best practices

Troubleshooting

Tools

Flyway

pg_cron

HikariCP

Snowflake

AWS RDS

AWS IAM

Jobbeschreibung

Project overview

The project focuses on migrating a database environment from Azure SQL to Aurora PostgreSQL for a major investment management client. You will design and implement the transformation of system-versioned tables into a PostgreSQL-based history pattern, define schema standards, support bulk data migration and validation, and help establish secure and scalable database operations in AWS. In addition to migration activities, you will be responsible for performance tuning, automation, access control, encryption, and supporting the data pipeline to Snowflake.

Position overview

We are looking for an experienced DBA with strong PostgreSQL expertise to own the database layer of a large-scale migration project for a major investment management client. In this role, you will support both the migration from Azure SQL to Aurora PostgreSQL and the ongoing database operations, ensuring performance, security, and reliability across the platform.

Responsibilities

• Design and support the migration from Azure SQL to Aurora PostgreSQL
• Transform Azure SQL system-versioned tables into a PostgreSQL trigger-based history table pattern using PL/pgSQL
• Map legacy columns and execute bulk data loads into history tables
• Validate data integrity after migration
• Design normalized Aurora PostgreSQL schemas with UUID v7 surrogate primary keys
• Define foreign key and index naming conventions, audit columns, and soft-delete patterns
• Author and maintain schema changes as Flyway migration scripts
• Configure and maintain AWS RDS IAM database authentication with passwordless access patterns
• Implement KMS at-rest encryption and TLS in-transit enforcement
• Define least-privilege database role separation for write and read access
• Perform performance tuning, query analysis, index strategy optimization, autovacuum tuning, and connection pool sizing
• Implement scheduled maintenance and retention jobs using pg_cron
• Support the data pipeline to Snowflake, including WAL-based CDC or scheduled exports
• Collaborate with engineering and data teams to ensure database reliability, scalability, and security

Requirements

• 5+ years of experience working with PostgreSQL
• Strong hands-on experience with Aurora PostgreSQL and AWS RDS
• Experience with Flyway and schema migration management
• Solid knowledge of AWS RDS IAM authentication and KMS
• Strong PL/pgSQL skills
• Experience with pg_cron
• Experience migrating databases from Azure SQL or SQL Server to PostgreSQL
• Good understanding of PostgreSQL schema design, indexing, and performance tuning
• Experience with security best practices for cloud databases
• Strong analytical and troubleshooting skills
• Ability to work closely with engineering and data teams on a migration project

Nice to have

• Experience with Snowflake
• Experience with time-partitioned history table patterns
• Knowledge of WAL-based CDC or scheduled export mechanisms
• Familiarity with HikariCP and connection pool optimization
• Experience with investment management or financial services projects

What We Offer

• Vacation days: Up to 26 business days per year.
• 10 illness/special days off per year (fully paid, no medical papers needed) for all contract types
• Health and life insurance (Luxmed)
• MyBenefit platform with Multisport option
• Internal psychological support service
• English language classes from the first working day
• Access to external learning platforms: O’Reilly, LinkedIn Learning, Udemy, and a wide catalog of diverse internal training
• Flexible workplace: work from the office, from home, or choose a hybrid option
• Tech Skills Mentoring Program
• Opportunities to develop as a public speaker, mentor, or technical interviewer
• Fully paid idle (bench) when not involved in a project
• Certification reimbursement (AWS, GCP, Microsoft, etc.)