We provide IT Staff Augmentation Services!

Sr. Database Administrator Resume Profile

MD

QUALIFICATIONS SUMMARY

Li is a Senior Consultant in the role of Database Admin/Architect, Data Warehouse Architect, and Data Architect. He has 17 years of Information Technology professional experience in healthcare, federal government, and telecommunication industries. Li is specializing in areas of Oracle Data Warehousing Technology, Informatica ETL Technology, Oracle E-Business Suite EBS Application Technology, Oracle Database Technology, Unix Shell and Perl scripting, System Architecture, Technical Proposal, and Project Management. Li is the winner of Computer Sciences Corporation CSC 2008 President Award in the category of Career Achievement. He is an US Citizen and is clearable for TS/SCI Security Clearance.

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. Database Administrator/Data Architect

Project Summary:

Implement Marketplace Management Information Dashboard of Medicaid Performance Management System at Centers for CMS. The President Office at White House and senior executives at CMS are our end users. This dashboard is in MicroStrategy 9.3.1 business intelligence user interface and is on Oracle Database 11.2.0.3 Data Warehousing platform with data fed by ETL tool of Informatica 9.5.1.

Technical Proposal:

  • Principal contributor in writing up Technical Approach of the proposal to in responding to the
  • RFP Oracle and SQL Server Database Administration Support of CMS. Participate post Red
  • Team Review.

Data Warehousing:

  • Tune the performance of post-ETL-load process in PL/SQL stored procedures by using Divide-
  • and-Conquer technique with explicit customized Materialized views and the WITH clause of
  • implicit temp tables, and using swap and compile technique, which totally results 500X
  • improvement in performance.
  • Tune the performance of page loading time for State Detail page in Dashboard of Microstrategy,
  • with the practices of Divide-and-Conquer technique, results 300X improvement in performance.
  • Make SQL tuning enhancement request to Oracle Database Technology, which is accepted and
  • published by Oracle as Bug 17505178 DYNAMIC MATERIALIZED VIEWS COULD BE USED TO
  • MAKE QUERIES FASTER and is rated as Severity: 2 very desirable feature . 2013/09/24
  • Implement Range-Interval partitions, Hash partitions, and List partitions for tables and local
  • indexes in database.
  • Develop PL/SQL stored procedures for Business Intelligence reports, to bring data to present
  • in Dashboard, and to work with ETL mapping transformation processes during and after
  • loading.
  • Create tables staging, load control, error handling, dimension, and fact and indexes to work
  • with ETL mapping and transformation processes in Data Warehouse.
  • Design logical data model, create and maintain metadata of data architecture in Data
  • Dictionary.
  • Perform capacity planning and size estimation of Data Warehouse.

Confidential

Role: Sr. Database Administrator/Database Architect

Project Summary:

Li was responsible for the upgrade of Training environment of NIH Business Systems NBS for FY13. This upgrade included an Oracle EBS App 11.5.10 and Oracle Database 11.2.0.2, and a Sunflower Property Management App and Oracle Database 10.2.0.4.

Auto Config Utility:

  • Configured and debugged the auto config job, including concurrent manager, of Oracle EBS App on database server.
  • Troubleshoot issues of Oracle forms, re-published all forms' URL as part of Auto Config job does in database to resolve issue.
  • Startup and shutdown all components of Oracle EBS app on app server.

RMAN Utility:

  • Built FY13 Training Oracle App's database by restored from Production hot backup.
  • Performed cold backup, and built FY13 Training Sunflower Property's Oracle database by restored from cold backup.

Database Architecture:

Implemented Flashback technology in Oracle database to reduce backup time and increase system uptime by 100X in performance.

Role: Sr. Database Administrator/Data Architect

Confidential

Project Summary:

  • Deloitte was partnering with QSSI to provide Enterprise Identity Management EIDM solution for CMS. In this engagement, Li provided leadership services in data and database architecture of the buildup in EIDM systems and environments. The EIDM solution provided the Identity and Access Management Services for millions of CMS partners, providers, insurance exchanges enrollees, beneficiaries, and other CMS non-organizational users, as well as thousands of CMS employees, contractors, and other users in four main areas: Registration Service, Authorization Assistance Service, Access Management Service, and Identity Lifecycle Management Service.

