Manager Database

Vinay K Tomer

Email ID: *************@*****.***

Contact: 682-***-****

Summary:

• Served as the DB2/ORACLE Database Administrator with responsibilities covering the

complete range of database activities including database security, logical and physical

database design, backup and recovery, performance tuning, and software

maintenance.

• Experience working on DB2 UDB EEE,EE.

• Extensive experience with DB2 UDB on AIX.

• Experience working on HADR, VCS cluster.

• Extensive experience working on VSU snap backup and recovery.

• Performance tuned numerous applications by managing the buffer pools.

• Experience Working on TSM.

• Experience in designing database model using Rational Data Architect.

• Monitored and tuned the DB2 subsystems, controlled the physical aspects of the DB2

database including backup and recovery.

• Provided database support for application development and provided database training for

applications developers.

• Strong knowledge in performance monitoring/tuning/troubleshooting on DB2 Unix, Linux and

Window servers.

• Experience in migration of DB2 from v8x to v9x.

• Strong experience in table Partitioning.

• Strong experience of data compression in DB2.

• Knowledge of MQT and MDC.

• Gained expertise in STMM.

• Good experience on db2mtrk and db2pd, db2dart, db2inspf etc.

• Skilled in Database designing and implementing complete life cycle client servers and

database applications with various development tools and languages.

• Good Experience in Database backup concepts and options such as user-managed backup,

VSU snap backup, operating system backup, cold and hot backup, full backup, incremental

and cumulative backup.

• Implementing backup and recovery strategies.

• Experience in 11g/10g Real Application Clusters (RAC), ASM, CRS installation and

maintenance

• Good Experience in Database backup concepts and options such as user-managed backup,

RMAN-managed backup with or without catalog, operating system backup, cold and hot

backup, full backup, incremental and cumulative backup. Implementing backup and recovery

strategies.

• Knowledge of High Availability Solution like Oracle 11g/10g Grid Infrastructure, RAC,

Advanced Replication, Oracle Stream, Oracle Failover using Active-Passive cluster

and disaster recovery.

• Unix Shell scripts for hot backups, SQL*Loader, export and import of database.

• Performed Daily Monitoring of Oracle instances using Oracle Enterprise Manager, TOAD,

monitor users, table spaces, memory structures, rollback segments, logs, and alerts.

Education:

Bachelor of Science (BS)

• Ch. Charan Singh University, Meerut. (J.V.College,Baraut,UP, India)

Certification:

• Microsoft Certified System Engineer (MCSE) SQL Server 2000.

Technical Skills:

Databases DB2 UDB 9.5, 9.1, 8.1, 7.X, Oracle 10g /11g, DB2 Relational Connect, DB2

Data Joiner, ETL

Applications DB2 Universal Developer Edition, Stored Procedure Builder, DB2 UDB EEE

Storage Tivoli Storage Manager

Clusters DB2 UDB EEE/ESE

Middleware IBM WebSphere

O/S AIX 5.1, Solaris 2.x, HP-UX 10.2, 11.0, Windows 2000, XP, NT-4.0

Hardware Sun Solaris, IBM RS 6000

Programming Java, Perl, C, PL/SQL, SQL, UNIX Shell

Professional Experience:

Verizon, Dallas TX Jan 08 – Present

DB2 UDB DBA / Oracle DBA

Responsibilities:

Designing, implementing and administering DB2 UDB for development, test and in production

environment. Worked in all phases of connectivity architecture, test and implement backup and

recovery strategies, disaster recovery planning, distributed database architecture, storage

management, capacity planning, data replication, database migration and performance tuning.

Experience in utilizing DB2 data sharing, installation, buffer pools, tablespaces, tables, indexes,

adding containers to the tablespaces, monitoring the database activities, monitoring tablespace

usage, applying fixpacks, data movements, SQL monitoring, configuring remote connectivity of

DB2 databases, assist developers regarding database and server related issues in a very large

and complex multi platform environment.

• Ability to troubleshoot day-to-day problems encountered on production as well as

development, test database environments in single and multiple partitions.

• Maintained a database which is 6TB in size.

• Experience in migrating data from v8 to v9.

• Good knowledge of table partitioning.

• Added partitions in tables. Attached and Detached partition.

• Added partitions and have done redistribution to different nodes.

• Experience of data skew.

• Experience Working on MQT.

• Improved performance on dataware house by 30%.

• Knowledge of data compression.

• Experience working on STMM.

• Optimize the query access plans, resource and space utilization.

• Strong skills in writing Perl and shell scripts in UNIX and the good knowledge about UNIX

servers and server architecture.

