Post Job Free
Sign in

Manager Oracle

Location:
Houston, TX
Posted:
August 08, 2015

Contact this candidate

Resume:

Michael J. Lee

**** ***** ** ***, *** ***

Houston, TX 77054

Cell 409-***-****

*************@*****.***

SUMMARY OF SKILLS

• Secret Security Clearance

• Oracle DBA

• Physical, electronic, and computer security auditing

• Network administration and auditing where wireless 802.11b/g/n is used in a network

• Management

• Security practitioner

• Installed, Configured and maintained mission critical, high traffic, large-scale Oracle 9i/10g/11g databases on Linux and Solaris platforms.

• Experience as On-Call 24x7 production DBA support, application/development DBA.

• Supported 24/7 Production databases of multi GB to 4 TB and responsible for round-the-clock database operations.

• Extensive knowledge on database administration for Oracle 9i, 10g and 11g, with experience in very large scale database environment.

• Installed Oracle 12c database and agent on Linux server.

• Upgraded database from 11.2.0.3 to 12.1.0.1 on Linux.

• Configured 3 Node 11g RAC on Linux with ASM on VM WARE for development and testing.

• Implemented Maximum Availability/High Availability Architecture (MAA/HA) by setting up RAC standby data guard for RAC primary database.

• Installed and configured OEM Grid Control agent(s) across 50+ production and development environments.

• Deployed latest security patches across all the Oracle environments, mostly for CVE-2012-1675.

• Patched 11g 3 node production RAC Grid Infrastructure and database on Linux.

• Performed upgrades & migration of 9i, 10g databases to 11g and applying patches.

• Experience in administering Oracle databases using Oracle Enterprise Manager (OEM), Toad, and SQLPlus.

• Experience in using data pump, Export/Import, transportable tablespaces, Flash-Back Recovery, AWR, ASH, ADDM and Recycle Bin.

• Oracle DBA activities include but are not limited to installation, configuration, importing/exporting, migration, patch installs, capacity planning, DBMS_SCHEDULER, DBMS_JOBS, backup and recovery of mission critical databases and data files using command line syntax as well as Oracle RMAN, and performance tuning of databases.

• Experience in configuration and maintaining Oracle Physical Standby databases (DGMGRL).

• Extensive experience in Dataguard configuration, implementing and monitoring of standby databases.

• Experience in Oracle database upgrades from 10.2.0.3 to 10.2.0.5 and 11.2.0.4 in RAC environment

• Participated in disaster recovery testing and documentation.

• Tuned SQL statements using explain plan, hints, query rewrite hints, index hints and using cost-based optimizer.

• Excellent knowledge of backup & recovery procedures including RMAN

• Experience in a variety of hardware and software platforms including; MS-Windows, Windows Server 2008 and 2012, UNIX/Linux, Sun Solaris, HP-UX & Ubuntu.

• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation.).

• RAC Clusterware administration, Configuration and Patching, RAC Backup and Recovery.

• Monitored Oracle Enterprise Manager (OEM) 10g, Grid Control 11g & Grid control 12c for database monitoring/performance/diagnostics.

• Extensive knowledge in database backup and recovery concepts using RMAN features and utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).

• Experience in backups and database migration tools with good experience in patching and upgrades. Expertise in upgrading Oracle Development and Production databases from 9i to 10g and 11g.

• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers and extensively used TOAD and SQLPlus for querying databases.

• Implemented 11gR2 RAC with ASM and scan listener technology.

• Worked extensively on VMWARE virtual machines/installed 12C agents.

• Worked help desk and change control tickets as necessary.

CERTIFICATIONS

• Oracle Database 11g Administrator Certified Professional Certification (OCP)

• Oracle Linux 6 Certified Implementation Specialist

• Oracle Real Application Clusters 11g Certified Implementation Specialist

• CompTIA A+

• CompTIA Network+

• CompTIA Security+

• CompTIA Linux+

• CompTIA Server+

• CompTIA Advanced Security Practitioner (CASP)

• Certified Ethical Hacker (EC-Council)

• Oracle Database 11g: Administration Workshop 1

• Oracle Database 11g: Data Guard Administration

• Orapub Tuning Oracle Using An AWR Report Part 1

• Orapub Tuning Oracle Using An AWR Report Part 2

WORK EXPERIENCE

Database Administrator – Database Administration, Inc. (EOG Resources). 6/2010-5/2015

Oracle Database Administrator

Houston, TX

• Korn shell scripting; auditing of backups via test recoveries; automation of test recoveries and automation of creating test databases across versions 9i, 10g, 11g with full export and import (expdp and impdp) and RMAN. Tested several recovery scenarios with RMAN (Recovery Manager). Performed patching of several RAC and single instance databases. Assisted in decommissioning several databases and Solaris (Sun OS) servers. Assisted auditors with Sarbanes-Oxley compliance. Constructed, configured, and repaired standby databases with DGMGRL and Enterprise Manager. Worked help desk tickets as needed.

Information Technology 2nd Class Petty Officer – U.S. Navy 10/2008-Present

Reservist

Naval Operations Support Center – Houston, TX

• Configured software and hardware; maintained network servers; installed network workstations, components, peripherals, software and operating systems; troubleshooting network hardware and operating systems; managed communication network security functions; monitored automated digital network systems; managed digital media distribution systems; managed information systems security documentation and programs.

Security Consultant/Auditor – Michael Lee Security Consulting LLC 2008-2013

Houston, TX

• Testing access control systems; physical, electronic, and computer security auditing; network administration and auditing where wireless 802.11b/g/n is used in a network.

AWARDS RECEIVED

• Outstanding Performance Award from Food Lion

• Machining Technology Certificate from Houston Community College

• Dean’s List Certificate of Recognition from Houston Community College

• Certificate of Appreciation from Luby’s, Inc.

EDUCATION

• University of Houston 2010-Present

Major: Journalism

Minor: Spanish

• Houston Community College 8/04-12/05

Basic Machining Technology Certificate-December 2004

Machining Technology Certificate-December 2005

• San Jacinto College

1/98-12/02

Associate of Art in Social Sciences- August 2002



Contact this candidate