Job Description

Job Title: Senior Software Engineer - PostgreSQL Developer

Years of Experience: 4 to 8 years

Location: Bangalore


###### Role Summary:


• Participate in the design and architecture of new and existing database features.
• Develop high-quality, maintainable, and efficient code using PostgreSQL.
• Conduct code reviews, unit testing, and integration testing of database components.
• Deploy database changes to various environments (development, testing, production).
• Collaborate with cross-functional teams to deliver high-quality database solutions.
• Troubleshoot and resolve database-related production issues.
• Continuously improve database development and optimization practices.

###### What skills are required?


• Bachelor's / Master's degree in computer science or a related field.
• 4 to 8 years of experience in SQL, PL/pgSQL (PostgreSQL).
• Advanced proficiency in SQL and PL/pgSQL, including functions, triggers, and stored procedures.
• Deep understanding of PostgreSQL architecture, database internals, and configuration management.
• Expertise in performance tuning, query optimization, and indexing strategies.
• Experience with database design, schema management, and normalization/denormalization techniques.
• Proficiency in handling complex data types, such as JSON/JSONB, arrays, hstore, and CTEs (Common Table Expressions).
• Knowledge of advanced PostgreSQL features like partitioning, sharding, and replication.
• Familiarity with backup, recovery, failover strategies, disaster recovery, and point-in-time recovery (PITR).
• Knowledge of security best practices, including role management, GRANT/REVOKE permissions, SSL/TLS setup, and data encryption.
• Experience in setting up auditing, monitoring, and compliance controls.
• Experience with cloud-based database solutions (AWS RDS, Google Cloud SQL, Azure PostgreSQL).
• Expertise in using monitoring tools like pg_stat_statements, pgBadger, Prometheus, Grafana, and Datadog.
• Proficiency in diagnosing and resolving issues related to database performance, memory usage, and locks.
• In-depth knowledge of PostgreSQL's MVCC (Multi-Version Concurrency Control) model, transaction isolation levels, and deadlock resolution. Should have knowledge on concurrency and lock management.
• Experience in upgrading PostgreSQL versions and migrating databases with minimal downtime.
• Familiarity with tools like pg_upgrade, pg_dump, pg_restore, and logical replication for migrations.
• Good communication and teamwork skills.
• Strong interpersonal, analytical, and problem-solving skills.
• Should be an excellent team player.

###### Additional Skill Set:


• Java 1.8 +
• JDBC
• J2EE Technologies like servlets and JSP's.
• Spring Framework, Spring Boot.
• Front-end Technologies like HTML, CSS, JavaScript, JQuery, Ajax