PROFESSIONAL SUMMARY

Over * years extensive experiences in Oracle databases (9i/10g/11g/11gR2/12c) as Sr. Oracle Database Administrator in Oracle database, IBM AIX, Oracle Linux, HP-UX and Oracle Solaris platform

Certifications in Oracle 10g OCP (Oracle Certified Professionals)

Solid hands-on experiences in installation, configuration, trouble-shooting, performance tuning in Oracle High Availability technologies, including RAC, ASM, Physical/Active DataGuard on AIX/Linux(X64) environments

Extensive experience implementing and support9i and 10g migrations and upgraded from Oracle 9i to Oracle 10g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux

Analyze and determine the feasibility of leverage the Oracle Enterprise Manager 12c solution to report on performance, provide metrics, and become the centralized proactive maintenance solution

Proficient with Database Cloning, Migration, Standby Database, Active Data Guard and Patching of Oracle Databases and Oracle Applications

Experience with Oracle 10g/11g/12c new features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring and Recycle Bin

More than 5 years experiences and solid hands-on experiences in Installation/Configuration/Performance Tuning/Troubleshooting Oracle GoldenGate data replicate middleware in Oracle to Oracle homogeneous environments and heterogeneous environments (including MS SQL Server to Oracle)

Proficient 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

Highly skilled in SQL Tuning by using Oracle statistics management, Explain Plan, TKProf and necessary SQL code rewrite. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Statspack/AWR/ADDM/SQL Advisor

Strong work experience with tools like Toad, PL/SQL Developer, Oracle SQL Developer, OEM Grid Control 12c

Proficient in developing management/monitoring scripts by using Korn/Bash Shell and Perl. Can develop automatic monitor frame work by using Cron jobs

Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly

TECHNICAL SKILLS

Languages: Java, C, PL/SQL, Perl, Korn/Bash shell script

Operation System and Hardware: Oracle/Redhat Linux X64, IBM AIX, HP-UX, Oracle Solaris

Database: Oracle 10g/11g R2/12c (RAC, ASM), MS SQL, MySQL

Monitoring System: Oracle OEM 12c, Zabbix

Data Replication: Oracle GoldenGate 11gR2, 12c

PROFESSIONAL EXPERIENCE

Boeing, Bellevue, WA Oct 2015 to Present

Sr.Oracle DBA/Application DBA

Boeing is the world's largest aerospace company and leading manufacturer of commercial airplanes and defense, space and security systems. I'm in off-hours support of 24/7 GLOBAL environments and participation in an off-hour/weekend duty rotation.

Worked on management and administration of existing production and non-production Global oracle database environments. Perform database design, modification, development, security, backup, tuning, and maintenance activities.

Analyze and resolve application performance issues in coordination with customers and other Database Administrators.

Scheduled RMAN backups, purge jobs, maintenance Jobs using control-M scheduler, DBMS_JOBS, DBMS_SCHEDULER and Crontab, Autosys tool.

Part of theDatabase application support team which supports development, test databases and coordinate with application developer team.

Setting Up High AvailabilityOracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments. Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from Oracle to MS SQL Server).

Implemented 11g Data Guard Physical and experienced with 11gR2 Data Guard new features Active Data Guard Standby.

Set up the physical standby for RAC environment, and monitored standby database in a daily basis and ensure it is always in sync with production database by checking archive log sequences.

Daily Oracle DBA tasks such as Oracle network trouble shooting, tablespace usage monitoring, rebuild index / tables etc.

Express Scripts, Franklin Lakes NJ May 2014 to Sep 2015

Oracle DBA/Application DBA

Express Scripts Holding Company is a Fortune 100 company as of 2013, the 20th-largest in the United States and is a leading healthcare company serving tens of millions of consumers.I worked as the oracle database administrator in the Oracle application DBA team. I was responsible for providing technical support for the database environments in 24/7 environment. Day to Day responsibilities include prod and non prod support for oracle 9i, 10g, 11g database servers in Large Enterprise environment of 700+ servers.

As a senior member of Oracle Advanced Technical support group, provide advanced technical support to State Street Bank Enterprise DBA team on Oracle database related technologies such as Golden Gate, RAC, upgrades, migration, Performance Tuning, Backup and Recovery, RMAN, Partitioning, Oracle Enterprise Manager, SQL, PL/SQL, Code review and optimization, Materialized views, Flashback, troubleshooting, Data pump, RDBMS security, VLDB, optimize server resource utilization etc

Mainly worked on Performance tuning. Working with primary DBAs in the DB support team, support the mission critical OLTP and Data Warehouse production databases. Working as one key member of the technical resources pool to support the Front Line Support On-Call team according emergence requirements and issues

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 by using Korn shell/Perl

