SUMMARY:

• Over 24 years of focused IT experience and 22 years of Oracle/Sybase Industry experience.
• Experienced data architect/ database modeler and optimized logical and physical database design.
• Senior DBA/Apps DBA.
• E - Biz suite migration from 11.5.20.2 to Release 12.
• Able to manage multiple and changing priorities effectively.
• Database Dev-Ops, Oracle and SQL Server, CI/CD, Docker and Terraform integration.
• Oracle Certified Professional, OCP. Oracle Security Administration definition and implementation
• Design, Implementation, and maintenance of new and existing Application Data Models.
• Oracle RAC implementation and installation on RedHat Linux AS, HP-UX, AIX, Solaris, True64. Oracle DataGuard implementation of multi-node to single-node, multi-node to multi-node on many platforms.
• Experience performing rolling upgrades on RAC/DataGuard environments. Experience migrating Oracle/Sybase databases between different platforms. Experience migrating physical servers to virtualized servers running on VMWare.
• Experience installing Oracle/Sybase/Postgress/SQL Server Databases on virtualized environments and implementation of high availability for virtualization.
• Experience implementing Homogeneous/Heterogenous Replication using Oracle/Sybase replication on XNIX platforms
• Experience implementing GoldenGate replication for Oracle and another mixed environment.
• Over eighteen years of focused IT experience in the areas of UNIX/Windows Administration, Network Administration, and Database Administration.
• Provided design, setup, update, installation procedures and support of in-house and customers Relational Databases (Oracle, MS SQL and MySQL).
• Experience with Non-SQL databases such as MongoDB.
• Professional level knowledge of Java, Maven, spring, Eclipse, Tomcat, Apache, Subversion, and full SDLC development cycle.
• Experience in the development, optimization, and tuning of Oracle Stored Procedures, packages, and functions using PL/SQL.
• Installation, support, configuration, upgrades, and maintenance of Oracle Databases ranging in size from 100 GB to over 4.58 PB.
• Experience upgrading Oracle database.
• Installation, support, configuration, and maintenance of High Availability Database System using Stand-by Databases, Replication, and Parallel Databases (Real Application Cluster)
• GoldenGate replication and database migrations and upgrade.
• Installation, configuration, and implementation of OEM 12c
• Installation, configuration, and implementation of MongoDB Databases and Clusters with up to five nodes.
• MongoDB Schema Design and Data Modeling.

SKILLS HIGHLIGHT:

Oracle Products: Oracle7, 8, 8i, 9i, 10g, 11g, 12c Enterprise Server; Personal Oracle 7, 8, 8i, 9i, 10g, 11g, 11gR2, Oracle RAC/OPS, Golden Gate classic and MA, Oracle Database Appliance, Oracle Data Guard/Standby, Oracle Streams, Oracle E-Biz Suite Technical Release 11, and, Release 12, PL/SQL, Oracle Enterprise Manager, Oracle Intelligent Agent, Oracle Server Manager, Data Pump, Recovery Manager (RMAN), Oracle Application Express, JDeveloper 3.0, Developer 6.0.

Operating Systems: Sun Solaris 6 - 10, Sun Cluster 3.x, RedHat Linux, Oracle Linux, IBM OS/400, IBM AIX 5, HP-UX, SCO Unix, Microsoft Windows Servers, Novell Netware.

Management/Leadership Skills: Technical Team Leader, Technical Mentor, Agile Project Management

Life Cycle Expertise: Requirements Analysis, Functional Analysis, Conceptual Database Design, Logical Database, Design, Physical Database Design, Test Plans, Testing, Implementation

Specialty Skills: Data Modeling, Logical and Physical database implementation, Database Security, Database Performance Tuning, High Availability Databases including RAC and DataGuard, Oracle E-Biz Suite Installation, Migration, Performance Tuning, Patch Installation, Oracle Parallel Server, OLAP systems, DSS systems, VLDB, Replication, Stand-By databases.

Other Products: Sybase ASE, Sybase Replication, GoldenGate, Postgres, MongoDB, MySQL, MS SQL Server, VMWarevCenter, VMWare ESX Server, Cognos Decision Stream, CA Erwin, Power Designer, DB Artisan, MS SQL Server, T-SQL, Quest Software Share-Plex, Quest Software SQL Expert, Quest Software Live-Reorg, Quest Software, Instance Monitor, Quest Software SQL Lab/Expert, Golden Gate, BMC SQL Backtrack, IBM Tivoli, Watcom SQL Database, HTML, Informix, SystemBuilder+, Sybase S-Designer, Microsoft Access, Visio, ODBC, JDBC, OCI, XML, Shell scripting, IBM ADSM Storage System, Platinum SQL Station, Platinum Desktop DBA, Perl Scripts, UNIX Shell Scripts, Java 2, Solaris LVM, EMC DASD, Veritas Volume Manager.