High Availability, RAC:

  • Installed a two-node cluster Oracle Grid Infrastructure 11.2.0.3 with Automatic Storage Management ASM in Oracle Enterprise Linux OEL 6.2 Virtual Machine VM local environment.
  • High Availability, Active Data Guard:
  • Built a Physical Standby database with Primary on Oracle Unified Directory OUD database in Active Data Guard configuration with Oracle RMAN 11.2.0.3 active database duplication in OE Linux 6.2 VM in TerreMark cloud hosting environment.

Data Architecture:

Utilized Repository Creation Utility RCU to load OIM, OAM, and BI Platform schemas into OUD database in OE Linux 6.2 VM local environment.

Supervising and Management:

Supervised and managed a data architecture team of three members: two database administrators and one ETL developer to deliver the RAC and Active Data Guard in VM local environment and TerreMark cloud hosting environment.

Confidential

Role: Sr. Database Administrator/Database Architect/Data Architect/System Architecture Team Lead

Project Summary:

Li was the lead of the System Architecture team at Medicare Part D program in CSC. He had developed and implemented all the maintenance programs and scripts of Korn shell and PL/SQL in Production database systems. Li was at expert level deployed all the major implementation of High Availability Active Data Guard and RAC, Data Replication in GoldenGate and Streams, RMAN Utility in backup/restore/duplicate of database, Performance Monitoring and Tuning, Data/System Architecture, Logical Data Model Design Identity Management, in projects of Data Conversion and Migration, database administration, Security and Auditing, Project Management and Coordinating, Supervising and Management, and Technical Proposal.

Data/System Architecture:

  • Evaluated Oracle Identity Management OIDM 11g services of Oracle Fusion Middleware OFM 11g by installing and configuring Oracle Identity Management identity lifecycle management, approval workflow, self-service account request, password and role management , Oracle Access Management single sign-on, risk-based authorization , and Oracle Directory Services LDAP service integration, database user security on Oracle WebLogic application server.
  • Evaluating solution for management of infrastructure hardware assets, software licenses, and application modeling: Configuration Management Database CMDB , and the Discovery and Dependency Mapping by BMC Atrium. Installing and configuring Atrium product to perform Proof Of Concept POC test in a lab.
  • Evaluated solutions to improve database backup, restore, and replication in three vendors: the Light Speed by Quest, Recovery Manager by BMC, and storage based replication by EMC: such as SnapView, MirrorView, SanCopy, and RecoverPoint solutions.
  • Designed, installed, and configured Oracle Database 11.2.0.2 servers on IBM AIX operating environments for Facets 4.81 upgrade project. Defined and utilized industry standards and the best practices of data center for Oracle platform. Changed disk I/O mapping of Logical Unit Number LUN to Volume Group to Mount Point from 1 to 1 to 1 to 5 to 1 to 1 resulting I/O performance 1.5X gain, while keeping mapping of physical disks to LUN unchanged 7 1 to 1 .

High Availability, Data Guard:

  • Built 2nd Physical standby database to serve as reporting database: diverged this 2nd Physical Standby to be the 2nd Primary database, opened for read and write for reporting jobs in the morning, then flashed back and reverted back to the 2nd Physical Standby role in the night and roll forward by special incremental backup of Primary to converge the data on Oracle Database 11.2.0.2 and 10.2.0.4 platform.
  • Monitored and diagnosed performance issue of SQL Apply processes in Logical Standby, conducted tuning on SGA and processors at Logical standby system level, as well as add RELY primary key on Primary and unique indexes in Logical Standby database.
  • Built and converted 2nd Physical Standby into Logical Standby database with Standby redo log to provide reporting and Business Intelligence capability, in addition to high availability, in production to both clients.

High Availability, RAC:

  • Installed a two-node Oracle RAC in Sun Clusterware raw devices for PEGA application in test environment on Oracle Database 9.2.0.6 platform.
  • Utilized RMAN to duplicate PEGA production database into test database, both were in two-node RAC architect.
  • Conducted a test of Transparent Application Failover TAF in a two-node RAC PEGA production environment by shifting Load Balance from randomly to be selectively 100 and 0 .

Data Replication, GoldenGate:

Conducted Proof-of-Concept POC evaluation test on GoldenGate product by installing and configuring Extracted And Data Pump processes multi-parallel on source database server, and Replicate processes multi-parallel on destination database server for data replication, in both deferred apply mode and real-time mode. Extracted trail files size was 4X smaller than Archive logs.

Data Replication, Streams:

Evaluated and built Streams as a possible solution to replicate data and build a reporting database.

