Postgresql Developer

1 week ago

Hyderabad Secunderabad, India virtusa consulting services pvt. ltd. Full time ₹ 20,00,000 - ₹ 25,00,000 per year
Job Description

Job Title: Senior PostgreSQL Developer
Location: Hyderabad
Experience Required: 8 Years

Job Summary

We are looking for an experienced PostgreSQL Developer with deep expertise in SQL development, schema design, query optimization, stored procedures, and application integration. The ideal candidate will have a strong background in building scalable database solutions, writing complex queries, and collaborating with backend/frontend teams to ensure efficient and reliable data access. This role is focused on development and engineering within PostgreSQL.

Roles and Responsibilities Database Design & Development
  • Design normalized and denormalized database schemas for high-performance applications.
  • Develop complex SQL queries, functions, views, triggers, and stored procedures to support application needs.
Performance Optimization
  • Write highly efficient queries, ensuring performance and scalability.
  • Conduct query tuning and indexing strategies to reduce latency.
  • Optimize data retrieval processes for real-time and batch processing workloads.
Application Development Integration
  • Collaborate with backend developers to build seamless integrations with PostgreSQL.
  • Support APIs and microservices by designing effective database interaction layers.
  • Work on ETL pipelines and data transformation tasks.
Testing & Quality Assurance
  • Write unit tests for queries and procedures using tools like pgTAP.
  • Ensure data consistency and accuracy across environments.
  • Perform code reviews for SQL scripts and database logic.
Collaboration & Delivery
  • Partner with product teams to translate business requirements into efficient database solutions.
  • Document database designs, queries, and logic for maintainability.
  • Provide technical guidance to junior developers and peers on best practices in SQL coding.
Primary Skills:
  • Strong expertise in PostgreSQL development (schemas, functions, triggers, views, stored procedures).
  • Advanced skills in SQL query writing and optimization.
  • Hands-on experience with query execution plans and indexing strategies.
  • Experience in data modeling, relational design, and query performance tuning.
  • Strong knowledge of transactions, concurrency control, and isolation levels.
  • Exposure to application development with PostgreSQL (integration with Java, Python, or other languages).
  • Exposure to cloud-hosted PostgreSQL services (AWS RDS/Aurora, GCP Cloud SQL/Spanner).
  • Extensive experience in database performance improvement.
  • Experience in Migration from Legacy DB to Postgres DB.
  • Hands-on experience with shell scripting.
  • Knowledge on Elastic Search.
Secondary Skills:
  • Working knowledge of unit testing frameworks for SQL logic (pgTAP, DbUnit).
  • Experience with PostgreSQL extensions (PostGIS, pg_stat_statements, pg_trgm, TimescaleDB).
  • Experience with database backup, recovery, and high availability solutions.
  • Proficiency in database security best practices and access control.
  • Knowledge of ETL tools (Apache Airflow, Talend, dbt) and data pipelines.
  • Familiarity with message brokers like Kafka/ActiveMQ for streaming integration.
  • Good understanding of CI/CD pipelines for database code deployment.

  • Postgresql Developer

    5 days ago

    Hyderabad, Telangana, India Mirabel Technologies Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Job SummaryWe are seeking a skilled and proactive PostgreSQL Developer / Administrator to join our team in Hyderabad. The ideal candidate will have strong experience in both database development and administration, with a focus on performance tuning, high availability, and operational efficiency in production PostgreSQL environmentsboth self-hosted and...

  • PostgreSQL Developer

    1 week ago

    Hyderabad, Telangana, India Bees Software Solutions Full time ₹ 1,50,000 - ₹ 28,00,000 per year

    We are looking for a talented PostgreSQL Developer to design, develop, and maintain robust, scalable, and secure database solutions to power our educational software platforms.Youll work closely with our backend developers, product team, and data analysts to ensure high performance and availability of mission-critical data.PostgreSQL DevelopmentStrong SQL &...

  • Qentelli - PostgreSQL Developer

    2 weeks ago

    Hyderabad, India Qentelli Solutions Full time

    Job Summary : We are looking for an experienced PostgreSQL Developer with a strong background in Oracle database development. The role involves designing, writing, and optimizing SQL and PL/pgSQL code, migrating database logic from Oracle to PostgreSQL, and working closely with application teams to implement data-driven solutions.This is a...

  • PostgreSQL

    1 week ago

    Hyderabad, India Teamware Solutions Full time

    Job Description Teamware Solutions is looking for a skilled PostgreSQL Database Administrator / Developer to manage, maintain, and optimize our critical PostgreSQL database environments. You'll be responsible for ensuring the high availability, performance, and security of our data, playing a vital role in our data infrastructure. This position is ideal for...

  • Postgresql Developer

    2 weeks ago

    Hyderabad, Telangana, India Ispace Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Required Skills & Qualifications6-10 years of experience in PostgreSQL development and administration.Expertise in SQL query optimization, indexing strategies, and partitioning.Strong knowledge of database replication, clustering, and high availability.Hands-on experience with PL/pgSQL functions, triggers, and stored procedures.Proficiency in Linux-based...

  • Senior PostgreSQL Developer

    2 weeks ago

    Hyderabad, India Prophecy Technologies Full time

    Role: Senior PostgreSQL Developer Experience: 5+ years Location: Hyderabad | Hybrid JD: We are looking for an experienced PostgreSQL Developer with deep expertise in SQL development, schema design, query optimization, stored procedures, and application integration. The ideal candidate will have a strong background in building scalable database solutions,...

  • Senior PostgreSQL Developer

    3 weeks ago

    Hyderabad, India Prophecy Technologies Full time

    Role: Senior PostgreSQL Developer Experience: 5+ years Location: Hyderabad | Hybrid JD: We are looking for an experienced PostgreSQL Developer with deep expertise in SQL development, schema design, query optimization, stored procedures, and application integration. The ideal candidate will have a strong background in building scalable database solutions,...

  • Senior PostgreSQL Developer

    3 weeks ago

    Hyderabad, India Prophecy Technologies Full time

    Role: Senior PostgreSQL DeveloperExperience: 5+ yearsLocation: Hyderabad | HybridJD:We are looking for an experienced PostgreSQL Developer with deep expertise in SQL development, schema design, query optimization, stored procedures, and application integration. The ideal candidate will have a strong background in building scalable database solutions, writing...

  • Senior PostgreSQL Developer

    6 days ago

    Hyderabad, India Prophecy Technologies Full time

    Description :Role : Senior PostgreSQL Developer.Experience : 5+ years.Location : Hyderabad | Hybrid.JD :We are looking for an experienced PostgreSQL Developer with deep expertise in SQL development, schema design, query optimization, stored procedures, and application integration.The ideal candidate will have a strong background in building scalable database...

  • Senior PostgreSQL Developer

    5 days ago

    Hyderabad, Telangana, India Prophecy Technologies Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Description : Role : Senior PostgreSQL Developer. Experience : 5+ years. Location : Hyderabad | Hybrid.JD : We are looking for an experienced PostgreSQL Developer with deep expertise in SQL development, schema design, query optimization, stored procedures, and application integration. The ideal candidate will have a strong background in building...