- Database event/alert monitoring, space management, user management, Database upgrades & migrations, cloning, Database backup, restore & recovery, Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
- Knowledgeable about Postgres database server and OS resources allocations and usage.
- Translate Oracle PL/SQL constructs to Postgres PL/pgSQL, i.e., Oracle packages, global temporary files, etc.
- Postgres performance/tuning analysis be able to tune Postgres PL/SQL code to meet required SLAs.