SUMMARY:

• Over 27 years in IT consulting experience, including Oracle Database Administration/Design, System Architecture
• Operations Management, Oracle EPM products Performance tuning, High - Availability Architecture and full cycle Oracle ERP and Big Data implementations.

TECHNICAL SKILLS:

Applications: Oracle Applications Release 9.x, 10.x, 11.x, 11.5.x, 12, SOA Suite, OBIEE, BI Apps (ODI, Informatica & DAC), Hyperion, Data Guard, RAC, Golden Gate, Oracle SOA, Weblogic, Identity Management, MariaDB & MySQL

Languages: Java, Python, Perl, SQL & PL/SQL

Operating System: HP-UX 11i, Sun Solaris, AIX, Linux & Windows

Big data: Hadoop, Hive, HBase, Spark & AWS EMR

AWS Databases: Aurora, Redshift, DynamoDB, DocumentDB, Neptune, QLDB & Keyspaces

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA/Manager

Confidential

Responsibilities:

• AWS Solutions Architect Associate
• AWS Certified Database - Specialty
• AWS Certified Data Analytics - Specialty
• AWS Cloud Practitioner

Confidential, Lisle, IL

Big Data/Cloud Architect

Responsibilities:

• Managing Cloudera Hadoop and Kafka clusters
• Security implementation (Kerberos, TLS & KMS/KTS) for Hadoop clusters
• Implementation of Hadoop cluster HA
• CDP Upgrade from CDH 5.16
• Monitoring, maintenance and troubleshooting the Hadoop cluster.

Confidential, Chicago, IL

Big Data Architect/Oracle DBA

Responsibilities:

• Installed and configured fusion middleware for Open Text Content Server integration with EBS
• Worked on internal big data Confidential using Hadoop technologies
• Managed Oracle Remote DBA practice for Oracle EBS customers

Confidential, Chicago, IL

Senior Oracle Apps DBA

Responsibilities:

• Installed and configured E-Business Suite R12 for OTC project
• Upgraded Oracle EBS to 12.1.3 and databases to 11.2.0.3
• Implemented middle tier load balancing and PCP and MLS for Spanish language.

Confidential, Dayton, OH

Oracle Apps DBA

Responsibilities:

• Installed and configured E-Business Suite R12
• Implemented RAC with 2 nodes for R12 and 10g AS Databases with ASM
• Installed and configured SOA RAC database & SOA HA
• Installed and configured Oracle Grid control to monitor the applications and databases
• OBIEE,OBIA installations and configured with R12

Confidential, Waterloo, ON

Oracle Apps DBA

Responsibilities:

• Oracle EBS 11i /R12 support
• Upgraded Oracle EBS from 11.5.4 to 11.5.10.2
• Installed and configured OBIEE 10.1.3.4.1 with BI Apps 7.9.6.2 on Linux x64 server
• Installed and configured OBIEE 10.1.3.4.1 with Weblogic Server 10.1.3 on Linux.
• Installed and Configured OBIA, Informatica & DAC to extract data from Oracle EBS 11.5.10.2

Confidential, Chicago, IL

Oracle Apps DBA

Responsibilities:

• Oracle EBS 11i support
• Installed and configured Oracle SOA High Availability
• Support, Oracle tuning & Backup/Recovery

Confidential, Chicago, IL

Lead Oracle Apps DBA

Responsibilities:

• Managing remote DBA/Infrastructure monitoring services for customers
• Implemented Site to Site to VPN to customer sites
• Installed and configured OBIEE/BI Apps for a Oracle EBS customer in WI
• Upgraded Oracle EBS from 11.5.4 to 11.5.10.2

Environment: Oracle Apps 11.5.10.2/12.1.1, Solaris 10, IBM AIX

Confidential, Duluth, MN

Lead Oracle Apps DBA

Responsibilities:

