SUMMARY:

• Database Design Engineer and DBA with Data Warehouse
• DB Administration, Data Warehouse, Database HA, Cluster and Disaster Recovery/Oracle DataGuard, Replication GoldenGate
• 70% Oracle, 15% MSSQL and 15% MongoDB in current position
• Design, maintain, upgrade, migration and troubleshooting on database issues as major responsibility, Automation as tool for better efficiency
• Previous experience with Data warehouse (Teradata and Oracle), ETL data integration, Modeling and Backend Development
• Proactively update knowledge and leverage the latest IT technology and product in work, knowledge and training on Hadoop, Gemfire, knowledge with Neo4j.
• Readiness for big data / data cloud, aim to learn more on data science and data technology
• Widen my view and experience in the new projects and environment.
• Latest 10 years work as Oracle, MSSQL and MongoDB DBA, the leading products on market
• Proactively keep updated in related data cloud and big data, like MongoDB and Hadoop
• Good experience with Developer (SQL and PL/SQL, shell scripting and Modeling skill with ER Win.
• Experience with system integration on DB/DW

TECHNICAL SKILLS:

DB/DW: Oracle 12c/11g/10g in current environment; shell scripting, grid control and automation with shell and batch file. Data cloud with MongoDB and Hadoop; Previous with Oracle APPS/HRMS, and other application development.

OS: Linux/SuSE, Solaris, Window 2012/2008/2005 , previous experience with RedHat, AIX, MS Windows OS

LANGUAGES: PL/SQL, SQL, Unix Shell Scripting, batch file and PS1 in work, beginner level Python, Previous working experience as developer using Visual Basic 6.0, Oracle Developer 2000, FoxPro/FoxBASE, HTML/CSS, Java Script, C, Academic Knowledge over VB.NET, Pascal, FORTRAN, COBOL.

TOOL: Oracle Cloud Control/Grid Control, multiple flavored scripting skills for database monitoring and maintenance, putty, Embarcadero DB tools, TOAD, previous experience with Erwin for data modeling, Technical documentation with and with MS word, Visio, Project. Version control with Git BitBucket; previous experience with Appworx (job scheduler); Infomatica Visio, Visual SourceSafe, ClearCase, CR/ECR tools; Crystal Reports; MS Office, Web page design and Image processing tools; PM & Coordinator; Documentation

OTHER: Agile and PM experience

EMPLOYMENT HISTORY:

Database Design Engineer Oracle / MSSQL / MongoDB

Confidential

Responsibilities:

• Oracle Database Administration (core DBA) role and responsibility, build, maintain and maintain production database, Disaster Recovery system, database troubleshooting and database activity monitoring; QA and DEV support and release implementation; Backup plan, Storage plan, database migration and new Data Center

Environment: Oracle 12c/11g/10gMSSQL 2008, 2014MongoDB 3.0.9 3.2.9

Tools: Oracle Cloud Control/Grid Control Data Guard, DR solution and GoldenGate, Embarcadero tools like DBArtisianShell scripting, batch file plus SQL scripting, some Python, Putty, UltraEdit Agile.

Consultant - Database Administrator Oracle / Progress

Confidential

Responsibilities:

• 95 % Oracle Database Administration, APPS infrastructure DBA, 9i and 10g DB/RAC/Linux AS 3&4; Grid Control 10gR2/3, Regular RMAN backup and cold backup, patching and cloning. E-Buz, BI-Discoverer 10g, Oracle Collaboration Suite, DMZ configuration, iLearning content server management etc; Production Support.
• 5% Progress SQL DBA

Environment: Oracle 10gR2 / RAC, 9i on Linux RHEL 4 & 3 on Sun boxes (PROD/QA/DEV/TEST) on Oracle APPS-HRMS, PROD, DEV and TESTING environments; Progress Database systems

Tools: Grid Control, Toad, PL/SQL, Unix script, sqlplus, Citrix, UltraEdit, Putty, VNC.

Consultant - Oracle Database Specialist

Confidential

Responsibilities:

• 30% Data Integration
• 70% Development, Performance Tuning and Reporting

Environment: Oracle 9i on Solaris 8 (PROD/QA/DEV);

Tools: TOAD, SQL Navigator, Composite Studio 3.1; Cognos, SQL and PL/SQL; UltraEdit, SecureCRT, Microsoft Suite

Oracle DBA Programming Analyst

Confidential

Responsibilities:

• 30% DBA, performance tuning, schema creation and maintenance (table, index, view), OS level jobs maintenance (CRON job);
• 60% Development including data integration (ETL from other different data sources), SQL and PL/SQL programming on stored procedure, packages and triggers; Unix Shell Scripting
• 20% Production Database Support; Documentation.

Environment: Oracle 9i/8i on Solaris 8 (PROD/QA/DEV), Linux (DEV/TESTING); MSSQL2K; Windows 2003

Tools: TOAD, Oracle OEM, SQL and PL/SQL; DB tools 5; ERWin(Modeling design); Benthic; UltraEdit, SecureCRT, Microsoft Office; PVCS

Senior IT Specialist Data Warehousing - Data Integration

Confidential

Responsibilities:

• Data Warehouse design; ETL from Oracle with Informatica mapping and workflow, data loading into Teradata DW with TPump, mfload and ffload with different loading strategy; BTEQ scripting and Unix Shell Scripting;
• Modeling design (Erwin and Power Design) and validate schema in data warehouse.
• Appworx job scheduling and Documentation
• Confidential (Internal System) Management and coordination.

Environment: Operation database: Oracle 9i/8i on Sun servers, Data Warehouse, Teradata V2R5 Tools: Oracle SQL/BTEQ SQL; Unix Scripting; Informatica; Appworx as job scheduler, ERWin, Power Designer, Microsoft Office, Windows 2003. TOAD, SourceSafe, Visio, ClearCase, CR/ECR Tools ( Confidential web-based application);

Confidential

Oracle DBA & Programmer

Responsibilities:

• Creating and Adjusting schema for applications (internal control system), which consists of critical and summary info about like retailer’s info, game control and sales info, the data sources come from: 1) Lottery Legacy System via CGI and 2) the type-in info and commands executions from client-side application;
• GUI design (developed with VB6) on functions: Call & Dispatch management, offering our clients with ease of operation over the legacy system via application based on Oracle database, PL/SQL, stored procedures
• Reporting functions offering high quality reports, active reports and crystal reports bundled with VB6, standalone Crystal Reports 8; Data preparation with views and stored procedures
• Internationalized version (Chinese version resource and help file) for clients in China. VB resource file
• QA including functional testing for production release.

