Talent.com
No longer accepting applications
Lead Database Application Engineer

Lead Database Application Engineer

Prophecy TechnologiesHyderabad, Republic Of India, IN
3 days ago
Job description

Location : Hyderabad / WFO

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

    Application Engineer • Hyderabad, Republic Of India, IN