• Managed and upgraded Oracle EBS from 11.5.10.2 (10.2.0.4) to R12.1.1 (10.2.0.4)
• Upgraded database from 10.2.0.4 to 11.1.0.7
• Implemented and documented best practices for Oracle EBS Upgrade

Environment: Oracle Apps 11.5.10.2/12.1.1, Solaris 10, IBM AIX

Confidential, Dayton, OH

Lead Oracle Apps DBA

Responsibilities:

• Installed EBS 12.0.4 on Solaris/Linux environment
• Upgraded Oracle EBS from 11.5.9 to 12.0.4
• Upgraded database from 9i to 10.2.0.3 during Release 12 upgrade
• Reduced the upgrade time from 160 hours to under 20 hours using upgrade best practices
• Migrated database character set from US7ASCII to AL32UTF8
• Migrated database from 10.2.0.3 on Solaris to IBM AIX
• Upgraded database to 11.1.0.7 from 10.2.0.3 on AIX
• Implemented RAC and Data Guard
• Implemented RMAN backups and resolved performance tuning issues
• Installed and implemented OBIEE/BI Applications 7.9.6 on Linux/Windows environment with Oracle EBS 11i and R12
• Installed and Configured Hyperion 9.3.1 on Linux environment

Environment: Oracle Apps 11.5.9/12.0.4, Solaris 8, IBM AIX and Linux AS 5

Confidential, Dayton, OH

Lead Oracle Apps DBA

Responsibilities:

• Installed and configured E-Business Suite 11.5.10.2
• Cloning, Database and Applications tuning, Backup and Recovery Strategies
• Upgraded 11.5.10 database (9.2.0.5) to 10g (10.2.0.2)
• Implemented RAC with 3 nodes for 11i and 10g AS Databases with ASM
• Load Balanced 11i Apps with Shared Middle-Tier technology with Web Seal
• Integrated Single Sign-On (SSO) with TAM Server
• Installed and Implemented BPEL server with 11i
• Implemented HA for OID, BPEL, 10g AS and OCS
• Configured Discoverer 10G with Oracle Applications
• Implemented 10G RAC with shared ORACLE HOME and applications on Linux Servers
• Installed and configured Release 12 applications on the Linux server and upgraded to 12.0.6
• Installed and configured 10G Grid Control to monitor the instances
• Implemented RMAN backups using 10G Grid Control
• Upgraded 11.5.10.2 to 12.0.4 on Linux server
• Installed and Configured OBIEE, BI Apps (Informatica and DAC) with 11i
• Installed and Configured Hyperion 9.3 on Linux & windows
• Installed Demantra & integrated with EBS
• Upgrade 11.5.10.2 database from 10.2.0.4 to 11.1.0.7
• Configured MLS (European Languages) for 3 customers in 11i environment

Environment: Oracle Apps 11.5.10.2, SSO, OCS, ASM, BPEL, Solaris 10, AIX, Mercury ITG

Confidential

Lead Oracle Apps DBA

Responsibilities:

• Installed Oracle Pre-requisite Linux Packages (RPM)
• Installed and configured E-Business suite 11.5.10
• Cloning, Database and Applications tuning, Backup and Recovery Strategies
• Upgraded 11.5.10 database (9.2.0.5) to 10g (10.2.0.2)
• Upgrade Oracle E-Business Suite from 11.5.9 to 11.5.10.2
• Implemented RAC and SSL for 11i
• Configured Discoverer 4i with Oracle Applications
• Implemented 10G RAC with shared ORACLE HOME and applications on Linux Servers

Environment: Oracle Apps 11.5.10 (Financials & HR), HP Proliant DL 585, Dell PowerEdge Servers, Sun Solaris, HP PA-RISC servers, Redhat Linux & 10G RAC

Confidential, Houston, TX

Lead Oracle Apps DBA

Responsibilities:

• Production Go-Live Support
• Cloning / Refreshing test instances
• Tuning database
• Backup and Recovery Strategy