• Develop and implement standards to create various database objects.

• Installing and maintaining DB2 environment includes creating databases, buffer pools,

logical and physical design of database storages using DMS/SMS tablespaces.

• Allocate database sizing with proper log space and establish securities.

• Create and implement effective referential integrity rules for complex databases in OLTP

environment.

• Maintain security administration includes handling instance / database level authorities.

• Implement DB2GOV utility for capturing queries running beyond the set limit of threshold and

queries causes lock-wait for other applications.

• Execute RUNSTATS for generating and updating table and index statistics.

• Experience with cataloging multiple instances and configuring connectivity to databases from

remote clients using CCA.

• Performance tuning of the production and development databases using explain tools.

• Schedule and execute reorg/runstat on the database tables.

• Develop automated scripts for redirected restore of database to clone databases for

development, Quality-Assurance and performance environments

• Installation, configuration and upgrading of DB2 server software and related products.

• Monitor databases for lock escalation, dead lock, resource utilization by sessions,

package caching, buffer pools hit-ratios, capturing long running SQL/runaway queries

using DB2 snapshot.

• Co-ordinate with IBM Global Support for resolving various reported issues.

• Develop event monitor to monitor deadlock.

• Monitor and benchmark database performance by using the DB2 tools like snapshot and

monitors.

• Develop scripts and procedures to monitor production databases for growing table spaces,

deadlocks and resource contention.

• Create scripts to purge not needed data on production.

• Creation of the Development, Test and Production Oracle 10g / 11g databases.

• Implemented Oracle 11g database in the test environment.

• Team member to upgrade the 10g database to 11g.

• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and

managing user groups, Database security, OS space monitoring etc.

• Tuning SQL at both database and user levels using SQL_TRACE, TkPROF,

EXPLAIN_PLAN.

• Backup/Restoration, scheduling Backups, taking Logical Backups.

• Cloning of production database to the test environment using Recovery Manager (RMAN).

• 10G Grid control especially monitoring the database, configuration of different notifications,

installing and configuring agent, listener, databases.

• Worked with backup team and was responsible for configuration and implementation of

backup strategies using RMAN.

• Scheduled jobs using DBMS_JOB,Cron and Grid.

• Created RMAN scripts for backup and recovery.

• Export and Import of database objects to copy from one database to another database with

use of datapump in 10g and convention oracle export, import for 9i database.

• Performed Performance Tuning at database level, Application level, and user level tuning.

• Keeping database up-to-date by applying patches and worked with oracle support on different

database issues.

Yash Solutions LLC, Atlanta GA Sep 06 – Dec 07

DB2 Administrator

Responsibilities:

• Maintain, tune, troubleshoot, upgrade installs and debug database storage and layouts of

DB2/UDB V8.1 Database components within the organization.

• Develop and maintain compliance to database standards and procedures. Assist with design

and organization of database during systems development process.

• Monitor databases and make adjustments to improve performance of database or

applications that use the data.

• Provide technical and on-call support to programming staff for Databases.

• Participate in disaster recovery and planning.

• DB2 UDB V8.1 Database design, modeling, performance tuning and database

implementation in a large production environment.

• Event monitoring and troubleshooting database issues, by enabling various diagnose level

settings.

• Work with application developer and monitoring SQL through gathering explains data and

advising SQL tuning tips.

• Identify and correct the poor execution plan of SQL statements that result in efficient

SQL statements processing using DB2ADVIS.

• Configure and fine tune DB2 DBM and DB configuration parameters for better

response, throughputs and proper utilization of global memory.

• Manage loading, migrating and maintaining data with LOAD, EXPORT, IMPORT DB2LOOK

and DB2MOVE utilities.

• Administer databases using Control Center, Command Center, CLP, and Script Center.

• Systems optimization, tuning and rotating 24x7 on-call support.

• Worked with development teams and Data administration staff for Database enhancements.

• Automated routine tasks like Backups, Reorg / Runstats, Benchmark, File cleanup, monthly

generated space reports using Korn shell scripts.

• Demonstrate clear, concise, accurate and timely communication to management and

customers in written and oral form.

• Strong attention to detail and problem solving skills.

• Ability to work within cross-functional teams.

Miracle Technologies, Noida, India May 05 – May 06

Database Administrator

Responsibilities:

• Software Development Life Cycle.

• Requirement Study Analyses, Design and Development.

• Creating Database, Tables, View

• Database backup and Recovery.

• Configuring Database for best Performance

• Installing, Configuring and Troubleshooting Access to Resources.

• SQL Programming

• DTM Package creations.

Contact this candidate