SUMMARY

• Over 7 years of experience in Database platforms. 7 years of experience as a Database Admin in DB2 LUW and 3 years of experience in Oracle and ParAccel (Matrix) as a DBA. Experience in full life cycle of database administration. Worked both as a development and a 24x7 Production Support DBA.
• IBM DB2 Certified Database Administrator.
• Skilled experience in installing and configuring DB2 9.x, 10.x versions and fix packs on UNIX, Linux or Windows operating system efficiently.
• Eternal knowledge in designing physical, logical and relational databases, development and maintenance.
• Worked on DB2 Federation server and established connections between DB2 and Sybase databases
• Experience working with very large databases on Data Partitioning Feature (DPF) environment.
• Supported partitioned environment (DPF) with 32 node dataware house.
• Developed many reusable shell scripts for monitoring and performing daily and weekly tasks. Developed automated system for production backups, reorgs, runstats.
• Expertise in Backup, Recovery and rollforward techniques.
• Efficient professional in working with movement and maintenance utilities like move, export, import, look, runstats, reorg, reorgchk, rebind, and flush package cache.
• High skills in monitoring and performance tuning a database using snapshots and event monitors. Troubleshooting sql statements with the help of Explains, db2advis, db2exfmt schema changes and configuration changes.
• Experience in developing disaster recovery techniques in HADR (High Availability Data Recovery) using TSA and db2haicu.
• Efficient professional in working with various tools like SQL visual explain, DB2 Connect, Query Optimizer, Health Monitor, Snapshot Monitor, Event Monitors and DB2mon.
• Skilled in developing SQL queries, packages, triggers and stored procedures.
• Ability to work independently with very little direction.
• Experience as Oracle DBA (11g/10g) on different Linux and AIX, environments.
• Experience in Oracle Real Application Clusters (RAC) Installation, administration, troubleshooting and Performance tuning in 11g.
• Experience in performing Hot and cold backups with and without RMAN
• Experienced in troubleshooting traditional export/import and datapump export/import.
• Experience in configuring and working with OEM.
• Expert in installing, configuring, upgrading and monitoring Actian’s ParAccel databases.
• Experienced in adding more compute nodes to an existing cluster.
• Expert in using backpack back and unpack utilities.
• Proficient in restoring PADB databases with a different configuration from the source configuration.
• Developed a monitoring script which check the clusters for any failed disk and sends a notification to DBA team.
• Expert in working with network team to replace the failed or slow disks and enabling the replaced disks back in cluster by recovering lun.

TECHNICAL SKILLS

Operating Systems: AIX 7.x/6.x, Solaris 10/11, Linux 7.x/6.x, SCO - UNIX 5, Windows 2K/XP/7

RDMS: DB2 UDB 8.1/8.2/9.x/10.x,, Oracle 10g, 11g SQL Server 2000, Paraccel 5.1 and 5.3

Shell Scripting: Korn, Bash, Bourne, and C Shell

Languages: C, C++, Java, PL/SQL, Perl, PHP, Visual Basic.NET

Database Tools: ERwin, RapidSQL, DBartisan, Power Designer, BMC, Query Patroller, Event and Health Monitor, SQL Explain, Control Center, Information Integrator, AQT.

Application Servers: IBM Web Sphere 4.0/5.0/5/1, BEA WebLogic 5.0/6.x/7.x/8.1, MS MQ Series, Apache Web server

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Responsibilities:

• Provided ONCALL support 24 * 7 involving DB2, Oracle and ParAccel on a rotation basis.
• Maintains and supports DB2 UDB databases on Linux and AIX platforms including implementing DDL/DML changes, backup, cross node data restore from TSM server, schema copies, tuning SQL, performance tuning, table partitioning etc.
• Migrated and upgraded a multi tera byte DB2 database from ESE to AESE with the intention to use table Compression feature and achieved it without having a down time on application.
• Implemented HADR and setup TSA using db2haicu.
• Worked on patching and upgrading DB2 databases on stand alone and HADR databases without down time on databases using failover technology.
• Implemented SQL replication on both table level and view based replication as per application team requirement.
• Worked on a critical data ware DPF with a 32 node environment involving around 20 TB data and testing to use DBBOOST backup technology.
• Created servers, wrappers, user logins and nicknames on federated databases to establish connection between DB2 and SYBASE databases and worked on replication between Sybase and DB2.
• Involved in capacity planning and space management. Worked on space estimate and tablespace design to accommodate large amount of data in data warehouse environment.
• Enabled native auditing on critical SOX databases for auditing purposes.
• Worked closely with Informatica team to optimize the batch jobs and monthly data loads process to minimize the batch period.
• Monitored Oracle instance performance, tablespace utilization, database objects, connectivity and database availability, validation of database backups, listener status and server space availability and maintenance.
• Refreshed Oracle databases using datapump utilities expdp/impdp . Troubleshooting expdp/impdp errors in RAC environment, configuring storage accordingly.
• Monitored the performance of the Databases and viewing Alert log files & Trace files.
• Involved in an Oracle RAC upgrade to 11g which uses data guard and Observer.
• Maintained ParAccel (Matrix) clusters on production and non production environments.
• Worked on a failed disk replacements in ParaAccel and enabled the disks back in cluster once the disks are replaced by UNIX team.
• Involved in a ParAccel (Matrix) cluster upgrade from 5.1.1 to 5.1.3
• Experienced in working with restoring cluster to non prod environement even with a different topology on non prod environment.

