SUMMARY

• 10+ years of experience in database physical design, planning, administration and performance tuning & optimization especially with IBM DB2 UDB 7.x, 8.x 9.x on LUW
• 2+ years of experience in handling complete life cycle of software projects involving requirements study, analysis, design, product conceptualization, estimation, solution architecture, coding, project management and delivery.
• 2 years of experience in the IT infrastructure management (From DBA Perspective on OS Side)
• 1+ years of experience in System Administration with AIX (User Management, LVM management)
• Excellent technical, analytical, interpersonal, problem solving and organizational skills
• Hands on Experience with supporting ERP products PeopleSoft

TECHNICAL SKILLS

Operating System: AIX, Solaris, Suse Linux, Windows (2000, XP)

S/W Languages: Visual Basic 6.0, JAVA

Databases: DB2 UDB 9.x (For Windows, Linux,AIX), Oracle 7.3,MySQL,MS - ACCESS

BI Tools: Crystal Report 7.0, Brio, COGNOS

Data Modeling Tools: ERWIN

External Archiving Storage: Tivoli Storage Management

Disaster Recovery & Failover Methods: HADR, HACMP

Application Servers: IIS 5.0, Apache Tomcat, IBM net.commerce, Websphere

PROFESSIONAL EXPERIENCE

Confidential

SR. DB2 DBA Consultant

Responsibilities:

• Helping in the migration from DB2 z/os to DB2 LUW on AIX v9.7.
• Normal Backup, Restore, Runstats, and Reorg for the databases.
• Created Federation for different databases.
• Migrated data from db2 on Mainframe to db2 on LUW.
• Conducting POC for db2 v10.5 for the client.
• Migrated databases from DB2 v9.7 to db2 v10.5. fix - pack 3a
• Participating in POC for vendor tools to chose a replication tool and set a standard for the client.
• Working closely with the PeopleSoft team to troubleshoot problems they are facing.
• Sharing knowledge with DBA's present at the client site to further their db2 knowledge.
• Working on PeopleSoft upgrade during a parallel re-platforming of DB2 from z/os to LUW.
• Troubleshooting issues that arise during the migration with speedy turn around.
• Creating the zos db shell on LUW by getting information from the mainframe system tables
• Validating object counts in between mainframe and the LUW shell.
• Working on Peoplesoft suites CRM, HCM, FIN, PRT, re-platforming from zos to LUW.
• Implementing MDC partitioning on DB2 LUW databases.
• Bring my extensive knowledge in DB2 LUW to the migration team.
• Collaboration with the DBA team to come up with a standard process for the Migration.
• Scripting portions of the migration activities to significantly reduce time taken.
• Working with the DBA team to come up with a security structure for the client's environment for DB2 LUW
• Actively performance tuning the databases for maximum efficiency/stability .
• Will be setting up HADR for the new DB2 LUW environments.

Confidential

DB2 DBA

Responsibilities:

• Maintaining the production and Development database servers
• Designing and developing Data Recovery strategies (HADR, HACMP)
• Did database upgrades from DB2 V9.1 to DB2 V9.7 FP5 on production and non - production environments.
• Provide documentation to the offshore DBAs to make them aware of steps followed for deployment activities
• Identifying the existing LPAR s before migrating into new DB2 fixpaks or versions.
• Provide input to the Management on team member strengths and development needs
• Resource development includes training, coaching and evaluation
• Identifying the technical gaps, planning and implementation of best practices to overcome the issues
• Root cause Analysis /Problem Troubleshooting
• Automation to reduce manual efforts.

Confidential

LEAD DB2 DBA

Responsibilities:

• Normal Backup, Restore, Runstats, and Reorg for the databases
• Maintaining the production database servers
• Maximize database performance by setting installation and storage parameters, allocate system resources and improve performance Estimate database size, log size, tablespace page size, containers size, bufferpool calculations, Responsible for application, memory, IO and storage tuning, query optimization
• Capacity planning
• Environment build
• Database Design, migration, installation
• POC on new DB2 V9.7 features (Data Compression and Index Compression)
• Did Production Deployments during maintenance windows
• Maximize database performance by setting OS/DB/DBM and storage parameters, allocate system resources and improve performance.
• Capacity planning and estimation (database size, log size, tablespace page size, containers size, bufferpool calculations) Responsible for application,memory, IO and storage tuning, query optimization.

Confidential

LEAD DB2 DBA

Responsibilities:

• Maintaining the production database servers
• Maximize database performance by setting OS/DB/DBM and storage parameters, allocate system resources and improve performance.
• Capacity planning and estimation (database size, log size, tablespace page size, containers size, bufferpool calculations) Responsible for application, memory, IO and storage tuning, query optimization.
• Investigate performance issues and other database problems using snapshots, event - monitors and other DB2 tools like db2pd, db2top
• Designing and developing Data Recovery strategies
• Environment building for SAP (defining FS and tablespaces)
• SAP DB copies from production to lower lifecycles - Restores and backups
• Database migration, installation
• POC on new db2 V9 features.
• Provide technical leadership to team of professional DBAs
• Technical documentation & Best practice documentation
• Consultancy to other region of HSBC across the globe

Confidential

DB2 DBA

Responsibilities:

• Provide input to the Management on team member strengths and development needs
• Maintaining the development, test and production database servers
• Database Design
• Maximize database performance by setting installation and storage parameters, allocate system resources and improve performance Estimate database size, log size, tablespace page size, containers size, bufferpool calculations, Responsible for application, memory, IO and storage tuning, query optimization.
• Investigate performance and other database problems using
• Quest Central Tool, snapshots, event - monitors, Linux System
• Worked extensively on large DPF environment running on DB2 v8.1
• Alert Resolution: Using Salesforce.com for alert ticket monitoring and depends on alert type (whether Severity 1, 2,3,4) responding the client with proper solution.
• Writing SOP (Standard Operating Procedure) and documenting alert Solving procedure.

Confidential

DB2 DBA

Responsibilities:

• Design and deploy a complete Enterprise Wide Information Data Warehouse Application.
• A global Application spreading across all three continents, with data in a centralized DB2/AIX partitioned environment on v7.1
• Worked extensively in setting up the maintenance shell scripts
• Written shell scripts to automate the load process and created a script to establish dynamic user aliases for the BI community within IBM.