RMAN Utility:

  • Developed, implemented, and maintained database backup and recovery processes in Oracle RMAN for all environments, and ensures data integrity, security, and recoverability.
  • Improved performance of copying database backup from a NFS-mounted storage to tape by 6X. Installed NetBackup as media manager to work with RMAN, and rewrote backup/duplicate/restore scripts of RMAN to work with NetBackup command line interface, to directly backup database onto LTO4 tapes.
  • Proposed the 2nd product enhancement request of RMAN utility to run recover operation in parallel with outlined algorithm to Oracle Database Technology, which was accepted and published by Oracle as Bug 8905525 RECOVER OPERATION RE-DESIGN TO BE ABLE TO PARALLELLY APPLY ARCHIVELOGS and was rated as Severity: 2 - Very desirable feature . 2009/09/14
  • Proposed a product enhancement request of RMAN utility to be re-startable on backup operation to Oracle Database Technology, which was accepted and published by Oracle as Bug 7192808 RMAN ENHANCEMENT and was rated as Severity: 2 - Very desirable feature . Confidential

Performance Monitoring and Tuning:

  • Developed hundred applications in Korn shell scripts, Perl scripts, SQL and PL/SQL scripts to real-time monitor Facets and PEGA Production database resource usage inside database instances and resource usage on the OS level, such as resource waits and session waits, object locks, top CPU intensive SQLs, disk sort in TEMP tablespace usage, long running operations, memory usage in shared pool of SGA, host objects and hit ratio and usage ratio in buffer cache of SGA, memory stats and work area memory usage in PGA, Oracle alerts, database file growth, changes add/deletion , top CUP intensive OS processes, CPU resource usage and I/O wait resource metrics.
  • Utilized the above monitoring logs, together with Oracle Statspack reports, AWR reports, ADDM reports, Oracle Enterprise Manager OEM database console, and database IDE tool TOAD, to diagnose root cause of performance issues and the top SQLs.
  • Improved 480X performance gain in a top SQL of Billing Export job from 40 hours elapsed time down to five minutes of 288X performance gain in a top SQL of SXC job from more than 24 hours reduced to five minutes of 144X performance gain in a top SQL of MAXM job from 12 hours run down to 10 minutes of 90X performance gain in a top SQL of KLS job from 15 hours elapsed time down to 10 minutes.

Logical Data Model Design Identity Management:

  • Designed database logical model for the project of Identity Management IdM and Access Management in Oracle Application Express APEX to support Information Security and User Provisioning in multiple/union clients, resulting about 30 tables in database to support this application.
  • Designed the overall process flow for this IdM system and application.

Data Conversion and Migration:

  • Supported converting one million members with 450K active ones from Instill application to Market Prominence application in Oracle database for Health Net client.
  • Supported converting 700K active members from Facets 4.21 on third party host Sybase database to TriZetto Facets 4.31 Oracle database at CSC for Universal American client.
  • Configured heterogeneous database link from Oracle to Sybase database by configuring Oracle Database Gateway service 11.1.0.6 on the gateway server which chosen on Sybase database.

OLTP Database Administration:

  • Installed, upgraded and patched Oracle Databases 10.2.0.4 to 11.2.0.2 and associated Oracle products and applications. Managed, monitored, and tuned Oracle Database 11.2.0.2 databases and applications.
  • Converted Enterprise Edition to Standard Edition of Oracle RDBMS software in non-Production and non-Performance-Engineering environments to save cost on Oracle license, by utilizing expdp/impdp Transportable Tablespace feature to retain database files across different edition of Oracle database instances.
  • Upgraded Oracle Database 9.2.0.6 to 10.2.0.4 and raise database compatibility to 10.2.0.4 in PEGA application for both Health Net and Universal American clients.
  • Installed Oracle Enterprise Manager OEM Grid Control agent, configure and control OEM Grid Control server and agents, and administrate Oracle Database 10g in OEM Grid Control.

Security and Auditing:

  • Generated audit reports and provided evidence logs to support SOX auditing, and Ernst and Young auditing.
  • Implemented CSC enterprise strong password policy into Oracle password verification function and enabled audit session in production database for both Universal American and Health Net clients.

