Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in chennai
>
Likewize
>
PostgreSQL DBA Architect

PostgreSQL DBA Architect

Likewize

10 years

0 Lacs

chennai tamil nadu

Posted:1 month ago| Platform: SimplyHired logo

Apply

Skills Required

azure computer science master's degree sql aws bachelor's degree scripting python

Work Mode

On-site

Job Type

Full Time

Job Description

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.

More Jobs at Likewize

NOC monitoring Engineer

Chennai, Tamil Nadu, India

6.0 - 6.0 yrs

Salary: Not disclosed

Sr.JDE CNC Admin

Greater Chennai Area

5.0 - 5.0 yrs

Salary: Not disclosed

Application Support Analyst

Greater Chennai Area

Experience: Not specified

Salary: Not disclosed

Fullstack Developer

Greater Chennai Area

6.0 - 6.0 yrs

Salary: Not disclosed

SAG Support Analyst

greater chennai area

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Likewize

Technology Services

Minneapolis

Login to

Please Verify Your Phone or Email

Confirm Action

PostgreSQL DBA Architect