Performance tuning / optimization

Monitoring long running query and optimization

Tablespace/index space and DB space management

Monitoring alert log and trace files along

Co-ordinate database migration and infrastructure activities

Experience DB maintenance and data archival activity.

Proactively monitor the database systems to ensure services are up and running

Creation of new tables, partitioning, indexing, rebuilding indexes, etc.

Setup archival

Setting up new oracle servers

Monitor and fix Prod performance slowness

Looks at AWR / ASH reports - identify enhancements / performance improvements

8 to 10 years of experience

Strong knowledge on Oracle Database

Working knowledge of Oracle maintenance and upgrading

Strong knowledge of Oracle database migration from one server to another server cross platform

None