PROFESSIONAL SUMMARY:

• 20 years of professional experience designing, developing and implementing relational database management systems. Expert knowledge with Microsoft technologies: Microsoft SQL Server (6.5, 7, 2000, 2005, 2008, 2008R2/2012/2014), SSAS (2000, 2005, 2008, 2012), PostgreSQL (8.4.1, 8.3.8, 8.2.14), FoxPro (DOS 2.5, 3.0, 95, 97, 2000, 2003), Access (2.0, 95, 97, 2000, 2003, 2007), MySQL (Versions 4.x - 5.7), and Sybase Adaptive Server 11.5, Oracle (8i/10g/11g/12C), Progress DB Open Edge v9/10
• 20 Years Cloud Technology
• Microsoft Azure
• Mongo Cloud
• AWS
• Oracle Cloud
• 8 years’ professional experience developing client-side website and 32bit applications.
• Over 20 years’ experience, development and support with Microsoft SQL Server, all versions up to version 2016
• Over 6 years’ experience with Oracle (OSS) Oracle Student System
• 3 years’ experience with Ellucian Banner ERP Student Information System
• Over 7 years’ experience, development and support with Mongo DB, all versions to current
• Replica Sets, Ops Manager, Sharding
• Rapid7 Nexpose Vulnerability Scanner and Masergy Vulnerability Security Scanner
• Expert in Vulnerability and Penetration Testing (Windows and Linux Systems)
• 2 years’ Support, Installation, Configuration and Development with:
• Rocket UniData v8.1.1 (Linux) - Current
• Rocket UniVerse v11.2.5 (Linux) - Current
• Rocket D3 (Windows v10.2) - Current
• Over 7 years’ experience with Hyper-V and VMWare
• Micro Strategy Analytics & Reporting - MicroStrategy Universal Edition - 8 years
• Oracle Cloud Compute (Elastic Cloud):
• Platform (PaaS), Infrastructure (IaaS), Hadoop (Big Data), Oracle Database 12c, Multi-Tennant and Single Tenant Virtual Machines for Development, Test and Production environments, Storage, Network and Cloud Machine, Oracle Cloud Messaging, Business Analytics and Business Intelligence.
• OpenStack Technologies - 5 years’
• Data Center Power Systems (High Efficiency Power Distribution Systems AC 120/240) - 6 years’
• Over 7 years’ experience with IaaS platforms (Amazon Web Services, Microsoft Azure, Confidential Cloud, Mongo Cloud)
• Expertise with Oracle RDBMS 8i/9i/10g/11g/12c.
• Expertise with Oracle Real Application Cluster (RAC) 9i/10g/11g/12c.
• Expertise with Oracle Data Migrations (9i to 11g/12c).
• Expertise with Oracle Database Appliance (X4-2, X3-2) installation, configuration and administration.
• Over 3 years’ experience and development and support with Amazon Web Services (AWS) and OpenStack
• Over 7 years’ hands-on experience with Data Center Consolidations and Migrations (Physical and P2V)
• Expertise with Oracle upgrades 9i to 10g/11g/12c.
• Oracle Enterprise Linux (OEL, current version 7) - 12 years’
• Security Hardening for Network, Windows Servers, Linux Servers - 10 years’
• Expertise in migrating Oracle database to Microsoft SQL Server (11g to SQL Server 2008R 2/ 2012/2014/2016 ).
• Expertise with Oracle upgrades and Migrations from 32bit to 64bit platforms.
• Expertise in migrations of data/DDL/DML, Packages, PL/SQL Procedures, database objects from 8i/9i to 10g/11g/12c.
• Expertise in migration of Oracle 10g/11g/12c to Microsoft SQL Server.
• Expertise with Oracle Recovery Manager 9i/10g/11g/12c.
• Expertise with Oracle Patch Management (Oracle Enterprise Manager) and Grid Control/Cloud Control.
• Expertise with Oracle RAC 10g/11g/12c implementations, support and resolution of performance issues.
• Expertise with Oracle Streams and Replication 10g/11g.
• Oracle Goldengate 11g/12c - 4 years’
• Expertise with Oracle Data Pump 11g and Oracle Golden Gate 11.2.1.0.2.
• Expertise with Oracle RDBMS migrations from 8i to 9i/10g/11g/12c.
• Expertise with Oracle Real Application Testing (RAT), Sarbanes Oxley (SOX), RAD and SDLC.
• Expertise with Oracle Sun Systems
• Expertise in developing and supporting Multi-Terabyte Data Warehouses (Oracle and Microsoft SQL Server).
• 7 years’ experience developing two, three-tier systems, and N-Tier systems using various methodologies.
• 7 years’ experience in web development utilizing IIS, ASP, ASP.Net, and C #, ADO.NET, XML, CSS, JavaScript, HTML, DHTML, VBScript, FTP, Java and HTML.
• Over 7 years’ development and script writing in Perl, Python, Ruby/Ruby Gems, Linux Shell Scripting (Korn, Bash, SH), MS Windows PowerShell Scripting
• Expert at SQL Server 2008/ 2012/2014/2016 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Object Search, Object Explorer Details, Activity Monitor, Multi Server Query, Intellisense in Query Editor and T-SQL Debugger.
• Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, ATTACH/DETACH Data Migration tools.
• Expertise in RDBMS S/w Installation, applying patches, upgrading, configuring, managing, monitoring disk space usage, and database integrity/consistency and troubleshooting of SQL Server 2008 R 2/05/00/ 2012/2014/2016 on Windows 2008/03/00 servers built on Clustered & Stand Alone Servers.
• Expertise in implementing and setting up DISASTER RECOVERY and HIGH AVAILABLITY solutions like Log Shipping, Mirroring and Replication (Transactional and Snapshot Replication), Microsoft SQL Server Clustering 2012/2014/2016 Always On
• Expert in Performance tuning of Database Management Systems (i.e. Table/Index Partitioning, T-SQL Performance Tuning, etc.)
• Experience in creating and deploying the CUBES in BIDS with Fact and Dimension Tables using different data warehouse styles (star and snow-flake schema).
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMVs and DMFs.
• Creating SSIS Packages using Complex Tasks like ActiveX script task, Fuzzy Lookup and fuzzy Groupings.
• Extensively used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Excellent skills in database Backup, Recovery, Linked Servers, Database Maintenance Planning.
• Excellent SQL Server administration skills including user authorizations, Database creation, Tables, indexes creation.
• Expertise in planning, implementing Database Security by creating users, Roles, and assigning permissions to them.
• 8 years’ Experience using Slurm, IPMI, Conman, Powerman, Zabbix, Gerrit in Linux Environments & Windows
• Experience in creating and scheduling DTS and SSIS packages, SQL Mail Setup, Jobs, and Alerts.
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries and Common Table Expressions.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) /Network Attached Storage (NAS).
• 24 X 7 Production Database on Call Support.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