Methodologies: P+ Methodology, AIM, CDM, Agile, Erwin.

PROJECT EXPERIENCE:

Confidential

Data Architect/Data Scientist

Responsibilities:

• Developed database solutions to store and retrieve company information and data analysis for product development and forecasting using Oracle, MS SQL Server, MongoDB, Hadoop.
• Utilized analytical, statistical and programming skills to collect, analyze, and interpret large data sets stored in Oracle and MS SQL Server.
• Worked with stakeholders throughout the organization to identify opportunities for leveraging company data to drive business solutions.
• Assessed the effectiveness and accuracy of new and existing data sources and data gathering techniques.
• Developed custom data models and algorithms to apply to data sets.
• Determined structural requirements by analyzing client operations, applications and programming; reviewing objectives with clients; evaluating current systems, and implementing use of new and emerging technologies.
• Implemented and Managed automated database CI/CD Development into Development Life Cycle.
• Maintained database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases;
• Evaluated compliance requirements for data security such as PCI, PPI, HIPPA, and GDPR; implemented data obfuscation technologies on existing data sources so that data could be made available to all stakeholders without violating compliance.
• Used predictive modeling to increase and optimize customer experiences, revenue generation, and targeting and other business outcomes.
• Installed, configured MongoDB clusters in multiplatform cloud environment, AWS, Azure, GCP, across different regions.
• Worked with Ops team to setup VPN’s for regions and configure secured VPC’s to allow MongoDB cluster communication to each shard.
• Support and troubleshooting of MongoDB Clusters and shards.

Confidential

Solution Architect - Consultant

Responsibilities:

• Provided expertise during planning, installation and deployment of the efficient architecture to properly mitigate usage, performance and cost of the new AWS environment.
• Provided knowledge and expertise of the AWS stack, migration tools, security model, etc.
• Provided expertise in the migration of Oracle Advanced Replication to GoldenGate Microservices Architecture.
• Provided knowledge and expertise in architecting, deploying and managing cost-effective and secure AWS environments across multi-zone and regions, leveraging AWS services such as EC2, VPC and RDS.
• Provided expertise in planning, deployment, and configuration of Oracle GoldenGate 12.3 Microservice Architecture to migrate existing Oracle Advanced Replication environments to Oracle GoldenGate in the cloud.
• Configured multi-master replication using GoldenGate 12.3 MA in a peer-to-peer model allowing multiple servers across multiple regions and time zones to replicate data back for forth among other servers.
• Installed and configure Oracle Veridata and agent software. Created multiple jobs to validate data consistency and conflict resolution across multiple servers in same VPC and across VPC’s with minimal down time.
• Oracle cloud user security. Commission and decommission of user id, configuration of password requirements, User access based on roles; configuration of user roles depending on geo-locations. Implementation of Oracle ID.
• Worked with developers to tune and optimize existing application and PL/SQL code running in Oracle 9i and 10g to run in Oracle 11gR2 and take advantages of new features.
• Worked with developers to update and tune existing application to run in AWS cloud.
• Worked with developer to create, test, and implement PL/SQL packages, procedures, and functions, as well as tune and optimize existing stored procedures so that they could run efficiently under the new architecture.

Confidential

Senior Database Consultant - Consultant

Responsibilities:

• Provided installation, back and recovery, database migration and troubleshooting of Oracle and Sybase databases.
• Created multiple Unix/Linux scripts to automate Database installation at client site.
• Created monitoring application to check the Replication environment running Oracle and Sybase Replication or GoldenGate and send alert when necessary.
• Provided complete database support, shell scripting, performance and tuning for customers and developers.
• Worked with Developers to create a SDLC and change management environment reflective of typical client environments for application testing and deployment.
• Setup development environment using Java, Maven, Sprint, Subversion, and Eclipse to develop a utility to monitor database performance and send alerts to administrators.
• Created documents to standardize client environment.
• Created documents to formalize recommendation for CUnify application installation.
• Documented implementation of high availability systems using GoldenGate and Sybase Replication server.
• Automated re-materialization of Sybase ASE Replicated Environment using a custom Java application.
• Worked with clients to tune up and resolve database performance issues.
• Performed cross platform migration for Oracle/Sybase databases.

Confidential

Senior Oracle DBA - Consultant

