PostgreSQL DBA Architect

2 days ago

Greater Chennai Area, India Likewize Full time ₹ 12,00,000 - ₹ 24,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

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

    India SSC- Chennai Likewize Full time ₹ 12,00,000 - ₹ 36,00,000 per year

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

  • Colan Infotech

    4 weeks ago

    Chennai, India Colan Infotech Pvt Ltd Full time

    DBA Architect PostgreSQL, Performance & Enterprise ComplianceJob Description : We are seeking an expert-level DBA Architect with 10+ years of extensive experience to join our team in Chennai. This critical role demands a master practitioner in PostgreSQL and database architecture, responsible for designing, building, and governing the performance,...

  • PostgreSQL Dba

    4 days ago

    Chennai, India Agilysys, Inc. Full time

    **About Company** We are looking for a capable resource to Responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration and maintaining mission critical production MS SQL Server /PostgreSQL databases both On-Prem and Cloud. **Responsibility** - Experience as DBA MS SQL/Azure SQL/ PostgreSQL...

  • Senior Aurora PostgreSQL Database Administrator

    1 week ago

    Greater Hyderabad Area, India JAGGAER Full time

    OverviewAs a Senior Aurora/PostgreSQL DBA, you will be responsible for managing, optimizing, and scaling our cloud-based database infrastructure. You'll play a critical role in ensuring high availability, performance, and security across our AWS-hosted environments.You will also be part of an international DBA team that manages a diverse portfolio of...

  • PostgreSQL Dba

    2 days ago

    Chennai, India Resourcetree Full time

    DB Architect for SQL Server, Snowflake, and Dynamics 365. - 4+ Years of experience cloud DB technologies viz SQL Azure and snowflake. Experience on DB Migration from On-Premise to Cloud. - 3+ Years of Experience in Dynamics 365 Administration. - 5+ years of experience in End to End team Management. - 8+ Years of experience inDataQuality Management(DQM) and...

  • Aws PostgreSQL Database Administrator

    1 week ago

    Tharamani, Chennai, Tamil Nadu, India mds hr consultancy Full time

    Designation - AWS PostgreSQL Database Administrator (DBA) No of Positions opening for : 1 Experience must be between 3-4 Years CTC upto - 13,00,000 **Position Overview**: As an AWS PostgreSQL Database Administrator (DBA), you will play a critical role in managing and maintaining the performance, integrity, and security of PostgreSQL databases hosted on...

  • Sr. Oracle DBA, RAC, PostgreSQL

    1 week ago

    Chennai, Tamil Nadu, India Atos Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Job Summary We are seeking an experienced and proactive Senior Database Administrator (DBA) with 8–10 years of experience in Oracle database administration and a proven track record in supporting enterprise-grade systems. The ideal candidate will have at least 5 years of hands-on experience managing Oracle RAC and Data Guard setups, performance tuning...

  • Dba Architect

    2 days ago

    Greater Noida, India Coforge Ltd. Full time

    This role will require troubleshooting and a high sense of responsibility for the problems and requests. - Communication and timeliness are a must in problem solving, initiating change, and escalation. Your day-to-day role will include: - Proactive DBA Activities to Improve Database Environment. - Serve as escalation from Tier 2. - Provide 24x7x365 DBA...

  • PostgreSQL Dba

    2 weeks ago

    Chennai, Tamil Nadu, India I2B Solution Full time

    **Requirements**: - Strong experience in Postgres Product Coding - Feature development, Bug fixes, Review Patches, Security Patches, Code fixes related to Long-Term Support, Performance Optimizations to queries and indexing strategies, Contribute Modules, Foreign Data Wrappers. - Certify and standardize database infrastructure. - Stay updated with the...