{bc}
Apply
company_site

Principal PostgreSQL Database Architect

Luxoft
Bengaluru, IND
Full-time
Senior
Onsite
Discovered 2 weeks ago
• 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.

Full Job Posting

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

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

Qualifications

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

Preferred Qualifications

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

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Luxoft

Semantic AI/ML Engineer

Noida, IND

Discovered TodayFull-time

Semantic AI/ML Engineer

Hyderabad, IND

Discovered TodayFull-time

Functional CRM Analyst

Abu Dhabi, UAE

Discovered TodayFull-time

Enterprise CRM Architect (Engagement Lead)

Abu Dhabi, UAE

Discovered TodayFull-time

Technical CRM Analyst

Abu Dhabi, UAE

Discovered TodayFull-time

Murex Market Risk Consultant

Pune, IND

Discovered TodayFull-time

Murex Market Risk Consultant

Gurugram, IND

Discovered TodayFull-time

Murex Market Risk Consultant

Bengaluru, IND

Discovered TodayFull-time