Emily Bai

Email: adnt7t@r.postjobfree.com

Office email: li.bai@credit_suisse.com

Cell Phone: 813-***-****

OVERVIEW: I am an Oracle DBA veteran with over ten years of focused experience in high end Oracle database administration covering various fields like finance, banking, health care and telecom. I have extensive experience in Oracle database design, analysis, modeling, development, administration, implementation, troubleshooting and quality control and management. I work with the IT Architects in designing the logical and physical model of the Enterprise level databases. I have long term, solid experience in RAC, GoldenGate, Grid, ASM, DataGuard, Oracle Exadata installation, configuration, troubleshooting, and performance tuning.

OBJECTIVES:

* Oracle Database Administrator (RAC/DataGuard)

* Oracle Exadata DMA (Database Machine Administrator)

* Oracle GoldenGate Administrator

TECHNICAL SKILLS:

* DATABASE: Oracle 10g/11g/12c/18c/19c

* LANGUAGE: SQL and PL/SQL, T-SQL, Korn/Bash Shell

* HARDWARE: Oracle Exadata, Redhat Linux, IBM AIX, HP-UX, Oracle

Solaris

* DATA REPLICATION: Oracle GoldenGate

* MONITORING: Oracle OEM 13c

* TOOLS: SQL*Plus, TOAD, SQL Developer

PROFESSIONAL SUMMARY:

•A Senior Oracle DBA offering 10+ years of progressive experience in Oracle database administration, including design, development, implementation, migration, upgrading, maintenance and production support of complex database applications and huge data warehouse system (Exadata).

•Experienced in installing and patching Oracle RAC with ASM on AIX, Solaris and Linux platforms.

•Expertise in setting up Physical standby, Active Data Guard and troubleshooting the log gaps.

•Well experienced in performing Fail-over/Switch-over activities periodically.

•Good exposure in upgrading and migrating 12c databases to pluggable databases in 19c container on Exadata Machine.

•Fabricated multiple CLONING databases using traditional method and RMAN utility for High availability configuration.

•Good exposure in Configuring Single and multiple instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) in Oracle 19c,12c,11g and 10g.

•Provided 24/7 on-call DBA support for Production databases, responding to troubleshooting calls from multiple database sites and offering solutions.

•Solid hands-on experience in Installation / Configuration / Performance Tuning / Trouble -shooting Oracle GoldenGate (OGG) in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and MS SQL Server to Oracle), extensive skills in upgrading OGG 12c to 19c, configuring OGG in RAC high availability environment.

•In-depth understanding Oracle Goldengate internal mechanism, OGG new features such as Integrated capture, coordinate apply mode, multi-threaded replication. Developed home-cooked OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM (Oracle Enterprise Manager) 13c.

•Performance testing and tuning of 19c RAC database after migration and upgrade from 12c by using AWR/ASH/ADDM/OEM 13c/SQL Plan Management and home-cooked scripts.

•Three years experience in Oracle Exadata database machine administration, patching, upgrading, performance tuning and troubleshooting. First hands-on skills about Exadata hardware architecture including Storage, Grid and Infiniband. Deep understanding of key Exadata features including HCC (Hybrid Columnar Compression), Smart Scan, Smart Flash Cache, Storage Index and Storage Management.

•Proficient experience in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full/incremental backup. Hands on experience in disaster recovery.

•Highly skilled in SQL and PL/SQL Tuning by using Oracle statistics management, Explain Plan and necessary SQL code rewrite. Strong work experience with tools like Toad, PL/SQL Developer, Oracle SQL Developer, OEM 13c, proficient in developing management / monitoring scripts using Korn/Bash Shell.

• Solved network related problems in Oracle database using Oracle Net Configuration Assistant (NETCA), Oracle Net Manager providing Oracle Networking Solutions (tnsnames.ora, sqlnet.ora).

•Strong experiences with monitoring, troubleshooting, and resolving database issues in 24x7 production environment.

•Strong analytical and communication skills with the enthusiasm and willing to take responsibilities.

•Proven ability to approach problems effectively, prioritize and complete multiple tasks.

•Results-Driven with ability to take initiative and meet deadlines in a fast paced changing environment and hard worker.

•Highly self-motivated, organized and able to adapt and learn new technologies quickly.

WORKING EXPERIENCES:

Sr. Oracle Database Administrator

Client: Credit Suisse, Raleigh, NC Oct 2017 – Till Date

Responsibilities:

• Successfully upgraded the databases from 12c to 19c.

•Configured the CDB and PDB’s with RMAN backup.

•Successfully patched Exadata Machine.

•Monitoring, Trobleshooting and performance tuning for Exadata Machine.

•Migrated the databases to 12c using Goldengate with zero-downtime to Exadata Machine.

•Performed the table restore and recovery on online database.

•Analyzing the application releases and recommending the necessary changes to the queries.

