PostgreSQL Database Administrator

Luxoft; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Luxoft, a DXC Technology Company, seeks an expert PostgreSQL/EDB DBA to expand its cloud/DevOps team in the APAC region. The role involves ongoing support and change services for the client’s AWS-based Capital Markets Trading platform (Murex), with focus on automation and extended AWS capabilities.

You will work across niche technologies like AWS, DevOps, and advanced PostgreSQL setups, including replication, migrations, and high availability.

Qualifications

• 7 to 9+ years total experience with PostgreSQL/EDB architecture and admin.

Responsibilities

• Provide expert PostgreSQL/EDB architecture and administration.
• Design and support streaming/logical replication, PGLogical, and multi-node replication.
• Develop scripts and tooling for database operations, monitoring, and recovery.
• Troubleshoot complex replication issues and perform end-to-end RCA.
• Lead migrations including Sybase-to-PostgreSQL and AWS migrations.
• Support AWS RDS/Aurora and on-prem PostgreSQL with patching and upgrades.
• Design HA/DR, warm standby, and failover solutions.
• Perform advanced performance tuning and optimization of DB parameters.
• Manage backup/recovery with Barman and PITR.
• Collaborate with cross-functional teams and establish DB standards.

Skills

PostgreSQL/EDB architecture

Streaming/Logical Replication

PGLogical

HA/DR

AWS DMS

RDS/Aurora PostgreSQL

Performance tuning

Barman/PITR

Shell/Python/Perl scripting

RCA & production troubleshooting

Tools

Terraform

CloudFormation

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

Mandatory Skills Description:

• 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.
• 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 Skills Description:

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