Principal PostgreSQL Database Architect

Project description

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. Capital Markets Expertise:
• Strong understanding of PostgreSQL/EDB integration within Capital Markets environments.
• Experience supporting large-scale, business-critical trading/capital-markets platforms.
• Understanding of database performance, workloads, deployments, upgrades, and application changes.
• Ability to independently troubleshoot and differentiate application, database, replication, and infrastructure-level issues.
• Experience supporting migrations, upgrades, deployments, and production changes.
• Ability to develop custom technical solutions, fixes and workarounds for environment-specific/non-standard requirements, beyond standard vendor procedures.

SKILLS

Must have

• You should demonstrate expert-level, hands-on experience with 7 to 9+ yrs 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.