PostgreSQL DBA Architect

3 days ago

chennai, 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 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

    1 week 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

    1 week ago

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

  • PostgreSQL DBA Architect

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

  • PostgreSQL Dba

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

  • PostgreSQL Dba

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

  • PostgreSQL DBA | Walkin | Chennai | TCS-C2H | 6+ Exp | 19th Nov

    1 week ago

    Chennai, Tamil Nadu, India Coventine Digital Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Interview Mode :Only face to faceWork more :WFO (5 days)Work Location: CHENNAI, TNJob Title: System AdministratorExperience: 6-8 YearsSkill Required: PostgreSQLJob Title: : Senior PostgreSQL Database Engineer (Reliability and Architecture)Role: PostgreSQL Admin L3Responsibilities:Leads PostgreSQL architecture and reliability. The role spans HA and DR design,...

  • SQL Dba

    4 days ago

    Chennai, India Servion Global Solutions Full time

    Job Description: - #LI-DNI - In this role, the PostgreSQL DBA will design, build, test, and deploy quality database solutions that are consistent with project objectives, technology architecture standards and departmental best practices. The DBA will design and implement database strategies, administer enterprise-wide data architecture, implement complex...

  • Postgresql Database Administrator

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

  • Looking for PostgreSQL Trainer

    2 weeks ago

    Chennai, India Intellecto Global Services Full time

    **Responsibilities**: - Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc. - Work closely with the CTO to implement effective and maintainable database coding practices that form an architectural foundation. - Work with front end developers to define simple yet powerful APIs. - Work with GIS...

  • SQL Server Application DBA

    4 days ago

    Chennai, India Gainwell Technologies Full time

    Summary We are looking for a highly skilled and motivated SQL DBA to join our dynamic DBA team.If you are passionate about technology, thrive in a collaborative environment, and have a knack for solving complex problems, this role is perfect for you. This role is strictly involved in the DBA of the product and does not involve access to Protected Health...