SUMMARY:

• A senior database team manager with 18+ years extensive leadership skills in strategic planning, process optimization, database solutions design, team - building and staff mentoring, project management, budgeting and cost control, vendor negotiation and management;
• A very hands-on senior database architect and administrator with expertise on Oracle, SQL server, Sybase, MySQL, AWS RDS on data modeling/architecture, conceptual/logical/physical design, installation/configuration, database operation management, performance tuning, advanced troubleshooting, capacity planning, high availability, disaster recovery, on premise database migration to cloud;
• Very strong technical skills in Big Data and Enterprise Data Warehousing architecture design, dimensional modeling, star schema, ETL, OLAP, data mining, and business intelligence (BI);
• Extensive IT infrastructure management experience with cloud computing (AWS, Azure), virtualization, data center management, UNIX (Solaris, HP-UX, AIX)/Linux/Windows platform, storage SAN and NAS, and network administration;
• In-depth knowledge and experience of enterprise resource planning (ERP) system implementation and customization with SAP and Oracle E-Business Suite;
• Excellent verbal and written communication, coordination, presentation, and interpersonal skills;

TECHNICAL SKILLS:

Oracle: Oracle Database 7/8/8i/9i/10g/11g/12c, Exadata, ODA, RAC, ASM, RMAN, Data Guard, Golden Gate, RAT, Data Pump, SQL*Loader, AWR, ADDM

Sybase: Sybase ASE 11.9/12.0/12.5/15.7, Sybase Replication Server 12.6/15

SQL Server: SQL Server 7/2000/2005/2008/2012/2014, DTS, SSIS, SSRS, SSAS

AWS: RDS, DynamoDB, Redshift

Infrastructure: Cloud architecture (AWS, Azure), Virtualization (VMWare), Data Center Management, UNIX (Solaris/HPUX/AIX)/Linux(Redhat/Oracle/Amazon), Windows Servers, Veritas Netbackup, Cisco Tidal, CA Autosys, EMC Symmetrix/VNX/VMAXe, NetApp storage

ITSM: ServiceNow ITOM, ITSM, ITBM

EDW/BI: Informatica Power Center, Oracle Warehouse Builder, Oracle OLAP, BusinessObjects, Microsoft Analysis Services

ERP: SAP Basis Administration, Oracle E-Business Suite

Software Engineering: Java, C/C++, XML, HTML, Perl, Shell scripts, PL/SQL, SQL, T-SQL

Project Management: PMP

Tools: Oracle OEM/Database Express, Quest TOAD/Spotlight/Performance Analysis/Foglight/Shareplex, Solarwinds DPA, Lab128, Hotsos SQL Profiler, Oracle SQL Developer, PLSQL Developer, Sybase Central, Bradmark Surveillance DB, Whitesand Proactive DBA, ExactSolutions iWatch, SQL Server Management Studio, Idera SQL Server Management Tools, Tidal Enterprise Job Scheduling, CA Autosys, PVCS, Star team, Accurev, Remedy, Symantec Service Desk, Altiris, JIRA, Remedy

PROFESSIONAL EXPERIENCE:

Database Team Manager/Senior DBA

Confidential

Responsibilities:

• Built Oracle database platform on 11gR2 RAC and migrated single-instance databases to Oracle RAC and ASM;
• Deployed production databases on Oracle Exadata (X3);
• Migrated and consolidated databases to Exadata (X5) platform from X3 and HP Blade servers;
• Upgraded Oracle database environment from 10g/11g to 12c;
• Automated routine database administration tasks such as space provisioning, performance monitoring, backup/restore/recovery, data dump, AWR/ADDM reports generation;
• Implemented Oracle database backup and recovery solutions using RMAN;
• Set up DR site by using Oracle data guard;
• Set up Sybase ASE 15.7 database clusters;
• Built new Microsoft SQL server 2012 database platform and upgraded existing 2003/2008 databases to 2012 on Windows and SQL server cluster;
• Performed database performance tuning and advanced troubleshooting;
• Developed checklist and runbooks for database administration tasks;
• Provided 24x7 on-call support on rotation basis;
• Managed a team of 15 onshore and offshore Oracle/SQL server/Sybase/DB2 database administrators and Linux admin;

Senior Database Architect and Administrator

Confidential

Responsibilities:

• Built multi-database platforms including Oracle, SQL server, and Sybase to support different business functions;
• Implemented highly available 4-node Oracle database clusters by using Oracle RAC and ASM;
• Set up DR site by using storage replication (EMC SRDF and RecoverPoint), Oracle Data Guard, Sybase Replication Server, SQL server logging shipping;
• Designed homogenous and heterogeneous database replication environments among global offices (UK, US, Singapore, Geneva, Japan) by using Golden Gate, Quest Shareplex, Oracle streams, and Sybase replication server;
• Architected enterprise data warehouse (EDW) and business intelligence (BI) solutions by using Informatica Power Center, BusinessObjects, Microsoft Analysis Services (SSAS) and Oracle database features (Star Schema, Partitioning, Parallel Operations, Bitmap Indexes, Analytic Functions, Materialized views );
• Performed the advanced root cause analysis (memory dump, lock/latch/mutex, hang analysis) and performance troubleshooting by using 10046/10053 SQL trace, ORADEBUG, TKPROF, OS trace (DTrace, STrace), profiling, SQL tuning (Execution Plan, Index, Statistics, Histogram, Hint, Outline, Profile, View Merging, Join Order/Method), and database/instance tuning (Stats Pack, AWR, ADDM, ASH, Advisors);
• Built Microsoft SQL server database platform on Windows cluster environment and managed all aspects of database administration including daily operation support, backup/recovery, data transfer, deployment, and real time production issue resolution; Diagnosed and addressed database performance issues using performance monitors and SQL profiler and other 3rd party tools;
• Set up Sybase ASE database environment on Linux platform for oil trading business; Configured Sybase replication server between Sybase and Sybase database, Sybase and Oracle databases;
• Streamlined and consolidated the data center monitoring functionalities to cover the whole IT stack such as hardware (server, storage, network), OS, databases, middleware (application server, web server, messaging systems), and application layers by using Oracle grid control/Oracle Enterprise Manager;
• Built and managed the global database team and oversaw teams delivering development to attain 99.99% system uptime;
• Developed policies and procedures in collaboration, information sharing, database administration, disaster recovery (DR), and business continuity plan (BCP) based on industry best practice;

Oracle EBS Database Administrator

Confidential

Responsibilities:

• Managed Oracle E-Business Suite databases including Account Payables, Account Receivables, Bills of Materials, Cost Management, Sales and Marketing, Human Resources, General Ledger, Work in Progress, Inventory, Order Entry, and Manufacturing;
• Performed Oracle database server and network installation, configuration, and administration;
• Migrated and upgraded databases from Oracle 6 on Sun to Oracle 7 on HP-UX;
• Set up a DR site and backup solution by using Oracle physical standby technology;
• Conducted and automated daily database administration routine job (instance management, space monitoring, security and auditing, schema objects and data integrity, and Oracle network management);
• Performed database logical and physical backups (cold backup and hot backup, export, import) and disaster recovery;
• Conducted database performance monitoring and optimization including database server and SQL performance tuning;
• Developed application programming interface (API) units by coding packages, procedures, functions, and triggers using SQL and PL/SQL.
• Performed AIX UNIX system administration, Oracle database and Oracle financial application software installation, upgrade, and migration;
• Performed comprehensive assessment of the financial computing environment for the entire company;
• Provided 24x7 level-1 technical support and troubleshooting for production staff and business analysts