Peter Lee Email & Phone Number

Frankfurt Am Main, Hessen, De

Environment:• ORACLE 12c /19c RAC, 13C Cloud Control, DataGuard, RMAN, Exadata, GoldenGate, ZFS• Oracle ExaCC Gen 2, Service Now/DB unity and Linux.Responsibilities Managed:• Support Production/Non-Production RAC, ASM and data guard databases on ExaData and ExaCC environments.• Expert in performance tuning application and system level using OEM grid control and performance views.• Performed database tuning using AWR, ADDM, TFA and SAR, iostat, vmstat and top operation system utilities.• Provided operation support as ON-CALL DBA on rotation. Supported Global Oracle database.• Complete support and handling of various internal Trouble-ticket/ DB unity work requests. • Part of Global DBA team which was involved in the maintenance of the RAC, ExaData, ExaCC databases for production and development environments• Identified SQL queries that are consuming high resources with SQL script, OEM console and AWR.• Implemented ExaCC 19c RDBMS binary installation and patching.• Build new ExaCC database though OCI console and Dbaascli.• Implemented ExaCC GI binary patching.

Us

Environment:• ORACLE 12C,18C, 19C, DataGuard, Oracle Cloud control 13c• Oracle Cloud Exadata, SQL, PL/SQL, ASM, Linux, ZFS, ZDLRA, Remedy, AnsibleResponsibilities Managed:• Implemented Oracle database automation upgrade.• Upgraded database from 12C, 18C to 19C.• Re-configured Transparent Data Encryption as 19C new setting.• Performance analysis and tuning SQL after migration.

Charlotte, Nc, Us

Environment:• ORACLE 12C and 19C, DataGuard, Oracle Cloud control 13c• Exadata, SQL, PL/SQL, ASM, Linux, ZFS, JIRA, Agile.Responsibilities Managed:• Migrated over 200 terabytes databases from Exadata X3-8 to Exadata X8-8.• Perform Oracle application performance analysis and optimization, define bottlenecks and manage testing and production implementation• Analyzing and troubleshooting the memory issue when the database convert Non-CDB to PDB • Responsible for working with the development/support teams to optimize SQL statements• Evaluate and configure the Automatic Indexing, Automatic Flashback Of Standby Database, Hybrid Partitioned Tables and SQL Quarantine of the 19c new Features,• Implemented the partial database migration from over 200 terabytes databases to 50 terabytes server.• Performed capacity planning for non-prod and PROD Oracle Exadata systems.• Database sizing and projections for the future growth.• Periodic database performance review and tuning recommendation• Used Scrum Agile Methodology in my work (Daily Scrum Meeting, Sprint Backlog meeting)• Proactively identifies and tracks projects and develops mitigation plans.• Work with senior stakeholders to ensure that migration projects are delivering the desired business benefits

Toronto, On, Ca

Environment:• ORACLE 11G,12C and 19C, DataGuard, Oracle Cloud control 13cR1 and 13cR4• GoldenGate, Exadata, SQLPLUS, ASM/ACFS, Linux, ZFS.Responsibilities Managed:• Migrated multiple terabytes databases from Non-Exadata or Exadata X4-2 to Exadata X8-2 using DataGard.• Apply Oracle BP patches and provide the rollback plan.• Upgraded database from 11gR2, 12cR2 to 19C.• Created shell script for automation build up over 30 Data Guard databases.• Implemented the Data Guard NOLOGGING and Active Data Guard-DML Redirection features.• Cloned the Database for the migration and upgrade projects need.• Cloned the RDBMS binary with PSU patch for the application test and rollback plan.• Implemented 19c new features, ex. DBCA cloning database or cloning PDB, DBMS_XPLAN plan comparison.• Configured the OEM 13c for X8-2 databases.• Upgraded Oracle Cloud Control 13cR1 to 13cR4• Upgraded Oracle Management Repository (OMR) database from 12.1 to 19C• Maintained databases and alerts from 13c cloud control (OEM)• Installed and configure Oracle GoldenGate 19.1 with 19C database.• Configured the Oracle GoldenGate between the Multitenant database (CDB) to CDB replication.• Implemented the Oracle GoldenGate Active-Active replication between CDBs.• Analyzing and troubleshooting highly complex integrated database systems for performance issues using Oracle wait event interface (AWR, ADDM, ASH, oratop and TFA reports). • Provide guidance on resolving performance problems by implementing of optimal query plans, usage of oracle compression, parallel processing and database flash cache.• Performed administrative maintenance, monitoring on Oracle database systems.• Providing technical expertise for designing, installation upgrading and patching of Exadata, RAC and RAC One node Oracle databases.• Configured the In-Memory function in the Multitenant database environment• Developed RMAN scripts for database backup and recovery• Performed Transparent Data Encryption security.

