PostgreSQL Developer
Cloud Raptor
- Mumbai, Maharashtra
- Permanent
- Full-time
the digital age. Founded with a vision to bridge the gap between technology and business, we specialize
in delivering innovative, scalable, and secure IT services that drive real value.Our team comprises of passionate technologists, experienced consultants, and certified engineers who bring
deep expertise in cloud computing, software development, DevOps, AI/ML, cybersecurity, and enterprise IT
transformation. We serve a diverse portfolio of clients across BFSI, Retail, Utilities, Education, and Public
Sector domains, delivering customized solutions aligned with their unique goals.
With international presence in India , the Philippines , UK , and headquartered in Australia , we combine
global capabilities with local insight. Whether you're looking to modernize legacy systems, scale with
cloud infrastructure, or build AI-powered products, we help you accelerate innovation securely and
efficiently.At our core, we believe in building long-term partnerships, fostering continuous learning, and delivering outcomes
that matter. Let's calibrate your future with technology.Job Title: PostgreSQL DeveloperExperience: 4 5 Years
Location: Remote / MumbaiJob DescriptionWe are looking for a skilled PostgreSQL Developer with 4 5 years of hands-on experience in database development, performance optimization, and production support. The ideal candidate should be proficient in designing, developing, and maintaining high-performance PostgreSQL databases to support business-critical applications.Key Responsibilities
- Design, develop, and maintain PostgreSQL database schemas, tables, views, functions, and stored procedures
- Write optimized SQL queries and ensure efficient data access
- Perform database performance tuning, query optimization, and indexing
- Manage database migrations, upgrades, and version control
- Ensure data integrity, security, and compliance with best practices
- Troubleshoot database-related issues and provide production support
- Work closely with application developers, architects, and DevOps teams
- Implement backup, recovery, replication, and high-availability solutions
- Monitor database health, capacity planning, and performance metrics
- Document database architecture and operational procedures
- 4 5 years of experience working with PostgreSQL in production environments
- Strong proficiency in SQL, PL/pgSQL
- Hands-on experience with:
- Query optimization and performance tuning
- Indexing strategies and execution plans
- Partitioning and large-scale databases
- Knowledge of replication, WAL, streaming replication, failover
- Experience with backup & recovery tools (pg_dump, pg_restore, pg_basebackup)
- Familiarity with Linux/Unix environments
- Understanding of transaction management, locks, vacuum, and analyze
- Experience supporting databases for high-availability and DR setups
- Strong analytical and troubleshooting skills
- Experience with PostgreSQL extensions (PostGIS, pg_stat_statements, etc.)
- Exposure to cloud databases (AWS RDS/Aurora, Azure PostgreSQL, GCP)
- Knowledge of NoSQL or other RDBMS (MySQL, Oracle)
- Experience with CI/CD pipelines, Liquibase/Flyway
- Basic scripting knowledge (Shell, Python)
- Good communication and coordination skills
- Ability to work independently and in a team
- Strong problem-solving mindset
- Experience working in 24x7 production support environments (if applicable)
- Tailor this JD to banking/finance, RPA, or enterprise systems
- Make it shorter for job portals
- Convert it into a skills-based hiring checklist or interview questions