Manager Data

Vasantha Sabinedi

EMAIL: ablvw4@r.postjobfree.com

PHONE: 405-***-****

Summary:

• Experience with Analysis, Design, Development and Implementation.

• Extensive experience in installation, database development, implementation and

maintenance of huge databases.

• Extensive experience in installation of DB2 UDB (EE) for AIX/Solaris & Windows server.

Developed and maintained compliance to database standards and procedures.

• Created Databases and Instances in DB2 UDB, ORACLE, Sybase and SQL SERVER.

• Implemented table partitioning and Archival logging in DB2 UDB.

• Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of

logs, problem identification and resolution, security and disaster recovery planning.

• Strong in performance monitoring and fine-tuning of database for optimal performance of

SQL queries using DB2EXPLN, Database Space Management, Schema creation, Data

Transformation Services.

• Heavily experienced with using BMC Change Manager. Data maintenance utilities used

REORG, RUNSTATS, RECOVER/RESTORE, LOAD, IMPORT, EXPORT, DB2LOOK, and

DB2MOVE.

• Setting up of user accounts and user groups with AIX and NT authentication. Writing Shell

scripts for day-to-day database tasks.

• Performed 24/7 supports for Production Database.

• Experience in Data modeling tools ERWIN.

• Expertise in designing and implementing databases, full life-cycle application

development, administration & installing DB2 UDB versions 5.2, 6.1, 7.1,8.2 and 9.5,

DB2 Connect, DB2 utilities and Tools.

• Developed and Documented all the High-Level Database Procedures and Standards such as

Trouble-shooting Procedures, Test Team Support, Application Team Support, Backup and

Recovery, End-user support, On-call Support, Disaster Recovery, Physical Database

Design and Logical Database Design .

• Good experience as an Application and Production (24X7) DBA with good Backup and

Recovery.

• Fine-tuning the performance by using EXPLAIN plan tables and running Snapshot and Event

monitors.

• Extensive Experience in Oracle, SQL Server, UNIX.

• Experience in writing scripts with shell programming for daily system administration tasks.

• Experience in using SQL table functions for monitoring using SNAPSHOT_CONTAINER,

SNAPSHOT_BP, SNAPSHOT_AGENT, SNAPSHOT_LOCK.

• Familiarity and experience with data warehousing.

• REORGCHK and Setting constraints (Check pending).

• Excellent and proven interpersonal and communication skills, problem solving skills,

technical analysis expertise.

Certifications:

• IBM Certified Database Administrator – DB2 Universal Database V9 for Linux, UNIX,

and Windows.

• IBM Certified Database Associate - DB2 Universal Database V9 for Linux, UNIX, and

Windows.

Technical Skill Set:

Operating Systems: AIX 5.3, Linux, SOLARIS 5.8, WIN NT/2000, SCO-UNIX, MS-DOS.

Languages: SQL, PL/SQL, C++.

RDBMS: DB2 V9.5/9.1, DB2 UDB v8.2, 7.0, SQL Server 2000/7.X, MS Access 97, 2000.

TOOLS: Quest Central, Embarcadero, Erwin, Informatica, Ascential Datastage, DB2

Replication, DB2 development Center, Control center, Visual Explain.

Hardware: Sun E6500, RS/6000, IBM PC's, and Pentium PCs, HP servers, IBM P-Series.

Nationwide Insurance, Columbus, OH Oct ’08 – till date

Database Administrator

Responsibilities:

• Installed DB2, performance tuned, monitored the databases and involved in 24X7 on-call

production support and resolved issues in timely manner.

• Lead the activity of installing V9.5 fixpack3a on 200+ database servers.

• Wrote in house monitoring scripts that utilize V9.5 admin views to check the health of the

databases.

• Involved in migration of DB2 databases from V8 to V9.5.

• Usage of DB2_EVALUNCOMMITTED to decrease the number of deadlocks in a application.

• Used compression and validated its impact on a CPU bound system.

• Usage of multipage_alloc in an application which was using SMS tablespaces.

• Used db2pd utility in monitoring the database in various scenarios.

• Troubleshooted load pending, backup pending and check pending for the loads.

• Prepared backup and recovery strategy at Database level for all test and production

Database.

• Involved in load tests, reviewed database performance using vmstat, iostat etc and

recommended changes for tuning database and database manager configuration parameters

and db2 registry variables.

• Performed redirected restores, database recovery using the include logs option and

logtarget option.

• Configured HADR on various environments. Verified the heartbeat and the virtual IP after

the configuration.

• Monitored package cache overflows, catalog cache overflows.