New York, Ny, Us

Environment:• ORACLE 11G,12C18C and 19C, DataGuard, AWS• GoldenGate, Exadata, SQLPLUS,ASM/ACFS/ASMFD, Solaris, Linux, Ansible playbook / Ansible Tower.Responsibilities Managed:• Evaluate, configure and test the 12cR2, 18C and 19C new features of Oracle RDBMS.• Created and Maintained Oracle 18c gold image for infrastructure• Create 12c, 18c and 19c databases under BYOL at AWS private Cloud for functions tested.• Configured Hybrid data guard for on Prem Primary and Cloud standby database.• Migrated database on premise to AWS Cloud by 19c DBCA duplicate. • Designed and implemented various high-end Oracle Exadata solutions for OLTP/DSS Systems.• Create standards and technical strategies for Oracle Database environments.• Maintaining software in an operational baseline.• Provide subject matter expertise across a variety of Oracle and related technologies.• Assist with recommendations for and the analysis and evaluation of systems improvements, optimization, and development or maintenance effort.• Evaluate, configure and upgrade GoldenGate 12.3 software.• Provide engineering support for the development and maintenance of engineering and related technical documentation.• Optimize and automate build/test/release cycle.• Provide production support as troubleshooting and solution need.• Installed and configure Oracle cloud control 13C release 3 with 18C repository database.• Evaluate, configure and test Oracle PSU patches for Oracle 12cR2, 18C and 19C• Implemented and converted the ASM to the ASM filter driver (ASMFD) at 12c and 18c.• Implemented Oracle automation installation using Ansible playbook from Ansible Tower.

New York, Ny, Us

Environment:• ORACLE 11g/12c, ORACLE 11g/12c RAC, ORACLE 12c RAC One Node, OEM Cloud Control, Data Guard• GoldenGate, PL/SQL, SQLPLUS, ASM/ACFS, Solaris and Linux. Responsibilities Managed:• Migration 11g databases to 12c Multi-tenant RAC or RAC One Node databases.• Applied quarterly patches for grid and database on 11gR2/12c.• Setup and implementation of Oracle GoldenGate Replicator with databases to Database Warehouse System.• Provisioning the coherence cluster with Oracle 12C Enterprise Manager.• Performed Oracle DataGuard broker configuration implementation as DR strategies.• Maintained high availability databases and implemented Disaster recovery plans using Oracle DataGuard/ RAC• Participated in many DR tests by planning and implementing Dataguard switchover / failover using Snapshot Dataguard.• Implemented Active Dataguard for high availability and no data loss for application.• Performed 12c Pluggable database level DR test under Dataguard environment.• Resolving backup/recovery issues with RMAN, including the backups from DataGuard database• Configured ASM/ACFS for the GoldenGate application.• Implemented advanced security for database and data redaction.

Palo Alto, Ca, Us

Hewlett Packard Enterprises, Jersey City, NJPOSITION: Senior ORACLE DBA on site at Deutsche Bank AGEXPERIENCE: 05/2015 – 11/2016 Environment:• ORACLE 11g/12c, ORACLE 11g/12c RAC, OEM Cloud Control, Data Guard, RMAN• PL/SQL, SQLPLUS, GoldenGate, ASM/ACFS, Solaris and Linux Responsibilities Managed:• Support involves handling multiple Oracle 11g/12c RAC with Oracle Clusterware across various applications hosted in Oracle 10g /11g and 12C Databases across Linux and Solaris.• Provided Deutsche Bank 24x7 global supports for over 3000 databases.• Migration 11g/12c databases from New Jersey datacenter to Georgia 12c Multi-tenant cloud datacenter.• Installed patch set for grid and database to upgrade to 11gR2/12c• Support involves in designing, building and managing oracle RAC and ASM databases for high available system.• Installed and configured Oracle GoldenGate on 11gR2/12c for replication between databases• Convert EMC-based DR / BCV settings to Data Guard standby databases. • Implemented daily refresh DEV/QA databases from PROD using RMAN Active Database Duplication• Trouble-shoot database run-time errors and slow performance issues. • Recover database due to data corruption / loss or human errors. • Build my own Exadata on VM for testing environment.• Hand on experience on commands dcli, cellcli, asmcmd, svrctl, crsctl etc..• Performed DR test RAC and Non-RAC environments using Data Guard broker.• Expert in setting up and troubleshooting DR solution using oracle data guard. Tested the oracle data Guard solution performing switch over process.

