SUMMARY:

• Dynamic, versatile IT Administrator with 18+ years of experience in all aspects of systems and database administration 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.
• Oracle DBA Netezza DB2 SQL Server DBA Siebel 7.8.2 Cloud Services
• Client Data Protection Channel Marketing Cloud Services Citrix
• Customer Service Systems Customer Service Promodel EPS AIX/UNIX/Linux

PROFESSIONAL EXPERIENCE:

Confidential, Mt. Laurel, NJ, PA

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

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

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
• Managed all phases of the 4 Siebel environments and Administration
• Managed Siebel and Oracle services thru MS Clustering software.
• Create Demo and Sandbox environments for potential clients.
• Analyze 7 Siebel systems for configuration and installation issues.
• Design future Siebel 7.5 systems on multi-platform environments. (AIX, WIN 2000, etc)
• Install Siebel eMedical, eFinancial, PRM, ERM, eSales, Handheld / Wireless, eFinance.
• Technical Lead on co-developed Siebel / Deloitte eMedical system for monitoring medical device complaints for the FDMA.
• Co-Technical Lead on Siebel Beverage project. Handheld and wireless system.
• Install Siebel web server on dedicated server in DMZ for external public access.
• Connect Siebel to LDAP for Authentication.
• Create install instructions from standardization across the different Siebel applications.
• Clients included HP, Meryll Lynch, OnStar, Irving Oil, Coke, Pepsi, Johnson & Johnson and others.
• Full automation of Siebel Server install process from the Gateway to the Database server.(Siebel calls this an unattended install)

Confidential, Linwood, PA

Siebel Administrator

Responsibilities:

• Helped resolve RLD (remote dial in issues) with MCI.
• Project lead for rewrite of price request inside Siebel.
• Installed the Siebel application and DB2 on the remote client laptops.
• Performed install of Siebel Servers, Gateway Servers, Enterprise Servers, and Database servers for Siebel 99 ( V5) and Siebel 2000 (V6) on Windows NT.
• Issuance of new Siebel.srf kits and upgrades.
• Created logical volumes / files systems for better disk performance.
• Changed default TCP/IP settings related to Siebel Server, Siebel Gateway, Siebel Enterprise Server.
• Created AIX scripts for monitoring of space utilization.

Confidential

Application Programmer

Responsibilities:

• Help implement Data warehouse architecture. Migrate data from the OS290 to an RS6000.
• Supported daily requirements, created new reports, and enhanced existing reports. Implemented resolutions and supported production team. Assisted with Y2K initiative.
• Inbound/Outbound telemarketing and Telecollections system. Assisted in implementation of Windows/Unix Melita system. Dealt with telephony issues regarding Aspect / Melita interface. Assist in creating SQL Server Database for reporting on Melita.
• Support numerous systems operating within Franklin Mint. Responsible for job scheduling, meeting daily online times, point out possible areas of system tuning, assist in system testing for packages (Ca-Scheduler). Serve as backup for Manager of Production Control. Changeman implementation team member.