Responsibilities:

• Lead team in migration of existing custom and COTS applications from MS SQL Server to Oracle database using Oracle Golden Gate.
• Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.
• Responsible for patch packaging, testing and deployment using various Oracle provided tools.
• Setup system and user profiles for Oracle E-Business Suite, administered concurrent manager and reports.
• Performed and provided patching support including Financials, HR, Purchasing and Public Sector.
• Developed scripts and utilities for maintenance of multiple Oracle Applications environments, environment configuration, initialize environment, automated databases, Webservers, Form servers, and concurrent managers startup/shutdown process.
• Provided support to developers and establish development cycle from development to production environments.
• Provided consultation to developers and created Oracle Workflow’s for custom applications.
• Performed E-Biz Suite installation and configuration, migration, patching, and cloning across platforms.
• Design, Develop and implement upgrades and enhancements using OA Framework.
• Troubleshooting skills across modules of Oracle EBS.
• Design, Development, modification and implementation of Oracle Workflow.
• Met with customer representatives to determine customer needs and system availability during cut-over.
• Analyzed and modified existing automatic deployment tools using MS Visual Studio to start using Oracle database and be able to deploy to an Oracle database using the same tools.
• Used Oracle Migration Tools to seed the migration of various MS databases and consolidated them into Oracle schemas on the same databases.
• Setup Oracle Security to satisfy existing and added security requirements for users, administrator, and shared objects.
• Designed and implemented data migration process to completely eliminate any down time during the migration process using Oracle Golden Gate.
• Designed and recommended replication strategy for post migration using Oracle Golden Gate.
• Lead team during the migration of MS SQL Server Replication to Golden Gate Replication running on MS SQL Server.
• Solid hands on experience on NoSQL Database (MongoDB). Replica Set and Sharing. Security measures, backup and restore.

Confidential, Salem, OR

Senior Oracle Apps DBA - Consultant

Responsibilities:

• Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.
• Setup system and user profiles for Oracle E-Business Suite, administered concurrent manager and reports.
• Performed and provided patching support including Financials, HR, Purchasing and Public Sector.
• Developed scripts and utilities for maintenance of multiple Oracle Applications environments, environment configuration, initialize environment, automated databases, Webservers, Form servers, and concurrent managers startup/shutdown process.
• Provided support to developers and establish development cycle from development to production environments.
• Provided consultation to developers and created Oracle Workflow’s for custom applications.
• Performed E-Biz Suite installation and configuration, migration, patching, and cloning across platforms.
• Design, Develop and implement upgrades and enhancements using OA Framework.
• Troubleshooting skills across modules of Oracle EBS.
• Design, Development, modification and implementation of Oracle Workflow.
• Responsibility for resolving all issues assigned in a timely manner.
• Ensure that modules conformed to system and programming standards and were documented.
• Administered, supported, maintained, optimized, and monitored complex database applications in a variety of environment.
• Performed technical troubleshooting and Instance recovery for all E-Biz environments.
• Worked as part of a team and provided 7x24 support when required.
• Sound knowledge of Oracle backup and recovery scenarios.
• Provided consultation to team and management in code migration, database change management and data management through the various stages of the development life cycle.
• Provided troubleshooting experience for the middle tier, database, tier, operating system, SAN, and network.

Confidential, Houston, TX

Lead Oracle DBA/Architect - Consultant

Responsibilities:

• Responsible for the installation, configuration, maintenance, and monitoring of the Company’s database system using Oracle 11gR2 RAC database software.
• Ensured system availability, usability and survivability.
• Developed a Rapid Deployment Methodology that allowed for the installation of RAC in two days.
• Developed policies and procedures in regards to security, backup schedules, restoration, and general deployment.
• Developed conceptual, logical, and physical data models (3NF).
• Designed and implemented version control solutions using MVN and SVN.
• Translated business requirements into an analytical solution.
• Determined the Oracle RAC architecture.
• Provided support of high availability database infrastructure including Oracle RAC and Data Guard Technology.
• Supported team members and ensured that established deadlines and client needs were met.
• Provided guidance on best practices and hardware configuration.
• Configured ASM using RAW devices for CRS and database files storage.
• Installed and tested Single Client Access Naming (SCAN) using DNS and GNS for connection failover.
• Installed, configured, and deployed Oracle Enterprises Manager repository and OMS Server for Monitoring and sending alerts.
• Installed, configured, and deployed Oracle Enterprises Manager 12c repository and components for Monitoring and sending alerts.
• Provided guidance on implementing Oracle Advanced Replication and Oracle Streams for replication.
• Served as a guide to the team in the deployment of the application.

