SUMMARY

• Accomplished, innovative Manager (former Senior Oracle Database Administrator) with strong technical and leadership skills.
• Combined business expertise with extensive Information Technology experience that includes architecture, design, implementation, management, disaster recovery, and pre - sales support.
• Able to strategically and cost-effectively utilize technology in alignment with corporate goals and objectives.
• Excels at building relationships, with proven ability to build motivated, energized, and focused teams.
• Experienced in multiple industries - Insurance, State Government, Automotive, Health Care, Banking, Staff Solutions, Media Publications, and Finance
• Management experience in Architecture, Operations, Systems Development, Project Management, and Database Administration
• Experience in architecting solutions for performance, scalability, and High Availability (HA)
• Strong technical background in Oracle (33 years)
• Disaster Recovery planning, development, implementation, and testing
• Strong documentation, technical manual, work instructions, writing, and excellent communication and presentation skills.

SPECIFIC AREAS OF EXPERTISE INCLUDE:

• Enterprise Architecture
• Database Technologies
• Information Management
• System Integration
• Data Security
• Data Architecture
• Leadership & Team Building
• Customer Relations
• Disaster Recovery Planning, Testing, and Execution
• Documentation and Architectural maps

PROFESSIONAL EXPERIENCE

Confidential, Southfield, Michigan

Manager - Database Administration

Responsibilities:

• Managing a team of eight DBA s in support of all database activities for the company.
• Manage resource allocation
• Manage DBA staffing - hiring and dismissals
• Manage day-to-day operations of all Oracle databases
• Perform Performance Reviews for each team member and monthly 1:1 meetings
• Manage Disaster Recovery planning, testing, and documentation - reduced MTR
• Tier 1 and Tier 2 databases from 36 hours in 2015 to 21 hours in 2016
• Personally implemented Oracle Advanced Security for encrypted databases to secure Personally Identifiable Information (PII) data in a centralized hub using db vault, key vault, audit vault, data redaction, and Transparent Data Encryption
• Created project plan/processes for upgrading databases
• Created project plan/processes for patching databases
• Created/managed internal/external project plans for the team project work
• Created standards documents for database/grid installs
• Supervised implementation/code pushes to prod daily

Confidential, Warren, Michigan

Team Leader/Senior Oracle Database Administrator

Responsibilities:

• Team Center Lead DBA responsible for one of the highest profile applications at GM. This application provides engineering drawings to engineers globally 24x7x365. This includes administration of 200 pre and prod databases, directing all tasks including provisioning servers, cluster creation, and software installation, database creation, backups, Flashbacks, and building of sandbox environments. I managed a team of four.
• Production Cluster owner responsible for all aspects of four (4) pre - production and production LINUX SOX clusters. This includes OEM setup/monitoring, RMAN backups for all databases on the cluster, storage allocation/maintenance and standards compliance.
• Led effort to plan and move 50 databases from old SOLARIS cluster to three (3) new Oracle LINUX two (2) node RAC clusters.
• Led effort to plan and move 11 production Team Center databases (totaling 20tb) onto a new cluster at a different location with DataGuard to an off-site facility.
• Led effort to plan and successfully upgrade the global Solutions Delivery application comprised of eight global and 11 local databases.
• Planned and created a way of automating one-off RMAN backup jobs for the application team to use to run on-demand backups.
• Owned several special one-off projects to support database moves.

Environment: LINUX, Solaris, Oracle 11.2.x, OEM 12c, CRS, ASM, RMAN, DataGuard

Confidential, Livonia, Michigan

Team Lead/Senior Oracle Database Administrator

Responsibilities:

• Administered LINUX/AIX RAC and non-clustered databases
• Cloning/refreshing of Oracle Databases using RMAN
• Backup and recovery using RMAN
• Performance monitoring/tuning using OEM/Grid and other scripts
• Monitor transactions and provide analysis for any problematic transactions that occur
• SOX compliant security administration
• Performed database reorganizations leveraging OEM
• Database installations/creations/upgrades/patching/cloning
• Maintained Oracle CRS/ASM for file management
• Maintenance of over 100 Oracle databases, up to 7tb
• Apply Oracle patches when required and create development and test databases upon request
• Implement and maintain operational and physical design of Oracle databases, conduct performance tuning of indexes and database as required
• Implemented Oracle Portal, WebCenter, WebLogic
• Installed OTM Web and App servers
• Installed and maintained Oracles Real User Experience Insight (RUEI) to monitor ERP applications
• Responsible for all physical database operations for DEV. TEST, and PROD IMO, with each instance being over 3tb in size
• Planned, implemented, wrote the manual, and conducted test and actual Disaster Recoveries
• Created/provided all technical documentation
• Review database design and implementation and make recommendations regarding enhancements and/or improvements.
• Create and support formulation of policies and procedures related to the management of all databases
• Provided on call support for production databases. The on call duties includes Production support and Help Desk ticket resolution
• Was Project Manager for all internal lead projects, creating plans and managing resources.

Environment: ORACLE 8,9,10,11, OEM/GRID, CRS/ASM, RMAN, RUEI, Oracle/Red Hat LINUX, AIX, WINDOWS

Confidential, Troy, Michigan

Oracle Database Architect

Responsibilities:

• Designed, built, and coordinated data warehouse ETL solutions for various PeopleSoft applications. This included PL/SQL coding, stored procedures, packages, triggers, developing test plans, testing, and documentation
• Designed Unix and SQL scripts to handle the daily feeds and load them into Oracle automatically
• Used tools such as Oracle Enterprise Manager (OEM) and TOAD to maintain the Development database environment and tune packages and procedures for optimal performance
• Review database design and implementation and make recommendations regarding enhancements and/or improvements
• Coordinated/managed monthly build/implementation activities for monthly releases using Compuware’s ChangePoint and company accepted SDM.
• Worked with HP Open Solutions to catalog various issues using their incident tracking system.
• Designed, developed, and implemented a system to gather data from the data warehouse, generate a Banking PIN change letter, and FTP it to a remote site for printing by a third party vendor.
• Developed and implemented standards for database objects
• Provided on call support for production databases. The on call duties include ETL process, daily/weekly/monthly report generation and resolving mission-critical issues

Environment: ORACLE 10g. PL/SQL, Oracle Enterprise Manager. TOAD, Open Solutions, Compuware ChangePoint. LINUX.