Job Description Summary

Chargé de programmer un composant, une fonctionnalité et/ou un ensemble de fonctionnalités. Travaille de manière indépendante et contribue à l'équipe concernée et à d'autres équipes de l'entreprise. Vous contribuerez également aux discussions sur la conception.

Job Description

Key Responsibilities:

• Having good experience Postgress RDS
• Should be able to manage SQL opeartions on Postgress RDS instances
• Creating and modifying databases, including tables, indexes, views and DB Partitions.
• Monitoring and optimizing database performance through tuning and indexing.
• Performing periodic backups and ensuring data recoverability during disaster.
• Troubleshooting and resolving database and SQL problems.
• Responsible to come up DB scripts to be required to migrate large volumes of data with entities across multiple databases/schemas.
• Developing and maintaining documentation and operating procedures.
• Writing and optimizing PL/SQL code for various database procedures, functions, triggers, and packages.
• Developing and maintaining database stored procedures and scripts to support application development.
• Optimizing SQL queries for performance and scalability.
• Collaborating with developers to integrate PL/SQL code with application logic.
• Writing and optimizing SQL queries for data retrieval, manipulation, and reporting.
• Developing and maintaining database views, stored procedures, and functions.
• Ensuring SQL code meets performance and scalability requirements.
• Debugging and troubleshooting SQL code issues independently and sometimes with application developer.
• Monitoring database performance metrics such as CPU usage, memory usage, and disk utilization.

Additional Information