Roja Garapati

845-***-****

adbnzf@r.postjobfree.com

Professional Summary:

US Citizen with 14 years of experience in IT industry comprising 14 years of solid DB2 LUW, 5 years Oracle along with 3 years of AWS RDS database administration experience.

Worked on Database Architecture, Installs, Upgrades, Migrations, Replication, Monitoring, Design, Model, Performance Tuning, Backup, Recovery in a 24x7 Production environment.

Worked and supported multi-terabyte size databases, DSS, ERP, Data Warehouses and Data Marts (OLAP and OLTP) in the partitioned environments (DPF/EEE).

Performed various DB2 upgrades in V11.1, 10.5, 9.7, 9.5, 9.1, 8.2, 8.1 and 7, instance migrations and latest fixpack applications and 32 bit to 64 bit migrations.

Worked on heterogenous databases on multiple platforms like Win2000, WinNT, Linux, Sun Solaris, AIX, HP-UNIX.

24/7 on call production support with strong experience in handling the critical applications.

Insourced and supported Multi-Terabyte SAP UDB databases.

Designed, planned and implemented the DB2 database cross-platform migration project which involves moving all the DB2 databases residing on HP servers to AIX servers.

Review SQL and tune to improve performance by various methods including re-writing SQL, creating or altering database objects, designing and creating MQT and MDC tables etc.

Implemented row compression, range partition and table partition features.

Expertise in disaster recovery planning, testing, implementation and experience installing, configuring and maintaining HADR and HACMP environments.

Experience in Oracle database administration including allocation and maintenance of rollback segments, automatic undo management, tablespaces, data files, redo log files, mirroring of redo log files across multiple disks and data replication.

Expertise in RMAN backup/restore, Data Pump, code drops, create users and trace sessions.

Extensive experience in applying the suitable APAR’s to fix problems and bugs in the DB2 software and working with IBM DB2 Support to resolve issues.

Database maintenance, security, backup, recovery, performance monitoring, tuning, maintenance of logs, disaster recovery planning, problem identification and resolution.

Experience using data maintenance utilities like inplace/offline reorg, runstats, export, import, load, quiesce, db2pd, db2move, db2relocatedb, db2mtrk, db2dart, db2expln, dynexpln, db2exfmt, db2top, db2service.perf1, db2advis etc.

Strong DB2 SQL, PL/SQL experience and exceptional skills in developing stored procedures and triggers.

Excellent oral and written communication skills demonstrating clear, concise, accurate, and timely communication to management, peers, and customers and ability to work within cross-functional teams.

Strong attention to detail, problem identification and solving skills and quick learning capabilities with passion to constantly learn new technologies.

Education:

M.S in Computer Science, Southern Illinois University Edwardsville, 2006.

Technical Skills:

RDBMS:

DB2 LUW V11.1/10.5/9.7/9.5/9.1/8.2/8.1/7.2, Oracle 12c/11g/10g/9i/8i/7, AWS RDS, SQL, PL/SQL, SQL Server, Progress, MS-Access, Erwin.

Operating Systems:

AIX 7.1/6.1/5.3/4.3, EC2, HP-UNIX, Linux, Solaris, Windows, OS/390.

SAP Components:

SAP R3 4.7, ECC5.0/6.0, BW 3.0/3.5, CRM, EP6.0, WebAS, NetWeaver, Solution Manager 4.0.

DB2 Tools:

SolarWinds, Quest Central, Foglight, Spotlight, Work Load Manager, Toad, db2top, db2 connect, db2pd, db2 connect, db2batch, TSM, IBM Tivoli Monitoring Service, CommVault Simpana software, BMC PATROL and Utilities, HADR, TOAD, TSM, Snapshot Monitor, Event Monitor.

Internet/Application Development:

Java, J2EE, Perl, MS FrontPage, C, C++, Unix Shell Scripting (Korn Shell), Rational Rose, Websphere, Power Builder.

Professional Experience:

Stanley Black & Decker, MD Mar ’11 – Till Date

Senior DB2 UDB DBA

Responsibilities:

Designed and implemented the major insourcing project of Multi-Terabyte SAP databases.

Provided 24/7 on call support for DB2, Oracle and RDS databases.

Involved in upgrade of SAP R/3 4.7 to ECC 6.0 and applying SAP Support packs, SAP notes, and using DB2, SAP traces to resolve issues working closely with the Basis team.

