Cygnet.One - PostgreSQL Developer - Database Design (3-8 yrs)

Key Responsibilities :

- Design, develop, and optimize PostgreSQL databases for high-performance applications.

- Write and maintain complex SQL queries, stored procedures, functions, and triggers.

- Perform database performance tuning, indexing, and query optimization.

- Develop and maintain ETL (Extract, Transform, Load) pipelines for data processing.

- Ensure data integrity, security, and backup strategies are implemented and maintained.

- Work closely with developers to integrate PostgreSQL databases with applications.

- Monitor database health, troubleshoot performance issues, and provide production support.

- Optimize database partitioning, replication, and sharding for large datasets.

- Implement and maintain PL/pgSQL scripting for business logic within the database.

- Collaborate with DevOps teams for database deployments, migrations, and automation.

- Maintain and update technical documentation for database structures and processes.