Profile

Canada Permanent resident

Senior Database Consultant with over 7 years of IT experience. 7 years of Oracle DBA experience, specialized in planning, architecting, designing and setting up OLTP and Enterprise Data Warehouse databases. Expert in implementation, upgrade, migration, data replication and managing enterprise class applications in cluster and High Availability environment.

Believe in service excellence, relationship management, knowledge transfer and building team trust.

Resourceful, result oriented with strong consulting experience.

Certifications

Oracle Certified Master (10g 12c)

Oracle Golden Gate Certified Implementation specialist

Oracle Certified Professional RDBMS (Oracle 8i, 10g, 12c)

MCP (Sql Server 2012)

Oracle Certified Professional Mysql

Education

Beijing union University Computer Sciences (MCS)

Key Strengths

7+ years of experience in planning, architecting, design, build, configuration and administration of complex OLTP and Enterprise Data Warehouse (EDW) databases with size up to 53TB in cluster and heterogeneous environment.

More than 7 years of experience in planning, architecting, designing and implementing High Available database systems in cluster environment using Oracle Cluster (9i, 10g, 11g and 12c RAC, & Data Guard Standby db).

7+ years of experience in planning, architecting and designing Disaster Recovery strategies for Enterprise database systems running in Cluster and HA setup including for Exadata. (Golden Gate)

Experience in configuring, setup and administration of Oracle In-Memory database option and Oracle TimesTen 7,11,12.

Experience in designing strategies and implementing data replication solutions using Oracle GoldenGate.

Strong experience in planning, implementation and administration of ETL systems in Cluster and HA environment using Informatica ( PowerCenter, Data Quality) along with its Content Management (Address Validation and Identity Management).

More than 5 years of experience in planning, designing & implementing Security policies, standards and guide lines to database systems.

Strong experience in planning, architecting and implementing partitioning, parallel processing, data compression and data masking strategies in Data Warehouse and OLTP environments (Compression: Warehouse, Advanced, EHCC).

Excellent grip and strong experience in architecting solutions and capacity planning for Enterprise database system.

Proficient in trend analysis and predicting resource requirements, and presenting these to senior management.

5+ years of experience and in depth knowledge of System Development Life Cycle, Change Management process, maintaining data models, and maintaining and securing database designs.

5+ years of experience in setting up efficient backup for VLDB with size over 53TB at one site and performed numerous recoveries to VLDB including partial and full recoveries.

Extensive experience of planning, architecting and designing, implementing and administration of Materialized view, Summary tables and their refreshes for DSS & Reporting.

5+ years of experience in performance and tuning (database server, database & SQL optimization)

Very strong handle on database system migration across platforms and excellent in database upgrades (9i, 10g, 11g)

5+ years of experience in authoring technical documents, User Guides and Cook Books

Strong experience in planning, architecting, administering and support of Distributed Database environments

Strong experience in planning, designing and implementing strategies of Enterprise Content Management using Oracle(10g & 11g 12c 13c) and SharePoint.

Strong experience and in-depth knowledge of data security (Encryption, masking, Sub-Setting and data scrambling) and its implication to database cloning, database refreshes and data migration for testing and QA purposes.

Unix shell & PL/SQL scripting and Core DBA skills - focus on process automation, stability and high availability

Organization and patience – focus on quality and deliverables specially under immense pressure

Extensive hands-on experience in designing and implementing replication solution using Golden Gate.

Technical Skills

Databases: Oracle (8i to 12c), Exadata, MySQL Server, Oracle TimesTen (In-Memory Database),Sql server 2012.

Data Warehouse: Informatica (v 8 to 9.5.1) including IDQ and Oracle Warehouse Builders.

BI and Reporting: Cognos, Hyperion, Business Objects, Crystal Report and Oracle Discoverer

Monitoring Tools: Grid Control, OEM, custom developed monitoring scripts

Data Migration/Replication: Golden Gate, Oracle Materialized views, PL/SQL, Triggers, Oracle Streams

Operating System: AIX (4,5, 6.1,7.1), Linux, HP UX (11i), Windows

ERP: Oracle E-Business Suite 11i (GL, AP, AR, ASCP, ATP, iStore, iSupport, Inventory, Order Management etc)

High Availability: Oracle RAC (10g, 11g), Data Guard, Grid Infrastructure 11i and 12c (Oracle Clusterware),

Languages: SQL, PL/SQL, Java, Unix Shell Scripting (bash, ksh, sh)

Design/CASE Tools: ERWin, Oracle Designer, Visio

Storage: ASM (10g, 11g, 12c), NFS (dNFS), Cluster and Non-Cluster File System (for RAC and Standalone databases)

Content Management: Oracle Enterprise Content Management

Security: LDAP, Oracle Directory Server

Data Security: Oracle Advanced Security (TDE, VPD and Label Security), Data Masking, sub-setting and data scrambling.

Cloud Services: Oracle EM Cloud 12c and13c.

ORACLE SOFTWARE SYSTEMS CO. LTD (Sr. Oracle Database Principal Consultant) Sep 2010 – Jul 2018

Technologies: Solaris (10 &11), Oracle 8i,9i,10g,11gR2, Oracle 12c, Oracle Grid Infrastructure 11g/12c (RAC), Oracle GoldenGate 12.x.,Timesten,Exadata

Hardware: AIX 5.3 6.1 7.1 HP-UNIX 11.23.11.31 Linux 5 6 7

Provide technical support and guidance to all database related activities including planning, designing, installation, configuration, schema setup, database and data security, auditing, backup and recoveries, database refreshes, replication, scheduling, performance and tuning both database and SQL, trouble shooting, root cause analysis.

Plan, upgrade and test database systems and perform impact analysis to design changes, and to incidents and problems

Suggest and recommend optimization opportunities to database system and perform and implement performance tuning to database refreshes, migration and recoveries initiatives during the process of SDLC. Diagnose and perform, suggest and implemented solutions.

Prepare build books / cook books for planning, design and implementation of database system. Authored numerous technical write ups during different phases of the Panorama project.

Responsible for process automation and optimization. Designed and developed PL/SQL, SQL and Unix shell script for backup verification, databases` health check, automatic startup and shutdown and numerous other DBMS maintenance activities including preventing incidents and problems.

Recommend, architect, design and implement partition and compression strategies. Recommended and implemented partitioning strategy to target databases for ETL loads in Panorama project.

Guide and suggest database and data security options to protect data and DBMS integrity. Implemented Oracle Advanced Security using Transparent Data Encryption and measured its performance impact to database queries. Implemented TDE with minimal impact to performance.

Lead the team to architect, layout design, develop standards and procedure, implementation strategy, migration path and capacity planning of 40 new RAC (11g/12c) and Non-RAC databases in Sun T4/T5 servers. Designed, developed and implanted Standards and Procedures in setting up Oracle Cluster environment (RAC 11g/12c) using NFS and ASM.

Planned, installed and configured Oracle OneNode RAC. Converted OneNode RAC to RAC and vise versa, and prepared

References: Available upon request.

Eric.Lin

ac7xmv@r.postjobfree.com 416-***-**** (Mobile)

Contact this candidate