WORK EXPERIENCE:

Confidential, Austin, TX

Senior Microsoft SQL Server DBA/Architect

Responsibilities:

• Responsible for acquisition and installation and support of SolarWinds Database Performance Analyzer and its Integration with SolarWinds Infrastructure and Server Monitoring.
• Design and Buildout of a Multi-Node SQL Server Cluster, segregated into multiple functions from Availability Groups for Reporting (SSRS)
• Designed and installed SSRS SQL Server 2016 Cluster, Database Cluster Nodes, and AlwaysOn Availability Groups
• SQL Server Developer in support of new Software & SQL Database projects for our Logistics
• SSIS 2016 Packages & SSRS Reports 2016 Development
• Business Intelligence & Anylitical Dashboards
• Overseer of Team Foundation Server Source Control
• Architect Microsoft Azure Cloud Implementation
• Hybrid / On-Premise and Cloud
• Microsoft Azure and Power BI with Visualization Dashboards Custom and Tableau
• SQL Server BI and Analysis and Reporting
• Architect and Implemenation of Star-Schema Datawarehouse, and migrations from non-standard unconventional Datawarehouses.
• Including TEL/ELT with SSIS 2016 and Visual Studio 2017 Developent of SSIS Packages and SSRS Reports.
• Planning for P2V Migration from Legacy Hardware & older versions of SQL Server from .
• Planning and strategy for all migrations to New SQL Server 2016 Cluster
• Working closely with RacSpace our Service Provider (Azure Stack & Power BI)
• Software our company develops for its many customers and thousands of Trucks on the road.
• Support of our Customer Service Department to help solve customer technical issues.

