BACKGROUND SUMMARY:

Project Management / Technical Lead

Confidential

Responsible for establishing and managing the scope of remediation activities for the various data warehouse performance tuning technical tasks Responsible for creating and maintaining a plan for execution of the data warehouse performance tuning activities Work closely with department heads as portions of the technical issues were shared inter-departmentally. In addition to building a close relationship I also defined the accountability resolutions to help long term problem solving pertaining to shared technical responsibilities. Focal point for all planning and execution activities for the technical environments involved. Accountable for the following tasks: Initial project planning, Development of project scope, Defining project guidelines, Resource coordination internal and contracted , Testing coordination. Manage project plans and project resource requirements and budget.

Senior Database Architect

Confidential

Develop database solutions by designing proposed system defining database physical structure and functional capabilities, security, back-up, and recovery specifications. Maintain database performance by identifying and resolving production and application development problems calculating optimum values for parameters evaluating, integrating, and installing new releases completing maintenance answering user questions. Prepare users by conducting training.

Senior Performance Tuning Consultant

Confidential

Responsible for performance tuning and optimization of Oracle databases, deployment of Oracle 9i and 10g RAC running on Linux, Windows and UNIX platforms. Provide consulting on performance tuning and troubleshooting, application workload testing, integration, data migration and general problem solving. Architect and implement backup and disaster recovery solutions including RMAN and Oracle Data Guard. Provide Customer training on Oracle database administration, Oracle RAC and Linux.

Senior Database Administrator

Confidential

Responsible for administering, performance tuning and optimization Oracle databases, deployment of Oracle databases Oracle RAC Grid Control SQL Server databases MySQL databases Informix databases DB2 UDB Databases Databases range in size from 100 GB to 50 TB. The concurrent user count ranges from 50 to 50,000 users web users con-current . The systems infrastructure that these databases operate on range from stand-alone systems clustered systems My experiences include architectures such as ERP, Data Warehousing, OLAP, OLTP and Replication solutions. My experiences include network and attached disk array configuration and utilization. These platforms include, Sun Solaris, HP HPUX, IBM AIX, MS Windows, SCO UNIX, LINUX and VAX/Open VMS.

BIG DATA Business Intelligence Architect Administrator

Confidential

Responsible for performance designing and developing Big Data solutions. Architected environments implementing and deploying the following technologies Hadoop, Cloudera, Informatica, Tableau, Hadoop Appache, Hive, Map Reduce, Pig NoSQL Database solutions utilized within Big Data designs with data migration strategies developed for the following technologies MongoDB, Casandra, Oracle NoSQL, Hadoop/Hive . SQL Database used to perform Big Data source data feeds into unstructured designs include SQL Server 2012, MySQL, Oracle and PostgreSQL DB. Business Intelligence BI /Online Analytical Processing OLAP interactively analyze multidimensional data roll-up, drill-down, data slicing Cluster Analysis Data Mining Predictive Modeling Crowdsourcing Textual Analysis Sentiment Analysis Network analysis Performance Management non-transactional, social data , Data Exploration, Social Analytics non-transactional, social data , Decision Science Apache Hive MongoDB DBA Couch DB DBA

Enterprise Resource Planning Systems Administrator

Confidential

Install, Deployment, Upgrades, Performance Tuning, Optimizing, Patching, and Maintenance Support of Peoplesoft, Oracle EBS, SAP and Lawson application environments. This includes new installations, implementations, module deployments, environment refreshes, interface development / support and integrations with other systems. My experiences include production, test, development, QA, UAT and Integration testing support. Data refreshes, application environment cloning, end user acceptance testing and performance stress testing are also included within my expertise with these applications.

Data Warehouse Systems and Data Migration Expertise

Confidential

Responsible for performance tuning and optimization of data warehouses Oracle, Sybase, MySQL, MS SQL Server and Informix technology . In addition my expertise includes the design and development of data warehouses. I have utilized both Star and Snowflake schemas and have designed and implemented data mining solutions for target data. Utilization of the 5 different data forms levels is also a part of my expertise.

Overall Technical Expertise

Confidential

Industry Experience Includes - Healthcare, Oil Gas, Telecommunication, Technology, Publishing, Banking Financial Services, Waste, Agricultural, Food Services, Pharmaceutical, Energy, Retail, Real Estate, Chemicals, Utility, Education

TECHNICAL SKILLS QUALIFICATION SUMMARY:

WORK HISTORY:

Confidential

• DBA Lead / Technical Lead / Oracle Database Architect Administrator /GoldenGate DBA / MS SQL Server Database Architect Administrator / DB2 Database Administrator
• Review of the database architecture as a whole to determine areas of improvement
• Performed database refreshes from production to test/dev environments
• Performance tuning exercises within MS SQL Server database and application parameters
• Performance tuning exercises within Oracle database and application parameters
• Performance tuning exercises including index strategies database Oracle MS SQL Server
• Make recommendations to include table level partitioning where it would improve performance
• Utilize Oracle Golden Gate and Golden Gate Veridata for both one directional and bi directional data replication
• Install, Configure and Setup ETL procesdure for Oracle XML DB Dev, Test Prod
• Oracle Agile Product Lifecycle Management Implementation and Configuration for Enterprise Deployment
• Oracle Lifecycle Management Oracle 12c Enterprise Manager 12c Agile Product Lifecycle Management Suite
• Deployment of patches through Oracle 11g Grid Control console.

• Data Transformation Services Create packages, replication, transformations

Confidential

• Big Data Technical Lead / Hadoop Administrator / Big Data Architect / MongoDB DBA
• Project Manager, Technical Lead Lead Architect
• Big Data Strategy performance management, data exploration, social analytics, data science
• Hadoop, Mongo DB, MySQL, Hadoop Cluster Administrator Architect
• Hadoop Cluster Cloudera Manager Hadoop Map Reduce Hadoop Pig Tableau Predixion Insight
• Execute technical assignments to foster new program designs for BDPA businesses
• Implement innovative software systems to solve key business challenges
• Acquire technical knowledge of technologies and proofs of concept
• Ability to execute tasks technically and report results
• Design and develop scalable software architectures Manipulate massive-scale datasets
• Setup Architecture for big data capture, representation, information extraction and fusion.
• Oracle Agile Product Lifecycle Management Implementation and Deployment of Fully Configured Environment
• Oracle Lifecycle Management Full Oracle 12c Enterprise Manager 12c Installation, Configuration and Deployment
• Relational, hierarchical and graph databases, distributed data file systems, data federation and query optimization
• Setup and manage Oracle Tools Suits Application Express for collaboration solutions.

Confidential

Technical Lead / Oracle Database Architect Administrator /Peoplesoft Database Administrator /Performance Tester

• Peoplesoft Upgrade to 9.1 via Peoplesoft Upgrade Manager and Database Upgrade from 10.2 to 11.2 via Oracle Migration
• Lead Technical DBA for Identification and Resolution of Oracle Database /Peoplesoft Performance Problems.
• Create Documentation and Standard Operating Procedures related to SAP Non-SAP Database Support.
• Oracle 11g Rel 2 Production Support / Financials, HR, Supply Chain, CRM Manufacturing

• Performance tuning exercises within Oracle 11gR2 parameters
• Oracle Parallel Query Optimization and Performance Tuning
• Performance tuning exercises utilizing Oracle 11gR2 Indexing strategies Automatic Database Diagnostic Monitor
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put via Parallel Query and Table/Index Partition

• Oracle Database Server and LINUX Kernel Performance Tuning
• Data ETL from Oracle Database to XML DB for power user data reporting.
• Validation of Database Backup and Recovery and Disaster Recovery Design and Implementation and Planning
• Database refresh and updates from production into test, QA development environment
• Validation of Oracle Data Guard setup and DR Database Deployment with Log shipping and Log Mining Setup

Confidential

MS SQL Server Database Administrator / SAP Database Administrator / SOP Development

• SAP Production Support / Test Support / QA Support / Development Support
• Database Instance Design / Hardware Server Migration
• MS SQL Server Maintenance Planning and Enterprise Wide Deployment Strategy Development

• Performance tuning exercises within SQL Server 2008 R2 parameters
• Performance tuning exercises utilizing SQL Server Indexing strategies Scripting SQL Profiler

• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put Database Indexing and Re-Indexing Strategy Development Typical database and server maintenance and backup procedures
• Validation of Database Backup and Recovery and Disaster Recovery Design and Implementation

Confidential

MS SQL Server Database Administrator / SAP Database Administrator

• SAP Production Support / Test Support / QA Support / Development Support
• SAP Application Upgrade Support / Database Upgrade / Hardware Server Migration
• MS SQL Server Maintenance Planning and Enterprise Wide Deployment Strategy Development

• Performance tuning exercises within SQL Server 2000/2005/2008 R1/R2 parameters
• Performance tuning exercises utilizing SQL Server Indexing strategies Utilizing SQL Profiler primarily
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put Utilizing SQL Profiler MS SQL Server
• Database Indexing and Re-Indexing Strategy Development

• Performed typical database and server maintenance and backup procedures
• Database Backup and Recovery and Disaster Recovery Design and Implementation
• Large data loads and updates from production into development environment

Confidential

• Lead Technical DBA for Identification and Resolution of Oracle Database /JD Edwards Performance Problems.
• Post Go-Live Database Performance Tuning - Oracle Database Administrator / JD Edwards DBA
• Oracle 11g Rel 2Production Support / Financials, Manufacturing, Supply Chain

• Oracle RAC 3 Node Cluster Performance Tuning
• Performance tuning exercises within Oracle 11gR2 parameters
• Data ETL Process design from Oracle to Oracle XML DB.
• Oracle Parallel Query Optimization and Performance Tuning
• Performance tuning exercises utilizing Oracle 11gR2 Indexing strategies Automatic Database Diagnostic Monitor
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put via Parallel Query and Table/Index Partition

• Oracle Exadata Database Machine / Advanced Security / Advanced Storage Hybrid Columnar Compression ZFS
• Oracle 11g RAC, Oracle Enterprise Manager, Oracle Advanced Compression, Oracle Active Data Guard
• Oracle Partitioning, Oracle Solaris / Oracle Linux
• Oracle Data Guard setup and DR Database Deployment with Log shipping and Log Mining Setup
• Oracle Streams Setup and Configuration

Confidential

Technical Team Lead / Peoplesoft Administrator / MS SQL Server Database Administrator / Oracle Database Administrator / Oracle Exadata DBA / Oracle Service Oriented Architecture SOA DBA / Oracle Golden Gate Administrator

• Production Support / Test Support / QA Support / Development Support
• Lead technical team responsible for performing the Peoplesoft Financials, HRMS and Global HRMS environment.
• Performance tuning exercises within SQL Server 2000/2005/2008 R1/R2 parameters
• Performance tuning exercises within Oracle 11gR2 parameters
• Performance tuning exercises utilizing SQL Server Indexing strategies Utilizing SQL Profiler primarily
• Performance tuning exercises utilizing Oracle 11gR2 Indexing strategies Automatic Database Diagnostic Monitor
• Performance tuning on queries that were poorly performing to identify ways to improve response time and through put Utilizing SQL Profiler MS SQL Server Automatic Workload Repository Oracle DB
• Oracle Exadata Database Machine X2-2 and previous versions ASM Advanced Storage
• Oracle 11g RAC w/ Oracle Grid Control Enterprise Manager
• Oracle Advanced Compression, Oracle Active Data Guard, Oracle Partitioning, Solaris / Linux w/ Super Cluster
• Oracle application express setup / maintenance upgrades for deployment of reports and other collaboration tools
• Peoplesoft HCM/HRMS 8.8 with Tools 8.45 MS SQL Server v2000 on Windows 2003 64 Bit
• Peoplesoft FS 8.4 with Tools 8.45 MS SQL Server v2000 on Windows 2003 64 Bit
• Peoplesoft HRMS 9.1 with Tools 8.51 Oracle Database 11gR2 on Red Hat Linux 5.0

Confidential

Technical Team Lead / Golden Gate Designer and Architect / Oracle Database Administrator / MS SQL Server Database Administrator / Peoplesoft HR / E-Business Suite Financials, CRM, Supply Chain Performance Tuning / SAP DBA

Oracle EBS/Oracle APPS DBA:

• Oracle Applications E-Business Suite v11i - v12i Oracle Retail Apps v10, - v14
• E-Business Suite Applications ERP Financials , HR, CRM, Procurement, SCM, Manufacturing
• Oracle Retail Applications MOM, SIM, RIB, POS Configure and Support w/ Weblogic Application Servers.
• Lead technical team responsible for performing the Oracle E-Business Suite environment performance tuning exercises.
• EBS and Database Cloning using Adclone old method and Rapid Clone process. DB Cloning also performed using RMAN.
• EBS Cloning processes done with data scramble process to create non-production db from clone of production db.
• Golden Gate Architect
• Oracle GoldenGate Process Groups
• Change Capture and Delivery with and without a Data Pump
• Bi-Directional Replication between MS SQL Server Oracle Database between Oracle DB2 Database
• Bi-Directional replication of HR and Finance Data between Oracle and SQL Server Peoplesoft Environments
• Bi-Directional replication Oracle E-Business Suites Data to Outside Database targets for Reporting and Business Intelligence
• Utilization of Oracle Veridata to verify data prior to commit of data changes.

Oracle DBA:

• Peoplesoft DBA:
• Responsible for the management of over 50 production, test and development Oracle Databases ranging in size from 25g to 8tb in size. Concurrent user base averaged over 500 simultaneous connections depending on the application.
• Oracle Streams setup and configure for large databases that required data share responsibilities. Configuration experience for staging and apply engine.
• Tested RAC for add on to Oracle Data Warehouse and several Data Marts
• Peoplesoft HCM/HRMS 9.0 to 9.1 upgrade with Tools Update Tools upgrades to 8.48 and 8.50 from previous versions
• Peoplesoft HR/FS/CRM/SC with Oracle 8i-11g Backend MS SQL Server v7-2008/R2 DB2 Informix
• Additional Peoplesoft Modules AM, SRM, CRM, Campus Solutions, EPM, EP

• Setup/Clone/Install and Properly configure all development, test, and production environments with an application server, web server, process scheduler and oracle/MS SQL Server backend database for the peoplesoft 8.4 to 9.0 CIS, Supply Chain, Change assistant was used to complete the peoplesoft patching necessary to bring the peoplesoft environments to the current patch levels recommended for the upgrade path.
• Oracle Exadata DBA:
• Oracle Exadata Database Machine, Oracle Super Cluster, Oracle OLAP / Business Intelligence / Advanced Security
• Oracle 11g RAC, Oracle Enterprise Manager, Oracle Advanced Compression, Oracle Active Data Guard
• Oracle Partitioning, Oracle Solaris / Oracle Linux / ASM Advanced Storage Compression ZFS
• Oracle Service Oriented SOA DBA:
• Oracle 11g Service Oriented Architecture, BPEL Process Manager, Human Workflow , Integration Adapters
• Business Activity Monitors, Complex Event processing, Business Rules, Oracle B2B, Oracle Web Services Manager
• Oracle Service Bus.
• SAP DBA:
• SAP DBA Performance tuning, Environment cloning/refreshes, Troubleshooting configurations
• SAP Modueles - APO, BI ABAP/Java, BOBJ, ECC-CWM, EP, eSourcing, GRC-GTS, GRC-AC, MDM, PI, Sabrix, SCM, SLD, SRM, TM
• MS SQL Server DBA:
• SAP-Oracle proactive monitoring / SAP DBA Cockpit, SAP-BR Tools for Oracle
• SAP BR Tools for Oracle, SAP-Oracle performance tuning, SAP-Oracle installs, upgrades, patching
• Performance tuning exercises within SQL Server 2000/2005/2008 R1/R2 parameters
• Performance tuning exercises utilizing SQL Server Indexing strategies Utilizing SQL Profiler primarily
• Database Upgrades: MS SQL Server 2000 to 2008 R1/R2 MS SQL Server 2005 to 2008 R1/R2

• Database Performance Tuning Utilizing SQL Profiler primarily
• MS SQL Server to oracle migration/conversion MS Windows to LINUX Platform migration/conversion