Frankfurt Am Main, Hessen, De

Environment:• ORACLE 9i/10g/11g, 12c RAC, OEM Cloud Control, DataGuard, RMAN, Exadata, GoldenGate• PL/SQL, SQLPLUS, SRDF, BCV, AIX, Solaris and Linux.Responsibilities Managed:• Supported critical application as trading system and fix income system.• Daily Database maintenance, monitoring and troubleshooting.• Implemented database security, managing users and their privileges.• As DBA Administration on Exadata• Migrated mission critical database into Oracle EXADATA. Help to resolve all applications and performance problem using EXADATA platform benefits. • Work with Patchmgr Process for applying and testing Oracle ExaData patches.• Develop and maintain scripts for monitoring, troubleshooting and administration of the databases.• Write and maintain a DBA utility for a quick lookup of real-time database information as backup, table space, patches and file system.• Configuration and Maintenance of Oracle 11g/12c Data Guard for Multiple databases for Disaster Recovery and Reporting Purpose.• Handling various backup and Recovery operations using RMAN and Shell Script.• Implemented BCV for database backups and refresh.• Support GoldenGate replication, setup parameter for extract, pump and replicate processes.• Installed, setup and configured GoldenGate schema / Tables based replication.• Responsible for tuning database objects including datafile placement to resolve I/O contention, memory performance, SQL, PL/SQL and stored procedures statement tuning.• Involved and Worked on SAN Replications using SRDF Synch/Split for Cloning, Weekly Backup and Site Synch purpose.• Performed multiples of migration/upgraded from Oracle 9i/10g to Oracle 11g/12c Database with and without RAC Infrastructure.• Helped in Design, Implemented new Database Projects including Hardware Selection, Software Evaluation, Capacity Planning and Migration of Database between Different Instances• Working on BMC Remedy/DB Symphony/Service Now for Incident management and Change request.

Nextsource Co, New York City, NYPOSITION: Senior ORACLE DBAEXPERIENCE: August 2001 to July 2004 Environment:• ORACLE 8i, ORACLE 9i, Oracle context, Oracle OEM, Oracle FailSafe, Oracle Data Guard, Oracle RMAN, Oracle Partition, PL/SQL, SQLPLUS, • Linux, Window NT, Window 2000 and ERWin.Responsibilities Managed:• Responsible for database standards, policies and procedures.• Coordination implementation and project administration across multiple Application systems.• Developed procedure and functions using PL/SQL, SQL and Developed critical reports.• Data modeling database design and data loading strategy for loading a star schema Data Mart.• Data warehouse requirements study affinity analysis for a strategic framework based on business queries.• Developers maintained and enhanced the data warehouse and the data mart and provided production support for the daily ETL Extraction Transformation Loading process.• Creating Oracle stored procedures, functions, packages, triggers, views, tables, indexes and constraints for the applications.• Responsible for tuning database objects including datafile placement to resolve I/O contention, memory performance, SQL, PL/SQL and stored procedures statement tuning.• Upgrade Oracle 8i to 9i.• Creating primary databases and standby database(Data Guard 9i).• Implemented database security, managed users and their privileges, backup strategy, and tested failover implementation. • Responsible for Oracle Server/Client installation, configuration, and upgrade on Linux / Windows 2000/NT, configuration InterMedia (Oracle 8i) / Oracle Context (oracle 9i).• Logical and physical design, file system layout.• Design and implement backup methods and disaster recovery strategies.• Monitor database growth and provide database capacity planning for applications expansion.

