PostgreSQL and SQL
ConfidentialHyderabad / Secunderabad, Telangana30+ days ago
Job descriptionStrong hands-on experience with PostgreSQL (version 12 or later preferred) Advanced proficiency in SQL (DDL, DML, joins, subqueries, window functions, etc.) Experience in writing and debugging stored procedures , functions , and triggers Experience with PL / pgSQL scripting Knowledge of PostgreSQL performance tuning , indexing strategies, and partitioning Familiarity with ETL tools or data migration frameworks Experience with database monitoring tools (e.g., pgAdmin, pg_stat_statements) Exposure to Linux-based database administration Version control with Git
Key Responsibilities :
- Design and implement PostgreSQL database schemas , tables, indexes, and constraints.
- Develop, test, and optimize complex SQL queries , stored procedures, functions, and triggers.
- Analyze and improve query performance using EXPLAIN plans , indexing, and tuning techniques.
- Maintain data integrity, security, and availability in PostgreSQL environments.
- Collaborate with development and data teams to support applications, ETL processes, and reporting needs.
- Perform data extraction, transformation, and loading (ETL) for business or analytics use cases.
- Assist in database backup, recovery, monitoring, and upgrades as needed.
- Document database structures, procedures, and best practices.
Mandatory Skills :
Desirable Skills :
Skills Required
Git, Postgresql, Linux
Create a job alert for this search
Postgresql • Hyderabad / Secunderabad, Telangana