PostgreSQL DBA Architect

6 days ago

India SSC Chennai Likewize Full time ₹ 7,00,000 - ₹ 21,00,000 per year

Job Description:

Job Title: PostgreSQL DBA Architect

Job Summary:

The PostgreSQL DBA Architect is responsible for designing, implementing, and maintaining robust PostgreSQL database solutions that meet enterprise-level performance, scalability, and security requirements. The role combines deep technical expertise with architectural vision, ensuring optimal data availability, disaster recovery, and integration with application and cloud ecosystems.

This is a hands-on role, requiring strong administration, optimization, and troubleshooting skills alongside architectural leadership.

Key Responsibilities:

Database Architecture & Design


• Design and architect PostgreSQL database systems for high availability, performance, and scalability.


• Define database standards, schema design principles, and best practices for indexing and partitioning.


• Plan and implement replication, sharding, and failover strategies.


• Develop and maintain database capacity and scalability plans.

Administration & Operations


• Install, configure, and upgrade PostgreSQL servers and extensions.


• Manage roles, users, privileges, and security policies.


• Implement automated backup, recovery, and disaster recovery procedures.


• Monitor database health using tools like pgAdmin, pg_stat_statements, Prometheus, Grafana, or pgbouncer.


• Perform performance tuning, query optimization, and resource utilization monitoring.

Cloud & DevOps Integration


• Deploy and manage PostgreSQL on AWS RDS, Aurora, Azure PostgreSQL.


• Integrate PostgreSQL into CI/CD pipelines using tools like Jenkins, GitLab, or Terraform.


• Automate database provisioning and configuration through Infrastructure as Code (IaC).

Security & Compliance


• Implement data encryption (at rest and in transit), auditing, and monitoring for compliance.


• Ensure adherence to regulatory standards (SOC, ISO27001, etc.).

Collaboration & Leadership


• Collaborate with application developers and data engineers for schema optimization and SQL tuning.


• Lead database modernization initiatives, including migrations from MSSQL Server /MySQL to PostgreSQL.


• Provide technical mentorship to DBAs and development teams.


• Create and maintain detailed architecture and operational documentation.

Required Qualifications:


• Bachelor's or Master's degree in Computer Science, Information Technology, or related field.


• 10+ years of overall DBA experience, with at least 6+ years focused on PostgreSQL.


• Proven experience in PostgreSQL architecture, administration, and performance tuning.


• Expertise in logical and physical replication, connection pooling, and high availability (Patroni, repmgr, or Pacemaker).


• Hands-on experience with PostgreSQL on cloud platforms (AWS).


• Strong scripting skills in Python, Bash, or PowerShell for automation.


• Solid understanding of database internals, query planner, and indexing strategies.


• Experience in database migration, upgrade, and version management.

  • Experience in DynamoDB configuration and JSON Scripts.

Preferred Skills:


• Knowledge of containerized environments (Docker, Kubernetes).


• Exposure to NoSQL databases (DynamoDB, Redshift) is a plus.


• Certifications such as EDB PostgreSQL DBA, AWS Database Specialty.

  • PostgreSQL DBA Architect

    4 weeks ago

    Chennai, India Likewize Full time

    Description :Job Title: PostgreSQL DBA Architect Job Summary: The PostgreSQL DBA Architect is responsible for designing, implementing, and maintaining robust PostgreSQL database solutions that meet enterprise-level performance, scalability, and security requirements. The role combines deep technical expertise with architectural vision, ensuring optimal data...

  • PostgreSQL DBA Architect

    4 days ago

    Greater Chennai Area, India Likewize Full time

    Job Description:Job Title: PostgreSQL DBA ArchitectJob Summary:The PostgreSQL DBA Architect is responsible for designing, implementing, and maintaining robust PostgreSQL database solutions that meet enterprise-level performance, scalability, and security requirements. The role combines deep technical expertise with architectural vision, ensuring optimal data...

  • PostgreSQL DBA

    3 weeks ago

    Mumbai, India Simple Logic IT Private Limited Full time

    Job Description Job Title: Lead Database Administrator Location: Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai *Immediate Joiners Only* Required Skills & Experience: PostgreSQL DBA (Level 3) - 5+ years of hands-on PostgreSQL DBA experience in production environments. - Deep knowledge of PostgreSQL internals, architecture, and tuning. - Proven...

  • PostgreSQL DBA

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

  • PostgreSQL DBA

    2 weeks ago

    Bengaluru, Karnataka, India, Karnataka Tata Consultancy Services Full time

    TCS Hiring for PostgreSQL DBA Experience Range : 10 To 15 yearsJob Location : Delhi, Hyderabad, Bengaluru, Pan IndiaJOB DESCRIPTIONMust have skills: PostgreSQL installation and Configuration on Linux/Windows OS platform.Configuring HA, DR databases.Database upgrades and applying PSU packs.Hands on experience in writing/troubleshooting shell...

  • Senior Associate Database Administrator

    1 week ago

    Bengaluru, India Datavail Full time

    Job Description Job Description Job Title: Senior Associate Database Administrator - PostgreSQL DBA Education: Any Graduate Experience: 6+years Location: 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...

  • PostgreSQL DBA

    2 weeks ago

    Hyderabad, India Infosys Full time

    Job Description PostgreSQL Server (latest stable versions, e.g., 14, 15, 16), psql (PostgreSQL command-line tool), pgAdmin (GUI for PostgreSQL management), pg_stat_statements (for query performance analysis), Point-in-Time Recovery (PITR), Barman / WAL-G / pgBackRest, Streaming Replication, Logical Replication, Patroni (for HA and failover), repmgr...

  • Contractor - Postgres DBA

    7 days ago

    Mumbai, India Datavail Full time

    Job Description Job Description Job Title: Technical Specialist Education: MCA/B.E/B.Tech/B.Sc/Any Graduation Experience: 8+years Location: Bangalore/Mumbai/Hyderabad 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...

  • PostgreSQL DBA

    2 weeks ago

    Bengaluru, Karnataka, India, Karnataka Infinite Computer Solutions Full time

    PostgreSQL Experience managing PostgreSQL databases. Install, configure, and upgrade PostgreSQL database systems on Linux platforms.Experience setting up and managing Cassandra or MongoDB or CosmosDBMonitor and manage database performance, capacity, and health to ensure optimal functionality and availability.Perform regular backups, recovery, and disaster...

  • PostgreSQL DBA

    3 days ago

    Bengaluru, Karnataka, India, Karnataka Infinite Computer Solutions Full time

    Work Location: -Whitefield, Bangalore / Mepz, Chennai5 Days working from OfficeExperience:- 7+ YearsPostgreSQL Experience managing PostgreSQL databases. Install, configure, and upgrade PostgreSQL database systems on Linux platforms.Experience setting up and managing Cassandra or MongoDB or CosmosDBMonitor and manage database performance, capacity, and health...