•Analyzing the application key tables and collecting the required statistics.

•Analyzing the day to day database and server load for the machine critical database and making necessary changes for better performance.

•Configured the Jumbo frames to improve the interconnect performance.

•Redesigned the tables of LOB columns with compress option to reduce the space consumption.

•Created baselines for several standard reporting queries.

•Migrated the databases from old Solaris to red hat Linux with new versions like 12c and 19c.

•Capacity planning and troubleshooting the day to day performance issues.

•Troubleshooting RAC node issues like node eviction, cluster diagnosis.

•Working with application and infrastructure teams to build the new database environments.

•Configured the active data guard for the production environments.

•Applying the PSU and bug fix patches to keep the databases compliance and secure.

•Configured the databases with different backup methods and testing the restore capability.

•Participating quarterly disaster recovery tests and certifying the business-critical databases availability.

•Installing the 12c agents in all the target database servers and configuring the targets for monitoring and performance analysis.

•Created Oracle Wallets and implemented Tablespace level TDE security.

•Successfully restored the data from previous backups to support legal issues.

•Analyzing the data growth in the database and making changes to the environment for application stability.

•Analyzing the huge tables in the database and advising the application to use different partitioning methods for data archiving and better performance.

•Successfully made the standby database in SYNC with Primary when there was a huge log gap using roll forward method.

•Upgraded Grid Infrastructure and databases from 12c to 19c.

•Participate in a rotating on-call schedule with other DBAs.

Environment: Oracle RAC 12c and 19c, OEM 13c, Goldengate 12.2,Oracle Data Guard, OEM 13c, Solaris.

Oracle GoldenGate Specialist II / Sr. Exadata Oracle DBA

Client: TD Bank, Tampa FL November 2015 to September 2017

Responsibilities:

•Installation, configuration, maintenance and support of Oracle 11gR2 Databases. Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 12c

•Installed, configured and maintained Oracle 11gR2 Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux 6.x boxes.

•Performance testing and tuning of 12c RAC database after migration and upgrade from 11gR2 single instance by using AWR/ASH/ADDM/OEM 12c/SQL Plan Management and home-cooked scripts.

•Installing ASM instance and migrating the database from a Filesystem to ASM storage.

•Installed and configured High Availability Oracle GoldenGate 12c systems on Oracle 11gR2 RAC environments.

•Implemented Oracle Goldengate for replicating data from Primary (OLTP system) to downstream systems such as data warehouse for reporting purposes. Implemented Goldengate integrated replicat and coordinated replicat (available from OGG 12c) to improve the performance of data replication to targets.

•Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc. Performance Tuning OGG in extremely high data volume environments.

•Involved in zero-downtime migration upgrade Oracle databases from Oracle 11.2.0.4 to Oracle 12.1.0.2 using Golden Gate.

•Migration of Oracle database 11g (11.2.0.4) from Linux Boxes to Exadata machine using Data Guard switchover and Export & Import and using Goldengate replicate data from front-end OLTP system and back-end datawarehouse Exadata Machine. .

•Built Oracle 12c Standby database, both active Data Guard for real-time replication and normal Data Guard for disaster recovery. Worked on Disaster Recovery by converting physical standby databases to Snapshot standby database and open in the read/write mode for testing without interrupting the primary production database.

•Writing many automation UNIX shell scripts for database refresh, monitoring, consolidated report, re-configure Data Guard switchover/switchback of database etc. Created, scheduled database maintenance tasks, such as tables/indexes analysis, index rebuild, materialized view refresh, database exports and janitorial day-to-day tasks.

•Using RMAN for backup/recovery strategy for different database. Applying different recovery procedures for complete and incomplete recovery depending on the type of failure.

•Tested disaster recovery with database failover and switchover also tested Goldengate replication after that using DBFS file system and ACFS.

•Worked as production support included receiving email alerts, attending production calls, troubleshooting emergent issues.

•Managing database security by creating new users, roles, profiles and providing privileges for implementation and maintenance of user security.

Environment: Oracle Exadata, Red Hat Linux RHEL 5.x and 6.x, Oracle 11g/12c, SQL, PL/SQL, UNIX Shell Scripting, STATSPACK, AWR, ADDM, Sql Developer, OEM, SQL* Loader, expdp, impdp, TOAD 12.6.

Sr. Oracle DBA and GoldenGate Specialist

Client: AstraZeneca -Gaithersburg, MD January 2012 to October 2015

Responsibilities:

•Installation and Setting up of 11gR2 two node RAC databases with Active Data Guard, Physical and Logical standby databases.

•Installed standalone servers on ASM and migrated databases to ASM and worked extensively on monitoring 11g grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

•Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.

•Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack)

•Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc.

•Built Oracle Standby databases, both Active Data Guard for real-time replication and normal Data Guard for disaster recovery.

