Lead PostgreSQL Database Administrator

3 days ago

Bengaluru India SWITS DIGITAL Private Limited Full time

Job Description Job Title: Lead PostgreSQL Database Administrator Location: Bangalore / Chennai Experience: 79 Years Job Summary We are looking for a highly skilled PostgreSQL Lead Systems Engineer (L2 DBA) responsible for managing global database operations in a 247 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 247 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: - postgresql.conf - pg_hba.conf - 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

    5 days ago

    Bengaluru, India Innova ESI Full time

    Role: Database Administrator- PostgreSQL Experience: 4+yearsLocation: PAN IndiaImmediate joiners onlyOverviewWe are seeking an experienced PostgreSQL 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,...

  • Database Administrator- PostgreSQL

    6 days ago

    Bengaluru, India Innova ESI Full time

    Role: Database Administrator- PostgreSQLExperience: 4+yearsLocation: PAN IndiaImmediate joiners onlyOverviewWe are seeking an experienced PostgreSQL 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,...

  • Lead PostgreSQL Database Administrator

    2 days ago

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

    Job Title: Lead PostgreSQL Database AdministratorLocation:Bangalore / ChennaiExperience:7–9 YearsJob SummaryWe are looking for a highly skilledPostgreSQL 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...

  • PostgreSQL - Database Administrator

    5 hours ago

    Bengaluru, India Bottomline Technologies Full time

    **About us**: Bottomline We are hiring for Database Administrators for our internal production team for seamless performance of database in Bengaluru location. Applicant should be expert in PostgreSQL administration with interest to learn Oracle DBA skills. **Location: Bengaluru (Hybrid)** **Start date**:Immediate.** The Expert Database Administrator...

  • Database Administrator- PostgreSQL

    5 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, Chennai, India Methodhub Software Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Title: PostgreSQL DBAExperience :7+ yrs to 14 yrsLocation: Bangalore/ChennaiNotice Period: immediate or 15 daysSkills: Expertise in PostgreSQL database management and administration Expertise in database backup and recovery solutions. Expertise in database security practices. Expertise in at least one shell scripting language Deep understanding of...

  • Postgresql Database Administrator

    2 weeks ago

    Bengaluru, India Capgemini Full time

    Job Description Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired bya collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizationsunlock the value of...

  • 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

    4 days ago

    Bengaluru, Karnataka, India CloudThat Technologies Full time

    About the Role we are seeking a skilled **Database & Data Infrastructure Engineer** to manage and evolve our data layer technologies currently hosted on EC2 instances. This role is ideal for someone with strong PostgreSQL expertise and hands-on experience with data streaming, caching, and message queuing systems. As we transition to AWS managed services,...

  • PostgreSQL Database Administrator

    1 week ago

    Bengaluru, Karnataka, India Allstate Full time

    At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers’ evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing...