PROFESSIONAL & TECHNICAL PROFILE

Oracle Database 8i Oracle 11i Applications SQL Server 2000 MCDBA Windows 2003 MCSEOracle Database 9i Database Administrator SQL Server 2005 MCDBA Windows 2008 MCSE Oracle Database 10g Certified Professional SQL Server 2008 MCDBA Oracle Database 11g Oracle OEM 11g Essentials SQL Server 2012 MCDBA Oracle Database 12c MySQL Certified Professional Certified Master Administering SQL Server 2008 DB2 UDB 8.1 & DB2 9.0 MySQL 5.1 Cluster Database MySQLCore Database Administering SQL Server 2012 IBM Certified Advanced Certified Database Administrator Certified Database Admin Database Administrator MySQL Database Administrator Xpert Rating Certified Professional Certified Big Data Professional Certifed Professional Certified Big Data Science Professional Certified Big Data Scientist Certified Big Data Consultant Certified Big Data Architect

PROJECT MANAGEMENT PROFESSIONAL:

Technical Project Manager & Technical Team Lead

Responsibilities:

• Conducted technical training session regarding Agile development methods.
• Participated in meetings, technical discussion, reviews and release planning.
• Provided technical assistance during project planning and demonstrations.
• Formulated, implemented and maintained tools and practices.
• Prepared and coordinated project proposals and schedules.
• Monitored IT programs and supported financial management functions.
• Evaluated information radiators and Scrum issues on daily basis.
• Implemented and supported Sprint planning and retrospective activities.
• Provided technical support for Sprint Cycles and testing with Rally tool.
• Formulated and executed process flows and product backlog.
• Trained other members regarding Agile methodologies and Rally usage.
• Direct and manage project from inception to completion applying methodologies listed above
• Define project scope and oversee quality control throughout the project life cycle.
• Project Delivery Tasks: Performs quality review of major project deliverables
• Estimate cost and schedule and deliver within the defined Project Delivery Performance targets
• Establish project proposals, statement of work, request for proposals documentation
• Delegate and/or escalate tasks and responsibilities to the appropriate individuals at the right time.
• Experienced in managing cross - functional project teams and high-visibility projects.
• Improved team velocity by incorporating capacity planning into sprint planning sessions.
• Implemented Issues Tracking in Version One to effectively track impediments against user stories.
• Resolved a complex infrastructure issue by creating a network of Scrum Masters, Product Owners and Technical Leads
• Developed innovative features (node graphs and timelines) based on current and future data
• Integrated D3 technology to allow for a more functional and robust dashboard.
• Monitored the development progress throughout each sprint to ensure project was within scope and budget.
• Conducted user interviews to help identify and understand different process for each user while simultaneously identifying their pain points.
• Identified potential project risks and helped developed a mitigation plan to resolve potential issues.
• Managed the insight and opinions of multiple stakeholders and helped to ensure all stakeholders agreed with the current scope and roadmap of the product.

BACKGROUND SUMMARY:

Project Management / Technical Lead

• 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 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

• 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.

• 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, Confidential, 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 Business Intelligence (BI)/Online Analytical Processing ( Confidential ); interactively analyze multidimensional data roll-up, drill-down, data slicing; Cluster Analysis; Data Mining; Predictive Modeling; Crowdsourcing; Textual Analysis; Sentiment Analysis; Network analysis; NoSQL Database; Hadoop; Hadoop Cluster Administration; MongoDB DBA; Big Data Strategies - 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 Install, Deployment, Upgrades, Performance Tuning, Optimizing, Patching, 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.

TECHNICAL SKILLS & QUALIFICATION SUMMARY:

