Cozzera logo

Database Architect – PostgreSQL

20 years

0 Lacs

jaipur rajasthan india

Posted:1 day ago| Platform: Linkedin logo

Apply

Skills Required

database postgresql design optimization engineering scalability security architecture strategies data storage documentation governance query tuning indexing monitoring planning management replication compliance leadership developer development devops migration aws azure gcp sql scripting audit communication microservices docker benchmarking certification

Work Mode

On-site

Job Type

Full Time

Job Description

Position Title:

Experience:

Location:

Employment Type:

Role Overview

Database Architect specializing in PostgreSQL

Key Responsibilities

Database Architecture & Design

  • Architect and design scalable PostgreSQL database solutions for enterprise-grade applications.
  • Develop database strategies for data modeling, storage, and performance optimization.
  • Define database design standards, documentation, and governance models.

Performance & Optimization

  • Conduct query tuning, indexing strategies, and database optimization for large datasets.
  • Establish monitoring, alerting, and capacity planning mechanisms.
  • Optimize schema design and database operations for performance and scalability.

Data Management & Security

  • Implement high-availability and disaster recovery (HA/DR) solutions.
  • Manage data replication, partitioning, and clustering.
  • Enforce database security, access control, and compliance policies.

Leadership & Collaboration

  • Mentor DBA and developer teams in best practices.
  • Collaborate with development, DevOps, and cloud teams on architecture and deployment.
  • Lead database migration and modernization initiatives.

Required Skills & Qualifications

  • 15–20 years of overall IT experience with 10+ years in database architecture and PostgreSQL.
  • Deep expertise in PostgreSQL internals, replication, partitioning, and performance tuning.
  • Strong knowledge of database design patterns, data modeling, and normalization.
  • Hands-on experience with cloud-based PostgreSQL (AWS RDS, Azure Database, or GCP SQL).
  • Advanced understanding of HA/DR tools (Patroni, Pgpool-II, repmgr).
  • Proficiency in SQL, PL/pgSQL, and scripting (Bash/Python).
  • Experience in data governance, audit compliance, and large-scale data environments.
  • Excellent leadership, communication, and documentation skills.

Preferred Skills

  • Exposure to microservices-based data architecture.
  • Familiarity with containerized PostgreSQL (Docker/Kubernetes).
  • Experience with performance benchmarking and monitoring tools like Prometheus, Grafana, or pgBadger.
  • Certification in PostgreSQL or Database Architecture is a plus.

More Jobs at Cozzera

Salesforce Business Analyst

Pune, Maharashtra, India

8 - 8 yrs
|

Salary: Not disclosed

MERN Stack Developer

Mumbai, Maharashtra, India

4 - 4 yrs
|

Salary: Not disclosed

Full Stack Engineer

Noida, Uttar Pradesh, India

8 - 8 yrs
|

Salary: Not disclosed

Salesforce Business Analyst

Pune, Maharashtra, India

9 - 9 yrs
|

Salary: Not disclosed

iOS Developer

Noida, Uttar Pradesh, India

Experience: Not specified

|

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

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

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.

Google Play App Store
coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Cozzera logo
Cozzera

RecommendedJobs for You

Cozzera logo

Database Architect – PostgreSQL

Cozzera

jaipur, rajasthan, india

Cozzera logo

Database Architect – PostgreSQL

Cozzera

jaipur, rajasthan, india