Sql Server Oracle Database
Resume:
Eileen Zhou
**** **** ****, *******, ** *****
**********@*****.***
SUMMARY:
Oracle 8i, 10g, 11g, 12C, 19C DBA with Oracle DBA certification of 8i and 10g. More than 20 years’ experience in database design, Oracle and SQL server database administration on premise and in cloud (AWS and Azure), database programming, and report generation. Core competencies include gathering, analyzing data and data modeling, developing systems in various industries. Responsible and dependable problem solver, committed to highest quality results. Technical skills including:
AWS and on premise Oracle database administration, Database migration from on premise to AWS
Full life cycle of database development
Oracle 9i, 10g, 11g, 12C, 19C, SQL Server 2008, 2012, 2014, 2016, 2019 stand alone and always on database administration, SSIS, SSRS
TOAD, OEM12C, OEM13C, RMAN
Oracle EBS application DBA
Unix, Linux, and Window operating system
PROFESSIONAL EXPERIENCE:
Genex Services/Enlyte (Wayne, PA) Senior Oracle/Sql server DBA 2014-present
Oracle/Oracle on premise and in AWS /SQL Server databases administration
Maintain Oracle EBS and other home grown Oracle Databases in Linux, Unix, and window environment, including backup and recovery, performance tuning.
Working with OEM 12C and EM 13C to monitor Oracle database and diagnostic problems.
Worked on AWS Oracle database migration into EC2.
Worked on AWS Oracle database migrating data to RDS.
Export and import data to different databases using S3 bucket.
Developed shell scripts for Oracle maintenance and materialized view refresh jobs
Patch and clone Oracle EBS database and application tiers.
Install and configure Oracle Discoverer and Apex
Configure db links between SQL server and Oracle databases
Maintain SQL server standalone and always on databases, database backup/recovery
Install SSIS and SSRS, configure, maintain, and deploy SSIS projects
Help developers to resolve performance issue
Resolve user issues from the ticket system and on call support during off hours
Begin to work on PostgresSQL, like to create database, users, objects
Catholic Health East (Newtown Square, PA) Oracle & SQL Server DBA 2009 – 2014
Oracle/SQL Server databases administration,
SQL Server and Oracle Database administration, backup and recovery
Software installation (including cluster environment) and upgrade databases specially for electronic medical record software
SQL Server and Oracle database refresh and resolve any database issues
Data transfer from between different systems
Report Writing with Microsoft SSRS
Monitor the database performance
Set up Oracle OEM to monitor Oracle databases
Oracle 11gR2 RAC administration
Set up Oracle DataGuard
Disaster Recover testing
Database Tuning
CDI (Philadelphia, PA) Oracle & SQL Server DBA 2005- 2009
Oracle & SQL Server databases administration,
Create and maintain Oracle and SQL Server databases
Database backup and recovery
Software installation (including cluster environment) and database creation
Security administration for financial system to satisfy Sarbanes-Oxley rule
Database refresh
Write TSQL scripts to automate db maintenance and data transfer tasks
Data transfer between different Oracle and SQL Server
Test disaster recovery plan
Monitor the database performance.
PHARMANET (Essington, PA) Oracle DBA/Developer 1999-2004
Maintained the ClinTrial (Oracle) database and designed a clinical trial tracking database.
Monitored the usage and the data integrity of the Oracle database to ensure accuracy.
project managers.
Installed and upgraded the software
Export-import operations, manage storage (datafiles, tablespaces, segments, and extents).
Provided support and troubleshooting to the development team
Managed users, privileges and resources. Create profiles and roles.
Designed and implemented the first company-wide clinical trial tracking database to facilitate regulatory compliance. Write report for the project managers. Data Modeling with ER Studio. Designed data entry forms with VB 6.0
Implemented backup/recovery strategy.
Reorganized and managed large tables and indexes
Developed reports for each department with Crystal Report
Tuned the database for faster performance
TRAINING:
Microsoft Azure and Amazon AWS
Install/Patch/Maintain Oracle E-Business Suite at Oracle
SQL server 2008 administration at Spring House
SQL server reporting services at Spring House
Mastering Website Design with InterDev 6 at Micro Endeavors, Inc
Oracle 8i and 10g Enterprise DBA at Oracle Corp.
Certified Client/Server program at Penn State, at Great Valley
Education
Ph.D., Biochemistry, Oregon Health and Science University, Portland, OR
Contact this candidate