PostgreSQL DBA Architect

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

    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

    3 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

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

  • Aws PostgreSQL Database Administrator

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

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

  • PostgreSQL Dba

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

  • Senior DBA

    2 weeks ago

    Chennai, Tamil Nadu, India Photon Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Significant experience working with a diverse set of RDBMs including their installation, maintenance, data model design, query optimization, and monitoring."Experience in Elastic is required"Lead Database AdministratorResponsibilitiesAdministration of PostgreSQL, Snowflake, and any other databases throughout the development and production lifecycles in the...

  • Postgresql Database Administrator

    7 days ago

    Chennai, Tamil Nadu, India Appscore Solutions Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    HIRING FOR TOP MNCPostgreSQL DBA/3-6 /CHENNAI/30 TO 40% HIKE.WORK FROM HOME Backup & RecoveryPT & Query OptimizationReplication, Partitioning & ClusteringHigh Availability & Disaster Recovery Cloud DB: AWS RDS, Aurora, GCP CloudSQL

  • PostgreSQL Developer/Administrator

    2 weeks ago

    Bengaluru, Chennai, Pune, India Lancesoft Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Must have hands on experiencePrimary - PostgreSQLRequired Skills & Experience• 7+ years of hands-on experience as Database Developer/DBA.• Strong knowledge of MariaDB/MySQL and PostgreSQL internals.• Proven experience in end-to-end database migration projects.• Expertise in SQL tuning, indexing, partitioning, and query optimization.• Familiarity...

  • Postgresql Database Administrator

    2 weeks ago

    Chennai, Tamil Nadu, India Smartavya Analytica Full time ₹ 10,000 - ₹ 60,000 per year

    Job Title: Greenplum Database Administrator (DBA)/Postgresql DBAExperience: 2-8 years in DBA role, with last 2+ years in Greenplum or postgresqlLocation:Location:Department: Big Data, Analytics and CloudCompany: Smartavya Analytica Private limited is niche Data and AI company. Based in Pune, we are pioneers in data-driven innovation, transforming enterprise...