Environment: Red hat Linux 6.1, DB2 (Versions 9.7, 10.1 and 10.5), RapidSql, IBM Utilities, Data Studio, Java, Oracle10g, 11g and 12c, ParAccel (Matrix) 5.1.1 and 5.1.3

Confidential, Research Triangle Park, NC

Database Administrator

Responsibilities:

• Worked on different version of DB2 UDB like 9.5, 9.7 and 10.1
• Worked on upgrading databases from 9.7 to 10.1
• Installation of Software and fix packs.
• Worked with development teams on projects and provide them assistance on database activities involved in it.
• Involved in ETL design, architecture, and performance tuning including load strategies.
• Worked on tuning around 20 stored procedures which had performance issues and yield better resulting using expln, db2exfmt and db2advis.
• Worked on Proof of concept for V10.1 testing
• Performed installs of DB2 software and builds of new instances; set up High Availability Disaster Recovery environment (HADR) for DB2 applications.
• Created multiple schema’s over the database based upon the requirement from the application team.
• Worked on database tuning and query tunings and educating developers on optimal query writing.
• Involved in running REORGCHK, REORG, REBIND, RUNSTATS, LOAD utilities against the database

ENVIRONMENT: RHEL - 5.x /6.x, DB2 EE V 9.5/9.7/10.1, Sybase ASE 12.5, Web sphere, AIX 5.xEmployer: Confidential Consulting Inc

Confidential, Mclean, VA

DB2 & Sybase DBA

Responsibilities:

• Performed DB2 cross platform migration from AIX to Linux from AIX 9.5 to Linux 9.7
• Upgraded DB2 databases and clients from 9.5 to 9.7 and 9.7 to 10.1 on Linux platforms.
• Worked on installing SYBASE ASE servers on Solaris and Linux in 12.5, 15.0, 15.7 versions
• Performed Sybase cross platform migration from Solaris to Linux
• Worked on Sybase Replication server and Failover and failback scenarios.
• Developed and enhanced existing scripts to handle cross platform migrations efficiently.
• Designed and implemented database with partitioning features (DPF).
• Improved performance by converting tablespaces to multiple partitions with DPF.
• Experienced in working on restore/recovery on DPF environments.
• Proficient in creating servers, wrappers, user logins and nicknames on federated databases to establish connection between DB2 and SYBASE databases.
• Worked on setting up QReplication on few tables in UDB and table level replication on Sybase.
• Coordinated with the development team for coding static SQL stored procedures. Also coordinated with application team for SQL Optimization, SQL Analysis and Streamlining. TEMPHas experience working and analyzing with SQL Visual Explains output.
• Developed scripts to capture benchmarks for performance of database. Captured and maintained capacity planning reports including CPU, MEMORY, me/O, Disk Space, and Projected utilization based on future business requirements.
• Created Event Monitors and used db2explain and db2advis to troubleshoot Production issues in lower environments.
• Identified problematic SQL and optimized SQL queries dat helped improve application performance.
• Automated scripts for having the backups of master, sysusers, sysprotects and sysalternates for each database everyday.
• Developed script to export and load data across different platform using cursor on DB2.
• Monitored error logs, database space allocations and transaction log space allocations regularly.
• Used system catalog tables (SYSIBMADM tables) for administration and system monitoring.
• Supported multiple databases across multiple platforms responding to developers issues.
• Helped in documenting all the SOPS for the team use.

Environment: Red hat Linux 5.10, DB2 (Versions 9.5, 9.7 & 10.1 Fix pack 3), IBM Utilities, Data Studio, Java, Sybase ASE 15.0.7/15.0/12.5, Oracle 11g

Confidential

DB2 UDB DBA

Responsibilities:

• Worked on installation of versions 9.7 of DB2 UDB on AIX 6.1.
• Performed POC of DB2 V9.7 on AIX 6.1.
• Developed shell scripts for daily maintenance tasks, archiving DB2 log files, and performance monitoring.
• Generated ERD for the database using Erwin
• Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) and logical database mapping to physical database (storage calculations, file systems, tablespaces, rollbacks, indexes, data files & logs).
• Worked on HADR setup with Tivoli System Automation (TSA).
• Worked on HADR setup for mission critical databases on AIX platform.
• Monitor HADR activity.
• Managed database storage and capacity planning on DPF and Non-DPF databases.
• Extensive experience on working on restore from TSM on DPF databases.
• Proficient on working on DB2 Utilities like import, export and load on DPF databases.
• Involved in ETL design, architecture, and performance tuning including load strategies.
• Responsible for risk management; analyze any suggested change to systems and determine risk factor as well as recovery steps.
• Performed capacity planning and performance tuning.
• Involved in managing log files and theirby ensuring high availability of database in a 24X7 scenario.
• Developed document dat provides an overview of the physical and logical design of the database environment and implemented.
• Provide database backup and recovery support for DB2 UDB
• Create, configure, monitor, and tune DB2 UDB databases for new internal projects
• Worked with tools DB2 Performance expert, DBArtisan, DB2MON, and Control center to debug and resolve database issues
• Extensively worked on tuning complex SQL queries, developing stored procedures, and functions
• Effectively carried out database performance tuning and troubleshooting & fixing problems faced by application developer.
• Involved in running REORGCHK, REORG, REBIND, RUNSTATS, LOAD utilities against the database

ENVIRONMENT: DB2 EE V 9.7/9.5/9.1/8.2, Web sphere, AIX 5.x, windows NT/XP, Server, ERwin, SAN, Clustered Environment.