Environment: Oracle Apps 11.5.9 (Financials, HR, Payroll & Advanced Benefits), SunFire 6800, SunFire 6900, Solaris 8

Confidential, Northbrook, IL

Senior Oracle Apps DBA

Responsibilities:

• Multi-Node Oracle E-Suite 11.5.9 installation
• Cloning/Refreshing Oracle Applications, Production Support, Backup and Recovery, Technical Support

Environment: Oracle Apps 11.5.9 (Financials, CRM and HR), SunFire, Solaris 8

Confidential, Houston, TX

Lead Oracle Apps DBA

Responsibilities:

• Capacity Planning and Installing Oracle E-Suite 11.5.9
• Post Install HRMS configuration
• Configured Quantum tax software with Oracle Payroll module
• Upgraded database from 9.2.03 to 9.2.05
• Applied latest Financials and HRMS family pack patches
• Cloned the instances, Backup and Recovery and Technical Support
• Tuned the HR and OAB tables for payroll processing

Environment: Oracle Apps 11.5.9 (Financials, HR, Payroll and Advanced Benefits), SunFire 6800, SunFire 6900, Solaris 8

Confidential, Chicago, IL

Lead Oracle Apps DBA

Responsibilities:

• Installing Oracle E-Suite 11.5.9 in multi-node configuration on Unix and Windows Servers
• Installed HRMS and Payroll modules and patches
• Configured Quantum tax software with Oracle Payroll module
• Technical Support
• Worked Oracle Applications Performance issues at ER MOORE and Moody Bible Institute
• Configured Discoverer 4i with Oracle Apps 11.5.9 and created EUL

Environment: Oracle Apps 11.5.9, Solaris 8, HP-UX 11i, Linux, Oracle Discoverer 4i, Windows XP

Confidential, Pittsburgh, PA

Senior Oracle Apps DBA

Responsibilities:

• Installing Oracle E-Suite Rel 11.5.x in a multi-node configuration using Rapidwiz.
• Implemented ASCP with EBS
• Cloning instances
• Upgraded database from 8.1.7.4 to 9.2.0.3 and to 9.2.0.5
• Technical Support to i-Procurement, Trade Management and other CRM modules
• Patch Application on multi nodes for different modules using AD Utilities, troubleshooting application related issues
• Installation and upgrade all Oracle db environments, following OFA Configure, test and implement backup/recovery solutions using RMAN and O/S backups
• 24x7 Support of Application
• Trouble shooting database problems such as space management issues, performance issues
• Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance
• Printer Installation and registering them with Oracle Applications, creating custom print drivers,
• Create custom responsibilities, menus and concurrent programs.
• Enrolling users, maintaining system security, controlling, monitoring user access to the database.
• Registered new reports, Report Sets, Custom Forms and PL/SQL stored procedure using AOL
• Documenting the database activities and other configuration details.
• Installed and Configured Vertex tax software with Oracle Applications
• Supported Vertex monthly updates and maintenance
• Configured Discoverer 4i with Oracle Applications (Business Views, EUL, Work Books)
• Worked on Oracle HR, Payroll, Benefits and Advanced benefits modules
• Worked with Stress test team to improve payroll performance. Worked on optimizing Pay action parameters

Environment: HP-UX 11.11, Oracle 9.2, Oracle 8.1.7, E-Suite 11.5.9, Kintana, Jet Forms, Vertex, Discoverer 4i, ASCP

Confidential, Reading, MA

Lead Oracle Apps DBA

Responsibilities:

• Install Oracle Applications 11.5.3 on multi-node environment
• Upgraded Oracle Applications from 10.7 Char to 11.5.3 and database migration from 7.3 to 8i
• Refreshing Test database from Prod on demand
• Improved the efficiency of the database by application tuning
• Preparing Oracle documentation and power point presentations

Environment: HP-UX 11.0, Oracle Applications 11.5.3, Oracle 8.1.7

Confidential, Dayton, OH

Lead Oracle Apps DBA

Responsibilities:

• Fresh Installation of Oracle Applications 11.5.2
• Upgraded from 10.7 Char ( Confidential Unix) to 11.5.2 (Solaris)
• Migrated database from 7.3 to 8.1.6
• AOL administration
• Maintenance includes applying patches, configuring printer setup, adding users, creating user defined functions, menus, responsibilities to satisfy the basic business needs
• Configuring the client machines to give them the access to the applications.

Environment: Solaris 2.6, Oracle Applications 11.5.2, Oracle 8.1.6

Confidential, Long Beach, CA

Oracle Apps DBA

Responsibilities:

• Multi-node installation of Oracle Applications 11.0.3
• Self Service Purchasing 5.0 (SSP) installation and Configuration
• Cloning & Refreshing the QA & Test instances
• Backup & Recovery Strategy
• Installed printers and registered them with Oracle Applications, modifying print drivers

Environment: Sun Solaris 2.6, Oracle Applications 11.0.3, Oracle Database 8.0.6, SSP 5.0

Toytrade.com

DBA Manager

Responsibilities:

• Multi-node installation of Oracle Applications 11.0.3
• Unix Administration, Database Administration, Tuning applications and backup/recovery
• Cloning & Refreshing QA and test instances

Environment: Sun Solaris 2.6, HP-UX 11.0, Oracle Applications 11.0.3, Oracle 8.0.5, VignetteOracle Applications Server 3.x and 4.x, Oracle i-Store

Confidential, Chicago, IL

Senior Oracle Apps DBA

Responsibilities:

• Multi-node installation of Oracle Applications 11.0.3
• Unix Administration, Database Administration, Tuning applications and backup/recovery
• Cloning & Refreshing QA and test instances
• Applications maintenance and Production Support

Environment: Sun Solaris 2.6, HP-UX 11.0, Oracle Applications 11.0.3, Oracle 8.0.5

Confidential

Responsibilities:

• Multi-node installation of Oracle Applications 11.0.3
• Unix Administration, Database Administration, Tuning applications and backup/recovery
• Cloning & Refreshing QA and test instances
• Applications maintenance and Production Support
• Installed and Configured Vertex tax software with Oracle Applications

Environment: Sun Solaris 2.6, HP-UX 11.0, Oracle Applications 11.0.3, Oracle 8.0.5

Confidential

Responsibilities:

• Multi-node installation of Oracle Applications 11.0.3
• Database Administration, Tuning applications and backup/recovery
• Cloning and Refreshing QA and test instances
• Applications maintenance and Production Support
• Integrated PayLinx Credit Card payments with Order Entry module
• Installed and Configured Vertex tax software with Oracle Applications

Environment: HP-UX 11.0, Windows NT, Oracle Applications 11.0.3, Oracle 8.0.5

Confidential

Responsibilities:

• Installed Oracle Applications 10.7 SC
• Unix Administration, Database Administration, Tuning applications and backup/recovery
• Cloning & Refreshing QA and test instances
• Applications maintenance and Production Support

Environment: Sun Solaris 2.6, HP-UX 11.0, Oracle Applications 11.0.3, Oracle 8.0.5

Confidential

Responsibilities:

• Oracle Applications 9.0.4 and Metrix (CRM) Support
• Unix and Oracle Administration
• Worked on Migration project (apps 9.0.4 to 10.7 NCA)
• Installed Oracle Applications 10.7 NCA (Multi-node)
• Tuning Oracle database & Applications, backup/recovery
• Installed Vantive (CRM) and integrated with Oracle Applications
• Installed and Configured Vertex tax software with Oracle Applications

Environment: HP-UX 11.0, Oracle Applications 9.0.4/10.7, Oracle 8.0.4, Vantive

Confidential

Responsibilities:

• Installed Oracle database 7.3 databases
• Cloning and refreshing QA, CRP and TEST instances
• Performance tuning, backup/recovery

Environment: Sun Solaris, Oracle 7.3