• Database Design, Data Maintenance, Database Security, Database Management, Requirements Analysis, Teamwork, Technical Zeal, Project Management, Presenting Technical Information, Training, Operating Systems
• 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.
• Oracle Exadata - Oracle 11g, Oacle RAC, Oracle Partitioning, Advanced Compression, GoldenGate, Active Data Guard, Business Intelligence, Oracle Enterprise Manager, Grid Control;
• Oracle WebCenter Suite Plus, SOA Suite for Oracle Middleware, SOA Management Pack Enterprise Edition, Unified Business Process Management Suite, Tuning Pack, Oracle API Gateway, Identity Governance Suite, Access Management Suite Plus, Cloud Management Pack for Oracle Database, Management Pack Plus for Identity Management, Application Express, Service Registry, Enterprise Repository, WebLogic Suite, WebLogic Server Management Pack Enterprise Edition
• Database Design and Administration - Oracle v7, v8, v8i, v9i, v10g, v11g, 12c; SQL Server v6, v7, 2000, 2005, 2008, 2008r2, 2012, 2014, 2016; MySQL, Sybase v4, v10, v11, v12, DB2/UDB, Informix v5, v6, v7, Ingres, Access
• Oracle DBA - Oracle v7, v8, v8i, v9i, v10g, v11g, 12c; DBA, Sun Solaris, IBM AIX, SCO UNIX, HP HPUX, Linux and Windows installation and scripting. ZFS Storage Administration; Exadata; ExaLogic;
• SQL Server SSRS, SSAS & SSIS, Database Clustering (Log Shipping, Data Mirroring, Replication), SAN Storage Technologies.
• SQL Server DBA - v6, v7, v2000, v2005, v2008, v2008r2, v2012, v2014, v2016; Windows designs, implementations and performance tuning
• MySQL DBA - v4, v5, v6, v7 windows, Linux designs, implementations and performance tuning, clustering, replication and data migration
• In-Memory DB Technology - DashDB, Aerospike, Times Ten, Oracle 12C, DB2 (BLU), Oracle Coherence, MS SQL Server 2014, SAP Hana, TPF
• Project Management - Project Managed via software manager, Team Lead, Technical Lead, Resource Management and Project Development
• Peoplesoft - v5, v6.x, v7.x, v8.x, v9.x Financials, HRMS, CRM, Student, Supply Chain Installation, Implementations, deployments and performance tuning. Ptools v8.14-8.50
• Oracle Apps / E-Business Suite - v10, v11, v11i, v12i Installation, Implementations, deployments and performance tuning.
• SAPDBA - Release 3 Financials, HRMS, Basis, MySAP Installation, Implementations, deployments and performance tuning. BR*Tools (
• Clinical Applications - MOM Reporting and Monitoring System; Eclipsys Clinical Application, MS SQL Server DB
• Staff and Budget Management - Management of Technical Resources up to 50 on-shore & off-shore in all. Departmental Budget and Project Budget Management for hardware and staffing requirements. Resource Management and Cost Analysis.
• Oracle Streams, Oracle Goldgate, Oracle Goldengate Veridata, Oracle Architrecture; Oracle Advanced Security; Oracle Spatial and Oracle Locator Options; Oracle Application Express;
• Data Warehouse - Star Schema, Snowflake, Business Objects, Hyperian, Micro-strategies, Extract Transform and Load, data migration and performance tuning.
• Big Data Strategies - Performance Management (non-transactional, social data), Data Exploration, Social Analytics (non-transactional, social data), Decision Science; Designing and developing scalable software architectures; Manipulate massive-scale datasets, Architectures for big data capture, representation, information extraction and fusion.
• Big Data Technology - Apache Hadoop; Hadoop Clusters, Hadoop Common, Hadop Distributed File System; Replication; Cassandra; MongoDB; Relational, hierarchical and graph databases, distributed data file systems, data federation and query optimization

WORK HISTORY:

Confidential, Santa Monica, CA

Big Data Architect / Enterprise Data Architect / Data Scientist

Responsibilities:

• Design Pivotal solution roadmap & strategy
• Define data migration strategy from 2000+ data sources into (HDFS) Hadoop/PostgreSQL/GreenPlum
• Design ETL strategies for data pipeline from source databases to (HDFS) Hadoop/PostgreSQL/GreenPlum
• Define to-be application and platform architecture for cloud native applications
• Assess a project’s technical feasibility, as well as implementation risks.
• Design and implement technical architecture.
• Architect & Administrator (AWS) GenGireXD, PostgresSQL, Greenplum, Hawq & Kafka environments
• Architect & Administrator (Azure) Hadoop Horton works, Hadoop Yarn, Hadoop Spark w/Mongo, Cassandra & CouchDB
• Support API and Java Developer teams with both Administration of the total cluster and data request from legacy and cloud
• Define the pivotal technical structure and the necessary interfaces
• Define guiding principles for the enterprise organization, software design and implementation.
• Influence the adoption of the Platform Design connecting use cases and technology capabilities
• Technical Lead for any Cloud Native work
• In conjunction with Cloud BA, define To-Be Cloud Native functional spec of an application
• Define To-Be application and platform Architecture for a Cloud Native application
• Designed and Developed data migration strategy for Cloud Solutions
• Define SOA based applications and micro-services for Data Pipeline Architecture
• Define Cloud Native (micro-services/BDD (behavior driven development), containers/Dockers, Agile, BDD)
• Define data ingestion strategies (Kafka, Flume)
• Pivotal Cloud Foundry and Spring Cloud
• Prioritize USE cases and convert into platform deliverables/solutions
• Oracle DBA 12c (450+ PRD DB’s); SQL Server DBA 2012/2014/2016 (425+ PRD DB’s); DB2 DBA 9/10 (75 PRD DB’s)
• Peoplesoft Production, Test, QA & Dev environment support and administration
• Peoplesoft Upgrade from 9.1 to 9.2 via Upgrade Assistant
• Peoplesoft Tools Upgrade to latest 8.51 to 8.54 via Change Assistant
• Oracle Database migration Peoplesoft Platform change to 12c Exadata Platform
• Peoplesoft Application Server, Process Scheduler, REN Server, Gateway, Weblogic & File Server Support/Upgrade

Confidential

Big Data Architect / Enterprise Architect / Data Scientist / Big Data Technical Lead

Responsibilities:

• Build services that help categorize data based on usage and underlying attributes coming from a variety of systems.
• Create systems that help quickly make anomalous patterns in data pipelines known to teams throughout enterprise.
• Provide requirements and techniques into systems that help cleanse data being used in key business data pipelines.
• Analyze data originating from many different source systems and database technologies.
• Work with people/teams throughout enterprise to find opportunities improve data quality for overall data products.
• Build features to support data categorization models, data quality anomaly detection and better data cleansing processes.
• Identify and improve data elements within existing data lakes and new data lakes still in design phase.
• Design and develop data requirements and samples that can be incorporated into engineering (technical) processes.
• Organized and facilitated Agile and Scrum meetings
• Scrum meetings included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Drafted Enterprise Big Data Platform policy which was incorporated in executive Project Management guidance
• Implementing Big Data Solution Architectural Layers (Data Sources, Data Ingress and Storage)
• Utilizing Event Stream Processing and Complex Event Processing, Egress, Visualization and Utilization
• Big Data Architecture and Security, Maintenance and Governance
• Big Data Design Patterns - Data Ingress, Data Wrangling, Data Storage
• Big Data Solution Patterns - Data Processing, Data Analysis, Data Egress, Data Visualization
• Defined scope for Big Data Platform and identified / Selected initial Use Cases that would drive Big Data Project
• Big Data Strategy – Developed Initial Approach and Selected Initial Technology Stack
• Big Data Strategy – performance management, data exploration, social analytics, data science
• Architect & Administrator (AWS) GenGireXD, PostgresSQL, Greenplum, Hawq & Kafka environments
• Architect & Administrator (Azure) Hadoop Horton works, Hadoop Yarn, Hadoop Spark w/Mongo Cassandra & CouchDB
• Designed and Developed data migration strategy between AWS and Azure environments
• Support API and Java Developer teams with both Administration of the total cluster and data request from legacy and cloud

Confidential

Big Data Architect / Big Data Administrator / Hadoop Administrator / Hadoop Technical Lead

Responsibilities:

• Organized and facilitated Agile and Scrum meetings
• Scrum meetings included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Drafted Enterprise Big Data Platform policy which was incorporated in executive Project Management guidance
• Defined scope for Big Data Platform and identified / Selected initial Use Cases that would drive Big Data Project
• Big Data Strategy – Developed Initial Approach and Selected Initial Technology Stack
• Big Data Strategy – performance management, data exploration, social analytics, data science
• Design and model database within the NoSQL area to accommodate data solutions with Hadoop and In-Memory DB
• Architect & Administrator Hadoop, MongoDB, Hadoop Cluster
• Architect & Administrator Hadoop Cluster; Hadoop HDFS; Hadoop Hive; Hadoop Map Reduce; Hadoop Pig
• Architect & Administrator Hadoop Horton works, Hadoop Yarn, Talend Analytics
• Oracle Goldengate / Oracle Data Integrator / Hive / NoSQL Data integration design & configuration
• 150+ MS SQL Server Database (Servers) housing over 900 SQL Server Databases – Consolidation/Data Migration
• 300+ Oracle Servers housing over 2200 oracle databases – Consolidation/Data Migration
• 100+ MySQL Database – Consolidation/Data Migration
• 120 DB2 Database Servers housing over 300 DB2 databases – Consolidation/Data Migration

Confidential

Big Data Architect / Big Data Administrator / Hadoop Administrator / Hadoop Technical Lead

Responsibilities:

• Worked to effectively combine the vision of customer with in-house designers to provide clear design specifications
• Provided daily communications, scrum notes, sprint reviews reports, and project retrospectives
• Provided regular snapshots of project velocity and budget burn rate.
• Organized and facilitated Agile and Scrum meetings
• Scrum meetings included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Drafted Enterprise Big Data Platform policy which was incorporated in executive Project Management guidance
• Defined scope for Big Data Platform and identified / Selected initial Use Cases that would drive Big Data Project
• Big Data Strategy – Developed Initial Approach and Selected Initial Technology Stack
• Technical Architect of analytics platform collecting usage from billions of records.
• After the burn-in period team was able to execute 80% - 90 % of user stories over multiple sprints.
• Rapid bootstrapping of distributed team and excellent cadence build-up with-in 2 iterations.
• High-performing and motivated team created with record close to 95 % participation in agile meetings.
• Team designed and trained to follow Kanban or Scrum based on project or user story.
• Executive briefing and reporting on scrum metrics, burn-up and process improvements periodically.
• Implemented backend platform for large scale ingest using HBase client modules performing fine grained analytical reports
• Designed the real time analytics and ingestion platform using Storm and kafka.
• Loaded multiple NOSQL databases including MongoDB, Riak, Couchbase, HBase and Cassandra.
• Led team of engineers and coordinated the QA effort for prod-ops, QA and presentations to product and executive teams.
• Implemented high speed caching engine directly serving millions of customers when not possible prior.
• The caching engine built for parsing of JSON content over the wire at nearly 100k per second requests.
• Designed a high speed proprietary NoSQL engine to serve as distributed cache within map-reduce.
• Defined data elements that were required for initial Big Data Platform
• Design initial data model & database design for NoSQL database solutions including Hadoop and In-Memory DB
• Managed Rackspace and MS Azure accounts utilized for Big Data Platform
• Documented cloud strategy for Big Data Platform and showed value for use cases selected for project
• Architect & Administrator of Oracle EDW & SQL Server EDW (Replacing Informatica with Big Data Platform)
• Oracle Data Integrator / Informatica / Hadoop / NoSQL – Data / ETL & replication for Bi-Directional updates
• Setup initial ETL design for Big Data Platform from Production EDW (Replacing Informatica with Big Data Platform)
• Architect & Administrator Hadoop Cluster; Hadoop HDFS; Hadoop Hive; Hadoop Map Reduce; Hadoop Pig
• Documented process and data flow showing side by side comparisons of current ETL and Big Data Solution
• Architect & Administrator Hadoop Horton works, Hadoop Yarn, Talend Analytics (Replacing Informatica with BD Platform)
• Moved more than 10 Billion rows of data into Big Data Plat form from Oracle EDW /SQL Server EDW

Confidential

DBA Lead

Responsibilities:

• Support, Upgrade, Performance Optimized, SAP Oracle Database
• Lead Architect DSP Hana Data migration from SAP Oracle database
• Hadoop Hortonworks and SAP Hana Installation, Configuration and Deployment
• Optimized SAP Hana and Hadoop functions for data delivery to customers and vendors
• Review database architecture to determine areas of improvement
• Performed database refreshes from SAP Oracle production to test/dev environments
• Migration from Oracle RAC into Exadata Cluster
• Oracle 12C Pluggable Databases Through Database Consolidation; Redaction Policy; Top N Query and Fetch;
• Oracle 12C Adaptive Query Optimization and Online Stats Gathering; Multiple Indexes on a Single Column;
• Oracle 12C Online Migration of Table Partition/Sub Partition; Temporary UNDO; In Database Archiving;
• Oracle 12C Data Integrator configuration with Hadoop/Hive & Oracle DB integration;
• Oracle 12C Invisible Columns; PGA Aggregate Limit setting utilization; DDL Logging utilization;
• Performance tuning exercises within Oracle 12C database and application parameters
• Performance tuning exercises within MS SQL Server 2012/2014 database and application parameters
• MS SQL Server Performance tuning exercises within MS SQL Server 2014 database and application parameters
• MS SQL Server Always Encrypted utilization; Dynamic Data Masking utilization; JSON Support;
• MS SQL Server Multiple TempDB Database Files; PolyBase; Query Store; Row Level Security;
• MS SQL Server R Comes to SQL Server; Stretch Database utilization; Temporal Table utilization
• Database Consolidation from Oracle, MySQL, DB2 & SQL Server into PostgreSQL Database (Data Warehouse Reporting)
• Utilize Oracle Golden Gate and Golden Gate Veridata for both one directional and bi directional data replication
• GG replication for changes from Oracle, SQL Server, DB2 and MySQL to PostgreSQL
• DB2 DW ReporDB2/UDB DBA v9.1, v9.5, v9.7, 10 &10.5 DB2 on AIX & RedHat Linux
• DB2 Compression, Partitioning and Deployment setup and configurations
• DB2 Performance tuning, parameter optimization and OS Kernel tuning database performance
• DB2 Data load/Bulk Load (ETL) optimization, query optimization, memory and file system tuning
• DB2 & UDB Upgrades, Server OS Platform Upgrades (AIX & Red Hat & Windows 2012)
• Implemented range partitioning on large DB2 V9 database to simplify data management and roll-in/rollout strategy.
• Tested base DB2 version 10.5 functionality
• Implemented the DB2 Governor to remove idle database connections
• Setup and establish Oracle API Gateway & Policy Studio on Linux
• Created and deployed Oracle API Gateway Instance w/API Gateway Manager via Mulesoft ESB standalone server
• Configured IBM DataPower gateway servers with the Oracle API gateway software on oracle/redhat linux
• Install, Configure and Setup ETL procedure 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
• Support, Upgrade, Performance Optimized, SAP Oracle Database
• Lead Architect DSP Hana Data migration from SAP Oracle database
• Hadoop Hortonworks and SAP Hana Installation, Configuration and Deployment
• Optimized SAP Hana and Hadoop functions for data delivery to customers and vendors
• Review database architecture to determine areas of improvement (Real-Time Architecture/Analytics)
• Installed, Configured & Deployed Greenplum (Postgres) Databases with Aqua Administration interface
• Deployment of Hadoop Clusters with MongoDB – Sharding, Replication, Data migrations, Database backups and restores

Confidential

Big Data Technical Lead / Hadoop Administrator / Big Data Architect

Responsibilities:

• Project Manager, Technical Lead & Lead Architect
• Big Data Strategy – performance management, data exploration, social analytics, data science
• Design and model database within the NoSQL area to accommodate data solutions with Hadoop and In-Memory DB
• Architect & Administrator Hadoop, MongoDB, MySQL, Hadoop Cluster
• Architect & Administrator Hadoop Cluster; Hadoop HDFS; Hadoop Hive; Hadoop Map Reduce; Hadoop Pig; Tableau;
• Architect & Administrator Hadoop Horton works, Hadoop Yarn, IBM Watson Analytics
• Real-Time Analytics, IBM Insight Analytics, Watson Analytics
• Installed and Configured Oracle API Gateway for XML to JSON conversion efforts for Hadoop data migration projects
• Microsoft Analytics Platform System - Implementation. DW Migrations from Existing DW into MS Platform System.
• Architecture of the MS Hadoop Solution with ETL design from multiple source systems.
• Implementation and deployment of SQL Server Parallel Data Warehouse (PDW), HDInsight
• Progress DB / Linux DBA, data migration projects to/from Progress to oracle, MS SQL Server and DB2.
• Cassandra DBA – OpsCenter, Enterprise, Data Center Replication & Compression configurations and deployments
• Installed, Re-Deployed & Upgraded Greenplum (Postgres) Databases for production, QA & test environments
• Uploaded business cases for analytical processing and selected data based on criteria (for testing)
• 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)
• Oracle Data Integrator setup between Oracle 12c and Hive/HDFS - ETL Oracle Exalogic and Hive / Cassandra Extracts
• Relational, hierarchical and graph databases, distributed data file systems, data federation and query optimization
• Setup and Deployed Oracle Exalogic Appliance for Finance application. Built oracle databases within appliance and deployed after setup was completed. Created ETL strategy for batch jobs to move data from legacy into Exalogic Appliance
• Oracle Internet Directory configuration and replication – Oracle Exalogic OID & Oracle Database Appliance Configuration
• Tuned Exalogic appliance for application performance, troubleshoot technical issues, setup monitoring console and backups.

Confidential

DBA Lead / Technical Lead

Responsibilities:

• Roles and Responsibilities transition from IBM Hosting Contract to internal team. Documentation of transition plan.
• Developed strategy and implementation plan for transitioning 1400+ MS SQL Server into Enterprise Monitoring Solution
• Created monitoring solution for 400+ production databases with PowerShell, Solar Winds & SQL Server Mgmt Studio
• Created & Documented high level SQL Server consolidation plan to upgrade older SQL Servers onto newer platforms
• Developed support plan for 1400+ MS SQL Server databases including performance tuning & high availability requirements
• Documented plan to migrate 200+ SQL Server 2000 database into SQL Server 2012 instances with very little complication
• Severed as contractor while Human Resources sought after full time resource for this opportunity.

Confidential

Technical Lead

Responsibilities:

• Lead Technical DBA for Identification and Resolution of Oracle Database /Peoplesoft Performance Problems.
• Oracle Exadata Database Machine / Advanced Security / Advanced Storage Hybrid Columnar Compression (ZFS)
• Peoplesoft Upgrade to 9.1 via Peoplesoft Upgrade Manager and Database Upgrade from 10.2 to 11.2 via Oracle Migration
• 300+ Oracle Database Consolidation from US Data Center to Canada Data Center – Shell Scripts/Powershell Scripts
• Oracle 11g Rel 2 Production Support / Financials, HR, Supply Chain, CRM & Manufacturing
• Oracle Parallel Query Optimization and Performance Tuning
• Performance tuning exercises utilizing Oracle 11gR2 Indexing strategies (Automatic Database Diagnostic Monitor)
• Performance tuning on queries adding Parallel Query and Table/Index Partitioning
• 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
• Data migration from Oracle / PeopleSoft to Cassandra DB for Big Data multi-database integration project
• NoSQL, Apache Cassandra, and DataStax Enterprise database administration
• Creating, adding data, and querying database objects with the Cassandra Query Language (CQL)
• Managing database objects with CQL and the command line shell.
• Managing and monitoring DataStax Enterprise with DataStax OpsCenter.
• Hadoop Cluster administration with storage and cloud support, performance monitoring and other Hadoop features

