Siji Yu

Email: acxgpe@r.postjobfree.com Phone: 646-***-****

SUMMARY:

Over two decades of proven experience in various IT fields, especially in databases architect, administration, development, Deep Learning, data analysis, statistics.

10+ years of hands-on experience with Oracle, SQL Server, MySQL, and other databases administration, development.

Lead Sr. Develop DBA and manager for whole enterprises’ databases in recent over nine (9) years without unplanned down time, on 24/7/365 availabilities.

Lead Sr. DBA for databases, ERP, EBS, OFSA, and other 3rd parties’ applications, for various corporations.

Proficient at time, priority management with multi-tasking.

Provided operations support to resolve issues proactively and with utmost urgency.

Provided leadership in the planning, coordination, and related activities associated with the design, development, implementation, support of database management systems and applications.

Hands-on experience in installations, configurations, administrations, patching, migrations, cloning, upgrading, troubleshooting databases on Development, Productions, Customer supports, QA, UAT, Benchmark Test, and POC environments.

Made new features of SQL Server 2016 to prior versions of SQL Servers via CLR .NET.

Provided great results with databases performance tuning and related OS (UNIXs, Linux, Windows), capacity planning, optimize SQL queries, stored programs, and applications.

Fine-tuned analytical, assessment, troubleshooting, problem-solving on databases, servers, clients and related applications on all environments and platforms.

Data Modelers for OLTP, OLAP, multi-TB BigData for relational and dimensional modeling.

Design, develop, administrate ETL, SSIS, SSAS, SSRS, AlwaysOn, Replicate, GoldenGate, Active DataGuard, etc.

Convert, sync databases among Oracle, SQL server, MySQL, etc.

Defining and acting on opportunities to increase operational efficiency & overall system availabilities and working closely with teams of development, QA, customer support, production.

Plan, develop, implement, and maintain databases D.R. procedures, with periodically recovery drills, including regular backups, clones.

Provided industry best practices and regulatory requirements to lead development, QA, production teams on issues related to the design, development, implementation, maintenances, proactive monitoring, while ensuring data protection and security.

Establish, implement, admin DB security, TDE, Redaction, TCP/IP SSL/TSL,, Oracle's DB Vault, Key Vault, Audit Vault, DB Firewall, Unified Audit, etc.

Self-starter, self-motivated to conduct research, determine issues, identify solutions and proposed business/technical solutions to senior management and implemented approved timely detailed action plans for high priority, multitasking, excellent customer service orientation.

Prepared Technical Analysis, Capacity Planning, Architecture & Upgrade Assessment proposals and plans for clients to implement databases and applications.

Oracle Financial Application (EBS) Migrations and upgrade.

Implemented, Managed databases TDE with PCI compliance. Audit databases accesses and various activities for security and audit compliance.

Linux/Unix and DOS scripting, automation of proactively monitoring, alert and balancing workload for databases environments.

Agile and Scrum management, TFS, and version control process.

Establish, administrate version control in Subversion, Git, TFS, for databases and applications.

Excellent presentation, interpersonal, coordination and communication skills, team player, leadership.

Participate in hiring activities and ensuring compliance with the equal employment opportunity policy.

Highly responsive and alert to new learning opportunities, growth and development of technical, interpersonal and business skills.

Self-Motivated and competent to develop objectives and timelines to accomplish goals.

EDUCATION:

M.S. Computer Science & Information Technology,

City College of CUNY

M.S. Industrial Engineering & Operational Research,

New Jersey Institute of Technology

EXPERIENCE:

2014 – Present Major IT Consulting Corp.

As a BI architect, design, develop, sharding, Multi-TB BigData project, Deep Learning applications.

As a database developer & administrator, designed, developed and implemented OLTP databases performance improvement, archiving, efficiently utilized cloud subscription.

As a architect for SaaS project, be responsible for system architecture, capacity planning, design, development, tests, etc.

Migrated on-premise systems to AWS, cloud environments.

