SUMMARY:

Dan McEwen is an IT professional, specializing in Oracle Database Administration. He has over thirty years’ experience in the IT industry with the last twenty focused on Oracle Database Administration with emphasis on Oracle E - Business Suite implementations. He has also worked with Oracle Retail, Manhattan and Curam software solutions. He has attended over thirty Oracle Education courses consisting of both applications and technical classes. He has received Oracle Masters Certificates for Oracle Database Administration, Oracle Applications Database Administration and Oracle Applications Implementation Team Member. Industry exposure includes manufacturing, automotive, retail and gaming industries as well as several federal, state and county government projects.

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, Ohio

A member if Confidential ’s Global Business Services, a national practice implementing Oracle solutions for various customers and industries. The majority of these have been Oracle E-Business solutions but also include Oracle Retail, Manhattan, Curam as well as custom solutions and implementations.

Software Release and Test Coordinator

Confidential - Jefferson City

Responsible for tracking and deploying application software releases to multiple environments. Tools used were Jenkins and Apache Subversion integration products to support a Curam Healthcare System implementation. Tasks included: coordinate Jenkins code builds and deployments to various teams and environments. Link that information in Jira to provide traceability and status to project management, BA's, testers, developers and the infrastructure teams. Also coordinated the use of the Solution-Soft "Time-Travel" product to emulate different dates to allow date changes in the software without changing server, database dates or code. Coordinated activities in these environments to facilitate integration testing. Also performed basic DB2 (v10) administration, coordinated and tracked database objects and version in multiple environments.

Senior Database Administration

Confidential - Chicago, Ill

Short term project to resolve performance issues with a rollout of a data warehousing application. The environment consisted of AIX 7.1, database version 12.1, and OBIEE 11.1.19. Worked with Oracle Support in identifying and resolving several database bugs and configuration settings. Also identified and resolved problem queries using AWR reports and the sqltune package.

Senior Database Administration

Confidential - San Diego, California

DBA tasked with the implementation and administration of the Curam Healthcare System for one of the largest counties in the United States. The solution also included the use of Oracle Fusion Middleware, Confidential Master Data Management (MDM) and Cognos Data Warehousing. The environment consisted of Oracle database version 11.2.0.4, ASM, RAC and DataGuard (using snapshot standby) on Solaris servers. Other tasks included administration of WebLogic on both Windows Servers and Linux. Specific WebLogic tasks included start/stop, deployment of EAR files, user administration and general debugging and support. The environment included approximately twenty-five databases and fifty application servers.

Senior Database Administrator

Confidential - Indianapolis, Indiana

DBA tasked with administration for a retail company implementing Manhattan Associates Warehouse Management (WMS) and Order Lifecycle Management (OLM) models, version 2012. Tasks included cloning, applying SDN’s (Manhattan patches), RAC service configurations to meet Manhattan requirements as well as general trouble shooting. The database environment consisted of Oracle Linux 5, Oracle database 11.2.0.3/4 running on Exadata models X2-2 and X3-2’s utilizing ASM and RAC. The project started with two environments, test and production each consisting of a two node cluster which expanded to four. Was responsible for installation, upgrading and administration of Fusion Middleware’s Oracle Data Integrator (ODI) agents using versions 11.1.1.7, 11.1.1.8 and 12.1.2 utilizing the Oracle Studio client tool. Also configured and implemented data masking for cloned databases from production.

Senior Database Administrator

Confidential - Cincinnati, Ohio

DBA tasked with database administration for an Oracle Retail (RMS) 13.2.5, implementation. Modules included RMS, RPM and ALLOC using the Oracle Retail Integration Bus (RIB). Database environment consisted of database version 11.2.0.2 running on AIX 6.1 utilizing ASM and RAC. The application tier consisted of Weblogic 11.1 running on RHEL 5.5. Specific tasks included application installation and patching, general application administration such as user creation and configuration and implementing the partitioning strategy. Developed and documented cloning procedures. Also installed and worked on the implementation of Oracle Internet Directory (OID) 11.1.1.5 and Single Sign On (SSO) 10.1.4.3.

Senior Database Administrator

Confidential - Indianapolis, Indiana