Confidential, SAP Database Administrator

Responsibilities:

• 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 (Utilizing Scripting & SQL Profiler –MS SQL Server)
• Database Indexing and Re-Indexing Strategy Development
• Performed 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

Responsibilities:

• 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

Responsibilities:

• Lead Technical DBA for Identification and Resolution of Oracle Database /JD Edwards Performance Problems.
• Oracle 11g Rel 2Production Support / Financials, Manufacturing, Supply Chain &
• Oracle RAC (3 Node) Cluster Performance Tuning
• 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
• 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
• Oracle Data Guard setup and DR Database Deployment with Log shipping and Log Mining Setup
• Oracle Streams Setup and Configuration

Confidential, Technical Team Lead

Responsibilities:

• Lead technical team responsible for performing the Peoplesoft Financials, HRMS and Global HRMS environment.
• Production Support / Test Support / QA Support / Development Support
• 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)
• Database Performance Tuning (MS SQL Server & Oracle)
• 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, Philadelphia, Pa

Technical Team Lead

Responsibilities:

• Oracle Applications – E-Business Suite v12.x
• E-Business Suite Applications – ERP (Financials), HR, CRM, Procurement, SCM, Manufacturing;
• Lead technical team responsible for performing the Oracle E-Business Suite environment performance tuning exercises.
• Review of the Oracle E-Business Suite (v 12) as a whole to determine areas of improvement
• Performance tune an existing Oracle E-Business Suite production application and database environment.
• EBS and Database Cloning using Adclone (old method) and Rapid Clone process. DB Cloning also performed using RMAN.
• Utilize Oracle Golden Gate and Golden Gate Veridata for both one directional and bi directional data replication
• Replication of Data from EBS database into MS SQL and MySQL databases Platforms for reporting.
• Utilize Golden Gate Veridata to validate data changes between Oracle and other RDBMS’s before data is applied
• EBS Cloning processes done with data scramble process to create non-production db from clone of production db.
• Concurrent manager Tuning & Maintenance–
• Maximizing throughput for jobs spawning parallel workers
• Concurrent manager tuning - Review and modification of Cache size, dedicated concurrent managers, and FND table purging
• Concurrent manager tuning - Workload management via specialization rules and work shifts
• Concurrent manager tuning - Review and modification of Transaction Manager
• Concurrent manager tuning - Tracing slow concurrent reports to determine options for optimization
• Application Tuning & Maintenance –
• Maximizing throughput for and tuning OC4J, Forms, JVM, CPU Allocation, Sizing, etc…
• ATG patching and JDK levels
• Diagnosing application tier response time / CPU issues
• Tuning Java garbage collection parameters
• Tracking down OutOfMemory errors, memory leaks
• Debugging JDBC issues, including mapping JDBC sessions to particular JVM processes
• Handling OA Framework and web application issues
• Using Pool Monitor to investigate Framework Application issues
• Using the R12 Application Server Control to monitor JVM usage and thread deadlocks via a web interface
• Application Modules Level Tuning and Maintenance –
• Optimizing Workflow
• Logging levels
• Purging and archiving strategies
• System administration using Oracle Applications Manager and the Applications Management Pack Grid Control Plug-in for Oracle Enterprise Manager
• Performance patches and Release Update Packs (RUP)