SOFTWARE MIND

[WBG] Database Administrator (PostgreSQL)

Brak informacji o wynagrodzeniu

SeniorZdalnie·WarszawaFull-time

#448251·Dodano 27 dni temu·2

Źródło: Software Mind

Aplikuj teraz

Tech Stack / Keywords

PostgreSQLAzure Database for PostgreSQLMVCCVACUUMWALReplicationPgBouncerSQL Linux Terraform

Firma i stanowisko

Software Mind develops solutions impacting global companies, including tech giants and unicorns. Their team works on transformative projects involving emerging technologies, focusing on cross-functional engineering teams in a respectful and open culture.

Wymagania

5+ years’ experience administering PostgreSQL environments, including mission-critical production systems.
Strong PostgreSQL administration, performance tuning, and troubleshooting skills.
Experience with PostgreSQL internals: MVCC, VACUUM/autovacuum, WAL, query planning, statistics, indexing, locking, 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.
Experience with Azure networking and security concepts: private connectivity, DNS, identity, access control.
Experience managing PostgreSQL roles, privileges, authentication, extensions, security configuration.
Strong SQL skills diagnosing and optimizing 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.

Nice to have:

Deep experience with Azure Database for PostgreSQL Flexible Server in enterprise environments.
Experience with PostgreSQL migration and assessment tooling, including migrations from Oracle and/or Microsoft SQL Server.
Oracle and/or Microsoft SQL Server administration experience.
Experience with PgBouncer and application connection-pooling patterns.
Knowledge of PostgreSQL observability tooling and Azure Monitor integration.
Terraform experience for automated database provisioning.
Experience integrating PostgreSQL with data platforms like Microsoft Fabric or Snowflake.
Experience establishing PostgreSQL engineering standards, operational runbooks, production-readiness controls.
Financial services or investment management sector experience.
Azure DevOps pipeline and Git workflow experience.

Obowiązki

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, recovery, point-in-time restore, patching, upgrades, performance tuning, capacity management, and maintenance.
Configure and optimize PostgreSQL features including MVCC, VACUUM/autovacuum, WAL, replication, indexing, statistics, roles and privileges, and extensions.
Design and support Azure PostgreSQL capabilities such as high availability, read replicas, private networking, backup, and disaster recovery.
Support PostgreSQL security controls including authentication, TLS, least-privilege access, auditing, and integration with Microsoft Entra ID.
Monitor and troubleshoot query performance, locking, long-running transactions, connection utilization, replication lag, storage, and database health.
Support connection management and pooling solutions such as PgBouncer.
Participate in cloud transformation and database migration initiatives.
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 as required.

Benefity

Flexible and remote cooperation options.
International projects with leading global clients.
Travel opportunities related to international projects.
Non-corporate atmosphere.
Access to language classes (terms depend on form of cooperation).
Access to knowledge-sharing initiatives.
Access to private healthcare and life insurance.
Access to multisport card.

Elastyczne godziny

Kursy językowe

Opieka zdrowotna

Karta sportowa

SOFTWARE MIND

33 aktywne oferty

Zobacz wszystkie oferty

Aplikuj teraz