Database Administrator (PostgreSQL)

About the Position

We are seeking an experienced PostgreSQL Database Administrator (DBA) to join our Data Platforms team. This role is responsible for the PostgreSQL database platform, with a particular focus on Azure Database for PostgreSQL Flexible Server, supporting critical production systems within a highly regulated financial services environment.

Responsibilities

• 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.

Requirements

• 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.
• Experience with 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.

Nice to Have

• Deep experience with Azure Database for PostgreSQL Flexible Server in enterprise production 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 such as Microsoft Fabric or Snowflake.
• Experience establishing PostgreSQL engineering standards, operational runbooks, and production-readiness controls.
• Financial services or investment management sector experience.
• Azure DevOps pipeline and Git workflow experience.

We Offer

• Flexible and remote cooperation options
• International projects with leading global clients
• Travels related to international projects
• Non-corporate atmosphere
• Access* to language classes
• Access* to knowledge-sharing initiatives
• Access* to private healthcare and life insurance
• Access* to multisport card

*The availability and terms of individual benefits may vary depending on the chosen form of cooperation.

About the Company

Software Mind develops solutions that make an impact for companies around the globe. Tech giants & unicorns, transformative projects, emerging technologies and limitless opportunities – these are a few words that describe an average day for us. Building cross-functional engineering teams that take ownership and crave more means we’re always on the lookout for talented people who bring passion and creativity to every project. Our culture embraces openness, acts with respect, shows grit & guts and combines employment with enjoyment.