Project Management:

  • Managed the Security Remediation project within the System Architecture team for a large complex project to quarantine the network segments which served two programs New York Medicaid program and Medicare Part D program to be isolated from CSC corporate business unit network BUN in a six months duration. Managed people resource including three off-shore teams and two on-shore teams to support four implementation phases. Communicated and educated staffs in Medicare Part D organization with the changes and impact of this project. Served as a liaison between the network change delivering project management team and the Medicare Part D program.
  • Managed the Facets conversion project within the System Architecture team for a large complex project to migrate Production servers to a new farm of servers and upgrade Facets to 4.81 and Oracle Database to 11.2.0.2 releases in an eight months duration. Developed work breakdown structure WBS to schedule work packages and activities and composed project plans, conducted process analysis and established process improvement plan to enhance Facets conversion performance by 30X, developed and established issue logs, and the hour by hour deployment plan for cut over activities. Managed people resources to deliver project within scope and schedules. Presented team status in weekly key shareholder status meetings and steering committee meetings.
  • Managed the Facets Re-Host project within the System Architecture team for a moderate complex project to transit all infrastructure services on Citrix web servers, Batch Application servers, and Facets and Pega database servers from CSC to TriZetto in a six months duration. Established improved processes in daily archive log backup, network performance and FTP. Developed communication plan, and the hour by hour deployment plan for cut over activities. Managed people resources to deliver project within scope and schedules.

Supervising and Management:

  • Developed and established Enterprise Environmental Factors, Organizational Process Assets, and System Architecture Repository to manage people, processes, and technology of the team.
  • Developed and established System Architecture Monthly Dashboard to measure performance metrics including Achievement Metrics Issues Log Metrics Risks and Response Strategy Metrics Human Resource Metrics and Portfolio of Projects Metrics.
  • Constructed Work Breakdown Structure WBS for the team and standardize it across functions for Department of Technical Operations. Produced Work Force Planning WFP to manage skill sets and productivities of the team.

Technical Proposal:

  • Composed multi-million dollars technical proposals, the Price Models of IT Service infrastructure, to bid for new business clients Coventry, Blue Cross Blue Shield Michigan, Universal American Financial Corp, Health Net, and more in Government Health Care industry. Included infrastructure architecture building plan of hardware, software, licenses, data storage with prices listed and implementation plan in phases with labor hours and prices estimated.
  • Enhancing technical proposal as a tool for pricing IT service infrastructure in dynamic platforms.
  • Involved in answering Request for Proposal RFP and writing Statement of Work SOW .

Confidential

Role: Lead Oracle DBA

Data Warehouse:

  • Migrated legacy grant systems into EIG grant application and tracking data warehouse system.
  • Investigated and debugged ETL process, which utilized Associate Array, Nested Table, and V-array collections of Record collection data structure in PL/SQL, in ODS data warehouse to fix production data issues.

Confidential

Role: Lead Oracle DBA

Data Warehouse:

  • Maintained SSP Performance Metrics data warehouse in production and development systems: monitored ten-minutely and daily sync ETL processes by orchestrating Korn shell scripts with PL/SQL and SQL coding. Created warehouse system in development UNIX server, including all database objects, applications, and ETL process source code of Korn shell script, Java and XML programs. Conducted performance tuning in directory structures and source code in both of production and development UNIX servers to eliminate code complexity and increase ability to maintain.
  • Developed and implemented NATB data warehouse including: designed logical database models, created and configured physical database instances, created database users and objects, developed ETL process between source databases and NATB by orchestrating Korn shell scripts with PL/SQL and SQL coding.
  • Provided proposal on solution on size of data growth in CMS database. Designed and developed CUSTAO data warehouse with ETL applications to periodically archive inactive customers from CMS into CUSTAO to further archive data from CUSTAO into external storage and to restore data from external storage back into the CUSTAO. Developed ETL processes between CMS and CUSTAO by orchestrating Korn shell scripts with PL/SQL and SQL coding to create admin user to create database links and objects such as tables, indexes, constraints, sequences, synonyms, stored procedures and packages, triggers, roles and privileges to use big rollback segment to handle exceptions to export/import data to perform hot backup and logical backups before and after application executions to periodically perform cold backup with TAR to coalesce tablespace to auto-extend data files to re-build indexes to truncate tables and to use range and hash partitions. Packaged code and documented implementation procedures, supported all phases of software engineering lifecycle including unit test, system integration test, production implementation and maintenance support.

