SUMMARY

• IBM Certified Database Administrator (DB2 UDB v 9.5/9.7/9.8/10.1 for LUW) with over 25 years of IT experience and a proven background of technical problem solving.
• Collaborated closely with IBM for over nine years paired with a strong working background as a DB2 UDB, Oracle, and SQL Server database administrator and architect on several kinds of applications including UNIX, Linux and Windows environments.
• Proven track record of maintaining and supporting DB2 UDB large data warehouses and OLTP databases on AIX, Solaris and Linux environments (clustered).

TECHNICAL SKILLS

RDBMS: DB2 UDB AESE and DPF/PureScale, Oracle, Sybase, MS - Access, SQL Server

Languages: UNIX Korn shell, Advance SQL, PL/SQL, C++

OS: UNIX (IBM AIX, Red Hat Linux, SUN Solaris), Mainframe Linux, Windows NT/XP

Hardware: IBM SP nodes with HACMP, SAN, Sun 490 servers, EMC, NT, Windows 2003

Tools: DBArtisan, Microsoft Visio, ER-Win, QMF, Designer/2000, BMC Petrol, Power Builder, Quest Foglight, Spotlight, Performance Analysis, Central

ETL: Informatics Power Mart 4.6, IBM DataStage, Ab Initio, SAP Business Objects

Middleware: IBM DB2 Content Manager, IBM’s WebSphere, XML Extender, DB2 Connect, Data replication, MQ Series, TSM, Data warehouse, Data mart, HADR

Additional: Java, J2EE, EJB, Servlets, ASP, OS/390 databases, Tivoli, BMC monitoring tools,VERITAS Cluster Manager, Autosys Multi-platform scheduler, BMC Remedy, LDAP, IBM Rational ClearQuest, AWS cloud platform

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Senior Database Administrator

Responsibilities:

• Actively participate in large DB2 database(s) on Amazon AWS migration, performance matrix.
• Responsible for maintaining and supporting DB2 servers sizing for high availability for large databases in multiple environments.
• Provide hands on experience in DB2 audit implementation with vormetric database encryption.
• Responsible for tasks including but not limited to DB2 backup restore, maintain database privileges/authorities, DDL deployment, HADR/HA/TSA setup.
• Perform various migrations of DB2 encrypted database from production to non-production via scrubbing process in high availability environment.
• In control for end to end tuning of databases and SQL queries for highly used database to bring out of SLA (Service Level Agreement) in a complex 24x7 BI environment.
• Provide 24x7 on-call DBA support to production databases, troubleshooting, worked with ETL, Java developers to provide RCA (Root Cause Analysis).

Environment: DB2 UDB V 9.7/10.1/10.5 (AESE, BLU, SQL replication, DPF, HADR, haicu), IBM DSM Tool, Linux 7.3, AIX 6.1, NFL File system, Dell Foglight, BMC Database automation, IBM Tivoli, IBM WebSphere/J2EE, LDAP, IBM MQ Series, IBM GPFS, Vormetric database encryption, ETL, Guardium, AWS Cloud.

Confidential, Chicago, IL

Senior DB2 Database Administrator

Responsibilities:

• Worked on table partition of large tables in DB2 Pure Scale environment to improve SQL performance and space optimization. Table size for BLOB over 400 GB and other tables has over 270 million rows.
• Improved existing DB2 backup and restore script in DB2 Pure Scale environment.
• Provide 24x7 DB2 support in production and non-production environment, not limited to Production to non-production database restore, user access/privilege, storage issue, Q-replication, HADR, setup etc.

Environment: DB2 UDB DB210.5 Pure Scale/HADR, AIX 6.1, IBM Tivoli, IBM WebSphere/J2EE, LDAP, IBM MQ Series, IBM GPFS, Vormetric database encryption

Confidential, McLean, VA

Senior Database Administrator (DB2)

Responsibilities:

• Responsible for the tuning of the database and developing/modifying SQL queries for DSS reporting database to bring out of SLA (Service Level Agreement) in complex 24x7 BI environment.
• Optimized and re-designed DSS reporting database using DB2 10.1 Adaptive compression, table range partition, clean up unused Indexes, and BLU technology.
• Provided hands on experience DB2 backup restore, migration from DB2 9.7 to 10.5 for large databases.

Environment: DB2 UDB V9.5/ 9.7/10.1/10.5 (AESE, BLU, SQL replication, DPF, HADR), Oracle, Linux 6.2, AIX 6.1, Dell Foglight, BMC Database automation, IBM Tivoli, IBM WebSphere/J2EE, LDAP, IBM MQ Series, IBM GPFS, Vormetric database encryption

Confidential, Milwaukee, WI

Lead DB2 Database Administrator

Responsibilities:

• Lead DBA for a large migration of DB2 9.5 Data warehouse (EEE) environment to DB2 10.5 DPF BLU involves six nodes, DataStage and Business Objects reporting.
• Developed solutions to optimize legacy data migration to new environment during go-live window.
• Worked on PoC for DB2 DPF data encryption using Vormetric Encryption.
• Developed korn scripts to convert 6 TB DB2 9.5 database to DB2 10.5 DPF BLU environment.

Environment: DB2 UDB V9.5 (EEE) 10.5 (BLU), AIX 6.1, Quest Toad of DB2, IBM DataStage, IBM Tivoli, IBM LDAP, IBM MQ Series, IBM GPFS, Vormetric database encryption

