Summary:

• Senior Database Administration includes database process efficiency, managing system resources and performance, database software versions and application support. Setting and documenting operational standards, migration standards, naming standard and technical standards.
• Support applications include e-Commerce B2C, B2B, Portal, CSR , order process, data warehouse Cognos and Business Process Management PEGA .
• Database infrastructure projects include replication, Data Guard, RMAN, RAC and others automate code promotion, backup recovery .

Technical Skills:

• Databases: Oracle 11g, Sybase, Informix, DB2, MS-SQL.
• Tools and Technology: Oracle RAC, RMAN, Data Pump, Dataguard, Performance Tuning -AWR, ADDM, SQLT, Quest PA.
• Languages: SQL, PL/SQL, UNIX Shell Scripts
• Operating Systems: UNIX IBM AIX, HP UX , Linux, z-Linux, MS-WINDOWS, MVS.

Experience:

Confidential

Senior DBA

• Responsible for upgrading Oracle 10g to Oracle 11g and cross platform migration of databases from HPUX to AIX using transportable databases.
• Reduced maintain and run costs by consolidating databases on AIX platform.
• SQL Performance tuning using SQLT, AWR and ADDM.
• Oracle 11g RAC setup on AIX for mission critical databases.
• Create ETL process to migrate/merge/convert marketing data provided by outside vendor to load into in-house databases.
• Disaster Recovery documentation and testing. Automated database refresh procedure.
• Standardized Oracle Patching and Installs using automated shell scripts and silent installs.
• Production support to manage user access, database changes and trouble shoot resolve issues of database functionality and performance.
• Support CRM applications requirement in merging data from various sources to create report to analyze market and sales activity.
• Developed database Runbooks and install cookbooks for the DBA team.

Confidential

Sr. Database Administrator

• Worked as System DBA and Primary application DBA to support OLTP / Web based applications and OLAP / DSS / data mining applications:
• Applications include B2C, B2B, Portal, CSR, Pharmacy backend process, Automate order process, data mining and datawarehouse with COGNOS vendor software, Business Process Management with PEGA vendor software.
• Standardize and perform procedures for DBMS software installation and upgrade/migrate database through releases/patches of Oracle 8i, 9i, 10g and 11g,
• Migration of Oracle databases from HP-UX to IBM AIX servers, MySQL on Window to Oracle on AIX, SYBASE/INFORMIX to Oracle.
• Converted UNIX scripts from HP-UX to IBM AIX 5L that monitor, collect stats, backup and restore databases and monitor UNIX file systems.
• Enhanced HARVEST migration tool to include migration of stored procedure as part of program versioning control,
• Collaborating with application developers to implement/pilot new applications, improve query performance and ETL procedures for OLTP, Portal, Internet and DSS/data mining systems that involve various vendor software, such as, PEGA, Cognos, Alfresco, BroadVision, Hyperion, Genesys, HARVEST and others.
• Use RMAN to clone database to speed up PEGA implementation for different line of business and keep PEGA release version consistent.
• Designed Dimension Tables and Fact Tables with partition for database in Cognos to support data mining and marketing application.
• Reviewed and tuned SQL used in reporting and ETL process for better performance.
• Compared SQL BackTrack and RMAN then integrated both technologies with Exp/Imp, DataPump for backup and restore strategy.
• Studied and proposed High Availability and load balance solutions. Created and setup Oracle Advanced Replication databases for Active-Active production environment.
• Installed Oracle 11g Enterprise edition on AIX/Linux database servers and Oracle clients on application servers.
• Deployed and configured 11gR2 RAC database with ASM on two Linux servers nodes .
• Created physical standby databases for QA and production environments utilizing Maximum Availability / synchronous mode. Configured and setup Standby Fast Start Failover / observing process / service name with FAN.
• Modified Oracle Startup and Shutdown scripts to accommodate Dataguard databases, OEM/Grid agents, detect and resolve hung database condition at shutdown and startup.
• Determined listener names in setting Dataguard configuration standard to minimize changes to existing monitoring scripts.
• Supported WebSphere eCommerce setup / deployments.
• Implemented data pump script using database link to sync up secondary staging database.
• Implemented data pump script using to backup database structure of dimensional database and Cognos metadata.
• Implemented Dataguard monitoring scripts to monitor gaps of applied logs, database primary/standby role change, blocking session and etc.
• Implemented change management process. Supported development teams located off-shore in different countries and managed / coordinated massive database change requests from various teams in an efficient way.
• Generated DMP files and prepared step-by-step documentation for production installation at off-shore Germany/India sites.
• Proactively monitoring production databases through GRID and regularly generated AWR reports to be compared with baselines.
• Provided database technology and design necessary to achieve the objectives and plans of every year strategic project portfolio ensure the production deployment of the database environment is optimized, measured and maintained in a manner that minimizes resources while providing stated service levels.
• Programmed various database monitoring scripts including backup, invalid objects, alert log errors, deferred transactions using Unix Shell and scheduled cron jobs.
• Implemented capacity planning process/procedure to prevent production outages.
• Participated oncall rotations to support 24 7 critical production database systems including databases in RAC, ASM, or Data guard configuration.

Confidential

Supports a Client/Server Decision Support System implemented on DB2, SYBASE UNIX and M/S SQL NT database platforms. Design logical / physical database, implement UNIX scripts and FTP procedures to automate transferring data from DB2 to Sybase and prototype executing query across platforms using ODBC, Sybase NetGateway, VB/ACCESS/Power Builder.

Prior Experience:

Database Administrator -

Application Developer - Confidential

• Support SYBASE on DEC/VAX platform, MDI DB2 Gateway on network platform and DB2 databases on MVS.
• Establish DB2 design/operation standard and object/dataset naming standard.
• Reverse Engineering and Data Architecture Analysis using Bachman Case tool to create Logical / Physical DB Model and create DB2 database accordingly.
• Manage resource and performance. Analyze PM reports and DB2catalog.
• Manage MVS and DB2 software versions, SMP/E.
• Supports DB2 application development and production availability.
• Install and maintain DB2 and Case tool software, FOUNDATION1.