Performed DB2 Installations, Upgrades, Migrations and Configuration with enterprise storage area networks (SAN).

Managing Oracle Databases on AWS EC2 and RDS services.

Migrated data from Oracle to RDS using AWS Database Migration Services (DMS).

Support designing, deploying, provisioning and operating highly available, scalable and fault tolerant systems using Amazon Web Services (AWS).

Experience in creating multiple VPC’s and public, private subnets as per requirement and distributed them as groups into various availability zones of the VPC.

Proficient in AWS services like EC2, S3, RDS, CloudFormation and CloudWatch.

Created and configured elastic load balancers and auto scaling groups to distribute the traffic and to have a cost efficient, fault tolerant and highly available environment.

Created S3 buckets in the AWS environment to store files, sometimes which are required to serve static content for a web application.

Created snapshots to take backups of the volumes and images to store launch configurations of the EC2 instances.

With the help of IAM created roles, users and groups and attached policies to provide minimum access to the resources.

Expertise with split mirror backups which involves taking a snapshot and initializing the database on a different server in a way which reduces load on the production systems.

Hands on experience installing and configuring Commvault clients on the database servers.

Worked on various backup, recovery, log archiving, performance related issues with IBM support, Oracle support, AWS support, Commvault support and successfully resolved them.

Extensive experience in database/tablespace backups, redirect restores/recovery/rollforward, archive log management and filesystems restore using CommVault interface.

Setup DB2 database encryption and implemented SSL setup to enable encrypted connections using certificates signed by internal CA.

Security implementation using CyberArk policies and expertise with CyberArk Vault, password rotations and malfunctions.

Experience in analyzing and monitoring the entire system to pin point the bottlenecks using tools like event and snapshot monitors, db2top, db2pd, db2advis, db2expln, vmstat, iostat.

Developed automated scripts using Unix shell and Perl for performing runstats, reorg, rebind, backup, load, export, database monitoring and performance.

Involved in the data modeling, physical and logical database design, database provisioning and implementing new database enhancements.

Tune SQLs to improve performance. Review SQL codes and improve performance by various methods including re-writing SQL, creating or altering database objects.

Performed SAP and DB2 audit checks manually and using db2audit and took necessary measures to correct the violations.

Extensive experience with Disaster recovery procedures and tests.

Implemented SolarWinds and ITM for monitoring databases.

Extensive experience with Service now and HP Openview Service Center for problem management and change management.

Performed oracle refreshes in 10g, 11g and 12c environments.

Maintained and performed daily administrative tasks in Progress database environment.

Environment:

DB2 LUW V11.1, 10.5, 9.7, 9.5, 9.1, SAP R/3, Netweaver, CRM, BI and Netweaver Based Products, AWS (EC2, VPC, ELB, S3, RDS, Cloud Watch, CloudFormation), HACMP, HADR, IBM Tivoli Monitoring Service, Quest, Oracle 12c/11g/10g/9i, AIX 7.1/6.1/5.3, Windows (XP/NT), TSM, Commvault, CyberArk, SolarWinds.

Comerica Bank, MI Dec ’09 – Mar ’11

Senior DB2 UDB and Oracle DBA

Responsibilities:

Installed, maintained, upgraded and administered UDB EEE and EE databases.

Provided 24/7 oncall support for UDB databases.

Created and maintained instances, databases, tablespaces, event monitors, snapshot monitors, schemas and users on both partitioned and non-partitioned databases.

Migrated V8.2 instances to V9.5, V9.1 instances to V9.5 and 32 bit instances to 64 bit.

Performed de-migration of databases to certain level due to undesired application performance.

Worked with IBM during talks to implement DB2 PureScale technology.

Expertise with Quest database monitoring tools on DB2 servers.

Provided cost savings by creating multiple instances and reducing licensing costs.

Implemented deep row compression on tables which saved 30% disk space in production.

Extensive experience downloading DB2 Connect client software, installing, configuring and maintaining and upgrading connect clients on AIX, Linux and Solaris platforms.

Performance monitoring and fine tuning of SQL queries using db2expln, db2advis, db2top and db2pd. Review SQL codes and improve performance by re-writing SQL, creating or altering database objects, designing and creating MQT and MDC tables etc.

Created and managed range partitioning tables and implemented a script to automatically roll-in/rollout monthly partitions for range by attaching/detaching table partitions.

Setup Database Federation in DEV/QA/PROD environments.

