SUMMARY:

20 years working experiences in information technology Industry, which include 6 years DB2, Tivoli, Lotus Notes technical support on Open System Unix/NT in Confidential, 14 years DB2 DBA on Unix in two years C programmer experience and some Oracle DBA experience.

COMPUTER SKILLS:

DB2/UDBLotus Notes/DominoAIXWindows server, Windows 7 OS/2 Warp DB2 Connect Solaris TCP/IPNETBIOSSNMPTIVOLI

ORACLEACCESSSYBASEODBCUNIX (KORN) SHELL

PERLC/C++JAVANETVIEWWebsphereSQL

SSL Foglight LotusScriptsMQSeriesFTPTELNET

DNSLinuxAutosys SQL Replication Q - Replication

WORKING EXPERIENCE:

Confidential, Jersey City, NJ

DB2 DBA

Responsibilities:

• Worked in online banking environment, DB2 is running on Linux/AIX platform.
• Support applications like profile, payment, message, alerts management which using DB2 database as backend database
• Working in DB2 V9, V10, V10.5 OLTP, High availability through HADR or SRDF.
• Using Qrep to sync profile data between different databases.
• Setup, monitoring, troubleshooting data replication using Qrep.

Confidential

Senior DB2 DBA on AIX/Linux/Windows

Responsibilities:

• Application DBA as well as provide third line production support for production DBA.
• As application DBA, we provide DBA expertise in project development, contribute DBA expertise on architecture design, perform logical and physical database design, SQL tuning and database configuration performance tuning and mornitoring. ( monitoring whole DB system performance like CPU and I/O memory usage status using vmstat or iostat, monitoring database performance like memory usage, lock status, application transactions through db2 snapshot, db2 admin view and table functions,DB2 utilities like db2pd, db2top).
• I also setup data synchronization using IBM SQL replication between two applications to performing near real time replication which including replicate CLOB data. I also tested the replication time in DEV environment using production volumn to test the CLOB data replication performance impact.
• I’m responsible for one core banking application--- branch sales and service application, which is used by all the branches. It is a complex system, since it is not only had transaction system function, also had analyse function in the application. So, we had couple databases to provide this function, which involved a lot of stored procedures, some triggers and quite complex SQL tunings.
• Explore and research Puresacle technology in our environment, get onsite training on purescale from IBM expert, setup Sandbox for proof of concept for the purescale technology.
• I kept on improving DBA work, like using new DB2 features to reduce database maintenance windows(online reorg), improve database response time(auto runstats) and enhance database availability (integration with foglight monitoring tools to prevent database issue).

Confidential

Senior DB2 DBA (V9.1,9.5) on AIX/Linux/Windows

Responsibilities:

• Responsible for database production support and maintenance.
• Application is 24*7 Online Banking Application. The environment is three tier environments, Application Server is called FFI—java based vendor Software, hosted by IBM Websphere Server, backend is DB2 UDB database in AIX. I’m responsible for database capacity planning, database maintenance and troubleshooting, database backup using EMC legato server/ NAS device later. The database servers are running on clusters with failed over functionality. We use VERITAS software to replicate data from production side to Disaster Recovery Server side.The data is async replicated.
• Support Enterprise Reporting database warehouse environment, which running on 4 physical nodes, 26 partitions, the database around 3 TB. Provide DSS support for the user.
• Also support other DB2 servers across multiple platforms, (Linux, Solaris, windows) applications including Content Management (CM), CMOD, ITIM, PASSMARK.
• DB2 on windows is cluster environment.
• Support connection to mainframe database through DB2 connect gateway server.
• Use Database federation functionality to transfer data across different DB2 environments.
• Write Perl, shell scripts for daily database admin activity.
• Troubleshooting and performance tuning for the database issue.
• Monitor database using CA DB2 database monitor modules
• Build new database, design physical database model, and implement physical database objects based on ERWIN model (ER Diagram).
• Performance tuning for the new database, including tuning configuration parameters, tuning query based on the DB2 explain and use MQT, MDC to increase the query performance, using db2pd, db2dart tools to troubleshooting.
• Setup database security policy. .
• Database capacity planning.
• Database backup and recovery design using TSM (Tivoli Storage Manager).
• Database production support and troubleshooting.
• DBA support for ETL developers and support for interface with AB initio ETL tool.
• SQL query tuning through explain and using Query Patroller(DB2 Workload Manager) to investigate and filter out expensive SQL.
• Automate monitor activity by UNIX scripts and Perl scripts, writing triggers and stored procedures to strengthen business rules and optimize applications development.
• Oracle database development and implementation for FRS system.
• Oracle database backup and recovery planning.
• Oracle advanced security implementation. ( SSL over TCP/IP )