Environment:• UNIX(Solaris), VERITAS Volume Manager, Window NT, ORACLE 8, 8i, • Oracle InterMedia, Oracle Replication, Oracle RMAN, Oracle OEM V2, • Oracle Partition, EMC BCV, and ER Win V3.5.2, • PL/SQL, SQL and PeopleSoft Tool 7.5., Responsibilities Managed:• Management of corporation database along with supervisory tasks.• Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects. • Responsible for tuning SQL queries (using EXPLAIN PLAN and TKPROF) with indexes and hints.• Responsibilities included the definition of high level architecture, technology, configuration and capacity requirements to support any proposed data warehouse/data mart activity. • Responsible for the logical and physical architecture of a corporate wide data warehouse.• Used PL/SQL, SQL Loader, Transportable Tablespace as part of ETL process to populate the operational data store. • Created primary databases and standby database. • Responsible for design and implement Master-to-Master replication database. • Used Oracle InterMedia(ConText Option) for text search engine.• Work closely with the technical staff to manage, enhance, and maintain PeopleSoft finance and other database applications.• Provide client with 24*7 on call for production Peoplesoft administration support.• Designed, created and configured databases for PeopleSoft applications.• Capacity Planning, Database Performance Tuning, Memory Tuning, Application Tuning and Monitoring and Database Administration.• Managed application and database upgrade.• Backup and Recovery using both conventional approach and Oracle Recovery Manager (RMAN). • Developed a star schema data warehouse data model for the 10 million members E-mail system and partition and maintain the data warehouse.

Environment: • UNIX(Solaris), ORACLE 7.3, ORACLE 8, 8i, PL/SQL, SQL, • Oracle Web Server V3.0, Oracle ConText Option V2.3, ER Win V3.Responsibilities Managed:• Supervised corporation database.• PL/SQL and SQL generation of database reports Standardizing cooperate databases.• Coordinated implementation and project administration across multiple systems.• Configured, Installed and Upgraded the ORACLE servers• Upgraded Oracle 7 to 8 and 8 to 8i.• Installed Oracle Web Server V3 and Oracle ConText Option V2.• Implemented the snapshot replication database.• Created databases and database objects.• Maintaining backup and recovery databases.• Database maintenance, monitoring and troubleshooting.• Implemented database security, managing users and their privileges.• Monitored Database and application tuning.• Partitioned and archive the 5 million records table.• Replicating data to multiple databases.• Evaluated oracle features and oracle related products.• Created Data Models and used ERWin 3.5

Environment:• Windows 95, ORACLE 7, PL/SQL, SQL, PowerBuilder V5, ER Win and Window NT.Responsibilities Managed:• Created databases and database objects. • Remodeling databases and refreshing data.• Maintaining backup and recovery databases.• Monitoring database performance, tuning and auditing.• Managed the size and I/O weights for tablespaces.• Converted the application system from SQL*FORMS V3 to PB V5.• Created Data Models and using ERWin.• Troubleshooting stored procedures and queries.

Environment:• HP-UNIX, MS Windows, ORACLE 7, PL/SQL, SQL, SQL*FORMS V4, V4.5• ORACLE REPORT V2, V2.5 and SQL*LOADER.Responsibilities Managed:• Creating databases and database objects.• Database logical and physical design.• Creating stored procedures and database triggers for the applications.• Redesigning the Parts Tracking System (PTS) which improved control over customer orders and returns, improved problem detection, reduced inventory carried and back order level, and improved existing security and control mechanisms. • Designed The Pricing System which improved control products price and price history.• Created the “1-800 # Consumer Reporting System” which analyzed the requirement of consumers and generated analytic reports.

Environment:• Novell, MS Windows, ORACLE 7, PL/SQL, SQL, SQL*FORMS V4, ORACLE REPORT V2.Responsibilities Managed:• Developed the automobile insurance claims system andincluded Entity Relationship diagram design.• Used C++ language and Visual BASIC 3.0 for prototype design and ORACLE version 7, PL/SQL version 2, SQL version 3.1, SQL*FORMS version 4 and ORACLE REPORT version 2 for implementation.

Environment:• UNIX, ORACLE version 6, C language, SQL*FORMS V3, SQL*LOADER.Responsibilities Managed:• Responsed for the redesigning of a Mortgage system which provided flexibility reporting system for trading related applications, and supported users interface requirements for the asset analysis.• Also responsed for tuning application performance Pro*C programs and upgraded SQL*FORMS from version 2.3 to new version 3.0 for mortgage analysis.

Environment:• UNIX, ORACLE version 5, C language, SQL*FORMS, SQL*LOADER and PRO*CResponsibilities Managed:• Design and code systems for business analysis that include inventory management, financial control and sales.• Implemented analytic system based on requirements of manager or customers.