Monitored data propagator scripts and verify the log files created by dprop scripts to ensure that the data is replicated on the server by querying the tables.

Extensive experience with Disaster recovery procedures and tests.

Expertise in database backups and point-in-time recovery in a partitioned environment.

Monitor transaction logs from being filled up, ensuring that logs are archived and backed up.

Expertise in installing and configuring 32 and 64 bit db2cops, performed DB2 audit checks quarterly and took necessary measures to correct the violations.

Extensive experience with peregrine tool for problem management and change management.

Running the reorgchk, reorg, runstats utilities in DB2 and maintained the scripts to automate online/offline reorgs and runstats.

Monitor and analyze database growth and space requirements of table spaces, performed backups, tablespace management and reorganization.

Expertise in Oracle database code installation, patch installation, client installation and refreshes in 10g and 11g environments.

Oracle database activities include allocation and maintenance of rollback segments, automatic undo management, tablespaces, data files, redo log files, listener and tnsnames.ora files, mirroring of redo log files across multiple disks, data replication.

Environment:

DB2 LUW V9.7, 9.5, 9.1, 8.2, 8.1 EE/EEE, DB2 Connect, Health Monitor, Replication center, HADR, Quest, Snapshot Monitors, Data Propagator, Oracle 10g/9i, Linux, Solaris, AIX 6.1/5.3/5.2/5.1, Windows (XP/NT), TSM, WebSphere, MQ-Series.

IBM, CO Oct ’08 – Nov ’09

Senior DB2 UDB DBA

Responsibilities:

Installed and maintained UDB EEE/EE servers and performed point in time recovery.

Supported UDB databases for various IBM internal, external and commercial accounts.

Built and supported IBM FileNet P8 (FileNet Records Manager P8, Content Engine etc) databases and application working very closely with application team for Records Management project.

Built Content Object Store, Fileplan Object Store, LDAP, Process Engine, FN System Monitor and Global Configuration databases for FileNet application. Built client to connect to the Process Engine database and all the other databases are connected to via FileNet datasources (via websphere).

Migrated and supported multi-terabyte size Warehouse and Mart databases in the partitioned environment.

Wrote shell scripts for dynamic configuration on different servers, performance analysis, checking error log, tablespace threshold alerts and automation of database utilities.

Extensive experience with IBM Manage now tool for problem and change management.

24/7 support for the production environment.

Databases are tuned to release the buffer pool space allocated for database but not used.

Restored the database from crash recovery, which wiped off the database while the containers still exist.

Hands on experience installing TSM clients on the database servers and configuring the TSM environment variables and 32 to 64 bit TSM migrations.

Resolved various TSM issues during backups, restores, log archiving. Experience monitoring and debugging TSM server.

Maintained the existing replication setup to monitor the updates on sensitive data.

Maintained the connection handles between the application server and the database server and synchronized the recycling process between the two servers.

Helped developers with problems related to accessing the DB2 database through WebSphere and resolved issues of MQ Series accessing the database.

Extensive experience with Disaster Recovery tests for the various IBM clients.

Environment:

UDB DB2 V9.1/9.5, AIX 5.3/5.2, Windows, Solaris8, Win NT, DBArtisan, WebSphere, DataStage, MQ-Series, Erwin, Platinum, Seibel, Windows 2000

DTE Energy, MI Jan ’08 – Sep ’08

Senior DB2 UDB and Oracle DBA

Responsibilities:

Installed, maintained and administered UDB DPF, EEE and EE SAP databases.

Maintained and administered Oracle databases including code installation, patch installation and client installation.

Provided 24/7 on call production support for various SAP components like R/3, BW on DB2 databases for the SAP accounts.

Migrated V8.2 instances to V9.5, V9.1 instances to V9.5 and 32 bit instances to 64 bit.

Designed, planned and implemented the DB2 database cross-platform migration project. It involves moving all the 40 DB2 databases residing on HP servers to AIX servers.

Deployed XML Extenders to parse xml data and to retrieve xml data stored in CLOB fields.

Extensive experience in database/tablespace backups, filesystem backups, redirect restores, point-in-time recovery, restores in a partitioned environment, archive log management and filesystem restores using lan-free TSM, tapes and disks during migrations and deployments.

Experience in table moves from 4k tablespace to 4k/16k/32k page tablespaces and tablespace management in db2 and in SAP using db6conv.

