Manager Sql Server

FRANCIS LIM senior db* database administrator

*** ****** ***, ****** ****, NJ 07302 ****@*****.*** 551-***-**** http://flim.home.comcast.net

tech skills: UDB v5.1 to v9.5 ESE/DPF, db2 workload manager, db2dart, db2gov, db2batch, db2exfmt,

PureXML, DB2 MTK, HACMP, HADR, SRDF, SQL, *NIX(AIX, SUN, LINUX), NT, XP, MAC OSX,

BMC Patrol, BMC Change Manager, Maestro, Tivoli Storage Manager, PERL, Korn Shell, VB,

C/C++, Java, HTML, DB2 EveryPlace, MQ, vi, awk, sed, Oracle, MS SQL Server, Informix,

Crystal Reports

experience: Independent Work, Jersey City, NJ (06/2008-present)

DB2 9.5 Work Load Management analysis, set-up and design. Pre DB2 9.7 script conversion

to utilize current version non-latching db2pd and threaded model. Low level corrupt data

recovery using db2dart. Developed iPhone Applications using Core Location and web services.

Senior DataBase Administrator, MetLife, NJ (08/2002-06/2008)

Performed administration tasks of small(ESE) to very large multi partition databases(DPF).

Recommended best-practices for building UDB DB2 from the ground up. Designed disaster

recovery and high-availability systems using HACMP, HADR, SRDF/A with BCV and log

shipping technologies. Designed performance tuning and analytics tool to identify problematic

queries from snapshots, event monitors and db2 explains. Backup and restore tuning. Created

automation scripts to improve efficiency and cut cost by decreasing DBA man hours needed to

accomplish repetitive enterprise wide tasks using scripting languages like PERL and shell

scripts. Installation, upgrade and hardening of database systems. Database migrations from

Oracle, MS SQL Server using a combination of the IBM migration tool kit and self generated

scripts. Migrated from UDB 32 bit UDB to 64 bit UDB. DB2 major and minor version upgrades

planning, testing and implementation. Member of the Data Masking pilot initiative to protect

customer privacy.

DataBase Administrator, Millennium Computer Systems, NY (11/2000-08/2002)

Created automation scripts for clients. Backup, restore and troubleshoot databases problems.

Develop web-based DBA contact information management system for primary and secondary

DBA assignment. Create a process to count licenses in use for a particular software using port

fingerprinting. Mentored junior DBAs on various topics, ranging from use of BMC Change

Manager, HACMP implementation in UDB, shell scripting, HTML, and ASP/JSP. Beta tested

DB2 Everyplace as a proof of technology for possible implementation.

DataBase Administrator/Software Developer, SecureTrade, Philippines(1998-2000)

Administer multiple databases ranging from MS SQL Server, Oracle, Informix and UDB DB2.

Develop Java Stored procedures used for the SecureTrade Electronic Payment Switch.

Administer UNIX servers. One of the contributing architects for the cross country and cross

currency electronic payment switch.

Application Developer/Analyst, Ateneo de Manila University, Philippines (1996-1998)

Systems Analyst and Designer for the Human Resource Information Systems(HuRIS) and

Ateneo Integrated Student Information Systems(AISIS). Application developer for the online

enrollment system, using MS SQL Server and then Oracle back ends with Active Server Page

front end. Also customized Crystal Reports ActiveX server component for the registrars office to

increase turn around time for producing the transcript. Developed the student schedule conflict

checking algorithm still in use today.

education: Ateneo de Manila University, Quezon City, Philippines

BS Management Information Systems, 1997

Contact this candidate