OLTP Database Administration:

  • Installed and configured Oracle9i/8i/8 software on Sun Solaris 9/8 platforms, documented instructions, supported all phases of software engineering lifecycle including unit test, system integration test, production implementation and maintenance.
  • Created and configured physical database instances, developed Korn shell and SQL scripts and packaged codes with instructions. Applied patches and patch sets to Oracle9i software. Upgraded Oracle901 to Oracle920 software by method of installing software and re-creating databases. Upgraded Oracle816 to Oracle920 software by method of two direct upgrades.

Performance Monitoring and Tuning:

Administrated database operations by developing and utilizing PL/SQL and SQL coding which orchestrated in Korn shell scripts. Conducted performance tuning on database applications, database SGA memory and system with EXPLAINPLAN, SQL Trace, TKPROF and adjusting Semaphores and Shared Memory parameters in UNIX system file on Solaris 9/8 platforms.

Technical Proposal:

Provided proposal on solution of database system's high availability by comparing methods of Oracle9i Real Application Cluster, Advanced Replication, and Data Guard and Standby Database. Provided level of effort and documented proposal for Oracle software upgrade. Provided database backup, restore and recovery plan on OLTP and Data Warehousing databases.

Logical Data Model Design:

Designed and normalized RDBMS logical data models with ERwin on the merging of DSL Order Entry/Registration database and DSL Online Order database.

Data Conversion and Migration:

  • Migrated database user and objects in Loop Qualification database from one Solaris platform into Verizon Online Service database on a second Solaris server utilized SSH, key generation, and SCP for data transfer in UNIX.
  • Merged DSL Reconciliation database into DSL Online Order database in MS SQL Server on NT platform. Utilized Visual Basic scripts to export data from DSL Reconciliation database and import data into DSL Online Order database. Developed Transact-SQL scripts to clean up duplicated records and archive inactive records to modify table structures before merge, such as updated data value, altered tables to add and rename columns, and added identity to perform the merge by inserts to modify table structures after merge, such as dropped columns and enable triggers
  • to refresh all stored procedures, triggers, and re-grant privileges. Documented implementation
  • instructions, supported all phases of SDLC including unit test, system integration test, and
  • production implementation.
  • Migrated two DSL Online Order databases in MS SQL Server on NT platform into two Oracle920 databases on Solaris 9 platform. Created and configured Oracle920 database instances, created admin and application users and database objects utilized DTS and BCP in MS SQL Server to generate data dump developed Korn shell and SQL scripts to FTP data, to generate SQL Loader control files and to load data into Oracle databases converted stored procedures and triggers in Transact-SQL of MS SQL Server into Oracle PL/SQL with utilization of dynamic SQL, temp table, cursor variable, reference cursor, and performed application level stored procedures testing in Java.

Confidential

Role: SAS Programmer/Oracle DBA

  • Administrated and maintained daily Oracle8 databases operation. Managed data files and disk space usage. Supported development and operation of database applications such as online contracts, IVR, and wireless phone ESN mismatch.
  • Developed PL/SQL and SQL programs to manipulate data in Oracle8 databases of wireless customer and call usage, and database of billing and revenue, to generate files feeding for web applications and generate reports and mailing labels.
  • Developed UNIX Korn shell scripts to control jobs, utilized PGP for data cryptography on the internet, and scheduled cron jobs.
  • Proposed and completed a Data Warehousing project to improve performance on IBM/MVS to 10X by modifying logics of data processing and efficiently extracting data in SAS and JCL codes.

Confidential

Role: Research Assistant

  • Simulated large failure time datasets for Finite Exponential Mixture Models FEMM , developed sequence of statistical methods EM algorithm, Minimum Chi-Square method and ML Estimation to obtain estimators of parameters in FEMM models by implementing numerical optimization methods in C and MATLAB.
  • Controlled MATLAB processes by implementing Bourne shell scripts to enable automatically execution through all classes of datasets. Designed Bourne hell scripts in UNIX to manipulate output datasets and summarize results, generate tables and graphics in LaTex and MATLAB.
  • Concluded modeling, theory and proofs, estimation algorithms, processes and results analyses in the master thesis in LaTex.

Confidential

Role: SAS Programmer

  • Transformed SPSS codes into SAS. Implemented SAS programs on UNIX to manage nutrition data sets, conduct statistical analyses and generate reports.
  • Applied C language to code a general menu for nutrition handbook.

Confidential

Role: SAS Programmer

  • Converted raw data stored in LOTUS spreadsheet into plaintext via QUATTRO PRO.
  • Designed SAS programs on PC and conducted statistical analyses in a project for the Department of Meat Science, ARS, USDA, Beltsville, MD.

Hire Now