SUMMARY:

• Over two decades of proven experience in various IT fields, especially RDBMS databases architect, administration, development, project management, data analysis, statistics.
• 10+ years of hands - on experience with Oracle, SQL Server, MySQL, and other databases development, administration.
• 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 quantitative, analytical, assessment, troubleshooting, problem-solving on databases, servers, clients and related applications on all environments and platforms.
• Data Modelers for OLTP, OLAP, multi-TB Data Mart, Data Warehouse, BigData for relational and dimensional modeling.
• Design, develop, administrate ETL, GoldenGate, SSIS, SSAS, SSRS, AlwaysOn, Replicate, RAC, 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 admin, development of databases, and applications.
• Excellent presentation, interpersonal, coordination and communication skills, team player, leadership.
• 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.

TECHNICAL SKILLS:

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

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

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

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

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• As an architect, design, develop, sharding, Multi-TB BigData project, ETL from RDBMS and NoSQL resources, support BI developers & End User.
• 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.
• 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.

Confidential

Lead Sr. Database Architect & Administrator

Responsibilities:

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

Confidential

Lead Architect, DBA and Developer

Responsibilities:

• 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, GoldenGate, SQL Server, MySQL.

Confidential

Lead Architect & DBA

Responsibilities:

• 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 Oracle database RAC 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.

Confidential

Sr. Oracle Architect & DBA

Responsibilities:

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

Confidential

Sr. DBA

Responsibilities:

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