Confidential, TX

DB2 DBA on AIX SP

Responsibilities:

• Design physical database layout based on the different function models.
• Design and implemented online and incremental database backup and disaster recovery plan using TSM.
• Database performance tuning and troubleshooting using DB2 tools and utilities such as snapshot monitors, event monitor, DB-GUYS and UNIX system monitor tools—vmstat, iostat and topas. Refining the database configuration parameters.
• Designing the plan to move the data warehouse from old SSA storage to new ESM storage, and redistribute data to the new containers.
• Database migration from Sybase to DB2 data warehouse database, including the data extract, transformation and conversion.
• Daily database administration and maintenance in DB2 UDB EEE environment.
• Writing UNIX scripts to automate database daily maintenance and monitor activity such as maintain and monitor logs size, tablespace size, data file system size, locks size, temp tablespace size. -Develop new process for Physical structure change, data extraction and loading into multi-partition environment.
• Complex SQL tuning for the application including rewrite the SQL, create indexes and summary tables based on the SQL explain.
• Write triggers, stored procedures using SQL procedure language: java and C.
• Develop process for the new projects, troubleshooting and optimization of the existing ETL process using informatica.
• Complex queries from data warehouse for the BI team.
• Writing some procedures, functions using TOAD for oracle database.

Confidential, MD

DB2 DBA on UNIX /Win2000

Responsibilities:

• Design database physical layout using ERwin, created reports on database model (Entities, attributes) through ERwin tools.
• Maintain and track different model version.
• Setup database three-tier environment which include backend --DB2 UDB, middleware--Sybase EA Server, Front-end GUI application developed by PowerBuilder. Plan for the DB2 implementation including database sizing, new volume group, logical volume, file system, how data placement on disks.
• Designed and implemented Backup and Disaster Recovery Plan using TSM.
• Designed and implemented security plan.
• Performance tuning and troubleshooting the database server. Developed application and database system update process.
• Wrote stored procedures using SQL and Java, enable debug function for stored procedure builder in development environment.
• Changed Database structure, extracted and loaded data. Automated routing operation using Korn shell, Perl scripts and SQL scripts.
• DB2 SQL coding support for the applications development team.
• Use crontab to automate system operation. Using vmstat, iostat to check the system I/O and CPU using condition.
• Designed and implemented the database file system structure and mirrored some important file system.
• Database capacity planning and monitoring.

Confidential

DB2/UNIX System Administrator

Responsibilities:

• Installation and configuration DB2 UDB EE and EEE on UNIX.
• Built large database (1TB) using different physical layout for best performance.
• Protected database log and data using raid5 and raid0 technology.
• Loaded data into the database, analyze and tuning the performance issues using UNIX and database performance tuning tools and database configuration parameters.
• UNIX system Installation, configuration and update.
• MQseries installation and configuration which include definition of queue, channel and cluster.
• Websphere installation and configuration which include web server configuration,
• Load balance configuration, security consideration, clustering configuration.

Confidential

Post Sale Technical Support on DB2, Tivoli, Lotus Notes

Responsibilities:

• IBM OS/2 helpdesk hotline service
• IBM internal helpdesk service
• Post-sale technical support on UDB implementation which including database installation and customization on open servers (IBM AIX, SUN Solaris, HP UNIX) and clients (Win95, Windows).
• Database physical and logical design support according to customer requirement.
• DB2 SQL coding support on application development.
• Technical support through the whole project phases which including application development, Unit Testing, System Testing, UAT and production phase.
• Database system performance tuning and troubleshooting in production environment.
• Database system update and application migration.
• Supporting on database Backup and restore strategy and tuning their performance.
• Recognition Award for Successfully implementation country wide DB2 project in Confidential .