[WBG] 数据库管理员（PostgreSQL）
[WBG] Database Administrator (PostgreSQL)
Software Mind 为全球公司提供具有影响力的技术解决方案。科技巨头与独角兽企业、变革性项目、新兴技术以及无限机遇——这些是我们的日常写照。我们组建跨职能的工程团队，他们拥有主人翁意识并追求卓越，因此我们一直在寻找那些为每个项目带来激情和创造力的优秀人才。我们的文化倡导开放、尊重、坚韧与勇气，并将工作与乐趣结合在一起。
项目目标
我们正在寻找一位经验丰富的 PostgreSQL 数据库管理员（DBA）加入我们的数据平台团队。该职位负责 PostgreSQL 数据库平台，特别关注 Azure Database for PostgreSQL Flexible Server，在高度监管的金融服务环境中支持关键生产系统。
成功候选人将负责企业级 PostgreSQL 环境的管理、优化、安全、可用性及生命周期管理。该职位支持关键业务应用、云部署以及交付战略技术解决方案的开发团队。
角色职责
· 管理和支持 PostgreSQL 数据库环境，主要为 Azure Database for PostgreSQL Flexible Server。
· 确保生产 PostgreSQL 系统的高可用性、弹性、性能和安全性。
· 执行备份与恢复、时间点恢复、补丁安装、升级、性能调优、容量管理及维护操作。
· 配置和优化 PostgreSQL 技术和功能，包括 MVCC、VACUUM/自动 VACUUM、WAL、复制、索引、统计信息、角色和权限以及扩展。
· 设计和支撑 Azure PostgreSQL 功能，包括高可用性、只读副本、私有网络、备份和灾难恢复。
· 支持 PostgreSQL 安全控制、认证、TLS、最小权限访问、审计以及与 Microsoft Entra ID 的集成。
· 监控和排查查询性能、锁、长时间运行的事务、连接使用率、复制延迟、存储和数据库健康状况。
· 支持连接管理和连接池解决方案，如 PgBouncer。
· 参与云转型和数据库迁移项目，包括将工作负载迁移到 PostgreSQL。
· 支持数据库 DevOps、基础设施自动化、CI/CD 流程
查看英文原文
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.
Project – the aim you’ll have
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.
The successful candidate will be responsible for the administration, optimisation, security, availability, and ongoing lifecycle management of enterprise PostgreSQL environments. The role supports mission-critical business applications, cloud deployments, and development teams delivering strategic technology solutions.
Role – how you’ll contribute
· 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.
Expectations – the experience you need
· 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.
Additional skills – the edge you 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.
What 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.