Principal Oracle DBA
Resume:
Zhun (Jack) Yang
Silas Hill Dr., Toronto, ON M*J 2X8 • 647-***-**** • ******@*******.***
HIGHLIGHTS OF QUALIFICATIONS
Over 10 years of experience in Oracle Database Administration, technical support and system administration.
Worked at Oracle Corportion as Principal Oracle DBA and Hewlett Packard as Senior Oracle DBA for over 6 years. And 4 years as Oracle DBA and System Administrator in Well-known Telecommunication Company
Oracle 9i and 11g OCP, Oracle WebLogic Server 11g Administration, ITIL V3 Foundation certificated
Outstanding analytical and problem solving skills with the ability to quickly assess situations and come up with solid creative solutions
Expertise in Database installation and configuration, backup and recovery, high availability, performance tuning, patching, upgrading, migration.
Extensive experience handling incidents for 7X24 On Call Service
Extensive experience testing various patches(Weekly Bundle Patch, One-off Patch, P4FA, CRM/ERP/HCM/BI PB) and upgrade on Oracle Fusion Middleware.
Experience in full project life cycle development for implementation and integration.
LinkedIn Profile: http://www.linkedin.com/in/yzjamm
Technical Skills and Expertise
Software
Oracle 9i, 10g, 11gr1, 11gr2, 12c, ASM+RAC, Data Guard, Oracle Golden Gate, RMAN
OEM and Grid Control, Oracle Cloud 12c
Oracle Fusion Middleware, Weblogic Server
EMC networker
System
UNIX(Sun Solaris, Redhat Linux, HP UNIX, Oracle VM)
Hardware
Oracle Exadata, HP UNIX Server(HP RP8440,HP RP7410,HP RP4440,HP RP 3440, HP PC SERVER HP DL380, DL580)
HP Library system maintenance for HP MSL5060, HP MSA1000, HP SSL Autoloader 1/8
HP Disk Array / storage system maintenance for EVA 5000
Language
Shell, Perl, PL/SQL,
Certifications
Oracle 9i and 11g OCP, Oracle WebLogic Server 11g Administration, ITIL V3 Foundation certificated
EMPLOYMENT HISTORY
Principal Oracle DBA Mar. 2014 – May. 2015
Oracle Corporation, Beijing, China
Providing technical support for Oracle Database and Oracle Fusion Middleware on Oracle VM/Cloud/SaaS environments
Key Projects:
Oracle Database and Fusion Middleware production installation, configuration, upgrade
Testing Weekly Bundle Patch, One-off Patch, P4FA, CRM/ERP/HCM/BI PB on Oracle Fusion Middleware
Perform day-to-day database administration and ensure integrity, security and availability of applications environments.
Work with US and Indian team members to ensure a smooth task handover across different regions.
Fix environment-related bugs filed by the developers.
Develop scripts to automate functions, processes and monitor Database and Fusion performance using Oracle Cloud 12c.
Senior Oracle DBA Dec. 2008 – Feb. 2014
Hewlett Packard, Wuhan, China
Providing Deep Technical Support (DTS – Level 3) for Oracle Database for Several Customers.
Key Projects:
Client: Cathay Pacific Air Line Account (1 year)
Change management/review/implementation and complex projects in pipeline implementation
Review and evaluate all the database changes, approve or reject, and assign them to appropriate DBAs
Implement complex projects, such as database infrastructure design/optimize, database refresh, migration, upgrade
Implement Disaster Recovery Activities for database.
Client: General Motors Hosting Enterprise Services Account(3 years)
7X24 on call management for 9i/10g/11g ASM+RAC pre-production and production, 300 physical database servers and more than 1000 database instances.
Handling Tickets on priority basis and meeting the defined SLA’s.,
Monitoring daily backups (RMAN ), check CRS logs, ASM logs, RDBMS instance alert logs
Installed and configured Oracle11g R2, perform DB upgrades from 10g to 11G R2
Migrate database from 10g to 11g, cross Platform from Solaris to Linux, using TTS (Transportable Table Space) method, Datapump
Large ASM +RAC databases management, more than 2 TB DB size, 4 nodes, multiple versions 10g/11g, more than 10 db instances on each nodes.
HA databases management. Solaris Sun Cluster, HP Service Guard
Oracle database decommission
Disaster recovery Drill activity, backup / restore / recovery
Apply Database quarterly CPU/PSU patches on pre-prod and prod
Oracle TSS remediation for regular instances or SOX, GM Secret, PII
Database performance tuning,AWR, stats pack, CPU, I/O, Memory
Encrypted listener/wallet installation, configuration, management
Tablespace management, increase, shrink, offline, drop
Maintain Data Guard primary and standby (physical/logical) by scripts.
Capacity planning/coordination, ASM diskgroup Management, knowledge with EMC disk arrays.
Client: GMAC – GM Financial Account (2 years)
Oracle E-Business Suit application and server maintenance.
Install and configure Oracle software, Weblogic software
Develop ER diagrams using Erwin tool, develop logical/physical models, Involved in logical and physical design of database
Provide services of application development to cover the following phases: Systems Analysis and Design / Technical Analysis and Design
Development and Testing
Implementation and System rollout support
Post-implementation problem solving & Ad-hoc Application issues
SQL tuning and troubleshooting.
3 months working in GM headquarter, Detroit MI, USA
Senior Database and System Engineer Jul. 2004 – Nov. 2008
Aspire Technologies (China Mobile’s Subsidiary), Shenzhen, China
Providing technical support for Telecom System in Telecommunication field for well-known China Mobile, including Databases/Physical Devices/Storage Disk arrays/Tape Library/network Devices.
Key Projects:
Maintenance for 7X24 on line mission critical databases Oracle 9i (HP Service Guard), including huge 100 TB Databases for billing system
Monitoring space, wait events, locks and long running operations on the databases.
Performance tuning for long SQL, stats pack analyze, kernel parameter tuning
Disaster Recovery maintenance. Backup database/system to tape, ship the tape to target server of another location, recovery database on target server.
HP Unix system maintenance for HP RP8440,HP RP7410,HP RP4440,HP RP 3440, HP PC SERVER HP DL380, DL580
HP Library system maintenance for HP MSL5060, HP MSA1000, HP SSL Autoloader 1/8
HP Disk Array / storage system maintenance for EVA 5000
Responsible for all issues on “Monternet” system within the province wide of Hubei
Responsible for administrating T-degree database
Responsible for all system technology support covering about 70 devices(HP RP8440,HP RP7410,HP RP4440,HP RP 3440,HP PC SERVER and storage system:HP EVA5000,HP MSL5060,HP DS5300,HP MSA1000,HP SSL Autoloader 1/8)
Projects tracking and supporting
Solving various problems from each departments of Hubei China Mobile
Writing documents of maintenance experiences
Internship Jul. 2003 – Jul. 2004
Sina Technologies, Beijing, China
Developing and Programming Mobile Apps on Nokia Mobile Device.
Key Projects:
Responsible for the development of WAP pages/service, including programming with Perl
Maintenance for Mysql database on FreeBSD.
Programming KJAVA software and EJB development in J2EE platform
EDUCATION HISTORY
B.Sc. Degree in Software Engineering Sep. 2002 – Jul. 2004
Tsinghua University, Beijing, China
(Equivalent to a Bachelor’s in Software Engineering, as determined by World Education Services, Toronto, ON)
B.Sc. Degree in Marketing Sep. 1998 – Jul. 2002
Beijing Information Science & Technology University, Beijing, China
(Equivalent to a Bachelor’s in Marketing, as determined by World Education Services, Toronto, ON)
References Available Upon Request
Contact this candidate