SUMMARY

• Dynamic, versatile Director with 22+ years of experience in all aspects of systems design, database design, Cloud migration and a proven track record of consistently resolving problems and developing solutions.
• Exceptional technology skills combined with proven ability to train, manage and nurture talent, support a large and diverse team, and successfully implement and oversee complex new projects like Cloud First.

TECHNICAL SKILLS

• C++(NOVICE)
• COBOL II
• Visual Basic 5.0
• Crystal Reports
• Easytrieve
• Excel
• Word
• Access
• Changeman
• Ca - Scheduler 7.4
• TSO
• XREF
• INFOSYS
• JCL.

PROFESSIONAL EXPERIENCE

Confidential, Mt. Laurel, NJ

Director, IT

Responsibilities:

• Lead three teams of Database Administrators and one team of AWS DMS replication experts focusing on a Cloud First strategy.
• For the Oracle team I have designed and managed the movement of 40% of the Oracle on-prem environment to Amazon AWS RDS instances using one time loads and ongoing CDC to easy application movement to the Cloud. Database areas successfully moved between Jan 2017 and present include Data Warehouse, Business Process Management and other industry specific databases. Expected project completed with 90+ complex Oracle databases is Mid 2019. My ongoing day to day daily CDC has allowed application owners to run in parallel without risks to the business. Cloud databases are validated extensively before the associated application is moved. We currently move 150 GB to 1.3 TB per night into AWS RDS instances with either homogeneous (Oracle to Oracle) or heterogeneous ( Oracle to SQL Server). I designed and implemented with a team of 10 individuals the first AWS DMS CDC replication for Freedom. I add hands on technical knowledge as needed.
• For the SQL Server team I have been facilitating and helping to coordinate the movement of 1500 SQL Server instances through either backup and restore or AWS DMS. DMS with the SQL Server has provided an easier path for those systems designed as Always On. I add hands on technical knowledge as needed. I am driving a move to SQL Server 2017 on Linux using AWS EC2 with a focus of storing more databases on Freedom MBU’s (Multiple Business Unit ).
• For the Progress OpenEdge team, I manage tasks and deadlines .
• For the Aws Replication team, as the sole AWS DMS expert, I have been conducting daily knowledge transfer to junior members of the Freedom IT staff across IT groups as well as mentoring members on IT best practices.
• Identify new areas of technology which has helped to create a better Client experience.
• Assist Sr. Management with Licensing and procurement of software across the Enterprise as well as needed tools for monitoring and interacting with Cloud databases.
• I am also responsible for the current POC of the Oracle Cloud Exadata with the ability to communicate across Cloud providers.

Confidential, Mt. Laurel, NJ

Technical Architect / DBA

Responsibilities:

• Sr DBA. Install Oracle 12c. Configure 12c Grid Control. Install and deploy 12c agents. Performance tuning for tablespace consolidations, memory and parameter changes along with data flow changes. Install patches 10.2.0.5 and full version of 12c. Upgrade databases from 10.1.0.4 to 12.1.0 on Aix 6. Create and tune RMAN backups and help to implement COMMVAULT with Oracle across 40+ Oracle databases. Migrate Oracle V8 databases to V11.2.0.3. Administer Oracle V12 database in Amazon for Expere software. Oracle Streams configuration. Oracle Forms and Reports 11g install and configuration. Aurora AWS. Data migrations with AWS DMS

Confidential

Technical Architect / DBA / Veeva Specialist

Responsibilities:

• Netezza V 6 DBA / Server Administration/Security/Architecture (15 TB per system V6) Support Production and Non-Production Netezza system consisting of 40+ production databases and 100+ non-production. Automate weekly unix cron processes for grooming and statistics to maximize performance. Perform database migrations between production server and non-production server for refreshing and debugging current issues, and development cycles using nz migrate. Investigate advanced performance issues for multiple development and support teams globally. Generate database/schema ddl and views using Netezza utilities for code migrations to production as well as updating the existing datamodel. Decreased ticket closure rates from weeks/days to hours. Interacted with the IBM teams on hardware and software issues related to the appliance. Install Aginity Workbench for development team members and request licenses as needed. Perform monthly security audits for both Accenture and Shire reporting mandates. Review existing user access levels. Remove users and access which was no longer needed.
• Lead DBA for CMSO operations team. Assist onshore and offshore support and development teams. Responsible for setting one offshore members’ tasks and responsibilities.
• Assess incoming JIRA tickets for the DBA team. Assign a priority and severity level. Assign a start date, end date and the correct member of the DBA team. Review sql scripts ( DDL and DML) which were included in the tickets. All work performed at Shire was done through Service Requests, Work Requests, or incidents where were created in JIRA
• Monitor and performance tune 24 oracle databases for the following applications: Veeva (Salesforce) ODS U.S. and International, Aggregate Spend Custom application, and MDM. Tuning activities include memory allocation recommendations, oracle specific initialization parameters, storage and backup processing. Create specific profiles to meet Best Practices security standards. Oracle 10g, 11g with multiple patch levels. Oracle 12c experience limited to beta testing team for rollout along with 12 OEM.
• Informatica Cloud Services Administration. Security duties included creating complex authentication to protect client data from external unauthorized access. (Users, Groups). Creation of job processes for replication and sync to the Veeva Cloud. SQL tuning for Sync and Replication processes. Tuning of Informatica Secure Agent and Windows 7 OS. Performance code migrates between environments for release deployments.
• Support SQL Server 2008/2005/2000 and upgrades for custom and non-custom applications. Duties included backup creation and scheduling. Space management with shrining and truncating of databases and log files. Migration of tables and code between environments.
• Siebel 7.8.2 support (Development, Test, QA, Production) for International users in 12 countries. Duties included database refreshes and environment resets for Development cycles
• ProModel EPS (Enterprise Portfolio Simulator) Duties include upgrade and patch installation. Configuring connections to third party external sources. SQL Server database maintenance, backup, recovery and tuning. Windows 7 configuration for performance.
• CDP (Client Data Protection) Create audit of all Oracle, SQL Server, and Netezza databases along with ICS (Informatica Cloud Services) access levels by environment into on standard Oracle reporting process where roll on and roll off procedures and policies could be implemented. Mentor CMSO team on PII Best Practices. Assist in setting Team standard of security based on need.
• Qlikview Assist in the initial architecture, installation and configuration of the Qlikview application. Assist in debugging network and Windows 7 performance issues. Assist in configuring Windows XP and 7 laptop setup to optimize end user performance.
• Jira Administration and ticket triage. Use a CMSO defined set of SLA’s to monitor the incoming ticket queue based on severity level approved by Shire. Assign tickets during business hours to the proper teams for immediate review and diagnosis. Conduct review of tickets monthly for CMSO metrics reports presented at the Shire monthly meeting. Create, delete, and update user access level based on need along with the required groups required. Identify ticket with missing updates for start date, end date, and status, etc . Create monthly report to notify team members of incomplete status.
• Citrix support Install software packages on selected Citrix servers. Assist Citrix team in performance resolution. Create upgrade and server expansion process to accommodate larger software packages and additional teams of users. Create roll off procedure for folders to remove sensitive data
• Mentoring Took an active role in mentoring junior members of the team on analytical thinking, data processing flow, Best Practices, and security.

Confidential, Malvern, PA

Siebel Administration/ Oracle DBA

Responsibilities:

• Administer 3 Development Environments, 1 QA, 1 Test and 1 Production Environment. Duties include code migrations. Server performance monitoring.
• Install Siebel and Hummingbird patches related to version 7.7.2.4. Full search across files and Oracle database.
• Debug workflow, search server, object manager issues for Sales Teams
• Perform Oracle performance monitoring with specific suggestions for memory and server sizing
• Perform Siebel Object monitoring using SARM to enhance the end user experience
• Identify and perform data cleanup as needed for PII
• Siebel Analytics Administration 7.8.4