Worked on Data Centers Migration project as core Oracle DBA, relocated 200+ oracle database servers(Oracle 9i 10g 11g, standalone and RAC in AIX 6.1,6.3 and Linux), using datapump, transportable tablespace via SRDF replication. Configured RMAN as databases backup to DDboost which is high speed method for data duplication.

Implemented 11g DataGuard Physical and experienced with 11gR2 DataGuard new features Active DataGuard Standby.

Worked on Prod-Nodes Reduction project, reducing standby host and nodes from RAC clusters. Created implementation plans, coordinated SA, Application team and DBA to proceed steps.

Worked on Genesys Informart optimization project, rebuilt and shrink partition, subpartition tables.

Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments 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. Installing and configuring OGG heterogeneous environments (from MS SQL Server to Oracle)

Worked on jBPM Phoenix project, created and configured oracle Lab, Dev, QA, Prod databases as requirement of project team, set up feature FBDA(Flashback Data Archive) for jBPM databases. Created and managed user, roles, privileges, profile, tested new services entries in OVD.

Have done checklist for new database servers build-out for Oracle RAC and standalone, generated SQL statements to validate and to implement Express-Scripts database standards - ESI oracle profiles strategy, ID Tags, check autoextend on datafiles, audit parameters, validated users, invalid objects, etc. Verified local listeners, scan listeners 's configuration changes for RAC and HAS servers. Implement maintenance and backup cronjobs for new databases.

Maintenance of production database and development database which includes table space management, user creation, and privileges, roles. support RMAN backup and recovery including physical backups and logical backups by using data pump (Expdp/Impdp) tool. Extensively develop and maintain Korn shell and Perl scripts

Worked on Sev1, Sev2 Issues and also providing 24x7 On-Call Support and provided on-call and day-to-day support

Nationwide Financial, Columbus, OH February 2010 to April 2014

Oracle Application DBA, Consultant

Nationwide Financial is one of the largest insurance and financial services companies in the world. I worked as the DBA in the Oracle application DBA team of its data center in Columbus, OH for more than 3 years.

Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments. 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. Installing and configuring OGG heterogeneous environments

Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 11g

Daily development/testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell

Perform CORE DBA tasks such as Database Administration on Oracle 9i, 10g and 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting

Architecting, planning, designing, developing, deploying and supporting Oracle 10g/11g R2 RAC/ASM environment

Installing & configuring Oracle 10g/11g clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole – bugs, network issues, configuration files issues, OCR issue, de-installation & cleanup of clusterware)

Worked with customer for different RAC related issue: hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on. Troubleshoot performance issues for the RAC instances (GC events)

Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area

Maintain Oracle SQL and PL/SQL scripts, Unix Shell Scripts, debugging and tuning. Implement Production Control and Change Management

Provides expertise and makes recommendations for physical database design, architecture, testing, performance tuning, and implementation of Oracle database

Handle daily database operation performance issues (track and trend overall database performance and database area, index, and drive performance). Recommending application code changes (processing strategies, queries, use of Oracle10g/11g new features)

Plan and Design Backup/Recovery solutions using shell scripts and RMAN. Ensure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development

Kunz & Leigh Associates, Southfield, Michigan August 2008 to January 2010

Oracle PL/SQL Developer

K&LA is one of the leading application designer and service provider in MI. I worked as the Oracle PL/SQL developer, and in the meantime, I worked as the SA to maintain the IBM PowerPC and X64 Linux boxes. My job was to design, develop, implement, modify, test, document, maintain and tune the systems for various agencies at the State of Michigan and other companies.

Part of the Data Architecture team which supports development, test and production databases

Worked on RMAN duplication, Cross-platform Transportable Tablespace

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

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

Completed numerous projects in data modeling, database design, and application design for a number of Departments of Michigan State using Oracle.

Collaborated with database team members, project managers, QA analysts, application users in the development and implementation of new software and applications.

Conducted user interviews to gather and document system requirements. Undertook system analysis, system design, and system documentation. Designed and developed user interfaces to databases.

Developed, integrated, maintained and troubleshot applications using various tools such as SQL, PL/SQL, Java, XML.

Performed benchmark test, test result analysis and reporting. Debugged applications and documented the changes.

Installed and configured Oracle database for the applications in development, QA and production environments. Analyzed database’s physical and logical layout, and proposed and implemented database structural changes.

Monitored database performance, troubleshot issues, performed database tuning and backup. Documented the backup and recovery procedures.

Developed and maintained user security.

Created and maintained user’s guide and technical manuals. Trained application users.

EDUCATION AND PROFESSIONAL DEVELOPMENT

TJ University of commerce, TJ China

Bachelor Degree of Computer Sciences

Certifications

Oracle 10g OCP (Oracle Certified Professionals), June 2010

Contact this candidate