SUMMARY:

• Over Ten years of experience in administration, implementation, maintenance and support of Business Applications using Relational Databases, Graphical User interfaces using DB2 UDB 7/8.1/9.1/9.5/9.7 , Oracle 8.0/8i UNIX and Windows NT.
• Experience providing DB2 UDB database administrator (DBA) support on AIX/Sun Solaris/LINUX.
• Extensive expertise in understanding DB2 UDB Database systems and experience in functional and technical issues.
• Enforcing Data integrity using integrity constraints & database triggers related with data model.
• Experience in Performance Tuning, Space Management and Planning Backup & Recovery Strategies.
• Experience in UDB DB2 Database Administration operated by multiple users and multiple databases.
• Experience in application performance and tuning.
• Configured users to Catalog the development and test database and helped them use DB2 UDB command Center.
• Preformed multiple installations and upgrades of DB2 in production systems.
• Experience in implementing and maintaining 24 * 7 production environments on UDB DB2 EE databases with HADR
• Setup and tested the HA on production systems.
• Performing day - to-day data base administration maintenance tasks.
• Good experience in IBM PMR process.
• Excellent in problem solving and logical, analytical, verbal, written skills.

SKILLS:

Operating Systems: UNIX (AIX, Linux, Sun Solaris), Windows XP/NT

Languages: SQL, PL/SQL, UNIX Shell Programming

RDBMS: DB2 UDB 7/8.1/9.1/9.5/9.7 , Oracle 8.x/8i

Case Tools: Designer/2000, ERWIN

Front Ends: Command Line Processor, Command CenterDeveloper/2000 (Forms 4.5/5.0, Reports 2.5/3.0)

Version Control Tools: PVCS, Rational Clear Case, Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Providing support to System Administrator (SA) in database installation, instance creation, instance upgrade, version migration and HADR.
• Database object creation & alteration (tables, indexes, views, stored procedures, functions etc.)
• Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
• Database performance tuning and troubleshooting & fixing problems faced by application developer.
• Query tuning for the problematic queries sent by application developer or identified during database monitoring.
• Exploring the use of Multi Dimensional Clustering (MDC) & Materialized Query table to enhance the system performance if required.
• Database monitoring (free space in tablespaces, event monitor outputs, security audit reports, performance reports etc.).
• Database backup & recovery (offline & online backups, Full, Incremental & Delta Incremental).
• Database cloning using redirected restores.
• Developing tools using shell/AWK scripts to automate various database administration jobs.
• Performing database security review (for the databases created & maintained by other DBA).
• 24X7 on-call support to troubleshoot issues with the Production.

Environment: UDB DB2 V9.7 with Fix pack 4, UNIX-Sun Solaris / AIX / Linux, K Shell, Quest Central

Confidential

DB2 DBA

Responsibilities:

• Provided highly technical expertise and support in the use of database technology to support the application.
• Identified and corrected data functions that are slow or expensive in terms of system resources.
• Developed queries to isolate, correct or eliminate redundant or bad data.
• Ensured that data integrity, security, and recoverability are built into the application.
• Experience with enterprise backup and recovery strategies.
• Creating primary database storage structures (tablespaces etc.).
• Creating primary objects (tables, views, indexes etc.).
• Collecting database resource & CPU utilization in busy hours & idle hours and doing maintenance through reorganizing, collecting statistics and rebinding of packages.
• Modifying the database structure, as necessary, after collecting information from application developers and based on statistics gathered.
• Enrolling users and maintaining system security, controlling and monitoring user access to the database.
• Configuring high availability & disaster recovery.
• Monitoring and optimizing the performance of the database, tuning database performance.
• Backing up and restoring the database, bringing database from no archive to archive mode, maintaining archived data on tape.
• Stand-by database management, log shipping and applying, DR drills to ensure smooth working of standby database in event of disaster, switch-over.
• Data maintenance through import, export & load.
• Handling database related production issues.
• Coordinating with application team to smoothen their efforts.

Environment: UDB DB2 V9.5, UNIX-Sun Solaris / AIX / Linux, K Shell, Quest Central

Confidential

Responsibilities:

• Provided highly technical expertise and support in the use of database technology to support the application.
• Developed logical and physical data base models.
• Good understanding of DB2 internal architecture.
• Identified and corrected data functions that are slow or expensive in terms of system resources.
• Developed queries to isolate, correct or eliminate redundant or bad data.
• Ensured that data integrity, security, and recoverability are built into the application.
• Experience with enterprise backup and recovery strategies.
• Creating primary database storage structures (tablespaces etc.).
• Creating primary objects (tables, views, indexes etc.).
• Collecting database resource & CPU utilization in busy hours & idle hours and doing maintenance through reorganizing, collecting statistics and rebinding of packages.
• Modifying the database structure, as necessary, after collecting information from application developers and based on statistics gathered.
• Enrolling users and maintaining system security, controlling and monitoring user access to the database.
• Configuring high availability & disaster recovery.
• Monitoring and optimizing the performance of the database, tuning database performance.
• Backing up and restoring the database, bringing database from no archive to archive mode, maintaining archived data on tape.
• Stand-by database management, log shipping and applying, DR drills to ensure smooth working of standby database in event of disaster, switch-over.
• Data maintenance through import, export & load.
• Handling database related production issues.
• Coordinating with application team to smoothen their efforts.

Environment: UDB DB2 V9.5, UNIX-Sun Solaris / AIX / Linux, K Shell, Quest Central

Confidential

Responsibilities:

• Supported 5 TB DB2 UDB databases on Version 9.1.6 in both OLTP and DW environments.
• Providing support to System Administration (SA) in database installation, instance creation, instance upgrade and version migration.
• Design, analysis and creation of new databases (analysis about number of database partitions, available memory, database size, database & database manager configuration options).
• Managing Database user privileges (granting & revoking permissions after proper analysis & approval).
• Database performance tuning and troubleshooting, resolving database issues for the dev support.
• Responsible for creating databases and objects such as table-spaces, tables, primary keys, indexes etc.
• Supported Data Migration for Frontier databases. Maintained referential integrity and referential constrains, using both EXPORT and IMPORT for data move to Frontier Servers.
• Query tuning for the problematic queries sent by application developer or identified during database monitoring.
• Database monitoring (free space in tablespaces, event monitor outputs, security audit reports, performance reports etc.).
• Database backup & recovery (offline & online backups, Full, Incremental & Delta Incremental) High Availability Disaster recovery (HADR).
• Database cloning using redirected restores.
• Perform capacity planning and analysis and implement required changes on the database server.
• Analyze application SQL for performance improvement opportunities and work with DB2 support on problems and questions.
• 24*7 Support for availability of Mission Critical Databases.

Environment: UDB DB2 V8.2 with Fix Pack 11, UDB DB2 V9.1 with Fix Pack 2a, Windows NT, UNIX-Sun Solaris / AIX / Linux, K shell, Quest Central

Confidential

Responsibilities:

• Administered UDB databases on SUN SOLARIS machines.
• Involved in database and schema set up, users and groups creation, permissions and privilege granting on database objects and setting up of a Release strategy.
• Involved in creation of tablespaces, tables, indexes, views, stored procedures and configuration of database manager and individual databases.
• Strategized data security guidelines under Sox Compliance.
• Threshold checks on tablespaces, transaction log monitoring, disk space monitoring, archival of transaction logs and db2diag.log.
• Involved in configuration of database and instance level parameters.
• Analyzed snapshot information on buffer pools, locks, applications and SQL statements.
• Work with application development team to design Frontier and re-engineer existing
• Applications
• Maintained referential integrity and referential constraints, using both LOAD and IMPORT to load data into the new tables.
• Used Reorgchk, Reorg, Runstats database maintenance utilities.
• Installed fix packs and security updates.
• Used DB2 utilities like db2move, db2look to help expedite the migration process.
• Involved in taking online and offline backups of the Database.
• Report weekly database activities using db2audit.
• Performed capacity analysis, planning and benchmark testing.
• Supported application developers in planning and preparation, and backup and recovery of data
• Provide 24X7 on-call support to troubleshoot issues with the Production schedule

Environment: UDB DB2 V8.1, Erwin, Windows NT, UNIX-Sun Solaris / AIX / Linux, K shell.

