Talent.com
This job offer is not available in your country.
PostgreSQL Developer

PostgreSQL Developer

Samvid SearchNoida
30+ days ago
Job description

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.

    (ref : hirist.tech)

    Create a job alert for this search

    Developer Postgresql • Noida