[WBG] Database Administrator (PostgreSQL)

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.

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

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