Oracle Database Software Development

Michael(XiangYang) Xu

**** *** **** *****

Furlong, PA 18925

Tel: 267-***-**** (cell)

email: *********@*******.***

PROFILE

Over 20 years IT experiences with all kind database technologies, Oracle, DB2, MSSQL, Taradata .

Extensive administrative experience in the field of Oracle Database on variety platform such as UNIX, Window, VMware etc.

Extensive hand-on experience with supporting large Oracle RAC (10g,11g,12c) with whole processes of implementation

Strong hand-on knowledge of implementation Replicate using Oracle Streaming and GoldenGate

Extensive experience in developing the ETL processes.

In-Depth knowledge in database logical design, physical architecture, and hand on implementation based on Oracle's Open Flexible Architecture..

Proficient in Database system performance Monitoring, Diagnostic and Tuning, Backup and Recovery, managing users and security.

Efficient in task automation and proactive monitoring via OEM, shell scripts

Team player and agile versatile to work independently, under pressure; communicate effectively

EXPERIENCE

US Postal (GDIT)

Contractor, Data Architect(Database Analyst Advisor)● Wilkes-Barre,PA 2020-Present

PL/SQL development to support Informed Delivery new functionality development

Performance monitoring, providing analyses and improvement approaches

Storage management, Tablespace reorganization and archive strategy

Software development to migrate processing platform to google cloud PostgreSQL’s

PJM Interconnection

Senior DBA ● Audubon, PA 2016-2019

As a member of DBA team, supported about 250 databases on 100 servers (PROD, STAGE, TEST, DEV, the largest one 50T)

Support BI group ETL with Goldengate streaming process

Using Data Guard managing two site switching to maintain 24X7 availability

Implementing GoldenGate Replicate to support data warehousing

Install, configure oracle 12C RAC on AIX 7.1 (2-node physical servers and 2-node virtual servers)

Configure RMAN backup using IBM Tivoli (TSM and TDPO)

Database monitor such us space usage, locking and blocking, long running queries, batch jobs.

Database performance tuning

Support in-house software releases for database related tasks

Review, test and deploy database change requests

Capacity planning for new database servers

24x7 on-call support on a rotation basis

Capacity planning for hardware resources needed by databases

BARCLAY CARD US ● Wilmington, DE 2015-2016

Senior DBA Consultant

Deploy CPU patch set for Oracle, ASM migration

Implement New Database

Maintaining Multi TB database for Database infrastructure delivering

Software release supporting using agile scrum

J & J PHARMACEUTICAL R&D LLC ● Spring House, PA 2003 -2014

IT Lead

Manage and troubleshoot multi TB Database to support global drug discovery and development cross three continentals

Evaluation of AWS platform initiatives

Lead development oracle 9i/10g/11G RAC Appliances on Linux using HP blade infrastructure.

Built OEM to maintain and manage RAC DB (alert event, stream replication, tuning and

backup).

Accomplished designing and deploying Oracle RAC Database for Data Warehouse.

Built Informatica Server to serve ETL process.

Developed and Implemented globe data sharing system by using Oracle Stream technology.

3-DIMENSIONAL PHARMACEUTICAL INC. ● Exton, PA 2001-2003

Database Engineer

Installed and configured Oracle Database to support DiscoverWork development.

Database performance tuning and query SQL tuning.

Built Sun Fire V880 server to support database development.

Implemented chemistry data cartridge using PL/SQL and external C++.

TELECOMMUNICATION SYSTEMS INC. ● Annapolis, MD 1998-2001

System Analyst

Worked as a consultant for City of Baltimore‘s Bureau of Budget Management Research.

Installed and built Oracle Database, performance tuning and migration oracle from 7.3.4 to 8i.

Participated full life-cycle software development of JAVA application using VisualCafe IDE,

OOA, OOD, OOP.

Administrated Unix system and configured it for DNS, NFS, Mail, Apache Web Server etc.

EDUCATION

Master in Computer and Information Science, Towson University, Towson MD

Master of Science in Organic Chemistry, Peking University, Beijing P.R.China

Bachelor of Science in Polymer Physics, University of Science and Technology of China,

Hefei, P.R. China

REFERENCES

Available upon request

Contact this candidate