SUMMARY:

DB2 UDB EE/EEE DBA, Teradata, Netezza, SQL Server with over seven years of experience in Database Administration on multiple platforms including Windows2000, WinNT, Linux, Sun Solaris, AIX, and HP-UNIX. Experienced in maintaining, tuning, troubleshooting, upgrading, installing and debugging database storage and layouts of Database components. Proficient in the database design, database modeling, performance tuning, and database implementation in a large production environment

EDUCATION:

IBM CERTIFIED UDB DBA
BS in EEE

TECHNICAL SKILLS:

RDBMS: DB2 UDB EE/EEE, SQL Server,
MS-ACCESS, CA\'s Erwin, Netezza, Teradata

Operating Systems: DOS, Windows, UNIX (Linux, AIX, HP-UNIX, SUN
SOLARIS), OS/390

Internet/Web App/Dev: Korn Shell, Perl, Java, JavaScript, EJB, JSP servlets, Applets,
JDK, JDBC, J2EE, JRUN studio, J++, COM/DCOM, ADO,
ASP, HTML/DHTML, XML, WebSphere, Apache, Web logic and
Microsoft FrontPage, BMC Change Management.

Client/Server App/Dev: Perl, Visual Basic, VB Script, VBA, Visual Interdev,C,
C++, MS Access, ODBC, RationalRose, Power
Builder, Crystal Reports, NetWare, REXX, LDAP, IIS

WORK EXPERIENCE

Confidential, Tallahassee, FL Nov 2007 - Current
Sr.DB2 DBA
Environment: DB2 UDB V8, DB2 9/9.5/9.7 DPF, SQL Server 2005,Aix 5.3/6,Windows, Linux, BMC Patrol, IBM Tivoli Flash Copy, Web sphere, Quest Control, Data Studio, Putty, Netezza, Teradata, Perforce.

Responsibilities:

• Working as a DBA on E-PAS (Electronic Policy Administrating System) application which is an OLTP system used by agents to process claims and on Enterprise data warehouse which will be used for BI & reporting.
• Tuning OLTP Databases to attain good performance and response time.
• Involved in POC of appliance warehouse Netezza & Teradata
• Involved in Partition expansion from 8 to 12 nodes.
• Scheduling daily Runstats on key tables.
• Working with Developers in designing Triggers/Referential Constraints.
• Working in Waterfall and Agile methodologies.
• Created Stored Procedure to do Batch Jobs on weekly basis.
• Implemented Range partition tables on monthly grain, which helps easy Rollin & Rollout of data & helps in monthly reporting.
• Implemented MDC to slice data on Zip code and policy date …etc to improve performance.
• Implemented MQT to pre-calculate heavily used calculations.
• Maintain Load Test environment in sync with production data with exception of PII data via custom build scripts.
• Wrote Korn shell / Perl scripts for data movement across different environments using cursor loads & federation.
• Set up TEST environments exclusively for the Application Development team.
• Provided 24/7 support for the production environment
• Involved in Point in time restores.
• Planned and implemented the version upgrades from V 8 to V 9.5 and then V9.7 and brought the system to the recent fixpack V9.7 FP3 on AIX and windows systems.
• Implemented Large Tablespace to support Large RIDS, which will bypass the Tablespace size limitations in previous versions also enable tablespace pages to hold more rows than previous hard limit 255.
• Implemented Storage optimization feature (Compression) in all environment by which we have reclaimed storage.
• Performing POC on WLM to replace Query Patroller.
• Involved in a quarterly HACMP / TSA failover tests.
• Involved in writing the shell scripts, stored procedures and triggers .
• Involved in Logical & physical design.
• Resolving the issues with the help of database snapshots, db2top,db2 logs and visual explains.
• Helped the developers with Schema changes and sql queries.
• Set up the replication to monitor the updates on sensitive data.
• Fine Tuned Backups and restores on EEE system.
• Scheduled daily/weekly/monthly database maintenance jobs.

Confidential, Orlando, FL June 2005 - Oct 2007
DB2 UDB DBA

Environment: UDB DB2 V9.1/V8.1/V8.2 DPF, AIX 4.3.2, AIX 5.1, Win2000, Win NT, SMP, P690, 32/ 64 Bit UDB EEE, Maestro, BMC Patrol, Perl, TSM

• Migrated instances from v8.1 to V8.2
• Involved in certifying db2 V9 version at enterprise level
• Supported Multi-Terabyte databases
• Migrated UDB database from 32bit to 64 bit code.
• Set up the scripts to monitor replication and prune the APPLY_TRAIL table.
• Maintained the existing replication environment.
• Used QUEST Control to maintain the test and production schemas.
• Set up a TEST environment exclusively for the Application Development team Maintained both Test and QA environments
• Provided 24/7 support for a production environment.
• Tuned the database to release the memory that was allocated for the database but not used by the database.
• Tuned the database based on the needs of the applications.
• Involved in Point in time restores.
• Created Database Snapshots for tuning the database using table functions.
• Helped the Developers with Schema changes and dumping table data node wise.
• Set up the replication to monitor the updates on sensitive data.
• Fine Tuned Backups and restores on EEE system.
• Involved in the day-to-day Administration of Database Servers and Application Server.
• Used Maestro client to schedule Batch Jobs.
• Used BMC Patrol to monitor database.
• Refresh the Development & test databases from Production Database.
• Supported many OLTP applications runs on websphere application servers.
• Ran the REORGCHK, REORG, RUNSTATS utilities.
• Involved in the day-to-day Administration of Database Servers and Application Server.
• Upgraded the Instances from V8 Fixpack10 to Fixpack14 to fix APAR's we have found when using blocked pages in bufferpools.

Confidential, Baltimore, MD March 2004 - May 2005
DB2 UDB DBA

Environment:- DB2 UDB V7.2/8.1 EEE/DPF , SP2, P690, , DMX3000, DB2 Governor, AIX 5.1 HACMP, SUN, Linux, BMC change Manager,Perl,Erwin,DB2 Connect,DB2 Data Joiner, Websphere.

• Migrated db2 udb from 32 sp2 nodes to 2 p690 lpars with 16 logical nodes.
• Handled datawarehouse with 8 TB.
• Worked with HACMP clusters on the data warehouse.
• Migrated UDB database from 7.2 to 8.1.
• Performance monitoring and tuning.
• Worked on creating MDC's and MQT's.
• Automated the backups, Reorgs, Runstats, Space monitoring, moving the db2diag.logs, monitoring the size of the table spaces by setting up a threshold (80%) etc.
• Created scripts to backup/recovery process from TSM
• Created snapshot monitors and event monitors to regularly check the health of the system.
• Created EXPLAIN tables and ADVISE tables.
• Performance monitoring and tuning the databases
• SQL tuning and ran the Visual Explain utility on SQL statements
• Used different data movement utilities like LOAD, EXPORT, IMPORT utilities to load data
• Supporting the development team and also 24x7 production on call support
• Created Shell and PERL scripts for migration of data