PostgreSQL and SQL

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:

• Strong 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

Desirable Skills:

• 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