About the role
Responsibilities:
- Design, develop, and maintain database systems using PostgreSQL.
- Write and optimize complex SQL queries to ensure efficient data retrieval and processing.
- Write and optimize complex PL/PGSQL procedures and functions to ensure efficient data retrieval and processing.
- Migrated from Oracle to PostgreSQL for stored procedures, packages, and query syntax.
- Collaborate with application developers to integrate database solutions with front-end and processing applications.
- Analyze and improve database performance, ensuring system stability and scalability.
- Implement backup and recovery strategies to safeguard data integrity.
- Monitor database health and troubleshoot issues as they arise.
- Document database designs, procedures, and structures for reference and compliance purposes.
- Stay updated on new technologies and tools related to PostgreSQL and database management.