•Worked on Disaster Recovery by converting physical standby databases to SNAPSHOT standby database and opened in the read/write mode for testing purposes without Interrupting the primary production database.

• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Data Pump utilities and SQL*Loader. Applied different recovery procedures for Complete and incomplete recovery depending on the type of failure.

•Experienced in scheduling the database backup jobs using crontab and created a clone database using RMAN.

•Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell, and Daily Oracle DBA tasks such as Oracle network trouble-shooting, tablespace usage monitoring, rebuild index / tables etc.

•Worked closely with PL/SQL developers for fine performance tuning and supported development teams by providing sql statement tuning and removing load and query performance bottlenecks.

•Primary technical resources in SQL tuning in Exadata Production and Performance Testing environments by using statistics, hints, SQL tuning set etc.

•Working as a DBA in the Database Support Team to support (daily On-Call rotation) production and non-production environments.

• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 12c

•Worked on Re-Organizing the tables to convert from non-partitioned to partitioned tables using Online Redefinition (with minimal impact to live system ), CTAS(create table as select ), exp/imp and creating the table with new DDL and direct insert sql.

•Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.

•Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal) for restoring the specific objects at the database level.

•Worked on upgrading of oracle databases from 11g to 12c, building and rolling out new 12c databases for test/dev/qa environments.

•Involved in 24x7 support for 40TB, 2 Node production RAC database with daily On-Call rotation.

•Worked effectively with multiple teams and able to thrive in a fast-paced, time compressed and dynamic environment, solid skills and discipline for Change Management practices processes.

Environment: Oracle Exadata, IBM AIX 6.3,7.1, Sun Solaris 2.6/7/8, Red Hat Linux 6.0, Oracle 10g/11g/12c, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER 9.2.0, Oracle 12c GRID, Oracle RAC, Data Guard, Toad 8.6

Sr. Oracle DBA, Consultant

Client: CITI Bank, Arlington, VA October 2009 to December 2011

Responsibilities:

•Working as a DBA in the Database Support Team to support (daily On-Call rotation) production and non-production environments.

•Implementation and support of 9i, 10g migrations and upgraded from Oracle 9i to Oracle 10g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux.

•Administering and setting up of 10g RAC and clusterware and instances. Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.

•Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.

•Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespaces.

•Scheduled RMAN backups purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER and crontab.

•Handled Chained Rows and Row migration, and solved the database performance issues.

•Generated Statspack/AWR reports using OEM from Oracle 10g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace and database growth.

•Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.

•Perl Scripting, Unix Shell Scripting and PL/SQL programming to resolve business problems of various nature.

•Involved in the projects which configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.

•Worked on various tables to create indexes to improve query performance. Also, worked on partitioning large Tables using Hash Partitioning.

•Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.

•Unix Shell Scripting, and PL/SQL programming to resolve business problems of various nature.

•Performed Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN Catalog for the same.

•Worked on DBMS Data pump packages at schema, table and partition level for moving data using network link.Extracted required data from the database tables and exported the data to different sources in different formats.

•Worked on various tables to create indexes to improve query performance. Also worked on partitioning large Tables using Range/List/Hash Partitioning, creating Index Organized Table (IOT), Cluster Tables.

•Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD(10.1), Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts, Golden Gate, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, AIX-5.3, JAVA.

Oracle DBA, Consultant

Client: Geico Arlington, VA October 2006 to September 2009

Responsibilities:

•Involved in Business Requirements, System analysis and Design of the Data warehouse application. Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

•Involved in installation of the Oracle GoldenGate (OGG) software to implement one-way data replication process, enable DML data replicate, setup the heart-beat table to monitor OGG replication lag and provide real-time lag report.

•Install, upgrade, and maintain database software, included creating user accounts, cloning database systems, ensuring nightly backups are performed, applying software patches.

•Involved in working with the Information/Data Architect and Database Designer/Modeler to implement the physical data model to support the mission critical OLTP and OLAP production databases.

•Performed installation, configuration, maintenance, and upgrades of Oracle development, QA, and production databases, including installation and upgrades for client/server software.

•Involved in working with Application team for a large number of tuning projects and working with third party developers on SQL code review and quality control. Performance load testing and tuning application,SQL code, and database instance by using a wide range of technologies including ADDM, AWR, ASH, Statspack, OEM Performance Manager and home-cooked scripts.

•Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.

•Involved in a team migrating 12TB & 40TB production database using Goldengate Zero down time migration.

•Installing ASM environment and migrating database from NON-ASM to ASM.

•Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.

•Troubleshooting errors and using the Expdp/Impdp utility on a very regular basis for copying data across schemas.

EDUCATION BACKGROUND:

Nankai University, Tianjin, P.R China

PhD in Medicinal Chemistry

LANGUAGES: English, Chinese

REFERENCES: Available upon request

Contact this candidate