PostgreSQL Developer

PostgreSQL Developer

Position Overview :

We are seeking an experienced PostgreSQL Developer with strong expertise in database design, development, and performance optimization. The ideal candidate will have hands-on experience with PostgreSQL, MS SQL, and related database tools, with a strong ability to write optimized queries, manage database operations, and ensure high availability through replication and tuning.

Key Responsibilities :

- Design, develop, and maintain databases using PostgreSQL and MS SQL.

- Write, optimize, and maintain complex SQL queries, stored procedures, functions, and triggers.

- Perform query optimization and performance tuning for large-scale datasets.

- Create and manage indexes (clustered, non-clustered) to improve database performance.

- Monitor and resolve deadlocks and concurrency issues in PostgreSQL.

- Configure and manage PostgreSQL replication for high availability and disaster recovery.

- Implement and maintain multi-version concurrency control (MVCC) strategies.

- Work with PGAdmin and other database tools for monitoring, backup, and administration.

- Ensure data integrity, consistency, and security across multiple environments.

- Collaborate with developers and system administrators for database integration and system performance.

Required Skills & Experience :

- 5+ years of proven experience as a Database Developer (PostgreSQL, MS SQL).

- Strong knowledge of PostgreSQL architecture, internals, and administration.

- Hands-on experience with query tuning, indexing strategies, and deadlock handling.

- Proficiency in PL/pgSQL and T-SQL for writing stored procedures and functions.

- Experience with database replication, backup & recovery, and clustering.

- Knowledge of MVCC, transaction control, and concurrency handling.

- Familiarity with Change Tracking (CT) and version control mechanisms.

- Strong problem-solving and debugging skills for database performance issues.

- Experience with PGAdmin, monitoring tools, and SQL Profiler.

Good to Have :

- Knowledge of cloud databases (AWS RDS, Azure PostgreSQL, or GCP Cloud SQL).

- Experience with data migration between PostgreSQL and MS SQL.

- Familiarity with DevOps, CI/CD pipelines, and database automation scripts.

Education :

Bachelors degree in Computer Science, Information Technology, or related field.