PostgreSQL DBA

Job Description

We are seeking a skilled and detail-oriented PostgreSQL Database Developer & Designer to join our team. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining scalable and secure PostgreSQL databases that support our application and business needs. Key Responsibilities: Design and develop efficient and scalable database schemas, tables, views, indexes, and stored procedures Develop and optimize complex SQL queries , functions, and triggers in PostgreSQL Perform data modeling and create ER diagrams to support business logic and performance Work closely with application developers to design and implement data access patterns Monitor database performance and tune queries for high availability and efficiency Maintain data integrity, quality, and security across all environments Develop and manage ETL processes, migrations, and backup strategies Assist in database version control and deployment automation Troubleshoot and resolve database-related issues in development and production Required Skills & Qualifications: Minimum 2–3 years of experience in PostgreSQL database development and design Strong understanding of relational database design principles , normalization, and indexing Proficient in writing complex SQL queries , functions, stored procedures, and performance tuning Experience with data modeling tools (e.g., pgModeler, dbdiagram.io, ER/Studio) Familiarity with database version control (e.g., Liquibase, Flyway) Solid understanding of PostgreSQL internals , query planner, and performance optimization techniques Knowledge of data security , encryption, and compliance standards Strong problem-solving skills and attention to detail Nice to Have (Pluses): Experience with cloud databases (e.g., Amazon RDS for PostgreSQL, Google Cloud SQL, Azure Database for PostgreSQL) Familiarity with NoSQL or hybrid data architectures Exposure to Kafka , RabbitMQ , or other message brokers Experience working in Agile/Scrum teams Knowledge of CI/CD pipelines for database deployments Understanding of data warehousing and analytics/reporting workflows What We Offer: Competitive compensation package Opportunity to work on high-impact systems and large-scale databases Collaborative team environment with growth and learning opportunities Remote-friendly and flexible work schedule Job Type: Full-time Pay: ₹1,500,000.00 per year Benefits: Health insurance Schedule: Day shift Experience: PostgreSQL: 5 years (Required) SQL: 5 years (Required) Work Location: In person Application Deadline: 05/07/2025 Expected Start Date: 01/08/2025