1. Should be able to write and understand the complex SQL Scripts, Stored procedures, Functions and triggers.
2. Should be able to debug complex SQL queries/stored procedures.
3. Experience in Oracle to PostgreSQL migration.
4. Query tuning
5. DB tuning
6. Any other DB related task needed for project Migration project to migrate from Oracle to PostgreSQL
7. Monitoring databases to optimize database performance and diagnosing.
8. Monitor and manage database indexes for optimal performance.
9. Maintaining custom vacuum strategies at table and DB levels.