• Used MQTs and clustered indexes to improve the performance.

• Tuned the indexes through index advisor and tuned the database using db2advis, visual

explain.

• Enabled STMM and monitored the STMM logs using the Perl based parser.

• Setup archival logging by modifying the LOGRETAIN and LOGARCHMETH1 parameters.

• Wrote shell scripts for online reorg on large tables and used crontab to schedule which

minimized down time and also to proactively monitor and review database performance and

to execute batch jobs.

• Involved in controlling lock escalations by tuning MAXLOCKS, LOCKLIST parameters and

reduced the number of deadlocks in production by modifying the LOCKTIMEOUT and

deadlock detection interval.

• Reduced the sort overflows by tuning SORTHEAP and SHEAPTHRES parameters.

• Worked with development teams in performing ad-hoc requests like executing the SQL in

staging and testing environments; Installed and troubleshooted query related and

configuration issues with DB2.

• Regular involvement in refreshing the data from production to test environments using data

movement utilities like export, import, load and db2move.

• Involved in preparing space requirements reports, buffer pool analysis, full explains on SQL

with index recommendations, database-level and instance-level configuration.

• Installed, performance tuned and maintained preproduction environment to mimic

production environment to troubleshoot the production issues.

• Monitored performance of applications using Snapshot monitors, event monitors and Quest

Spotlight for DB2 UDB.

• Documented the known issues such that proper care is taken in future.

Environment: DB2 ESE 9.5, 8.2, WebSphere Commerce 6, Linux, AIX, Windows NT/XP

SEARS, Chicago, IL Aug ’07 – Sep ‘08

Database Administrator

Responsibilities:

1. Worked on offshore- onsite coordination basis and trained offshore resources on DB2.

2. Involved in troubleshooting the issues with daily backup jobs and automation of daily jobs

like deleting the old backups and file system monitoring for DMS table spaces.

3. Wrote stored procedures for loading data from large flat files into tables.

4. Created Entity relationship diagrams for the new database and designed tables as per

3rd Normal form.

5. Coded SQL queries and reviewed pre-production SQL changes and made performance

recommendations based on EXPLAIN plan Analysis.

6. Did performance tuning of packages for the procedures.

7. Created MQTs to improve the response time of queries which will generate monthly

reports.

8. Compressed 8TB database to 5TB using V9 compression feature.

1. Assisted developers in resolving the issues with PL/SQL and provided guidance to

programmers for program development with DB2 on Windows.

2. Added clustered indexes to tune the queries with DISTINCT, ORDERBY and GROUPBY

on large tables.

9. Worked with various data movement utilities like EXPORT, LOAD, and IMPORT from

refreshing data in test and development regions.

10. Used RUNSTATS, REORGCHK and REORG utilities and tuned various database and

database manager configuration parameters to improve the overall performance.

11. Identified the risks arising out of connection user usage and created a new connection

user.

12. Wrote shell scripts which FTP’s flat file, table space monitoring script which alerts when

the DMS table spaces are 75% full and used Windows Scheduler to automate the

database tasks.

13. Installed SQL Server in various production and non production environments and

performed data modifications and migrations by using Data Transformation Services

(DTS)

14. Involved in creating and maintaining the transition hand book.

Environment: DB2 ESE and EEE 8.x, 9.1, SQL Server 2000, IBM Websphere 5.1, Linux, AIX

5.x, Solaris, Windows NT/XP

Indiana Family and Social Services Administration FSSA, IN Jan ‘07 – Aug ‘07

FSSA Eligibility Modernization Project

DB2 Database Administrator

Responsibilities:

Installation and configuration of UDB DB2 V8.1/V7.1 on AIX, as a DB2 Database

•

Administrator responsible for the performance tuning of applications.

Involved several database design and architectural activities working directly with data

•

architect involving in physical design and configuration of database.

Designing and constructing partitioning key, primary key, table constraints (foreign key, check

•

constraint etc), DDL implementation, modification and design of DB2 database objects and

used ERWIN tool for database design and configuration.

Performance tuning activities to manage database manager, database configuration, and

•

buffer pool configuration, registry variable configuration.

Provide support to development, testing and Production Systems.

•

Understand and implement star schema with a thorough understanding of FACT tables and

•

dimension tables.

Performance tuning activities to manage database manager configuration, database

•

configuration, registry variable configuration and buffer pool configuration.

Supporting the development team and also 24x7 productions on call support.

•

Migration of data from various development environments to production.

•

Created the MQTs and MDCs after an extensive analysis of the pros and cons.

