Senior Software Engineer

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.