Confidential, Roy, UT

Lead Oracle DBA/Architect - Consultant

Responsibilities:

• Defined and implemented the selected Development Environment, including the specific development tool sets for development, packaging, and automated deployment of Java classes and Oracle Database scripts under a controlled Release Management environment.
• Provided overall guidance and structure for creating and maintaining the whole application development software effort. Served as the single point of responsibility for the application solutions.
• Served as a Project Manager using an Agile approach to development and the Agile methodology.
• Defined the application architecture.
• Developed Conceptual, Logical and Physical Data Models (3NF)
• Developed Data Dictionary and established meta-data models, Heavy use of Data Modeling patterns.
• Developed and implemented Data Management plan.
• Resolved high-level functional issues.
• Coached the Engineering team in the development of the application solution.
• Served as a guide to the team in the development of the application.
• Provided continuity in all major application solution decisions.
• Determined how technology was applied to provide an efficient solution.
• Recommended and implemented frameworks
• Determined data requirements, structure, and distribution.
• Conceptualized and developed frameworks for implementation of systems on projects and other work assigned.
• Applied data architecture concepts and techniques to facilitate major technical decisions..
• Designed and implemented effective version control solutions using MVN and SVN.
• Managed the implementation of the architecture throughout the software development lifecycle and provided technical mentoring.
• Installed and configured full Java development environment using Subversion, Maven, Eclipse, Spring, tomcat, Apache, and Oracle.
• Created and performed unit testing of several Java classes used in DoD application using SDLC environment.
• Configured Oracle Streams for high availability replication between 11gR2 2-node RAC databases geographically distributed.
• Installed and configured Golden Gate replication between Oracle databases.
• Researched the benefits of replacing Oracle Streams with Oracle Gold Gate software.
• Provided support of high availability database infrastructure including Oracle RAC and Data Guard and Streams Technology.
• Installed, configured, and managed EMC SAN network storage system using Fiber Channel Brocade switches.
• Developed Web applications using Java, Java Scripts, JSP, and JSF technology.
• Installed and administered Web application servers using various technologies such as Apache, Web Logic, JBoss, and Tomcat.
• NoSQL database (MongoDB), Installation and configuration of MongoDB, Addition/Deletion of nodes, Replica Set configuration. Backup/Restore using Mongodump/Mongorestore utility.
• Created custom scripts using various technologies such as Perl, SQL, Java script, etc., to assist with maintenance and administration of Oracle, Sybase, and SQL Server databases and various other systems.
• Collected measurement and metrics for replicated environment.
• Made changes to RAC databases and Streams configuration to take advantage of high availability features available.

Confidential, Salt Lake City, UT

Senior Database Engineer

Responsibilities:

• Provided support services monitoring and troubleshooting Production, Development, and Testing environments of Oracle 10G RAC on three node clusters.
• Provided support of high availability database infrastructure including Oracle RAC and Data Guard and Streams Technology.
• Maintained development and production OLAP environments of a very large data warehouse, 4.5PB.
• Analyzed data usage, source documents and existing applications to design and implement data models.
• Designed, modeled, documented, and guided the logical and conceptual relationship of data and database changes for complex applications.
• Analyzed needs and requirements of existing and proposed systems.
• Developed technical, structural, and organizational specifications.
• Tune and re-factor databases to drive optimum performance and scalability.
• Expert DB Tuning of databases up to 4.5 PB. Implementation and right tuning of Oracle Partitioning.
• Created a number of script, Bash and SQL, to implement automatic deployment of database changes using version control tools.
• Worked with Java and .NET developers creating and optimizing PL/SQL stored procedures that would returned REF CURSOR result sets to be manipulated by the Java classes.
• Developed and implemented automated database cloning process using RMAN.
• Database and SQL performance Tuning.
• Extensive use of Eclipse and Hibernates for code development under a collaborative environment.
• Application Bug resolution.
• Oracle Application Server 10g installation and support.
• Configured Oracle Streams for high availability replication between 11gR2 2-node RAC databases geographically distributed.
• Installed, configured, and managed EMC SAN network storage system using Fiber Channel Brocade switches.
• Developed Web applications using Java, Java Scripts, JSP, and JSF technology.
• Installed and administered Web application servers using various technologies such as Apache, Web Logic, JBoss, and Tomcat.
• Created custom scripts using various technologies such as Perl, SQL, Java script, etc., to assist with maintenance and administration of Oracle, Sybase, and SQL Server databases and various other systems.
• Assisted Oracle Forms and Reports developers with bug resolution and other issues related to development and testing of Oracle Reports and Oracle Forms.
• Development life cycle
• Code version control and change control management of new PL/SQL stored procedures as well as database changes and schema changes and deployment.

