OBJECTIVE

Seeking work opportunity in a progressive and challenging work environment where I can leverage my experience and knowledge of Oracle EBS/Applications Database Administration to add-value and justify a Firm's investment in me.

QUALIFICATION & HIGHLIGHTS

• Four+ years of experience in the software industry as an ORACLE EBS/Applications DBA / ORACLE DBA / EBS System Administrator, carrying out DBA activities on UNIX (HP-UX) platform. Experience includes installation, upgrading, code migration, implementation, maintenance, patching, general administration and performance tuning of the ORACLE Database, Applications and various related 3rd party tools;
• Results and goals oriented, energetic, great organizational skills, team player, detail-attentive, strong problem solving, presentation, technical report writing, troubleshooting, and analytical skills;
• Experienced with providing on-site technical support; Willing to travel and relocate anywhere in the United States.

TECHNOLOGY

• Hardware: HP-9000 Series, HP-UX Itanium, HP Blade Systems
• Operating Systems: Oracle Enterprise Linux (OEL), Linux, HP-UX Itanium 11.31
• Programming Languages: C, C++, Perl, SQL, PL/SQL, HTML, UNIX Shell Scripts, Java
• Oracle Database/RDBMS: 10(g), to 10.2.0.4; 11(g), to 11.2.0.3
• Oracle EBS/Applications: Versions 11.5.1, 11.5.7, 11.5.9, 12.1.1, 12.1.3
• Oracle DBA 3rd Party Tools: Oracle Enterprise Manager, SQL Developer, TOAD, RMAN, SQL*Loader, F-Secure, Putty, Oracle Resource Monitor

EDUCATION

Bachelor of Information Technology: University of Toronto, Toronto Ontario, Canada.
Enterprise Database Management: Sheridan College, Oakville Ontario, Canada.

PROJECT WORK EXPERIENCE

Confidential - Oracle EBS/Applications Database Administrator March 2009 - Present

• Senior Oracle EBS/Applications Database Administrator for on-site development team;
• Administer and maintain R-12 (12.1.3/12.1.1) and R-11 (11.5.9/11.5.10.2) instances. Main responsibilities include general administration, upgrade testing, code migration, regular maintained activities (backups and restores), application and promotion of patches;
• Experience in addressing daily issues of concurrent managers, printer setups, custom RICEW issues, monitoring database performance, and releasing record blocking locks;
• Front end - monitoring and troubleshooting of Apache, Forms, and Concurrent managers;
• Set up and monitor Custom Concurrent Processing servers, define Concurrent Managers and work-shifts; Monitor completion of concurrent programs from the applications using the System Administrator responsibility; Monitor the Internal, Standard and Conflict Resolution managers;
• Installed patches in development, test and production environments; Analyzed impact of patches as part of end user (SMEs) support;
• Periodic cloning and refresh of the various instances to support development team; Conversant with "conventional" cloning methodology (manual creation of control-file) as well as "adcfgclone"/Rapid Clone for R12 EBS;
• Define sub-menus, menus, functions, forms, request groups, responsibilities, users and users assignments using the System Admin responsibility;
• RDBMS tuning, including initSID.ora parameters; Conversant with use of tools like Oracle Resource Monitor with Performance Pack;
• Experience in conventional and/or RMAN based hot and cold backups;
• Monitor growth of database and resizing objects (tables, partitions, indexes) in a High Available (MAA) environment;
• Using Import and Export functions to backup/restore database contents; also import and export of database objects, tables, tablespaces etc.
• Setup and administer Workflow Components, including Workflow Notification Mailer;
• Configuration of Oracle Enterprise Manager (OEM) to further monitor the database;
• Worked on technical issues with Oracle Support, via Service Requests;
• Responsible for process documentation.

Confidential - Oracle Database Administrator July 2008 - March 2009

• Installation, management and administration of Oracle databases, Managing user schema accounts, schema security privileges, Backup/Recovery monitoring and testing, RDBMS space management, Tuning (including creation of Indexes and Partitions), Performance Monitoring, use of Data Import utility (exp/imp and expdp/impdp) for data transfer and cloning;
• Pro-active maintenance (Quarterly PSU Patches), monitoring, and tuning of ORACLE production database systems;
• Test application and impact analysis of ORACLE patching in test/development instances;
• Creation of SQL*Net Listeners, Troubleshooting end user/developers connectivity issues;
• Administering Backup/Restore UNIX cronjobs, using hot and cold backup/RMAN scripts;
• Perform server based file system backups, Monitor cronjob scripts, Assist in Disaster Recovery Scenarios testing for SOX and Audit compliance;
• Developed and tested storage strategies and disaster-recovery plan;
• Installation, Configuration and Administration of ORACLE Enterprise Manager and Performance Pack monitoring tools;
• Enhanced end users\' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials;
• Worked in a high availability environment (MAA compliant) with database uptime at near 100%. Used administration techniques such as online backups, clustering, replication, and standby databases to achieve near perfect uptime;
• Worked on technical issues with Oracle Support, via Service Requests.

EXTRA CURRICULAR

Confidential, Member April 2011 - Present

• Educated older adults on the basic of technology use in a classroom environment;
• Assisted Seniors (65+) who were interested in learning how to use technologies such as a computer, the Internet, digital cameras, etc;
• On-site manager - trained volunteers on how to educate seniors ("Train the Trainers").