•

Implemented the backup of database across all partitions to go onto TSM.

•

Written shell scripts to backup the database across all partitions.

•

Used Tivoli Work Load Scheduler to kick of the Load jobs and regular DB maintenance jobs

•

across development and production environments.

Created Snapshot monitors and event monitors to regularly check the health of the system.

•

Created MDC indexes to get the best performance.

•

Created block based bufferpools to get the better performance.

•

Created monitors for tablespaces, tables and calculated the Bufferpool hit ratio for various

•

tablespaces.

Creating and Populating User-maintained Materialized Query Tables.

•

Generated database statistics reports using DB2LOOK utility.

•

Created EXPLAIN tables and ran the Visual Explain utility on SQL statements.

•

Automated the scripts like backup, recovery, runstats etc.

•

Used Load utility to load data in partitioned environment.

•

Created EXPLAIN tables and ran the Visual Explain utility on SQL statements.

•

Used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load

•

data.

Performed Reorgchk, Reorg and RUNSTATS as and when necessary to eliminate the

•

defragmentation.

Environment: db2 udb ESE v 8.2 (fixpak 12), AIX 5.3, Business Object, Brio, java, Quest

Central, Tivoli Storage Manager (TSM), p690, RS/6000.

Chrysler LLC, Auburn Hills, MI Nov ’05 - Dec ‘06

DB2 UDB DBA

Responsibilities:

• Used Snapshots on Locks, Applications, Database, Tables, Buffer pools and Dynamic SQL.

• Used iostat, vmstat to monitor input/output and virtual memory.

• Developed DDL scripts to create tables, constraints, indexes and Triggers.

• Developed DDL and PERL scripts to export and compare data in two different databases and

generate the DDL to fix the issue with triggers.

• Restored Test system with online backup from Production system.

• Developed and modified PERL script to do maintenance tasks like REORG, RUNSTATS and

BIND etc.

• Handled issues where the database hangs at periodic intervals.

• Developed SQL statements to generate data as per the customer requirement.

• Extensively used EXPORT, IMPORT and LOAD to replicate date from the online database

to offline database.

• Efficient in SQL tuning to improve performance using DB2EXPLN, DB2ADVIS and

DB2EXFMT.

• Modified various Database and Database Manager Configuration parameters as a resolution

to various issues.

• Worked on taking a complete system (sysback) tape backup from the online side and

restoring it on the offline side.

• Worked on new installations of DB2, AIX, LINUX and Client software at different locations.

• Extensively worked on data warehouse Report Issues.

• Used Monitor Switches, Inspect, Event Monitors and DB2LOOK etc to diagnose various

issues.

• Extensively worked on Day to Day database maintenance tasks like Backup, REORG, and

RUNSTATS and monitoring health.

• Provided 24x7 On Call Production Support.

Environment: UDB DB2 V 7.1 Enterprise-Extended Edition, Data Warehouse Manager,

AIX 4.3.2, Win2000, Win NT, Linux, CA Erwin, ERStudio, Data Propagator, DB2 Connect

TCS India Jun ‘04 – Nov

‘05

Honda of America, Columbus, OH

Developer & DB2 UDB DBA

Responsibilities:

• Used utilities to Backup and Recover user data and DB2's catalog.

• Created databases and other database objects.

• Worked with export, import, load utilities to manage table data.

• Prepared and implemented standard recovery procedures for data recovery.

• Used RUNSTATS, REORGCHK and REORG to enhance application performance.

• Used DB2 access control mechanism to implement security within the database.

• Involved in installing DB2 UDB on AIX, create Instances and databases including DBM

configuration on different servers and provide connectivity to Development, test, staging and

production databases.

• Recovered data to a prior point in time.

• Creation of Database Objects Tables, Table space, Indexes and Storage group.

• Involved in developing database application objects like stored procedures, functions, triggers

and user defined data types.

• Involved in Performance and Tuning by considering the parameters like Hardware, Database

configuration Parameters, SQL statements and Web Sphere App Server .

• Using EXPORT, IMPORT and LOAD utilities, moving Data between tables and output files.

Environment: UDB DB2 V 7.1 Enterprise-Extended Edition, Data Warehouse Manager, AIX

4.3.2, Win2000, Win NT, Linux, CA Erwin, ERStudio, Data Propagator, DB2 Connect, DB2

DataJoiner, Control Center, Tivoli Storage Manager (TSM), WebSphere, SP2, OLAP

Integration server, Brio, Informatica, SIEBEL, RS/6000 model R50, S85, B50

Contact this candidate