Lead PostgreSQL Database Administrator

5 hours ago

Bengaluru, Karnataka, India SWITS DIGITAL Private Limited Full time

Job Title: Lead PostgreSQL Database Administrator
Location:
Bangalore / Chennai

Experience:
7–9 Years

Job Summary
We are looking for a highly skilled
PostgreSQL Lead Systems Engineer
(L2 DBA) responsible for managing global database operations in a 24×7 production environment. The role involves end-to-end ownership of PostgreSQL databases, including performance tuning, upgrades, disaster recovery, automation, and incident management.

Key Responsibilities
Database Operations & Support

  • Provide 24×7 PostgreSQL database support including incidents, service requests, problem management, and change management.
  • Handle on-call support during weekends and off-business hours.
  • Serve as the Primary DBA for multiple applications.
  • Troubleshoot and resolve complex performance, replication, and availability issues.

Projects & Enhancements

  • Plan and deliver database patching, upgrades, and migration projects.
  • Drive automation initiatives to reduce manual tasks.
  • Manage and maintain tools/scripts used for database administration.
  • Contribute to ticket volume reduction through proactive problem management.

Disaster Recovery & Performance

  • Execute and validate Disaster Recovery (DR) tests and exercises.
  • Perform advanced performance tuning, monitoring, and optimization.
  • Work with application and infrastructure teams to improve performance and reduce incident probability.

Innovation & Collaboration

  • Identify and implement POCs for new PostgreSQL features, open-source tools, and technologies.
  • Collaborate with cross-functional global teams to solve database and application challenges.
  • Proactively identify problems and implement preventive solutions.

Mandatory Skills & Experience
PostgreSQL Expertise

  • Strong hands-on experience working with PostgreSQL 12, 13, 14 & 15.
  • Deep understanding of PostgreSQL architecture, design, and internals.

  • Expertise in:

  • Backup & Recovery (PG_DUMP, PG_DUMPALL)

  • WAL Archiving, PITR (Point-in-Time Recovery)
  • Replication setup & troubleshooting
  • Performance tuning (query tuning, index tuning, config optimization)

Tools & Extensions

  • Experience with:

  • REPMGR

  • PGBACKREST
  • pg_repack
  • pg_crypto
  • pg_audit
  • pg_bouncer
  • Foreign Data Wrapper (FDW)

Configuration & Monitoring

  • Strong knowledge of:

  • Experience with open-source monitoring and performance analysis tools.

Scripting & Automation

  • Good experience with Ansible and Shell scripting.
  • Knowledge of Perl/Python scripting is a plus.

Cloud & Large-Scale Environments

  • Experience administering AWS RDS for PostgreSQL.
  • Experience managing 1000+ databases in large enterprise setups.
  • Familiarity with cloud & hybrid "as-a-service" platforms.

Process & Leadership

  • Strong understanding of ITIL processes (Incident, Problem, Change).
  • Excellent coordination, communication, and crisis management skills.
  • Ability to handle operations in a large, globally distributed environment.

