PostgreSQL DBA

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