Confidential, Los Lunas, NM

Responsibilities:

• Developed a Suite of ERP & HRMS Applications called CRONUS ERP & HRMS which integrates seamlessly with all major ERP & HRMS Vendors.
• Customer: San Felipe Pueblo, Algodones, NM
• Developed in .Net & C# and Microsoft SQL Server and MySQL
• Utilized Chef & GIT, along with other tools such as Habitat for Automated Deployments of our Systems. GIT/GITHUB for our Repositories
• Networking Monitoring & Provisioning using: Kickstart, Cobbler & PXE - Pre-booting Systems via Linux Fast Server Deployments, using Centos OS.
• Provisioned IP’s & DNS, internally and external, Fire-Walls, TCP & UDP Port Assignments for all Servers & Network Devices, CLI Linux tools such as FreeIPA.
• Bare-Metal Rack Server Builds in Data Center for all Systems:
• Shipping & Receiving for all required hardware and equipment
• 8 Clustered Application Servers
• 16 Clustered SQL Servers in High Availability / Always-On
• 4 Clustered MySQL Instances / Servers (Virtual Machines - VMWare)
• 8 Clustered Oracle RAC 12c Physical Servers / Active-Active, with Log Shipping and Replication
• Responsible for working with Hosting Data Center, running cabling for all Networking Devices, and F5 Load Balancers.
• Applications Architect & Designer of CRONUS ERP & HCM/HRMS (Oracle E-Business Suite 12c)
• Upgraded Oracle EBS 11i to 12.7 & Applied Patches
• Oracle Enterprise Linux (OEL)
• Reverse Engineered Oracle EBS HR & ERP Modules to build Interfaces to CRONUS ERP & HRMS
• Cloned using Rapid Clone to other environments
• Created Oracle RAC instances to support back-end databases
• Upgraded Oracle 11g to 12c
• Setup RMAN backups
• Code Reviews, Scrum & Design Sessions with all my developers
• Data Modeling, Database Design and ETL Architecture and Design
• Software Deployments & Upgrades
• Created Virtual Servers / Application Servers on Amazon Web Services (AWS) for External Access to Internal Web Servers via Web Services & JSON
• Quality Assurance and User Experience
• Break/Fix & Defects
• Technical Documentation, Infrastructure Diagrams, User Guides and Training Manuals & Videos

Confidential, Los Lunas, NM

Sr. DBA/Architect/Systems Administrator

Responsibilities:

• Provided support of development, QA and Production Microsoft SQL Server 2008 R2, 2012, 2014 and 2016 Instances/Databases
• Performance tuning (indexing, stored procedures, batch processes)
• Table/Index Partitioning for very large tables
• Install and configure Fog light for monitoring of Production SQL Server’s
• Support for Fail-Over/SQL Server Clustering (Installation and configuration)
• Microsoft Data Protection Manager (DPM) - backup all systems
• Microsoft SCOM - For monitoring and performance tuning.
• Setup and Configuration of SQL Server Replication
• Configure Publishers and Subscribers
• Transactional, Merge, Peer-to-Peer and Merge Replication from SQL Server’s in the Montreal and Boston Data Centers to Data Centers in California and China
• Development with Visual Studio 2012/2013/2015 (SSIS) - ETL Packages, support current BI Team
• Upgraded VS from legacy Visual Studio 2005 to VS 2013
• Migrated and Converted all SSIS Packages (200) to VS 2013
• Installation, administration and support Cassandra 3.7
• Security, Administration, Maintenance, back and Recovery and High Availability
• Setup and configure Vulnerability and Security Penetration Testing
• For all our Microsoft Windows and Linux Servers in Boston and Montreal
• Setup scripts and batch jobs for weekly Security Vulnerability and Penetration Testing using:
• Rapid7 Nexpose Vulnerability Scanner - For our internal testing and;
• Masergy Vulnerability Security Scanner - For External testing of all open TCP,UDP, …Ports
• Recommend and Implement Security Hardening:
• Windows Host Security Hardening
• Linux Host Hardening using SE Linux
• Network Security Hardening (disabling unused ports, enforcing firewall rules)
• Web/Application support (Linux, Node.js, Python and Perl, PM2, NVM-Node Version Manager and NPM - Node Process Manager), Dev., Test and Production
• Team lead, Architect for Data Center Consolidation and P2V migrations of Development, QA and Production Web Applications
• Linux Shell Scripting, Ruby Scripting, Python Scripting and Perl
• Developing interfaces, Node Micro services, batch jobs and Messaging with RabbitMQ
• Migrated Web Applications (Node.js/Java Script Micro Services) - P2V (Hyper-V) Hardware Consolidation
• Over 100 individual Web Applications
• OS Migration from Sun Solaris (Joyent) to RedHat Linux/Centos
• 20 Windows Server 2008 R2 with Upgrades to Windows Server 2012 R2
• Physical to Virtual Data Center Migrations (P2V)
• Bare Metal build/OS install, OS Packages, DNS and Network Configuration
• Security
• Network configuration
• Configure Backups with DPM
• Support for RabbitMQ in Development, QA and Production
• Support, Installation, Configuration, Management (Administration), Development: (In support of Shark Ninja Customer Web Sites, Marketing Information, Sales and Product Information)
• Rocket UniData v8.1.1 (Linux)
• Rocket UniVerse v11.2.5 (Linux)
• Rocket D3 (Windows)
• Rocket U2 Development Platform
• SystemBuilder v6.4.1
• Support QlikView Applications on Windows Server 2012 R2 and batch processes
• Development, QA and Production support for Node.js Web Applications
• Support for JAMS Batch Scheduling
• Installed, configured MySQL Cluster CGE ver. 7.2 (Linux) - DB’s For External Web Applications
• Setup/configured replication between data center and DR facility
• Write procedures, creating tables and indexing
• Performance tuning
• Backups with MySQL Enterprise Backup and MySQL Dump
• Monitoring with MySQL Enterprise Monitor
• Responsible for supporting 12 Mongo DB (3.X) Instances (Linux and Windows Server 2012 R2)
• Designed and Configured an (11) node Sharded Cluster with Replica Sets
• 3 config servers, 2 application servers with Mongos, 2 Primary/4 secondary
• Backups/Restores mongoexport, mongoimport, mongodump, mongorestore
• OpsMgr and Mongo Cloud
• Administration support with Mongo Cloud, and all utilities
• Setup/support for daily backups
• Participate in daily/weekly meetings
• 24x7 On-Call Support/rotations

Confidential, Philadelphia, PA

Elastic Cloud Architect/Oracle ExaData DBA

Responsibilities:

• Provided support of development, QA and Production Microsoft SQL Server 2012 Instances/Databases
• Manage/Configure SQL Server 2012 in Microsoft Azure Cloud
• Responsible for design of database Data Model, Logical and Physical Design
• Patching of all tiers (Exalogic & Exadata)
• Development of Stored Procedures, functions, views
• Oracle Cloud Compute/Elastic Cloud - (DR Site)
• Multi-Tennant and Single Tenant Virtual Machines for Development, Test and Production environments
• Platform (PaaS), Infrastructure (IaaS), Hadoop (Big Data), Oracle Database 12c, Storage (Configured all storage), Network (Configured) and Cloud Machine (Install and Configure), Oracle Cloud Messaging (Install, Configure and work with development to integrate with Node.js applications, Business Analytics and Business Intelligence (Setup/Develop Reporting and Analytics).
• Installed and configure Oracle 12c/Oracle Enterprise Linux on Oracle Elastic Cloud (VM) - Production
• Implemented/installed and configured Oracle Exalogic Elastic Cloud & Oracle Database Machine (ExaData)
• Oracle WebLogic, Oracle Coherence, Tuxedo, Exalogic Control and Exalogic Hypervisor on Oracle Exabus.
• Exachk for security and configuration, auditing and reporting. Provide support for full system checks, updating platform templates & configurations, applying patches, and network assignments
• Cycle complete platform (shut down complete architecture/sub-systems and bring up, for maintenance purposes)
• Support of Exadata Database Machine (X2) & Exadata Storage Server & Fabric Switches
• Support Java/Node.js applications/Micro-Services on Oracle Enterprise Linux 6
• Designed and Implemented (HA Proxy - Application Server Load Balancing), 4 node Centos 6 with Physical F5 Load balancer.
• Network Oracle Cloud Virtual Machines with Confidential Network (NAT, Network Address Translation).
• Installed, Configure Oracle DataGuard for DR of Production Oracle Exadata/Exalogic System/Databases to Oracle Compute Elastic Cloud
• Configure and Manage DNS
• Setup & Configured MicroStrategy Universal Edition - For Analytical & Reporting needs
• Developed custom dashboards and reports
• Configure SSH for Linux
• Power Shell Scripting, Batch Command line scripting, Python Scripts for automating batch jobs, Disaster Recovery - Python Scripts for automating copies of data files, restoring.
• Import 1TB of Oracle exports (Partitioned data)
• Data Center Migration of all SQL Server Instances and databases to Microsoft Azure Cloud, including all Apache and IIS Web Applications

Confidential, Philadelphia, PA

Senior Oracle DBA/Systems Architect/Migration

Responsibilities:

• Provided support of development, QA and Production of Oracle Instances
• Installed and configured Oracle 11g/12c in Dev., Stage, QA and Production
• Migrated Oracle databases from legacy hardware to Oracle Virtual Machines in Quest Data Centers.
• Data Center Consolidation and Migration
• Moved/Migrated over 400 development, QA, and Production Linux and Microsoft Windows Server’s with IIS Web Applications from Express Scripts and RX.COM Data Centers to Confidential Data Center’s (QDC1, QDC2 and QDC3)
• Physical/Bare Metal installs/platform migrations
• Physical to Virtual (P2V) Migrations, from Legacy Unix Operating Systems to RedHat Linux/Centos
• Patched and upgraded Oracle
• Setup and configured RMAN for backups
• Linux, Perl and Power Shell Scripting for Migrations, Moving large data files, backups, automated startup/shutdown scripts
• Provided detailed documentation on all processes.
• Configured Symantec VCS for fail-over clustering
• Supported Confidential Sys admins
• Daily meetings with Quest and Confidential
• Responsible for Sybase ASE (15), Sybase IQ, Sybase Replication server database administration. Primarily responsible for database design, data warehouse administration. Monitor disk space, database health checks, database backups and error log scanning. Configure Servers to achieve the best performance and writing automated database monitoring scripts.
• Installation, administration and support Cassandra 2.27
• Security, Administration, Maintenance, back and Recovery and High Availability
• Created ETL for Oracle to Cassandra
• Developed and maintained ETL processes Oracle to Cassandra

Confidential, Philadelphia, PA

Senior MySQL DBA/ETL Developer

Responsibilities:

• Provided support of development, QA and Production MySQL Instances/Databases
• Manage/Configure MySQL (5.0) in Amazon Web Services/RDS (Cloud)
• Responsible for design of database Data Model, Logical and Physical Design
• Development of Data Model and ETL Design tasks in Agile/Scrum environment
• Scope and complete daily/weekly Sprint tasks/Stories
• Responsible for development of Clover ETL Job Flows and Graphs for load of external data sources and Customer data (Medical/Pharmacy) to MySQL databases/schemas and Mongo DB (Big Data) Collections
• Create JSON Blocks/Format for load of JSON data to Mongo DB Collections
• Linux Shell/Perl Scripting for ETL processes/engines
• Setup & Configured MicroStrategy Universal Edition - For Analytical & Reporting/Data Warehousing
• Developed custom dashboards and reports
• Designed Data Models for Multi-Dimensional Analytical Reporting
• D3 - Used Tree Diagram generated from external JSON data
• JSON data from Mongo DB
• Load of external data and CSV data using D3 JavaScript
• Handling dynamic JSON data via D3
• Reading in data using D3 JavaScript (PostgreSQL DB)
• Install and configure PostgreSQL DB - Migrate Data from Mongo DB Collections via JSON blocks to PostgreSQL DB
• Monitor, Tune and backup PostgreSQL DB
• Indexing for PostgreSQL DB
• Data Modeling for PostgreSQL DB
• High Availability for PostgreSQL DB
• Responsible for Design and Architecture of ETL

Confidential, Upper Darby, PA

Senior Oracle DBA

Responsibilities:

• Provided production, Quality Assurance (UAT) and development support for Oracle 10g/11g.
• Supported Oracle 10g/11g for Lawson Financials.
• Supported Oracle 10g/11g for Power plant (System for Water and Sewer).
• Maintained and upgraded current Power plant system and worked with vendor during upgrade.
• Maintained security for Power plant.
• Cloned Oracle databases from production to development and test (Expdp/Impdp and RMAN).
• Developed disaster recovery procedures for Lawson Financials and Oracle 11g database.
• Involved in 5 day DR exercise at Confidential site in NY State.
• Recovered Lawson Financials Database on DR Confidential AIX Server.
• Staff at DR location tested and confirmed Lawson Application/Oracle database.
• Supported Banner ERP and Oracle 12c
• Upgrades and Patches
• ETL and Data Warehousing (to SQL Server 2012 R2 Data Warehouse & Batch processes)
• BI and Analytics
• Installed and configured Oracle Cloud Control 12c.
• Configured user defined Metrics and Alerts (email).
• Configured job scheduling, asset and configuration management, change management, metric thresholds, provisioning and patch management.
• Deployed Agents to over 100 Oracle and Microsoft SQL Server Instances.
• Applied management packs.
• Utilized ADDM, AWR and ASH for problem resolution and troubleshooting performance issues.
• Trained Aqua DBA’s on how to configure and maintain.
• Configured and maintained Oracle RMAN Catalog for daily backups.
• Developed AIX Shell Scripts for maintaining file system.
• Used Python and Perl with AIX Shell Scripting to develop tools for automating back and recovery, monitoring and batch jobs
• Developed Crystal Reports for Lawson Financials and Human Resources (for budgets, purchase orders and work orders).
• Installed and configured Oracle Goldengate 12c
• Maintained HA/DR processes
• Deployed Crystal Reports to Lawson Business Intelligence (LBI) Dashboard.
• Oracle Enterprise Performance Management (11.1.2.3) - OFSAA.
• Funds transfer pricing, pricing management, profitability analytics, balance sheet planning, DB administration, reporting, patching and upgrades.
• Weekly staff meetings on daily projects.

Confidential, Upper Darby, PA

SQL Server DBA/Architect/Sr. Oracle DBA

Responsibilities:

• Involved in production, staging, QA and development support for Kenexa/ Confidential application Oracle databases.
• Supported Oracle RAC 11g, Oracle RAC 9i and Oracle RAC 10g.
• Installed and configured Oracle Database Appliance (X4-2).
• Used ILOM and OAKCLI, deployed on virtualized platform, using ODA BASE Template, Configured Oracle Auto Service Request, installed Oracle Grid binaries and Oracle Database, setup and configured Oracle RAC, shared repositories, configured Linux OS and applied Oracle Patches.
• Used ODA for production web Oracle Applications.
• Maintained ODA in stage and production.
• Oracle data migrations (9i to 11g).
• Oracle archiving and Oracle partitioning.
• ADRCI/Log rotate for Oracle maintenance log files, listener and alert logs.
• Installed, configured and supported Oracle distributed document capture.
• Installed database and configured server configuration.
• Created application pools and configured capture security.
• Involved in Linux/UNIX Shell scripting and automating of monitoring systems, disk usage, resources and ASM (capacity planning and forecasting).
• Used Oracle Enterprise Manager 12c monitoring of production, stage, QA and Development Oracle Database Instances.
• Migrated Dev, Test and Production SQL Server 2012 R2 Instances from Confidential ’s Data Center to Confidential ’s new Cloud
• Data Center Consolidation and Migration
• Migrated Oracle 11g database (2 TB) to Microsoft SQL Server 2012.
• Used Microsoft SSMA (SQL Server Migration Assistant for Oracle 5.2.1259) Project (Oracle to SQL).
• Mapping of Oracle and SQL Server data types.
• Converted 50 Oracle 11g Schemas to Microsoft SQL Server 2012 Schemas.
• Used Microsoft SSIS to cleanse/massage data from Oracle 11g to SQL Server 2012.
• Loading Converted data from oracle 11g to Microsoft SQL Server 2012.
• Assessment reports.
• Backup and recovery procedures/jobs.
• Converted PL/SQL Procedures, Functions and Packages to SQL Server Stored Procedures.
• Performed in DEV, TEST and production environments.
• Involved in Oracle database upgrades and patches.
• Installed and configured and maintained Oracle Goldengate 11g
• Involved in staff meetings, team meetings, technical documentation and training.