PROFESSIONAL SUMMARY:

Multifunctional professional with over 7+ years of strategic leadership and performance based management experience. Proven track record of unceasingly exceeding administrative goals. A proactive, driven individual recognized for bringing value to situations disregarded and lacking functional probability. Experience in: 10g, 11g Database Administration, 11g Real Application Cluster (RAC) on ASM installation, Data Guard Administration, RMAN Backup and Recovery

TECHNICAL SKILLS:

Operating Systems: Microsoft, Windows 2000, 2003 & 2008 Advanced Server, Red Hat (Linux), UNIX, VM Ware, OBI KPI s, Powershell

Networking Topologies / Protocols: Ethernet, TCP/IP

Programming Languages: SQL, PL/SQL, SQL*PLUS

Software Applications/Tools and Utilities: Data Migration - Export-Import, Backup & Recovery Performance Tuning-SQL-Loader, and Dataguard.

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential

Responsibilities:

• Maintained an 11g database security using encryption, and Fine Grain Access Control.
• Configured, audited, granted privileges, restricted access, created users, profiles, roles and monitored quota on tablespaces in line with resource planning guide.
• Managed multiple databases and instances using DataGuard, RAC in a real time production, testing, and development environment.
• Used Enterprise Manager DB console to monitor performance, clone databases, tuning and maintaining optimal performance.
• Used Oracle Grid control on UNIX/Linux and Windows to maintain a 500Gb database with a group of DBAs in a 24/7 365 production environment involving technical proficiency.
• Used DataPump for migration, Remapping, SQL*loader, import and export of database/schema/Tablespace.
• Generated Reports and preparing memo to communicate progress and providing early alerts for major updates.
• Used a hot and cold backup and recovery using RMAN.
• Used Enterprise Manager to schedule backups.
• Used Data guard to perform both switch over and failover exercises.
• Configured and managed database backups (full and incremental), restores, cataloguing, and migrations on primary servers and across servers within a project.
• Performed SQL tuning and object management.
• Used SQL*Plus, iSQL*Plus, Oracle SQL Developer, Putty, PL/SQL, Command-line tools to accomplish projects.
• Advanced troubleshooting using trace files, alert log
• Developed and enforced database related policies, standards, naming conventions, operating procedures and best practices.
• Generated reports.
• Executed database backup and recovery strategies.
• Monitored thresholds in relation to the FRA.
• Monitored database security by controlling and monitoring user access
• Created and monitored roles and profiles.
• Created and maintained database structures and objects.
• Experienced and managed Oracle database partitioning (Range, List, Hash and Composite).

Oracle Database Administrator

Confidential

Responsibilities:

• Patched and installed Oracle software.
• Supported and troubleshot to detect and correct problems.
• Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software troubleshooting and backup testing.
• Used incremental and full back up; Auto-backup with Job function.
• Fixed restore and backup errors.
• Experienced in working with DBMS automation scripts, and deploying scripts.
• Linux environment experience with Data guard.
• Was responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• Created different table spaces, tables, schemas, constraints to enforce business rules and users accounts.
• Performed daily database administration on production environments.
• Changed password for users, killing sessions, granted privileges, altered roles, and set alerts.
• Performed performance tuning.
• Used RMAN to backup database.
• Worked daily on incremental backup and weekly on full database backup.
• Used OEM to schedule backup.
• Handled disaster testing.
• Cloning and creating new databases using operating system commands.
• Managed and monitored direct database access security, data integrity, enforcing constraints, and database privileges.
• Configured and monitored the TNS/Listener using NetCA, NetMgr.
• Used DataPump to implement database refresh with the hot backup using DUPLICATE or full export.
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Executed Oracle 10g logical and physical databases design, implementation and maintenance on UNIX and NT.
• Performed tuning using the AWR, ADDM to guide tuning and maintain high database availability and reliability.

Machine Operational Supervisor

Confidential

Responsibilities:

• Responsible for efficiently running track containing up to thirty laborers and machine operators.
• Responsible for maintaining line production and for adhering to company and government regulated standards for heightened efficiency as well as safety, quality assurance and environmental compliance.
• Knowledge of and full operational skills of all equipment within production department.
• Required to track and document all production efficiency, downtime and labor costs for the shifts’ run.