Extensive experience with Disaster recovery procedures and tests.

Opened PMRs with IBM DB2 support for critical issues and guidance on problem solutions.

Extensive experience with Peregrine Service Center and Access Enforcer for problem management and change management process.

Implemented backup compression for the daily backups and it reduced the network traffic and disk space utilization before the backups moved on to tape.

Running the reorgchk, reorg, runstats utilities in DB2 and SAP and maintained the scripts to automate online/offline reorgs and runstats.

Database activities include allocation and maintenance of rollback segments, automatic undo management, tablespaces, data files, redo log files, listener and tnsnames.ora files, mirroring of redo log files across multiple disks, data replication.

Installed and configured catalog database for Recovery Manager (RMAN) and used RMAN to take full differential/cumulative incremental backups.

Worked closely with other teams for ongoing activities, future tasks, performance issues and enhancements for their landscapes.

Performance monitoring and fine-tuning of database for optimal performance of SQL queries using DB2 explain plan, creating and analyzing event monitors and snapshot monitors.

Environment:

DB2 LUW V9.5, 9.1, 8.2, 8.1, EE/EEE, SAP R/3 4.7/4.6C, BW 3.5, WAS 620/640, DB2 Health Monitor, Quest, Snapshot Monitors, Oracle 10g/9i, RMAN, DB2cops, XML extenders, XML, AIX 5.3/5.2/5.1, TSM, WebSphere.

Borders, MI Apr ’07 – Jan ’08

Senior DB2 UDB and Oracle DBA

Responsibilities:

Installed migrated and maintained UDB EE/EEE administered Oracle databases.

Created and maintained instances, databases, tablespaces, schemas and users (both administrative and development) on both partitioned and non-partitioned databases.

Performance monitoring and tuning for DB2 databases and applying updates and APARS.

Wrote scripts to schedule cron jobs to perform backup and to unload certain tables for transfer from DB2 UDB on Windows NT platform to Mainframe platform and scripts to monitor tablespace thresholds, utilities like runstats, reorgchk, reorg etc.

24/7 support for the production environment.

Physical and logical design modeling of the database using tools like Erwin.

Responsible for day-to-day administration of database servers and application servers.

Creates, supported and administered MDC’s, MQT’s and replicated MQT’s on multi-terabyte size data warehouses and data marts in partitioned environment for optimal performance.

Used BMC change manager, catalog manager and DASD manager for space management and data-migration.

Opened PMRs with IBM DB2 support for critical issues and guidance on problems.

Performed cross-platform replication and maintained the existing replicated environments.

Expertise in Oracle code installation, patch installation, client installation.

Oracle database activities include allocation and maintenance of rollback segments, automatic undo management, tablespaces, data files, redo log files, listener and tnsnames.ora files, mirroring of redo log files across multiple disks, data replication.

Environment:

UDB DB2 V9.1/8.2/ 8.1, Oracle 10g/9i/8, AIX 5.3/5.2/5.1, DBArtisan, Db2Connect, Control Center, RMAN, DataStage Control-M, WebSphere 5.1, MQ Series, Java, DB2 Run Time client, JDBC, ODBC, BMC, Win NT, Windows 2000.

Avaya, NJ Oct ’06 – Mar ’07

DB2 UDB DBA

Responsibilities:

Performed regular DBA duties like installing DB2 software, applying fixpacks, installing clients, creating instances and databases.

Set up monitor scripts to page when the table spaces threshold has been reached.

Load data using data movement utilities like db2move, export, import and load.

Modified the database manager and the database configuration parameters for performance and configure the DB2 registry variables.

Tuned the long running queries for better performance, resolved locking issues and redirected restore the databases from production to development and QA environments.

Granting and revoking authorities and privileges for users and objects on the database.

Log Archiving is turned on by setting up Userexit program (C language).

Running the reorgchk, reorg, runstats utilities and automated them.

Experience working with Tivoli Storage Manager (TSM) for backups.

Migration of instance from V7 to V8.2.

Designed, created and implemented data purge process to purge all the old data.

Troubleshoot problems in installation, development and production environment.

Environment:

DB2 UDB 9.1/8.2, DB2 Utilities, Perl, SQL*Loader, Import/Export, Erwin, DB2 Connect, Control center, SQL*Plus, Ab Initio, PL/SQL, RMAN, Unix, AIX 4.3/5.3, Windows 98.

Contact this candidate