Principal PostgreSQL Database Architect

Role overview

Principal PostgreSQL Database Architect at Luxoft

Responsibilities

• Design, implement and support Streaming/Logical Replication, PGLogical, multi-node, table-level/selective replication, including lag, conflicts, slots, synchronization and failover.
• Support AWS RDS/Aurora and on-premises PostgreSQL, including architecture, patching, upgrades, maintenance, and troubleshooting.
• Manage backup, recovery and security, including Barman, PITR, authentication, authorization, encryption, auditing and secure connectivity.
• Analyze recurring PostgreSQL issues and develop permanent fixes, automation and workarounds to improve platform stability.

Required qualifications

• Skills Must have You should demonstrate expert-level, hands-on experience with 7 to 9+ yrs of total experience.

Preferred qualifications and skills

• Nice to have Strong experience with Murex database/application architecture and supporting Capital Markets, Trading, Risk or other business-critical platforms.

Employment details

• AWS DMS, RDS/Aurora PostgreSQL and hybrid cloud database environments.
• Location: Bengaluru [India]

Application details

• Troubleshoot complex database/replication issues and perform end-to-end RCA across PostgreSQL, OS, network, application and infrastructure layers.
• Design and implement HA/DR, warm standby, failover and resilient database solutions supporting patching, upgrades and frequent application deployments.
• Collaborate with PostgreSQL Application, Cloud, DevOps and Infrastructure teams to resolve complex cross-platform technical issues.
• Understanding of database performance, workloads, deployments, upgrades, and application changes.

About the employer

• Project description Luxoft, a DXC Technology Company, is looking to expand its Murex cloud/DevOps team in the APAC region.

Additional role details

• 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.
• Develop custom scripts, automation, and tooling for database operations, replication, monitoring, health checks, deployment and recovery.
• Lead database migration and modernization, including Sybase-to-PostgreSQL and on-premises-to-AWS migrations using AWS DMS, EDB and PostgreSQL technologies.
• Perform advanced performance tuning and optimization, including queries, execution plans, indexing, memory, CPU, I/O, WAL and database parameters.
• Support production changes, deployments, upgrades and migrations in a highly controlled Capital Markets environment, including out-of-hours support when required.
• 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.
• 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.
• 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.
• 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.
• 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.
• Other Languages English: B2 Upper Intermediate Seniority Senior