PostgreSQL DBA Architect
1 day ago
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
6 days ago
Pune, India Tata Consultancy Services Full timeJob Description TCS has been a great pioneer in feeding the fire of Young Techies like you. We are a global leader in the technology arena and there's nothing that can stop us from growing together. We are Hiring For PostgreSQL DBA Job Description Experience: 5-12years Location: Mumbai, Pune, Delhi, Kolkata, Hyderabad, Bangalore, Nagpur, Indore Required...
-
AWS PostgreSQL Database Administrator
2 weeks ago
India Springbord Full timeSpringbord is hiring an experienced AWS PostgreSQL Database Administrator (DBA) with 8–12 years of hands-on expertise in managing, optimizing, and securing PostgreSQL databases on AWS. This role is ideal for a skilled database professional who can ensure high performance, reliability, and automation of database operations in a cloud environment. Job Title...
-
Senior AWS PostgreSQL DBA
1 week ago
IND - - Bangalore Based Entity, India LabCorp Full time ₹ 20,00,000 - ₹ 25,00,000 per yearSr. AWS PostgreSQL DBA Labcorp is recruiting a Senior AWS PostgreSQL DBA for a dynamic team in either the RTP or Burlington, NC area. Get ready to redefine what's possible and discover your extraordinary potential at Labcorp. Here, you'll have the opportunity to personally advance healthcare and make a difference in peoples' lives with your bold ideas...
-
AWS PostgreSQL Database Administrator
2 weeks ago
India Springbord Full time𝐉𝐨𝐢𝐧 𝐎𝐮𝐫 𝐓𝐞𝐚𝐦 𝐚𝐭 𝐒𝐩𝐫𝐢𝐧𝐠𝐛𝐨𝐫𝐝! Springbord is hiring an experienced AWS PostgreSQL Database Administrator (DBA) with 8–12 years of hands-on expertise in managing, optimizing, and securing PostgreSQL databases on AWS. This role is ideal for a skilled database professional who can ensure high...
-
PostgreSQL DBA
1 week ago
Hyderabad, Telangana, , India Kshema Full time ₹ 12,00,000 - ₹ 24,00,000 per yearAt Kshema, we are re -imagining agriculturalinsurance with the power of Public Cloud, GIS, Remote sensing and cutting -edgeAI -based algorithms to assess, model and price insurance risks for farmersadequately. We are taking the latest advances in Mobile, Geospatialtechnologies and the web to empower the next generation of agriculturalinsurance. We are...
-
AWS PostgreSQL Database Administrator
2 weeks ago
India Springbord Full time𝐉𝐨𝐢𝐧 𝐎𝐮𝐫 𝐓𝐞𝐚𝐦 𝐚𝐭 𝐒𝐩𝐫𝐢𝐧𝐠𝐛𝐨𝐫𝐝!Springbord is hiring an experienced AWS PostgreSQL Database Administrator (DBA) with 8–12 years of hands-on expertise in managing, optimizing, and securing PostgreSQL databases on AWS. This role is ideal for a skilled database professional who can ensure high...
-
DBA Architecht
2 weeks ago
Gurugram, Haryana, , India Overture Rede Full time ₹ 12,00,000 - ₹ 36,00,000 per yearJob Summary: The DBA will lead the overhaul of the existing SQL Server database to amodern, scalable SQL, PostgreSQL or other scalable backend on AWS. This role involvesdesigning and implementing the new database architecture, ensuring data integrity, optimizingperformance, and supporting the development team in translating old business logic to the...
-
Colan Infotech
3 weeks ago
Chennai, India Colan Infotech Pvt Ltd Full timeDBA 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
1 day 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...
-
Kochi, Kerala, , India Ellow Technologies Full time ₹ 18,00,000 - ₹ 24,00,000 per yearTitle – DBA Multi Platform Oracle Apps Exadata PostgreSQL Experience : 6+ years. Location: Kochi, TVM, Bangalore Budget: 6 to 8 Years -17LPA Years -24LPA Job Description Role - DBA - Multi -Platform – Oracle Apps DBA, EBS ,Exadata , PostgreSQL Experience: 6+ years Role Overview: We are seeking a seasoned and hands -on Database Administrator (DBA) with...