Jobs
Interviews
Luxoft logo

PostgreSQL Database Architect

7 - 9 years

Bengaluru

Posted:4 days ago

Apply

Job Description

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.


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


Skills Required

Postgresql Devops AWS Capital Markets Automation Database Migration Troubleshooting Performance Tuning Auditing Technical Leadership Hybrid Cloud Backup and Recovery

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Job Type

Full Time

More Jobs at Luxoft

Senior Production Support Engineer

Bengaluru

3 - 8 yrs
|

Salary: Not disclosed

Progress 4GL OpenEdge Developer

Pune

5 - 10 yrs
|

Salary: Not disclosed

Jasper Reports Server / Jaspersoft specialist

Bengaluru

5 - 10 yrs
|

Salary: Not disclosed

Temenos Senior Developer

Bengaluru

10 - 15 yrs
|

Salary: Not disclosed

Murex MLC/MxML BAU Support Consultant

Mumbai, Chennai

3 - 8 yrs
|

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Luxoft logo
Luxoft

IT Services and IT Consulting

Zug New York

RecommendedJobs for You

Luxoft logo

PostgreSQL Database Architect

Luxoft

Bengaluru

Luxoft logo

PostgreSQL Database Architect

Luxoft

Bengaluru