Postgresql Administrator

Pyramid It Consulting; Bengaluru; Hybrid; INR 5,000,000 - 7,000,000; Full time

Job summary

Pyramid It Consulting Bangalore seeks a senior PostgreSQL DBA with 10+ years of hands-on experience. You will manage 15+ PostgreSQL databases on Red Hat Linux, implementing security, backups, DR, and performance tuning.

The role requires working 5 days in office at Bagmane during KT sessions (6:30 PM to 2 PM IST) with shifts post KT. Strong scripting in Python/Perl/UNIX shell is expected.

Qualifications

• Minimum 10 years of hands-on PostgreSQL experience, including EPAS and community deployments.
• BCS or diploma in CS; postgraduate CS preferred.
• Build, configure, manage, document, and tune PostgreSQL 15+ on Red Hat Linux.
• Support databases across dev and prod lifecycles with operations teams.
• Provide reviews, troubleshooting, and adherence to company policies.
• Expert in security, auditing, and disaster recovery for PostgreSQL.

Responsibilities

• Lead design, development, and optimization of PostgreSQL services.
• Implement and monitor security, access, and encryption controls.
• Manage backups, patches, and vulnerability remediation.
• Ensure high availability, failover, and disaster recovery readiness.
• Collaborate with architects and build teams for smooth migrations.
• Provide technical guidance and coaching to juniors.

Skills

PostgreSQL expert

EPAS & community PostgreSQL

Red Hat Linux

Database tuning & performance

Backup & recovery (Barman)

High availability & DR

Security: encryption, RBAC, LDAP

Auditing & logging (pgAudit)

Scripting: Python/Perl/Unix shell

Monitoring & troubleshooting

Education

BS or diploma in Computer Science

Postgraduate CS preferred

Tools

pgAdmin

Barman

PostgreSQL replication

Open source databases (assets)

CA-7/AutoSys (assets)

Job description

Location: Only Bangalore

Level: M/SM
Exp: M 8 to 12 Yrs
SM - 12-16 Yrs

Must be willing to work 5 days in office (Bagmane) during the KT session (6:30 PM to 2 PM IST)

Shifts will be general or UK shift post KT

JOB DESCRIPTION:

Mandatory technical skills include:

• Minimum 10 years of hands‑on experience with PostgreSQL, including EnterpriseDB Postgres Advanced Server (EPAS) and community PostgreSQL deployments.
• Undergraduate degree or diploma in Computer Science. A postgraduate degree in Computer Science is preferred.
• Responsible for building, implementing, configuring, managing, documenting, and tuning PostgreSQL 15+ databases on Red Hat Linux.
• Support PostgreSQL databases across development and production lifecycles in collaboration with related operational teams.
• Provide PostgreSQL database solution reviews and advice within company policies; troubleshoot and resolve PostgreSQL database‑related issues.
• Provide expert knowledge in the design and development of PostgreSQL database services, standards, automation, and operational best practices.
• Experience with PostgreSQL database security, encryption, role‑based access control, and authentication methods such as LDAP or certificate‑based authentication.
• Expert‑level knowledge of PostgreSQL user access management, roles, privileges, and schema‑level security controls.
• Expert‑level knowledge of PostgreSQL auditing, logging, and monitoring, including configuration of server logs, pgAudit, and audit control baselines.
• Hands‑on experience deploying Postgres database security patches and remediating database vulnerabilities.
• Expert‑level knowledge of financial industry compliance requirements such as SOX, PCI DSS, FISMA, the Gramm‑Leach‑Bliley Act, and FATCA.
• Expert experience with PostgreSQL high availability and disaster recovery solutions, including streaming replication, logical replication, failover architecture, and recovery planning.
• Expert‑level knowledge of PostgreSQL replication, failover, and recovery technologies, including physical replication, logical replication, and standby management.
• Experience performing PostgreSQL backup and recovery using tools such as Barman, and native backup and restore utilities.
• Expert‑level knowledge of PostgreSQL performance tuning and analysis using tools such as PEM, pgAdmin, EXPLAIN/ANALYZE, and system‑level monitoring utilities.
• Solid hands‑on experience troubleshooting and resolving urgent or critical incidents on production systems.
• Experience with Python, Perl, and UNIX shell scripting is required.
• Provide sound advice and/or act in a lead capacity for operational systems/applications planning, performance, availability, integration, operations support, and release/deployment management.
• Develop and recommend technical strategies and solutions to maintain and/or expand service levels.
• Work with architects, design teams, and build teams to ensure that environment modifications interact appropriately, data conversion impacts are considered, and other areas of impact are addressed to meet project performance requirements.
• Influence product direction, foresee issues and gaps, identify solutions, and work comfortably with leading‑edge products that may be untested or emerging in the market.
• Work independently and/or autonomously on a diverse range of tasks and operational support activities and be relied upon to coach and educate others.

Proficiency with the Microsoft Office product suite (Word, Excel, PowerPoint, Project, Visio, etc.).

The following qualifications are considered as assets:

• Experience with Storage Area Networks (SAN).
• Familiarity with the CA-7/AutoSys enterprise batch scheduling solution.
• Knowledge of Open source Non-Relational Databases