Confidential

Database Architect/Senior Database Administrator

Responsibilities:

• Architected high availability database solutions using DB2 10.1 PureScale technology for OLTP and Other databases such as Process Server, Decision server, Quality Server and Data Stage.
• Hands on experience setup and deploy large scale DB2 PureScale databases on six AIX servers having four members and two cluster facility (CF). Participated in hardware sizing to deploy PureScale and Data warehouse databases in multiple environments.
• Worked on performance tuning of DB2/AIX during stress test of EMC Documentum application deployment and application is being rolled out all regional offices of states.
• Setup high availability using db2haicu utility (HADR) in DB2/AIX database to minimize production database down time.
• Architected DB2 data warehouse database and Q-replication with DB2 OLTP database. Presented DB2 BLU solution for data warehouse and Business Analytics requirement. Worked on proof of concept how does DB2 masking feature (RCAC) works and performance impact. Wrote korn shell script to automate archive data of high-volume transaction table used by documentum.
• Provided installation instructions to setup database repositories for lots of IBM tool set such as Adobe LiveCycle, DataStage, QualityStage, TIM/TAM, and Compute Grid. Assisted in SSO (Single Sign on) configure to have DB2 Transparent LDAP plugin with LDAP security.

Environment: DB2 UDB V9.7/V10.1 (PureScale) 10.5 (BLU/HADR), AIX 6.1, Quest Toad of DB2, CA ER-Win rel7.3, WebSphere, J2EE, IBM DataStage/QualityStage, IBM ComputeGrid, IBM Tivoli, IBM LDAP, IBM MQ Series, IBM GPFS.

Confidential

Senior Database Administrator (DB2 UDB)/ Data Architect

Responsibilities:

• Performed data analysis to migrate large legacy Client Index database to Oracle Siebel/MDM environment.
• Worked on architecting data model to enhance functionality of OLTP turn key project.
• Responsible for the enhancing data model DDL (new/modify tables, views, triggers and stored procedure) and implementing across multiple environments such as Development, Test, UAT and Training. And prepare DDL for production environment.
• Wrote lots of data conversions Korn scripts to accommodate new application releases and built stress test database involves data migration and scrubbed production database copy (ETL).
• Gave presentations to management team about benefit about DB2 STMM (Self tuning memory management) v/s DB2 dedicated instance. Worked with technical team to fine tune application and database configuration and Operating system parameters.
• Defined database archive strategy to optimize database size and tested approx. 65% application performance gain in transaction.
• Managed and monitored application related issues such as lost application; activate new site/branch, add/modify case workers profiles, etc. and application performance issue such as Deadlock, locking, memory utilization, etc.
• Wrote lots of complex SQL to generate lots of Business intelligence reports and Ad hoc reports.
• Assisted Business Analysts on effort estimation for new work and developer on privilege issue, application troubleshooting, and explaining new data model enhancement.

Environment: DB2 UDB V9.7, AIX 6.1, Quest Spotlight, Quest Toad of DB2, CA ER-Win rel7.3, SAP Business Objects Designer and Web Intelligence XI V3, WebSphere/J2EE, Ice Faces, Spring, Open JPA, Oracle 10g/11g, Linux, Siebel

Confidential, Foster City, CA

Senior DB2 UDB Database Administrator

Responsibilities:

• Consolidated and migrated over 150 TB size large data ware MPP databases in DB2 UDB DPF on AIX platform in Development and QA environment to effective utilities operating systems resources such as CPU, memory, storage and better database performance. Database consisted of over 2500 tables of multiple projects in star schema model, fact tables, dimension table, MDC, replicated MQT, statistical views, etc. It involved the setup of a new environment as per IBM BCU (Balanced Configured unit) methodology on new hardware, setup new File systems, GPFS, setup new instance, create new database, extract and copy DDL from production, followed by finding differential DDL between production and Dev/QA environment and copy, setup UNION ALL views, loading data using load cursor, granting privileges, setting up maintenance scripts, and user acceptance.
• Extensively involved in SQL tuning in existing large DSS/ODS Production data ware house database (32 partitions on 2 nodes) on DB2 UDB DPF/AIX platform. It involved finding poor performing SQL and executing DB2 explain to find cost estimate, analysis various solution such as creating new MQT, MDC, Table partition or Statistical view or creating new indexes. Resolved poor performing SQL query from over 25 minutes to 2 minutes by creating statistical view and small index.
• Sized and Setup new data ware house database (10 TB) environment for new application to conduct POC (Proof of concept) on DB2 UDB DPF v 9.7 on AIX 6.1 platform as per IBM BCU methodology. In involved installing DB2 UDB DPF v9.7 on multiple servers, setup GPFS, creating new File systems, using DB2 v9.7 new features such as automated storage, global temporary tables, creating write partition keys, MDC and table partition etc.
• Enhanced korn shell script to DB2 performance tuning scripts using DB2 UDB v9.1 using new features SYSIBMADM views; wrote script to copy data from using load cursor utilities without uncompressing file.

Environment: DB2 UDB V9.1/9.5/9.7 DPF, GPFS, AIX V5.2/6.1, IBM BCU methodology, Quest Central, Ab Initio ETL, BMC Remedy, korn shell