Preferred Skills

  • AWS RDS for PostgreSQL certification.
  • Experience in banking/financial domain.
  • Experience in automated operations environments.
  • Knowledge of Python/Perl for advanced automation.
  • Hands-on experience with cloud-based infra operations.

  • PostgreSQL Database Administrator

    2 weeks ago

    Bengaluru, Karnataka, India DigitalRecruiter™ APP Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Role OverviewWe are hiringexperienced PostgreSQL Database Administrators (DBAs)for one of our clients, aleading global technology company. The role involves providing BAU support, performance tuning, and maintenance for PostgreSQL environments while ensuring database availability, security, and reliability. The candidate will also collaborate closely with...

  • Database Administrator- PostgreSQL

    3 days ago

    Bengaluru, Karnataka, India Innova ESI Full time

    Role: Database Administrator- PostgreSQLExperience: 4+yearsLocation: PAN IndiaImmediate joiners onlyOverviewWe are seeking an experiencedPostgreSQL Database Administrator (DBA)to design, optimize, and maintain mission-critical database systems. The ideal candidate will possess strong expertise in PostgreSQL administration, performance tuning, automation, and...

  • PostgreSQL Database Admin

    3 weeks ago

    Bengaluru, Karnataka, India, Karnataka LTIMindtree Full time

    Role: PostgreSQL Database AdminExperience: 8 years to 12 yearsLocation: PAN IndiaJob Description:12 years of IT experience and minimum of 5 years of experience on PostgreSQL database administration Should have worked with the team size of above 10 members technically guided the team Willing to provide 24x7 support flexible to work in the shiftsKEY...

  • Database Administrator

    2 weeks ago

    Bengaluru, Karnataka, India Zzazz Full time

    MongoDB / PostgresqlKey ResponsibilitiesDesign, install, configure, and maintain MongoDB / Postgresql on-premises clusters (replica sets, sharded clusters).Manage and optimize database performance, including query tuning, indexing strategies, and resource utilization.Implement and maintain monitoring and alerting using Grafana, Prometheus, and MongoDB...

  • Senior Database Administrator

    2 hours ago

    Bengaluru, Karnataka, India Tezlogic Full time

    Experience 8+ years Location - Bengaluru Job SummaryAs a senior database administrator, you will be responsible for the administration, optimization, and reliability of Liongard's core platform database. You will work closely with development and DevOps teams to ensure database instances are performant, scalable, highly available, and cost-efficient.The...

  • Senior Database Administrator

    5 days ago

    Bengaluru, Karnataka, India TALENT PRO Full time

    **Read jd before applyingCandidate must be from Bengaluru location onlyStrong Senior/Lead Database Administrator profileMandatory (Experience years of hands-on experience as a Database Administrator working with both databases - MS SQL Server and Oracle (PostgreSQL exposure preferred)Mandatory (Experience 2) - Strong experience in database performance...

  • Database Administrator

    2 days ago

    Bengaluru, Karnataka, India Material Depot Full time

    We are seeking a motivated and detail-oriented Database Administrator / Developer to join our IT Operations and Support team. The ideal candidate will be responsible for managing, optimizing, and maintaining database systems to ensure efficiency, reliability, and security across our infrastructure.ResponsibilitiesAdminister and maintain SQL/NoSQL...

  • PostgreSQL DBA

    3 weeks ago

    Bengaluru, Karnataka, India, Karnataka MNC Full time

    Senior PostgreSQL/Database Administrator (DBA) – On-Prem & AWS RDSRole OverviewWe are seeking an experienced Senior PostgreSQL/ DBA with strong expertise in EDB PostgreSQL, Oracle and AWS RDS for PostgreSQL to join our team. The ideal candidate will be responsible for the administration, performance tuning, high availability, and security of...

  • Senior Associate Database Administrator

    2 weeks ago

    Bengaluru, Karnataka, India Datavail Infotech Full time US$ 60,000 - US$ 1,20,000 per year

    DescriptionJob Title: Senior Associate Database Administrator - PostgreSQL DBAEducation: Any GraduateExperience: 6+yearsLocation: Bengaluru, Hyderabad, Mumbai.Key Skills: PostgreSQL Open Source and EDB PostgreSQL. AWS, Microsoft Azure and GCP - PostgreSQL.Pgbadger, PgAdmin, Pgbouncer, BARMAN, pgbackrest, repmgr, Patroni and pg_repack.Job Description:6+ years...

  • Oracle Database Administrator

    3 weeks ago

    Bengaluru, Karnataka, India, Karnataka ACL Digital Full time

    Oracle Database Administrator or Oracle DBAExperience : 5+yrsCTC : 12-15LPALocation: Bengaluru / Hyderabad / RemoteSkillset: DBA with strong experience in Oracle databases, and experience with other databases such as Sybase, DB2, Informix, MySQL, Firebird, and PostgreSQL