Senior DBA tasked with analysis, design and implementation of an Oracle E-Business Suite 11.5.10.2 to 12.1.3 migration and upgrade. The environment consisted of a database tier running Oracle 10.2.0.4 on Itanium HP-UX 64bit and Dell M610 Blade servers running RHEL 5.6 on the application tier. The project also required migrating from a 32bit application tier to new 64bit running RHEL. I was tasked with determining and documenting the upgrade strategy as well as the initial migration and upgrade to a 12.1.3 environment

Senior Database Administrator

Confidential - Boulder, Colorado

Senior Database Administrator for Oracle 11.5.10.2 E-Business Solution, AIX implementation for an international manufacturer and distributor. Primary responsibilities were assisting with the architecture planning and performing the environment implementation. Specific tasks included providing input for sizing, Oracle Grid monitoring, multiple languages (8), DMZ application servers configuration, load balancing, SSL, virtual hosts/IP’s, parallel concurrent processing (PCP) and Advanced Supply Chain Planning (ASCP). Also streamlined and documented the cloning process, designed documented and executed RMAN database recovery requirements. Was the DBA SME for an SSO/OID implementation using Tivoli Directory Services (LDAP), Oracle Application Server 10g (10.1.4) SSO/OID interfacing with the Oracle E-Business Suite with primary focus on the 10g Application Server and the E-Business Suite. Also worked with Sabrix Tax software and had exposure to Fusion 10g, SOA and BPEL, B2B. Assisted in supporting the production environment for three months after go-live.

Senior Database Administrator

Confidential - Washington DC

Senior Database administrator for a Federal iProcurement system implementation. The environment consisted of Oracle E-Business 11.5.10(11i) interfaced with the Compusearch Prism product via MQ and the OCI interface in an AIX environment. Responsible for DBA activities supporting phased releases and administrating the production environment. Support tasks include patching, cloning, troubleshooting, security, tuning, connectivity and MQ monitoring using MQ Explorer. Also administered the Prism package performing version, SP and FAR updates as required. Other key tasks included analyzing and implementing an 11.5.8 to 11.5.10 upgrade, performing a database upgrade from 9.2 to 10.2. Installing and analysis of an R12 environment and its architecture. Designed and implemented a backup and recovery solution using RMAN and Veritas. Other requirements include implementing a SAN migration, SSL and Rapid Clone. Performed analysis, testing and Implementation of Oracle DataGuard for a disaster recovery solution. Performed analysis of Single Sign-on and Oracle security patches for customer. Also mentored and supervised several DBA’s throughout the project.

Lead Database Administrator

Confidential - St Louis, Missouri

Lead Database administrator of an Oracle E-Business 11.5.8 (11i) Federal Financials implementation in an HP-UX environment. Responsible for DBA activities supporting a Phase II implementation team requiring fourteen instances as well as the Phase I production environment. Support tasks included patching, cloning, troubleshooting, security, tuning and connectivity. Other requirements included: implementing the Oracle Rapid Clone and Recovery Manager (RMAN) utilities, upgrading from database version 8.1.7.4 to 9.2.0.4, migrating all environments (development, test, certification and production) to upgraded HP servers and replacing a Hitachi SAN system with an EMC solution, configuring HP Service Guard and Secured Socket Layer (SSL). Project management tasks included delegation and coordination of tasks among 2-3 DBA’s, assistance with troubleshooting, hands-on implementation, documentation, backup and recovery strategy, assisting with a disaster recovery plan, developing an instance and change management strategy.

Test Instance Lead

Confidential - Baltimore, Maryland

Technical lead for five test teams consisting of approximately forty members implementing the Oracle E-Business 11.5.7 (11i) Federal Financials modules on Sun Solaris using Oracle 9i. Responsibilities included applications administration, developing and implementing change management standards (using Rational Clear Quest), insuring the integrity of the environments and general troubleshooting. Also responsible for identifying and communicating technical requirements to the Application Service Provider’s DBA Team to support interfaces, data conversions and testing.

Lead Database Administrator

Confidential - St Louis, Maryland

Database administrator for an Oracle E-Business 11.5.8 (11i) Federal Financials implementation in an HP-UX environment. Responsible for analysis of sizing and hardware requirements, developing and implementing the project instance strategy. At the customer’s request, analyzed a proposed installation of a split configuration consisting of Linux on the applications tier and HP-UX for the database tier. Performed installations of the Applications including 9iAS, Discoverer 4i, the XML Gateway and Transport Agent. Supported the functional and development teams including patching, cloning, connectivity, troubleshooting and analyzing Web ADI.