Extensive knowledge on database administration for 11g,12c and 19c, with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
Good experience in writing/editing batch/shell scripts.
Setup Oracle Enterprise Manager (OEM)for database monitoring/performance/diagnostics.
Experience in performance tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
Extensive experience in database backups RMAN (full/incremental backups) and in traditional hot/cold backups.
Developing and maintaining databases, ensuring data security, tuning performance, backing up data, and providing training and support to users.
Responsible for the performance, integrity and security of databases.

Oracle DBA

Unison Consulting Pte Ltd