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