SUMMARY:

• Latest 10 years work as Oracle, MongoDB and MSSQL DBA and architect, DM/DW experience, RDBMS and NoSQL
• Recent data cloud and big data experience with MongoDB/Linux SuSE
• Good experience with SQL PL/SQL Developer, Performance Tuning, Troubleshooting Shell Scripting and some Python
• ER Modeling experience with ERStudio and ERWin.
• Experience with DW integration with ETL/Infomatica and migration Oracle utility and GoldenGate
• Recent training: Hadoop/Cloudera, Neo4j and Gemfire.
• Practice: Neo4j on AWS/EC2 Amazon Linux AMI
• Database Engineer & DBA on RDBMS and NoSQL database, interested in Data Cloud solution & Big Data
• DB Administration, Data Warehouse, Database HA, Cluster and Disaster Recovery/Oracle DataGuard, Replication with GoldenGate
• 50% Oracle, 30% MongoDB and 20%MSSQL DBA, MongoDB takes more percentage in recent 2 years in data cloud project.
• Design, maintain, upgrade, migration and troubleshooting on database issues as major responsibility, Automation as tool for self - management and efficiency
• Previous data integration with ETL(Informatica) for data warehouse (Teradata and Oracle), good modeling experience on RDBMS
• Proactively update knowledge and leverage the latest IT technology and product in work, knowledge and training on Hadoop, Gemfire, knowledge with Neo4j. Recent learning and practicing MySQL, AWS/EC2 and New4j on AWS. Readiness for big data / data cloud project.
• Widen my vision and experience in the new projects and environments.

DB/DW: Oracle 12c/11g/10g in current environment; shell scripting, grid control and automation with shell and batch file and Python. Data cloud with MongoDB as data source and Training on Hadoop;

Database: ER Design and application development, ER Studio and ERwin.Previous Oracle APPS DBA on HRMS

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

LANGUAGES: PL/SQL, SQL, Unix Shell Scripting and Python, batch file and some PS1 in work. In learning node.js and Django. 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

Project Tool: PMP training, Agile/Scrum experience with Projects.

EMPLOYMENT HISTORY:

Confidential

Responsibilities:

• Continuing studying and practicing data cloud and big data related technologies
• Coordinator of program events from planning to implementation
• AWS/EC2: Neo4j on AWS, Docker
• MySQL
• Hackolade Modeling tool 4 NoSQL database
• Studio 3T for MongoDB
• Nodes.js

Confidential

Database Design Engineer Oracle / MongoDB / MSSQL

Responsibility:

• Oracle Database Administration (core DBA) role and responsibility, build, maintain production database, Disaster Recovery system as needed in iAT/uAT/PRD, database troubleshooting (DB error and application errors) and database activity monitoring and evaluation; QA and DEV support and release implementation; Backup plan, Storage plan, database migration and DR databases build in Data Center; knowledge of 18c and AWS.
• MongoDB DBA, working on two new cloud applications since 2015, which is based on Oracle as source DB and MongoDB as middle-tier database across several data centers, virtual servers for pre-prod environment and physical servers for productions; installing new instances across multiple data centers and OPS Manager (HA cluster), also worked on POC box on which it has Oracle and MongoDB together with MongoDB OPS manager installed and configured for developers and testing.
• MSSQL DBA, working on three internal security and performance application databases, manage the database upgrade and release implementation; performance tuning based on feedback form users and troubleshooting when in need.

Environment: Oracle 12c/11g/10g, Linux (Oracle 11gR1/R2 and Oracle 12c; Solaris (Oracle 11gR1) and windows (prior to Oracle 10g before 2014) MongoDB 3.0.9, 3.2.9, 2.6 MSSQL 2008, 2014, 2005 (clustering and DR with log shipping)

Tools: Oracle Cloud Control/Grid Control; DR solution with advanced Data Guard and GoldenGate; Embarcadero tools like DBArtisianShell scripting, batch file plus SQL scripting, some Python, Putty and Atom, UltraEdit SSMS for MSSQL databases. MongDB OPS for MongoDB monitoring and management.

Confidential

Database Administrator Oracle / Progress

Responsibilities:

• 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.
• 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.

Oracle Database Specialist

Confidential

Responsibilities:

• Data Integration
• Development, Performance Tuning and Reporting

Environment: Oracle 9i on Solaris 8 (PROD/QA/DEV); Merck global lab database centers.

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

Oracle DBA Programming Analyst

Confidential

Responsibilities:

• DBA, performance tuning, schema creation and maintenance (table, index, view), OS level jobs maintenance
• Development including data integration (ETL from other different data sources), SQL and PL/SQL programming on stored procedure, packages and triggers; Unix Shell Scripting
• 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
• GRDS(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 (eBay web-based application);

Oracle DBA & Programmer

Confidential, Parsippany, New Jersey

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 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, Elmsford, NY

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);
• 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

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.
• Programmer (10 yrs) with dBase/FoxBASE/FoxPro, C ANSI, COBOL; System Integration (application in LAN and WAN environment, Novell, 3Com network and window NT network), some exposure to Sun SPARC (web server, Solaris 4)