Confidential

Responsibilities:

• Provided Administrative support to UDB databases on SUN SOLARIS machines.
• Created the database and configured the clients and gave necessary Privileges on database.
• Co-ordinate with dev team in supporting application releases and changes.
• Automated daily maintenance process using shell scripts.
• Used DB2LOOK to extract the DDLs.
• Setup and implement data Backup and Recovery procedure.
• Experience in performing the Redirect Restore.
• Worked with Erwin 4.0 in designing the layouts as per the requirements.
• Performed SQL tuning at the application and database level.
• Table space Monitoring and growth Management.
• Written database monitor shell scripts.
• Addressed Time-outs, Deadlocks and other database related issues.
• Used the Explain Tables to find out the timerons of each query executed.
• Used DB2ADVIS in creating the Indexes.
• Provided the application support in resolving the issues related to Database.

Environment: UDB DB2 V8, Erwin, Windows NT, UNIX-Sun Solaris / AIX / Linux, K shell.

Confidential

Responsibilities:

• Import/export of tables from UDB databases.
• Work with application development team in supporting application releases and changes.
• Extensively used Load utility to load data into the new tables.
• Used DB2LOOK to extract the DDLs.
• Maintained the replication between UDB databases.
• SQL and system monitoring and tuning, re-writing SQL’s.
• Data/ Object Migrations.
• Setup and implement Data Backup and Recovery procedure.
• Addressed Time-outs, Deadlocks and other database related issues.
• Applications support.
• Creating EXPLAIN tables and running the visual explain utility on SQL statements.
• Look at the APPLYTRAIL to debug the problems of UDB replication.
• Configured the cronjobs entries to continuously monitor replication APPLYTRAIL.
• Performed SQL tuning at the application and database level.
• Created the test data for the Testing teams, Development teams and created environments for multiple testing teams (Manual/Auto/Functional/Performance).
• Prepared data management procedures and performed data validation.
• Performing data quality control checks and organizing data into database.
• Supported application developers in planning, preparation, and backup and recovery of data.
• Performed database activities on daily basis and resolved day to day issues pertaining to the database.
• Provided resolution and escalation of issues (where required).

Environment: UDB DB2 V8, Humming Bird, Rapid SQL, Erwin, Windows NT, UNIX-AIX, K Shell

Confidential

Responsibilities:

• Set up the UDB servers on AIX and SUN machines.
• Set up the replication between the UDB databases to send the data to the corporate data warehouse.
• Installed and configured Oracle 8 Server on Windows NT.
• Created the database and configured the clients; Created users, roles and gave necessary Privileges on database.
• Database design, Table design, Table indexing.
• Involved in writing PL/SQL Stored Procedures, Functions, Database Triggers and Packages.
• Data loading using SQL*Loader.
• Import/export of tables from UDB and ORACLE databases.
• Table space Monitoring and Management.
• Worked with Erwin 4.0 in designing the layouts as per the requirements.
• Involved in design and implementing backup and recovery strategy.
• Performed SQL tuning at the application and database level.
• Auditing the Database.
• Solved Net8 Problems using Net8 Configuration assistant.
• Maintenance and documentation of software.
• Written database monitor shell scripts for UDB.
• Taken snapshots at different levels of the database to check the query performance and ran explains for query tuning.

Environment: UDB DB2 V7.x, DATA JOINER, Oracle8i (SQL*PLUS, PL/SQL), Windows NT, UNIX

Confidential

Responsibilities:

• Developing and Implementation of Modules.
• Created Stored Procedures, Functions and Triggers using PL/SQL.
• Involved in the design and creation of Tree Walk structured Queries.
• Created triggers that would audit changes made by the users.
• Tuned complex SQL statements and debugged PL/SQL packages.
• Designed and developed a front end GUI for the system using Developer/2000.
• Performed tuning on stored procedures.
• Developed the test cases for testing the technical design of the package

Environment: Oracle-8.0 (sql, pl/sql), Developer/2000(Forms 5.0, Reports 3.0), Compaq Alpha Server, UNIX Shell Programming, and WINDOWS - NT SERVER