Confidential, Jacksonville, FL

Database Manager

Responsibilities:

• Installed and Configured Oracle RAC on a variety of platform including RedHat Linux Advanced Server, Solaris, HP-UX, AIX, True64, Windows Server.
• Installed and Configured Oracle Data Guard on a variety of configuration from Single primary database to 8 node primary RAC database with a single standby database to a four node RAC standby database.
• Installed and setup Oracle RAC. Setup Oracle RAC and DataGuard in a Maximum Availability Architecture configuration where the primary and standby databases are in a Real Application Clusters environment. Setup cross instance archival operation.
• Configured Oracle Data Guard with a RAC primary database with up to four multi-node RAC and single instance standby database.
• Configured RAC and Data Guard using flash back query and Automatic Storage Management (ASM). Providing distinct modes of data protection such as Maximum Protection, Maximum Performance.
• Extensive work on Oracle Apps Advanced topology including Multiple Middle Tier, DMZ setups, Configuring Internet facing secured Self Service Tiers, Parallel Concurrent Processing, Shared APPL TOP.
• Migrations an upgrades using staged APPL TOP, E-Business Suite with RAC for High Availability and Disaster Recovery for business continuity in E-Business Suite.
• Designed and developed workflow required for Information delivery across multiple business applications.
• Oracle Migration of workflow to BPEL.
• Configured Oracle Streams for high availability replication between 11gR2 2-node RAC databases geographically distributed.
• Installed, configured, and managed EMC SAN network storage system using Fiber Channel Brocade switches.
• Developed Web applications using Java, Java Scripts, JSP, and JSF technology.
• Installed and administered Web application servers using various technologies such as Apache, Web Logic, JBoss, and Tomcat.
• Created custom scripts using various technologies such as Perl, SQL, Java script, etc., to assist with maintenance and administration of Oracle, Sybase, and SQL Server databases and various other systems.
• Created backup and business continuity strategies that included complete application fail-over with alternate recovery site.
• Installed and configured Oracle Application Server in a single instance, farm and cluster configuration with load balancing.
• Configured and deployed oracle DGMGRL and enabled monitoring of standby databases using OEM.
• Developed a tool set of scripts used to monitor and send alerts to On-Call DBA’s indicating potential areas of problems in all client environments.
• Standardized Software installation, procedures and configuration control management across multiple installations and clients.
• Analyzed existing database performance, database and application security model, configuration, and backup and recovery strategies to identify areas of potential improvement, made optimization recommendations and then executed those recommendations as needed.
• Performed monitoring of SAP R/3 Database and OS
• Used SAPDBA tool for tablespace management, reorganization, BRBACKUP, BRARCHIVE, BRRESTORE, Import and Export of database objects.
• Created Log on Groups for Logon balancing.
• Created and maintained SAP user master records.
• Monitored SAP active users and work processes.
• Performed and monitored Oracle upgrades to SAP R/3, BW, and APO.
• Acted as mentor to junior DBA’s

Confidential, Scranton, PA

Database Architect - Consultant

Responsibilities:

• Used different methodologies to generate appropriate system documentation.
• Worked with client defining and gathering system requirements.
• Identified major requirements for new system including data sources, data type, Security and privacy, control requirements, information storage and retrieval, reports, documents, and interfaces.
• Provided expertise in the design, logical and physical modeling of OLTP databases.
• Provided expertise in tuning and optimizing Oracle databases.
• Defined and implemented upgrade process for Oracle database from 9i to 10g.
• Proposed system equipment and software.
• Implemented various high availability installations of oracle databases using one node clustered database and Real Applications Cluster.
• Analyzed existing database performance, database and application security model, configuration, and backup and recovery strategies to identify areas of potential improvement, made optimization recommendations and then executed those recommendations as needed.
• Identified and proposed optimal methods for data loading by analyzing and testing all available methods to the enterprise.
• Worked with Oracle Statspack to Identified and proposed methods to improve database server performance.
• Developed and documented guidelines to establish and enterprise wide coding and development standards.
• Created and maintained application database model using Erwin.
• Worked with client in identifying business and process requirements.
• Developed and implemented automated programmatic solutions to existing and new problems.
• Worked with developers to improve existing program code using PL/SQL and UNIX Shell scripting.
• Worked with Client in the development and quick resolution of business reports using Oracle Forms and Reports.