Rss

Contact_user

Lin Y

Database Administrator - 16 Years of Experience - Near 94588

Occupation:

Database Administrator

Education Level:

Medical Degree

Will Relocate:

YES

CollapseDescription

SUMMARY * More than 16 years' Oracle DBA experiences with OCP 9i and 10g Certificated (on Sun Solaris/IBM AIX/HP-UX/RHEL and Windows platforms) * 8 year experience of Oracle RAC and 6 year experience with 11g RAC. * Installed and configured Oracle RDBMS (From 8i to 12c). * Evaluated and tested the new features from Oracle 8i through 12c RDBMS. * Set up and configured RMAN for backups and recovery (9i, 10g and 11g). * Developed, tested and documented disaster recovery plan (DR plan). * Designed, configured, implement and managed Data Guard (9i, 10g and 11g) environment via DGMGRL utility. Tested switchover and failover procedures in regular interval. * Capacity plan, Space growth trend monitoring * Upgraded Oracle databases from 8i onward to 11gR2 * Migrated SQL Server and MySQL to Oracle database * Build replication system with Oracle Golden Gate and Streams (10g and 11g). * High level sed, awk programming skills to solve some special problems * Excellent skills in SQL and PL/SQL development. warning and conditional compilation, parallel processing, unit testing, bulk collection operations, result cache * Expert skills in Database Modeling with strong knowledge of SDLC * Logical and physical database design with UML and implementation * Application, Database and SQL, PL/SQL performance tuning * Install, configure and manage 10g/11gR2 RAC with ASM storage. * Senior level skills for ADDM and AWR report analysis. * Designed, tested, implemented and documentation Disaster Recovery Plan. * Good experiences of ANT, Python and PERL programming in scrip development * Excellent skills of SQL*plus and some other command-line utilities * Superb skills in shell scripting to automate all possible operations in database management and data handling and monitoring system. * Experience of VLDB with Oracle partitioning technology to improve the performance. * Some development knowledge with PHP, JSP, PSP and Java. * Worked with QA, Development teams to resolve Dev., QA or UAT environments' issues. * Data warehouse and mart design, development, implementation and performance tuning. * Oracle Resource Management design and implementation * OLTP and OLAP application database design, development and implementation. * Application and script Version control with Subversion (SVC) * Worked in Hadoop Distribution FS for big data analysis projects with R/MapReduce * 3 years MySQL management (Install, admin, tuning, backup and troubleshooting), * 5 years management experience with SQL Server (7, 2000 and 2005) * 7x24 On-call support of production environments

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseJob Skills

Left_template4_bottom

CollapseKeywords

Left_template4_bottom