Principal PostgreSQL Database Architect

About the Position

Luxoft, a DXC Technology Company, is looking to expand its Murex cloud/DevOps team in the APAC region. This role provides ongoing support and change services for the client's current AWS implementation of their Capital Markets Trading platform (Murex). The project is looking to automate further and extend the relevant AWS capabilities. Our project offers a unique opportunity to work across a wide range of niche technologies like AWS and DevOps alongside legacy and the latest Murex versions.

Responsibilities

• Provide expert PostgreSQL/EDB architecture and administration, including internals, configuration, WAL, vacuum, locking, transactions, and storage.
• Design, implement, and support Streaming/Logical Replication, PGLogical, multi-node, table-level/selective replication, including lag, conflicts, slots, synchronization, and failover.
• Develop custom scripts, automation, and tooling for database operations, replication, monitoring, health checks, deployment, and recovery.
• Troubleshoot complex database/replication issues and perform end-to-end RCA across PostgreSQL, OS, network, application, and infrastructure layers.
• Lead database migration and modernization, including Sybase-to-PostgreSQL and on-premises-to-AWS migrations using AWS DMS, EDB, and PostgreSQL technologies.
• Support AWS RDS/Aurora and on-premises PostgreSQL, including architecture, patching, upgrades, maintenance, and troubleshooting.
• Design and implement HA/DR, warm standby, failover, and resilient database solutions supporting patching, upgrades, and frequent application deployments.
• Perform advanced performance tuning and optimization, including queries, execution plans, indexing, memory, CPU, I/O, WAL, and database parameters.
• Manage backup, recovery, and security, including Barman, PITR, authentication, authorization, encryption, auditing, and secure connectivity.
• Support production changes, deployments, upgrades, and migrations in a highly controlled Capital Markets environment, including out-of-hours support when required.
• Analyze recurring PostgreSQL issues and develop permanent fixes, automation, and workarounds to improve platform stability.
• Collaborate with PostgreSQL Application, Cloud, DevOps, and Infrastructure teams to resolve complex cross-platform technical issues.
• Provide technical leadership, mentoring, and best-practice guidance to DBA teams and establish database standards and operational procedures.

Requirements

• Must have:

  • Expert-level, hands-on experience with 7 to 9+ years of total experience.
  • PostgreSQL / EnterpriseDB architecture, administration, internals, and advanced troubleshooting.
  • Streaming & Logical Replication, PGLogical, replication lag, conflicts, WAL, and replication slots.
  • HA/DR, warm standby, failover, and table-level/selective replication.
  • Database migration/modernization, including Sybase-to-PostgreSQL migration.
  • AWS DMS, RDS/Aurora PostgreSQL, and hybrid cloud database environments.
  • Performance tuning, optimization, patching, upgrades, maintenance, and security.
  • Backup & recovery, including Barman and Point-in-Time Recovery (PITR).
  • Shell/Perl/Python scripting and automation for database operations.
  • Complex production troubleshooting, RCA, and resolution of non-standard database issues.

• Nice to have:

  • Strong experience with Murex database/application architecture and supporting Capital Markets, Trading, Risk, or other business-critical platforms.
  • Hands-on experience with Sybase ASE and Sybase-to-PostgreSQL migration/modernization projects.
  • Advanced knowledge of PostgreSQL replication technologies, including PGLogical, BDR, multi-site/multi-region replication, and DR architectures.
  • Experience with AWS database/cloud technologies, including RDS PostgreSQL, Aurora, AWS DMS, cloud security, and networking.
  • Experience with DevOps, CI/CD, and Infrastructure-as-Code (Terraform/CloudFormation) for database deployment, automation, and lifecycle management.
  • Strong scripting and automation experience using Shell/Python/Perl, including database monitoring, health checks, replication validation, deployment, and self-healing solutions.
  • Experience in advanced PostgreSQL troubleshooting, internals/customization, performance optimization, zero/minimal-downtime upgrades/migrations, security, and complex production RCA, with the ability to design customized solutions for non-standard requirements.

We Offer

• Competitive salary
• Opportunity to work with cutting-edge technologies
• Professional growth and development opportunities
• Collaborative and innovative work environment

About the Company

Luxoft, a DXC Technology Company, is a global leader in digital transformation and technology services. We empower businesses to thrive in the digital age by delivering innovative solutions that drive growth, efficiency, and customer satisfaction.