Senior Oracle Database Administrator
InfoGraph
Total years of experience :16 years, 3 Months
- Database Administrations
Database Installation and Configuration
Backup Startegy, Restore and Recovery
Storage Management
Performance Tuning
Export and Import Dumpfile
Troubleshooting and Fix database problems
Database Migrations
Create Standby database, Dataguard
- SDE Administrations
SDE Software Installation and Service Creation
Enterprise Geodatabase Creation
Support the Functionalty of Geodatabase
Upgrade the Geodatabase
SDE Geodatabase backup and Recovery
Design a Model Builder
Installing & Configuring Database under Linux, Windows
Database Backup \[ Rman Backup incremental 0 - 1, Offline Backup\].
Database Restore and Recovery.
Clone Backup and Restore.
Export and Import, , and Using Datapump.
Creating & Maintaining Database Objects.
Table Partitioning, Add Partition, convert non Partitioned table to Partitioned online
PL/SQL Function, Procedure, Package
Create Job, Scheduler window group.
Tablespace Management
User Management
User Accounts Management \[ Identified, Expired, Lock and Unlock\]
SQL Reports
SQL Tunning
SQL Loader
LogMiner
Database Auditing
Daily Check, , , \[Alert Log, OS, RMAN Log, Tablespaces, Listener and Standby Database \].
Install Linux Redhat 5, Redhat 6.1
Install Centos 6.3
Database Analysis and Creation.
Tuning,
Archiving,
Export and Import,
SQL Reports.
Backup and Recovery.
PL/SQL
and others ...
Database Installation
Database Backup
User Management
Privileges and roles management
Export and Import (Dump-file)
1- Database creation & design
2- create and management users accounts on database
3- grant privileges, Roles to users
4- database backup
Project Analysis, Creation, Programming and Testing