Senior PostgreSQL DBA – Remote & Flexible Azure

Software Mind; Warszawa; Remoto; PLN 180.000 - 260.000; Tempo pieno

Vantaggi offerti da questo lavoro

Flexible and remote cooperation

International projects

Travel related to international work

Non-corporate atmosphere

Language classes

Knowledge-sharing initiatives

Private healthcare and life insurance

Multisport card

Descrizione del lavoro

Software Mind is seeking an experienced PostgreSQL Database Administrator (DBA) to join our Data Platforms team. This role focuses on the PostgreSQL database platform, with emphasis on Azure Database for PostgreSQL Flexible Server, supporting critical production systems in a highly regulated financial services environment.

The successful candidate will administer, optimise, secure, and maintain enterprise PostgreSQL environments, support cloud deployments, and collaborate with development teams

Competenze

• 5+ years’ experience administering PostgreSQL environments, including mission-critical production systems.
• Strong PostgreSQL administration, performance tuning, and troubleshooting experience.
• Experience with PostgreSQL internals including MVCC, VACUUM/autovacuum, WAL, query planning, statistics, indexing, locking, and transaction management.
• Experience designing and operating highly available and resilient PostgreSQL environments.
• Experience with backup, point-in-time recovery, replication, disaster recovery, patching, and major-version upgrades.
• Experience with Azure Database for PostgreSQL Flexible Server or equivalent enterprise managed PostgreSQL services.
• Azure networking and security concepts relevant to managed databases, including private connectivity, DNS, identity, and access control.
• Experience managing PostgreSQL roles, privileges, authentication, extensions, and security configuration.
• Strong SQL skills and experience diagnosing and optimising complex queries.
• Linux administration and shell scripting skills.
• Experience with automation and Infrastructure as Code in cloud environments.
• Strong analytical, troubleshooting, and communication skills.
• Experience operating within formal incident and change management frameworks.

Mansioni

• Administer and support PostgreSQL database environments, primarily Azure Database for PostgreSQL Flexible Server.
• Ensure high availability, resilience, performance, and security of production PostgreSQL systems.
• Perform backup and recovery, point-in-time restore, patching, upgrades, performance tuning, capacity management, and maintenance activities.
• Configure and optimise PostgreSQL technologies and features including MVCC, VACUUM/autovacuum, WAL, replication, indexing, statistics, roles and privileges, and extensions.
• Design and support Azure PostgreSQL capabilities including high availability, read replicas, private networking, backup and disaster recovery.
• Support PostgreSQL security controls, authentication, TLS, least-privilege access, auditing, and integration with Microsoft Entra ID where appropriate.
• Monitor and troubleshoot query performance, locking, long-running transactions, connection utilisation, replication lag, storage, and database health.
• Support connection management and pooling solutions such as PgBouncer.
• Participate in cloud transformation and database migration initiatives, including migration of workloads to PostgreSQL.
• Support Database DevOps, infrastructure automation, CI/CD pipelines, Git, and Azure DevOps.
• Participate in incident, problem, and change management processes.
• Maintain operational documentation, standards, runbooks, and support project onboarding activities.
• Provide PostgreSQL technical leadership, mentoring, and knowledge transfer to other database professionals.
• Participate in on‑call rota and out‑of‑hours support where required.

Conoscenze

PostgreSQL administration

Performance tuning

Troubleshooting

SQL proficiency

Linux administration

Incident management

Strumenti

Azure Database for PostgreSQL Flexible Server

PgBouncer

Azure DevOps

Git

Terraform

Azure Monitor

Descrizione del lavoro

Software Mind is seeking an experienced PostgreSQL Database Administrator (DBA) to join our Data Platforms team. This role focuses on the PostgreSQL database platform, with emphasis on Azure Database for PostgreSQL Flexible Server, supporting critical production systems in a highly regulated financial services environment.

The successful candidate will administer, optimise, secure, and maintain enterprise PostgreSQL environments, support cloud deployments, and collaborate with development teams