Enhanced version control for databases and applications, streamlined support and deployment procedures, QA, UAT, Production, and policies.

Timely provided solutions by troubleshooting and finding out root causes for customer support issues on various productions, increased and secured millions in revenue.

2013 – 2014 The Knighted LLC, software company.,

Lead Sr. Database Architect & Administrator

Full responsible for Oracle, SQL Server, DB2 i5/OS for WMS, BI systems.

Timely and fully support, closely work with development and QA Teams.

Full support for customers’ production systems, troubleshooting, performance tuning, backup, proactive monitoring.

Capacity planning, architectural design and benchmark test for systems for new customers.

2008 – 2013 NY Telecom. Inc.,

Lead Architect, DBA and Developer

Provide 24/7/365 support to Production environment for whole enterprise’s databases around the world.

Eliminated unplanned downtime for all databases, in addition to increase performance and utilized new features, collaborated with develop, QA teams.

Installation, configuration and administration Oracle RAC, Data Guard, Streams and GoldenGate, SQL Server, MySQL.

2007 - 2008 Liberty Travel Inc.,

Lead Architect & DBA

Provide 24/7 support to Production/Dev/QA environments for Oracle, SQL Server databases on multi-tier OLTP Web applications, ERP/EBS in RAC, and VL Data Warehouse.

Upgrade RAC Oracle database from 9i to 10g under UNIX (HP-UX) and Linux platforms.

Coordinated with Business and developer teams on upgrading EBS and other apps on RAC configuration and HP Superdome.

1998 - 2001 Oracle Corporation

Sr. Oracle Architect & DBA

Principal Financial Consultant for various major International Financial Institutions in the United States and overseas.

Performance Tuning on Operation Systems, Oracle database servers, Oracle Applications, Data Warehouse (multi Terabytes) and Applications with OWB on Oracle multinational financial institutions' sites around the world.

Build, Clone and Manage POC, Development, UAT/TEST/QC and Production of OFSA (Data Warehouse) Systems, Oracle Financial Applications (EBS), and other applications.

Conducted Benchmark tests and Scalability with multi Terabytes database size for major U.S. financial firms in conjunction with IBM, Sun and EMC.

Systems Design with Sun, HP, IBM & EMC and all these servers and storages Integration & Testing.

Provided mentoring to clients' DBAs in the installation, configuration, upgrade, implementation, performance tuning, etc.

1995 - 1998 CitiBank N.A.

Sr. DBA

Project plan and management for design, development, deployment and maintenance of Banking Information System (OLTP) with ORACLE RDBMS including logical and physical database design, business function modeling, performance tuning, SQL optimizing,

PL/SQL stored procedures developing, security managing, Oracle server installation, configuration, patching, upgrading, ETL from mainframe, and SAS, coding PL/SQL programs as a project leader and Oracle DBA and developer.

Designed, developed Banking IS for QC and Marketing Research with ORACLE, SAS, Excel & VBA under Solaris & NT environment.

Provided significant value-added new features to the IS Quality Improvement.

SKILLS HIGHLIGHT:

Databases and others: Oracle, SQL server, MySQL, AS400 DB2, PostgreSQL, Hadoop, Tensorflow, AWS, ERwin, Toad, RedGate, AS, IIS, WebLogic, etc.

OS: Linux, UNIX (HP-UX, Solaris, AIX), Windows.

Languages: PL/SQL, T-SQL, SQLs, Python, C++, UNIX/Linux Shell and DOS Scripts, C#, Java, VBA, SAS, SSIS, SSRS, Perl, etc.

Life Cycle: Full project life cycle of enterprise level of database & application systems design, development, test, deployment, implementation and maintenance.

HONORS/ACHIEVEMENTS:

Evaluated at A plus performance ratings many years.

Project Quality Control Award by Citicorp Quality Council.

Graduated magna cum laude from University.

Awarded at Calculus Competition at University.

Contact this candidate