Database Administrator
Resume:
Jaiganesh Thangavelu 571-***-****
**********@*****.***
Summary:
• IBM certified Database Administrator with over 15+ years of IT experience in Database
Administration as DB2 UDB DBA having extensive experience in installation, database
development, implementation and maintenance of large databases.
• Worked on UDB v8, V9.5, V 9.7. V 10.1 and V 10.5
• Upgraded databases from V 9.7 to V 10.1.
• Executed a daily basis administration task in SAP and OS systems.
• Extensive experience in installation of DB2 UDB for LUW Administration tools like
Database Studio, Optimum Database Administration, Control center, Command line processor,
Configuration assistant, Script center, Alert Center.
• Read and Write complex SQL queries and understand the business that necessitates
that complexity.
• Knowledge on database administration for Oracle 9i, 10g and 11g, with experience within
very large scale database environment and mission critical large OLTP and OLAP systems.
• Setup backup and recovery procedures using oracle rman tools.
• Database Sizing, Tablespace Management and Rollback Tablespace Management,
Transaction Management and Security Administration.
• Deployed shell scripts in multiple servers.
• Performed SQL Tuning, DB/DBM parameter tuning and different levels of memory
allocations
• Written scripts to automate the jobs (REORG, RUNSTATS & BACKUP) to monitor daily
activities.
• Extensively worked on Performance Tuning, recommended SQL Queries for better
performance using snapshot monitor, db2top, db2 index advisor and db2exfmt.
• Enhanced application performance using runstats, reorgchk and reorg utilities.
• Supported OLTP databases for transportation, end to end support of new builds and
applications.
• High availability (HA) and disaster recovery (DR) experience with DB2 HADR
• Instance and database monitoring and tuning experience using the DB2 Health Center,
Snapshot and Event monitors to monitor and optimize instance and database configuration
parameters, table spaces, and buffer pools.
• Database utility experience including reorg, runstats, rebind, export, import, load, auto-
load, backup, restore and recover database utilities.
• Database backup and recovery experience with online full and incremental backups,
online and offline transaction log archiving, restore and roll-forward (including redirected
restore), and recover database utilities.
Certifications:
• IBM Certified Database Administrator DB2 9 for LUW.
Jaiganesh Thangavelu **********@*****.***
• IBM Certified Advanced Database Administrator DB2 9 for LUW.
• IBM DB2 UDB 8.2 Certified Database Administrator
• IBM DB2 UDB 8.2 Advanced Database Administrator
Education:
• Bachelor of Engineering (Electronics) April 1998, University of Madras, India
Work Experience:
Jun 2011- Till Date BNSF Rail Road Company Senior DBA
Fort Worth, TX
• Installed and configured DBMS software, maintained software release levels.
• Migrated udb database v9.5 to v10.1, enabled compression to reduce the database storage in
multi node Infosphere Warehouse environment
• Provided 24/7 support to highly available OLTP, ODS, DW databases.
Monitored, recommended and implemented changes and enhancement to the database/server
environment viz., table space growth, partitioning, index management, physical design in order to
achieve maximum performance.
• Installed and configured DB2 V10.1 HADR environment
• High availability (HA) and disaster recovery (DR) experience with DB2 HADR
• Supported Data Mart and Data warehousing environment.
• Designing system storage structure and planning future storage requirements (design &
analysis of file systems, logical volumes, raw containers)
• Implemented instance level and database level configuration parameters for database
concurrency, authentication, performance and allowing remote clients accessing server
• Database objects creation & alteration (tables, indexes, views, stored procedures, functions,
etc.)
• Worked in data movement utilities IMPORT, LOAD, and EXPORT.
• Tuned databases using tools like snapshot monitor, visual explain, Index adviser, db2expln,
db2exfmt .
• Federated database server creation in order to allow access of another databases (DB2 or non-
DB2) inside a DB2 database.
• 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.
• Worked with database vendors and external support on issues such as upgrades, technical
problems and solutions.
Jaiganesh Thangavelu **********@*****.***
• Administer the DB2 UDB Databases, including, backups and recovery in DPF,
• Administer the udb security systems, including user administration,
Sep 2005-Mar 2011 Freddie Mac -Mclean, VA Sr.DBA Consultant
Responsibilities:
• Extensive experience in installation of DB2 UDB for LUW Administration tools like Database
Studio, Optimum Database Administration, Control center, Command line processor, Configuration
assistant, Script center, Alert Center.
• Responsibilities include disaster recovery, capacity planning, and Real Time monitoring,
troubleshooting, and proactive maintenance.
• Implemented HADR and High availability in DB2 UDB.
• Strong in performance monitoring and fine-tuning of database for optimal performance of SQL
queries using Visual Explain.
• Data maintenance utilities used REORGCHK, REORG, RUNSTATS, BACKUP,
RECOVER/RESTORE, LOAD, QUIESCE, IMPORT, EXPORT, DB2LOOK, IMPORT and INGEST
• Read and Write complex SQL queries and understand the business that necessitates that
complexity.
• Knowledge on database administration for Oracle 9i, 10g and 11g, with experience within very
large scale database environment and mission critical large OLTP and OLAP systems.
• Setup backup and recovery procedures using oracle rman tools.
• Database Sizing, Table space Management and Rollback Table space Management,
Transaction Management and Security Administration.
• Deploying shell scripts in multiple servers.
• Perform file system copy from production to non-production using TSM backup and recovering
DB2 databases in non-prod environment.
• Offshore Co-ordination, work allocation, mentoring junior DBAs, work review etc..
• Developed streamlined process for reorgs on different types of table such as cluster, normal,
MDC, SAP Cluster, volatile tables etc..
• Developed and maintained compliance to database standards and procedures.
• Created Databases and Instances in DB2 UDB and Oracle.
• Fixpak installation and version upgrades.
• Implemented Database 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.
• Used DB2 Advisory for optimizing the query.
• Written shell scripts for monitoring the backup, Restore, Health monitoring.
• Used Quest central for DB2 Monitoring, db2 performance monitoring etc...
• Implemented backup compression technique and can support Time finder backups
Jaiganesh Thangavelu **********@*****.***
Mar 2005-Aug 2005 Lehman Brothers -Jersey City, NJ DBA Consultant
Responsibilities:
• Provided 24X7 on-call support rotation with staff DBA’s, minimizing downtime of databases.
• Installation of DB2 UDB EE and Fix packs on UNIX and Windows machines.
• Install and configure DB2 UDB new releases, upgrades, and patches.
• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of
tablespaces, physical I/O rates, and table access activities.
• Proactively monitor performance, diagnose problems and tune queries and database.
• Assisting with the creation and modification of primary database storage structures
(tablespaces) and primary objects (tables, views, indexes)
• Changing instance level and database level configuration parameters for database
concurrency, authentication, performance and allowing remote clients accessing server.
• Design, Creation and maintenance of databases for highly demanding environments.
• Replication and Migration of databases across heterogeneous platforms.
• Performance tuning of databases including query tuning and optimization.
• Understanding of database access and ability to assist developers in implementing efficient
SQL.
• Establish standards, controls, and procedures to ensure data integrity and security.
• Developing strategies to manage large data volume growth of Enterprise Data warehouse.
• Backup and Recovery of databases and High Availability Disaster recovery (HADR).
May 2004-Feb 2005 IBM Global Services,India DBA
Responsibilities:
• Analyzed the existing legacy system, requirements gathering and source system analysis on
data from various servers (internet log files from 45 different servers).
• Provided physical DB2 database analysis and DB2 database modifications.
• Conducted performance tuning and SQL EXPLAIN statement
• Performed tuning and optimization of Data warehousing application. Lead performance testing
(database related part) of the new application releases. Proposed and implemented numerous tuning
recommendations that helped to improve application performance and scalability, end user response
time, significantly decrease database and operating system resources consumption
• Instituted new data definitions for system enhancements.
• Creation and maintenance, and performance tuning. Including physical database design, and
significant performance tuning of tables, indexes, and application SQL.
Jaiganesh Thangavelu **********@*****.***
• Loaded data using autoloader on 8(Including catalog node) database partitions (nodes), setting
different prefetch sizes.
• Bringing the database to supported mode as the logs were corrupted and IBM didn’t supported
until we bring it to supportive mode.
Mar 2003-Apr 2004 Covansys India Ltd,India Database Analyst
Responsibilities:
• Designed the logical and the physical data model for the Hewitt Associates data mart.
• Capacity planning for the Hewitt Associates Data mart.
• Generated the People soft SQL Script and running it against Hewitt Associates Data mart.
• Extensive Performance tuning to optimize the mapping, session, source and target
performance by eliminating bottlenecks
• As a DBA, involved in Tuning Database/Application Engine for Hewitt Associates.
• Installed People Soft tools (8.19) and HRMS (8.3) on udb/Solaris and created the PeopleSoft
DEMO, SYS databases
• Configured PS Application server, PS process scheduler, PS Tuxedo.
• Involved in People tools up gradation and SQL tracing in Application designer.
• Involved in analyzing the performance using tools like Quest Central, Load Runner.
• Wrote Documentation and Production migration processes
• Developed and Implemented Unit testing, UAT and System Integration testing
• Involved in Postproduction support and enhancements
Jan 2001-Feb 2003 SSI Technologies Ltd,India Sr.DBA
Responsibilities:
• As a senior DBA, involved in logical and physical database design of Operational Claims
Management System.
• Performed routine maintenance, database performance tuning and monitoring
• Used Power Designer modeling tool for Physical/Logical Structure Design.
• DB2Look utility is used to find all DDL and DML commands in the database
• Used client application enabler the remote databases are monitored and tuned.
• Snapshot monitoring was done to detect deadlocks, buffer pools, lock escalations.
• Involved extensively in migrating data from NON STOP TANDEM using guardian, which gets
the data in ASCII test format to DB2 on AIX and NT Systems.
• Involved in writing scripts to trouble shoot triggers and stored procedures
• Also worked on a project involved in porting data from AS/400 to UDB database
Jaiganesh Thangavelu **********@*****.***
• Created Visual Explain Access plans and tuning applications.
• Designed and trained employees on transitioning from non stop tandem to UNIX environment.
• Backup/Recovery scripts were written to backup the data.
• Prepared monthly performance charts, troubleshooting and installation guides.
• Presented project plans and also involved in preparing time estimates.
• Involved in training members on database structure, configuration, processes and
maintenance.
Jun 1998-Dec 2000 Kaashyap Radiant Systems, India DBA
Responsibilities:
• Database Backup/Recovery on databases and file system backups. Redirect Restore to move
application from Development, QA and Production
• Advise Business Systems Analysts, technical managers and business users to help them
define business requirements and objectives in the implementation of specific area advanced
technologies.
• Analyze past trends and make suggestions to meet future requirements with respect to capacity
and performance.
• Use tools like db2advise, db2look, db2move and db2adutl to monitor, analyze and make
changes in the database.
Jaiganesh Thangavelu **********@*****.***
Contact this candidate