Talent.com
Software Engineer

Software Engineer

Prophecy Technologiesnagpur, maharashtra, in
13 hours ago
Job description

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, 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

o Design normalized and denormalized database schemas for high-performance applications.

o Develop complex SQL queries, functions, views, triggers, and stored procedures to support application needs.

  • Performance Optimization

    • o Write highly efficient queries , ensuring performance and scalability.

    o Conduct query tuning and indexing strategies to reduce latency.

    o Optimize data retrieval processes for real-time and batch processing workloads.

  • Application Development Integration

    • o Collaborate with backend developers to build seamless integrations with PostgreSQL.

    o Support APIs and microservices by designing effective database interaction layers .

    o Work on ETL pipelines and data transformation tasks.

  • Testing & Quality Assurance

    • o Write unit tests for queries and procedures using tools like pgTAP .

    o Ensure data consistency and accuracy across environments.

    o Perform code reviews for SQL scripts and database logic.

  • Collaboration & Delivery

    • o Partner with product teams to translate business requirements into efficient database solutions .

    o Document database designs, queries, and logic for maintainability.

    o 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 Elastics 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.
    • Create a job alert for this search

    Software Engineer • nagpur, maharashtra, in