Xinshang (Matt) Wang Home: 201-***-****, Cell: 201-***-****, E-mail: ac00i7@r.postjobfree.com

SUMMARY:

Oracle Database Administrator with over 16 years of extensive hands-on experience as an Oracle Certified Professional. Successfully lead and implement high availability database solutions (Oracle RAC, Data Guard\Standby Database, Goldengate Replication). Provide critical expertise in architecture design and implementation. Interact with functional teams to ensure successful and on-time deployment. Develop and ensure industry Standards and Best Practices in database administration. Implement and enforce database Security and regulatory Compliance. Coordinate and implement application releases. Allocate database resources for optimum performance and cost effectiveness. PROFESSIONAL EXPERIENCE:

3/2001 – 4/2017 as Database Administrator at S&P Global, Inc. in New York

Vertica and Other Big Data Technologies: install, configure server/client, set up DR replication, troubleshoot SQL performance and resource usage, upgrade 8 node cluster) HP Vertica Analytics Server in production and non-production environment on Red Hat Linux platform. Support Solr, Horton Works Hadoop (MapReduce, HBase, NoSQL) databases.

Goldengate Replication: design, implement and support Oracle Goldengate replications among Oracle databases on Exadata, and to MS SQL Servers. Successful resolve various datatype compatibility (UTF8 to WIN1252), missing data, various SQL errors and other data exceptions. Over the years have implemented various other data replication technologies, such as Oracle Advanced Replication, Streams, SharePlex.

Backup/Recovery and Data Guard: implement RMAN hot backups using UNIX/Linux shell scripts. Conduct database restore and DR testing regularly. Set up and maintain standby databases in all database releases for all production databases.

Performance Tuning: troubleshoot and resolve SQL and database performance issues using Oracle Enterprise Manager (OEM), SQL Trace, Explain Plan, Statspacks, SQL Access Advisor, SQL Tuning Advisor, Toad for Oracle, and Precise.

Globalization Support: design and configure standard client/database different database character sets to support multi-language applications, especially in database replication. Troubleshoot and resolve data corruption. Convert database to UTF8 character set to support different regions and languages.

Upgrade: successfully upgrade Oracle databases to 12 using various methods. Implement 12c new features (Multitenant, Adaptive Query Optimization, Dynamic Statistics, DB In-Memory). Consolidate databases/Schemas. Design and implement standard procedures to ensure the best practice.

Installation/Configuration: work closely with system administration and network teams to ensure standard and consistent platforms (Sun Solaris UNIX, Exadata, Redhat/Oracle Linux), storage provisioning and configuration. Apply patches and bug fixes. Design and implement new functionality. Converted standalone databases to RAC.

Maintenance: set up shell script cron jobs and OEM to monitor database status, to alert on-call DBA, to backup databases, to monitor space usage (uses Automatic Storage Management), and to generate status reports. Refresh non-production databases using Oracle export and import, using RMAN restore and recovery. Provide 24/7 general database support.

MS SQL Servers: provided administration support, especially in configuring Oracle Goldengate replications, clustering Goldengate services, setting up monitoring jobs, making sure datatype compatibility with Oracle databases. 11/2000 – 2/2001, Oracle DBA at US Medical Network, Inc., New York

Set up Oracle database environment in Red Hat Linux environment. Installed and configured Oracle server software, SQL*Net and applications.

Successfully designed and implemented Oracle Peer to Peer Replication.

Optimized database configuration and performance (memory allocation, file systems layout, multiplexing and I/O efficiency).

Implemented and maintained Oracle database backup and recovery (cold and hot backup) using shell scripts to support 24x7 production environment.

8/1999 – 10/2000, Oracle DBA at Organic, Inc. New York

For each project, coordinated with clients, project leaders and software engineers to define and implement user interface, functionality and back- end systems (application servers and data architecture). Documented business and technical specifications. Enforced coding standards. Participated product quality reviews.

Designed Oracle database models (logical/physical) to meet various business requirements. Formulated database structure using Platinum ERWin. Generated business logical flow and Oracle database DDL.

Worked closely with UNIX SA’s to set up Oracle database environment. Established standard memory allocation and storage configuration by OFA guideline.

Installed and configured Oracle database server/client on Sun Solaris/MS-NT platforms.

Installed and configured application servers (Story server, Dynamo).

Design and created efficient standards for Oracle development, test and production databases for different projects.

Designed and implemented database backup and recovery strategies for 24x7 production databases.

Wrote UNIX shell scripts for database loading with SQL Loader and database rebuilt automation.

Programmed PL/SQL procedures, functions and packages. Established a coding standard for engineering group. Trained developers to write efficient PL/SQL programs.

Responsible for daily database maintenance, monitoring, audit performance using DBArtician, Oracle Enterprise Manager.

Tuned PL/SQL programs in productions database and troubleshoot performance issues.

Set up database replications using packaged PL/SQL procedures, snapshots for remote data deployment, data extraction and consolidation.

Implemented Oracle updateable snapshot replication between staging database and production database in two projects.

Set up Standby Databases serving as either reporting database or backup database using Oracle 8i new features.

Successfully migrated Oracle databases to latest versions and applied patchsets and bug fixes.

Mentored other DBA’s and developers to understand advance database features (Partition, Replication, Data Guard, RMAN backup).

Designed, implanted and maintained MS-SQL Server databases. Set up replications. Generated reports. 2/1998 – 8/1999, as Oracle DBA at Health Insurance Plan (HIP), New York

Conducted numerous meetings with different department heads to explore business initiatives. Designed and developed client-server system and data warehouse that served various applications for different departments.

Worked closely with consulting firms (Anderson Consulting, Inc. and Brandon Co.) to advance company’s information technologies from legacy system to client-server system.

Designed Oracle database (logical & physical) using ERWin. Implemented the company’s first near 24x7 Oracle RDBMS for customer service and voice response applications using MS-Internet Information Server on MS-Windows NT platform.

Migrated data from other databases to Oracle database. Automated daily data FTP download from IBM Mainframe, updating Oracle database using DOS scripts.

Tuned PL/SQL scripts, database configuration to improve performance.

Developed Oracle database backup strategy for complete and incomplete recovery using RMAN. Established Standby Databases for database backup and reporting.

Implemented database security for database access and object privileges using Oracle Enterprise Manager (OEM). Implemented Oracle Names server for database access management.

Performed daily monitoring, troubleshoot and other administrative tasks.

Developed a standard documentation procedure for all applications. EDUCATION and TRAINING

ITIL Foundation, 2014.

Oracle Database 11g Administration Certified Professional, 2014.

Oracle Database 10g Administration Certified Professional, 2005.

Oracle Database 9i Administration Certified Professional, 2003.

Oracle Database 7.3 Administration Certified Professional, 1999.

BS degree in BioChemistry, Hebei University, China, 1984.

~

Contact this candidate