Environment: Oracle 9i/8i/8, AIX/WindowsNT/2000, Erwin 4, VB6, Linux RH9, C

Oracle DBA, System Analyst & Project Coordinator

Confidential

Responsibilities:

• Project coordinator, system analyst and leading designer, business requirement analyzing, dataflow, system architecture and data architecture; Logical and physical design with Erwin & designer2K; Schema creation & management, Technical documentation (specification and manual);
• Oracle Database Administration including: Install and create schema and maintain database in development and production; Backup & Recovery; Performance Tuning and application performance tuning on time-costing applications; Replication over distributed environment, Production Support and database healthy status monitoring; Data Modeling and schema release control, HA solution and implementation (Oracle Cluster/ Parallel Server and RAID); Backup & Recovery; Monitoring status and instance and resources; Auditing; Operation and Reports; Data loading (massive information of lottery ticket transaction) into data warehouse and performance tuning on major time-consuming inquiries; 7X24 support to production operation (27 nodes). Data Warehousing and customer-defined processing for operational resource data, customized/manual ETL; production implementation and release control; Storage planning; new technology and Hardware evaluation;
• Financial Statement, Annual Quota Control, Regional Data center Management, Retailer Management; developing suite: Developer 2000 (forms and reports, graphics) and PL/SQL
• Technical HR including recruiting new IT professionals and organize training.

Environment: Oracle 8/8i/7, WindowsNT/ AIX, Erwin 2.5, Oracle Developer2000, SQL Loader, Distributed Database System, C

IT Consultant & Specialist

Confidential

Responsibilities:

• Office Automation, requirement analyzing and specification, Data modeling; C/S Application development for projects to meet the various needs from departments and affiliated associations. Project management.