PostgreSQL Developer

• Design and implement robust database schemas, tables, and dictionary structures
• Write and maintain high-performance PL/pgSQL, including complex stored procedures, triggers, and views
• Analyze query execution plans using EXPLAIN ANALYZE and implement optimizations such as indexing (B-tree, GIN, GiST) and partitioning
• Ensure the consistency and reliability of data through proper normalization and constraint management
• Monitor database performance, perform regular vacuuming, and manage bloating issues
• Work closely with Backend Engineers and PMO to translate business requirements into efficient data models
• Manage data migration, transformation, and scripting using Git for version control

• B.Tech or M.Tech in Computer Science, IT, or a related Engineering discipline
• 3 to 5 years of dedicated experience in PostgreSQL development and administration
• Expert-level knowledge of SQL, including window functions, CTEs, and complex joins
• Strong experience in tuning slow queries and understanding PostgreSQL internals (WAL, Buffer Cache)
• Proficiency with pgAdmin, DBeaver, and command-line psql
• Knowledge of Role-Based Access Control (RBAC) and data encryption practices
• Immediate Availability: Candidates who can join immediately or within 15 days
• Analytical Mindset: Ability to troubleshoot complex data issues and provide scalable solutions
• Strong verbal and written communication skills for internal team coordination

Experience with cloud databases (AWS RDS/Aurora) or NoSQL features within PostgreSQL (JSONB)

• Engage with cutting-edge technologies and diverse project domains
• A transparent work culture focused on objective performance and growth
• Competitive compensation package and employee-centric benefits