Lead PostgreSQL Database Administrator

14 hours ago

Bengaluru, Karnataka, India SWITS DIGITAL Private Limited Full time ₹ 10,40,000 - ₹ 17,80,000 per year

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.

  • Database Administrator- PostgreSQL

    4 days ago

    Bengaluru, Karnataka, India Innova ESI Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    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 Administrator

    1 week ago

    Bengaluru, Karnataka, India ea5ea2a2-9527-41f2-bc78-529a5f850f1c Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Job Opening: PostgreSQL Database Administrator PostgreSQL DBALocation: BengaluruExperience: 4 8 YearsJob Type: Full-Time | PermanentNotice Period: Immediate – 30 DaysJob DescriptionWe are hiring an experienced PostgreSQL DBA to manage, maintain, and optimize our on-premise and/or cloud-based PostgreSQL environments. The ideal candidate must have strong...

  • Database Administrator

    2 weeks ago

    Bengaluru, Karnataka, India Zzazz Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    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

    12 hours ago

    Bengaluru, Karnataka, India Tezlogic Full time ₹ 12,00,000 - ₹ 24,00,000 per year

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

  • GoDigit - PostgreSQL Database Administrator

    2 days ago

    Bengaluru, Karnataka, India 15071e47-49ee-49de-9af5-13b750ac7ec2 Full time ₹ 12,00,000 - ₹ 15,00,000 per year

    DescriptionJob SummaryResponsible for administration of Postgres databases with secondary skills in administration of DB2, Oracle, MS-SQL, Clickhouse, Neo4J.Skill Requirements4+ years of experience in Postgres database administrationDB design (Architecture design principles, modelling, partitioning, setting standards and normalisation), installation,...

  • Senior Database Administrator

    14 hours ago

    Bengaluru, Karnataka, India Infosys Finacle Full time ₹ 8,00,000 - ₹ 25,00,000 per year

    Job Description: Senior Database Administrator (PostgreSQL/Oracle) – 10+ Years Experience-JL6We are seeking a results-driven Senior Database Administrator with 10–20 years of hands-on experience in managing, architecting, and optimizing large-scale, mission-critical database environments. The ideal candidate will have deep expertise in PostgreSQL /...

  • Database Administrator

    8 hours ago

    Bengaluru, Karnataka, India Material Depot Full time ₹ 15,00,000 - ₹ 35,00,000 per year

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

  • Senior Database Administrator

    5 days ago

    Bengaluru, Karnataka, India Steady Rabbit Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Title: Senior Database Administrator (DBA)Experience: 12+ yearsLocation: RemoteKey Responsibilities:Assess and monitor the health of a large-scale PostgreSQL (Aurora RDS) database (>50 TB).Identify and resolve performance bottlenecks, including I/O, memory, and CPU-related issues.Identify and Optimize db bottlenecks, long-running SQL queries, indexes,...

  • Mysql Database Administrator

    5 days ago

    Bengaluru, Karnataka, India Route Mobile (RML) Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    Production Support Role with 24 x 7 responsibilities, work with Global Operations team to deliver 99.99% uptime. Coordinate & collaborate with DBA team members on priorities and support.Provide DB administration for Linux based database engines Required Candidate profileDatabase experience on Linux based systems with MySQL/ PostgreSQL. Experience in...

  • Database Administrator

    5 days ago

    Bengaluru, Karnataka, India NetApp, Inc. Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Job Summary As a Data Engineer and DBA, you will perform administration of our database and analytics platform, including MySQL, Postgres, MongoDB, Microsoft SQL server, and Oracle as well as collection of data lake in a large technology ecosystem. You will ensure the smooth operations of systems including uptime and performance. As a technical expert for...