Quality Assurance Database

Gopal Ramasamy

Phone 720-***-**** E-mail:

*****.*****@*****.***

[pic]

[pic]

OBJECTIVE

I am seeking a position as a Lead Sr. Database Administrator

with an organization that will leverage my current skills and

provide career growth.

STRENGTHS:

I am a team player, problem solver, and quick learner with analytical

Skills. Led the team with high degree of initiative and great sense of

responsibility, and ability to perform at high level to meet project

deadlines, adaptable to ever changing priorities and supporting

24x7(365 days)

On call DBA support. Supported Telecommute job (Work from home remote

job).

SUMMARY

> Over 17+ years of experience in IT with expertise in Design,

Implementation & Maintenance of OLTP & Data Warehouse systems in DB2

UDB 7.2, 8.2, 9.5, 9.7, 9.8 PureScale & 10.1 Database Administration

on AIX, LINUX, UNIX, SOLARIS and WINDOWS environments.

> A self-motivated team player with superior analytical,

communication and interpersonal skills and a proven ability

to lead, problem solve, manage projects and adapt to

changing environments.

> An accomplished Database Administrator with demonstrated success

designing and implementing database solutions that improve business

functionality.

> Supported other database administration includes Oracle and SQL

server.

> Supported in Business areas includes Banking & Finance, ERP &

Accounting, Manufacturing, E-Commerce, etc.

> Have performed in a variety of roles including data warehouse (DWH)

and OLTP support, Project Lead, and Database Administrator.

> Experience includes deploying InfoSphere Warehouse

Enterprise Edition for large Data Warehouses

> Expertise in setting up High Availability and Disaster Recovery (HADR)

solutions. Applying fix packs by taking over the standby to Primary

and Primary to standby in the HADR solution.

> Data maintenance utilities used REORG, RUNSTATS, RECOVER/RESTORE, LOAD,

IMPORT, EXPORT, DB2LOOK, and DB2MOVE.

> Expertise in moving tables online by using the ADMIN_MOVE_TABLE

procedure.

> Expertise in ADMIN_COPY_SCHEMA procedure - copy a specific schema and its

objects.

> Experience in data warehousing with large partitioned DB2 EEE/ESE/DPF

databases.

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

performance of SQL queries using DB2EXPLAIN, Database Space Management,

Schema creation, Data Transformation Services.

> Proven ability to implement latest technologies that decrease costs,

increase performance and positively affect the bottom line.

> Deep understanding of technology with focus on delivering business

solutions.

> Polished leadership skills, with ability to motivate teams to increase

productivity.

> Proven ability to handle onshore/offshore business model & production

database support.

> Very quick to learn and deliver results.

> Development and implementation of different monitoring scripts on DPF

and non-DPF environment, using Shell script.

> Experienced in supporting 24/7 production environments and Change

Management tools.

CERTIFICATION:

. IBM Certified Database Administrator DB2 10.1 for LUW.

. IBM Certified Advanced Database Administrator DB2 9 for LUW.

. IBM Certified Database Administrator DB2 9 for LUW.

. IBM DB2 UDB 8.2 Certified Database Administrator.

. SUN Certified System Administrator for Solaris 8 Operating

Environment.

. Oracle (9i) Certified Associate DBA.

TECHNICAL SKILLS:

Data Modeling ERWIN 4.x/3.x, MS Visio

Tools

OS Aix 5.3, Aix 6.1, 7.1, Linux, Red Hat Linux 4.6, 5.5,

CentOS-5.5, SUSE LINUX 10.0 and Sun Solaris 9.

Databases DB2 UDB 7.2, 8.2, 9.5, 9.7, 9.8 DB2 PureScale & 10.1,

Oracle 9i/8.1.x/8.0.x/7.3. SQL Server2000/2005

Tools/Solutions Export/db2load, db2 Explain Plan, db2pd, db2top, Optim,

Quest Central, Toad, Spotlight, Embarcadero, Tivoli

Storage Manager(TSM), Erwin Data Modeling tool (Data

Modeler), Microsoft Cluster Services (MSCS), VERITAS

Net Backup and EMC NetWorker (formerly Legato

NetWorker), InfoSphere Optim High Performance Unload

Version 4.2.1 for DB2 for LUW, Web Application

Integrator for IBM WebSphere Web Portal.

Hardware SUNFIRE servers M3000,M4000,M5000, Linux, IBM P series

Platforms P550, POWER 6 and POWER 7

WORK EXPERIENCE

JOB Title Client Name Duration

Sr. Lead Database Experian, Chicago, IL Oct 2005 - Present

Administrator

DB2 LUW database administrator support for Experian's worldwide DB2 LUW

systems, Of course I can't do this alone, so I am a member of a 9 person

team [OLTP and Warehouse databases]. Database Partitioning Feature (DPF) is

my specialty. Experian has one of the largest corporate DPF environments in

the world, with over 56 servers and 441 DB partitions for one database.

1. Experience in database administration working with a global team.

2. Involved and supported for multi terabyte environments, database size

supported up to 500 terabytes.

3. Experience with DB2 LUW V8 & V9.5, 9.7, 9.8 PureScale and above.

4. Explain query using dynexpln & db2exfmt, used db2advis to tune Index.

5. Hands-on experience with new V9.7 and 9.8 features and implementation.

. Worked with IT groups to coordinate current and future plans and

activities including technical assistance to facilitate specific

development projects that involve several system environments, design

reviews, capacity planning and scalability analysis, software upgrades

and installation of new products.

. Data Center Move: Coordinated with IT groups to plan and deploy multiple

server activities on time and with 100% success.

. Provided 24/7 on call primary production support for DB2 LUW, did

secondary support on z/OS

. Used new features of UDB 9.5, 9.7 including DB2pd, a problem

determination tool, online reorganizers, used tools such as DBMON and

db2top.

. Performed DB2 DPF configuration, installation, tuning and maintenance to

manage additional database capacity requirements.

. Involved and recommended for actual integration of new BCUs into the

current Production system.

. Monitor databases and make adjustments to improve performance of database

or applications that use the data.

. Develop and maintain compliance to database standards and procedures.

Assist with design and organization of database during systems

development process.

6. Backups, Reorgs, Runstats, Space monitoring and moving the db2diag.logs.

7. Installing and maintaining DB2 environment includes creating databases,

buffer pools, logical and physical design of database storages using

DMS/SMS table spaces.

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

9. Maintain security administration includes handling instance / database

level authorities.

10. Experience in InfoSphere Optim High Performance Unload Version 4.2.1

for DB2 for LUW.

11. Identify Table Skew and resolve the tablespace full issue by drop &

recreate skewed tables with right partition key column and fix the skew

issue.

12. Troubleshoot locking, load issues and Runstats issues with system

catalog access contention.

13. Availability of database servers, Data Protection and Recoverability,

Security of Data and Database System Performance management, Database

Designing, Data Integrity, Analysis /debug day to day issues and

resolve.

14. Database refreshes/upgrades/patching/monitoring/fix packs.

15. Expertise in ADMIN_COPY_SCHEMA procedure - copy a specific schema and

its objects.

. Scheduled database backups thru VERITAS Net Backup and EMC NetWorker

(formerly Legato NetWorker) as well as on local disks.

16. Installation and Configuration of DB2 UDB v7.2/v8.1/v8.2/v9.1/V9.5/V9.7

and related Fix-Packs and Special Builds on different platforms.

. Installed and configured DBMS software, maintained software release

levels.

. Migrated UDB databases from v8.2 to v9.5 and v9.7, enabled compression to

reduce the database storage in multi node InfoSphere Warehouse

environment.

. Implementation of new database systems and architectures, scalability and

capacity planning using DB2 DPF v8.2, 9.5 and v9.7.

. Provided 24/7 support to highly available OLTP and Data warehouse

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 V9.5 HADR environment, supported V9.7 HADR

databases.

. High availability (HA) and disaster recovery (DR) experience with

DB2 HADR

. Production DB2 UDB DBA support for very large, 24*7 production databases.

17. Implemented instance level and database level configuration parameters

for database concurrency, authentication, performance and allowing remote

clients accessing server

18. Database objects creation & alteration (tables, indexes, views, stored

procedures, functions, etc.)

19. Worked in data movement utilities IMPORT, LOAD, and EXPORT.

20. Tuned databases using tools like snapshot monitor, visual explain,

Index adviser, db2expln, db2exfmt etc

21. Federated database server creation in order to allow access of another

databases (DB2 or non-DB2) inside a DB2 database.

22. Database performance tuning and troubleshooting & fixing problems faced

by application developer, used DB2TOP tool to capture and monitor

production databases to troubleshoot.

23. Query tuning for the problematic queries sent by application developer

or identified during database monitoring

24. Database monitoring (free space in tablespaces, event monitor outputs,

security audit reports, performance reports etc.).

25. Database backup & recovery (offline & online backups, Full, Incremental

& Delta Incremental). Database cloning using redirected restores.

26. Worked with database vendors and opened PMR for external support on

issues such as upgrades, technical problems and solutions.

27. Expertise in backups and recovery within DPF databases.

28. Administer the UDB security systems, including user administration,

29. Created instances, developed databases, tested, designed, modeled data,

developed and supported multiplatform DB2 UDB DBA on AIX Unix, Red Hat

Linux and Windows 2000.

30. Created Unicode utf-8 database.

31. Provided 24/7 on-call support to research problems, determine

resolutions and support new deployments.

32. Policies and procedures, review of user accounts and user roles.

33. Database Sizing, Tablespace Management and Rollback Tablespace

Management, Transaction Management and Security Administration.

34. Environment: AIX 6.1, 7.1, db2 9.5, db2 9.7, 9.8 PureScale,

Quest Central, Toad.

JOB Title Client Name Duration

Senior Database Extra Quest Corporation, March 2004 - Oct 2005

Administrator Denver, Co USA

> Database Security Installation /

Upgrades

> Performance Tuning UNIX

> Backup / Recovery Linux

> ETL application support AIX

> DB2 UDB v7, 8.1, 8.2 Microsoft Windows

> SQL Optimization Erwin

> EE/EEE K-Shell

> Web Sphere / Portal DB Toad / Quest Central

PROFESSIONAL EXPERIENCE

Lead DBA supporting a large scale data warehouse environment running on

multiple instances of DB2 UDB databases for LUW, on both AIX & Linux

platforms. Key contributor in the design and deployment of global

distributed DB2 environments. Skills in both OLTP and data warehouse

applications. Developed and documented formal DB2 Backup & Recovery

procedures.

. Performed database tuning in all phases including application tuning

during the initial development design and configuration, load testing and

integration testing with "near real time" volume.

. Successfully migrated db2 databases from v7.2 to v8.2.

. Successfully applied fix packs on development, staging and production

databases.

. Used DB2EXPLAIN, REORGCHK, REORG and RUNSTAT to tune and

improve application performance.

. Automated Reorgs, Runstats, on production databases using UNIX shell

scripts.

. Deployed UNIX shell scripts for backing up logs and monitoring the

production databases.

. Successfully done backup and restore test in development & test servers

for BCP.

. Successfully applied fix pack 6, 7, 8 and fix pack 9 on development and

production database.

. Database Capacity Management and planning (disk space, database growth

and expansion)

. Database Performance Monitoring and Tuning, Weekly database structural

and performance statistics collection.

. Production Database Support for weekly and monthly Maintenance jobs.

. Creates instances, databases, schemas, tablespaces, etc for any supported

DBMS. Executes DBMS utilities and write scripts to automate those

utilities: backups, update statistics, export, import, reorganization,

etc. Involved onsite support for any critical DBA activities.

. Creating database objects (tables, views), altering tables and adding

check constraints, triggers and referential integrity.

. Using EXPORT and IMPORT/LOAD to access the data for loading into

different database subsystem for testing and reporting.

. Design, analysis and creation of new databases (analysis about number of

database partitions, available memory, database size, database & database

manager configuration options).

. Database objects creation & alteration (tables, indexes, views, stored

procedures, functions)

. Federated database server creation in order to allow access of another

databases (DB2) inside a DB2 database.

. Provide all DB2 UDB Database Administration related support to all

production and development environments.

. 24x7 monitoring of database replication jobs implemented.

. Performing regular backups using IBM's Tivoli Storage Manager as well as

on local disks.

. Setup backup and recovery procedures using db2 restore and recover tools.

35. Extensive experience in using DB2 utilities like Export, Import, Load,

DB2move, DB2look.

36. Good at using DB2TOP, DB2PD, DB2ADVIS, DB2DART, INSPECT, DB2MTRK,

EXPLAIN and root cause analysis in distributed environments.

37. Worked/implemented DB2 table & index compression, database/table

Partitioning.

38. Running DB2 utilities and daily/weekly maintenance - Reorgs, Runstats,

Backup/Restore, Load/ Import/ Export, DB2LOOK and DB2MOVE.

39. Developed and implemented Backup and Recovery strategy for Databases.

40. Configuring both database and DBM parameters for optimal performance.

41. Have done tuning (SQL, application, Memory). Achieved significant gains

in the performance of SQL queries against the database.

42. Set up DB2 UDB buffer pools and tablespaces proactive performance

monitoring procedures using DB2 snapshots.

43. Performed DB2 server and client installations and fix packs, database

backup and recovery, re-directed restores, problem determination and

resolution, table moves, data loading / export / import / moving,

performance monitoring and tuning, user access control and application

SQL analysis and tuning.

JOB Title Client Name Duration

Senior Database Toshiba, Singapore April 2003 - July 2003

Administrator

Interact with business users, IT developers, IT managers, and outside

contracting firms to provide data management solutions, database

availability, backup and disaster recovery.

Provide expert application/technical support for the users on DB2 databases

with 33 partitions.

Perform diagnostics of performance problems, troubleshoot and develop

technical solutions for production DB2 database problems in Windows and

AIX.

. Provided 24X7 on-call support rotation with staff DBA's, minimizing

downtime of databases.

. Installation of DB2 UDB EE/EEE 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.

. Instance and database creation, configuration and tuning experience in

single node non-partitioned, multiple nodes partitioned, and multiple

logical node (MLN) partitioned database server's configurations.

JOB Title Client Name Duration

Database Administrator Prep2Go, Singapore Jan 2001 - March 2003

Database Administration Expert responsible for DB2 UDB online

databases and data warehouses on AIX and WINDOWS operating

systems. Provide specialized technical support and design

support of DB2 databases on these platforms as well as

provide support to other DBA's and application teams. Highly

experience and well rounded knowledge.

. Used DB2EXPLAIN, REORG, RUNSTAT and REORGCHK for tuning applications.

. Performed schema creation, scripts for table creation, scheduling jobs

for various activities.

. 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.

. Maintaining the database in development, Integration and production

environment.

. Developed automated script to do the performance monitoring & tuning.

. Worked with developers in tuning and achieving desired SQL query

performance (db2advis and db2explain).

. Troubleshoot and fix both development and operational systems

(Development/Testing and Production).

. Responsible for backup, restore, moving the data between different

databases/servers and running database utilities.

. Database design, planning, implementation, support and maintenance for

Clients.

. Database tuning, Application Tuning, Indexes, & performance monitoring

Changing.

. Supported database application customization needs; created analyzed and

implemented physical design based on logical design requirements.

. Established naming standard for the database objects.

. Installation, configuration, maintenance and DB2 database upgrades.

. Expertise in production database Performance and Tuning.

. Documented backup schedules and recovery procedures, Unix Shell scripting

. Did the capacity planning for the new database implementation that

includes their production and development databases.

. Identified bottlenecks in the application and provided solution for the

same.

. Maintained several databases for Production, Development and Staging.

. Quality Assurance including providing guidelines for database integrity,

guidelines for monitoring and tuning the relational database, review of

relational systems to insure that standards and quality assurance goals

are met.

. Customer Relations including maintaining a close, ongoing, open

relationship with customers, a joint team effort concept, prompt response

to customer requests for assistance, assisting in resolving production

problems, successfully communicating concerns to management and customers

as directed, preparing reports as requested, tracking and monitoring

customer requests for services, monitoring upgrades and developments in

the technology arena that would be beneficial to the applications

supported.

. Administrative including informing supervisor of progress and of real or

potential problems, providing verbal and /or written status reports,

accurately recording time worked on projects, travel, hardware/software

problems, maintaining hardware and software assigned for personal use,

prompt responses to management requests for information, participation in

meetings and facilitation of training sessions, ability to make decisions

within assigned scope of authority.

JOB Title Client Name Duration

Database Administrator Tritech Solutions Pvt. Ltd, Jan 1998 - Dec 2000

India

. Taking offline and online backups for databases.

. Loading of data through direct load insert and SQL*Loader.

. Migrated from various database components from developmental to

production release.

. Worked with development team in tuning the database during volume test

for

. Performance gains. Analysis, Design, Coding, Implementations and

Maintenance.

. Troubleshooting the Network Environment, RMAN backup/restore

implementations.

. Logical & Physical Database design and maintaining the Control files.

. Managing IIS 4.0 / 5.0 Web Servers and Adding and removing the Patches.

. Provided technical assistance to developers for writing smart SQL and

PL/SQL codes to

Avoid unnecessary trips to database to access the required data that

resulted in overall performance gain.

. Administered all aspects of 24/7 Oracle databases and Troubleshooting in

Networking

. Supported the production and QA (quality assurance) systems

. Supported production SAP/Oracle database environment

. Developed process to move database changes from test to production.

. Restoring database backups into exiting database or creating new

databases with database backups.

. Implement database backup and recovery strategy for all Oracle databases.

. Performed Data Migration from Oracle 7.3 to 8.1.7 at corporate office.

. Monitored database activity for both Oracle 8.1.7 and DB2 7.x

. Performed database point-in-time recovery of databases.

. Performed back up of the databases, restoration from failures.

. Developed and Implemented Unit testing, UAT and System Integration

testing

. Involved in Postproduction support and enhancements

. Performed routine maintenance, database performance tuning and monitoring

. 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.

. Created Visual Explain Access plans and tuning applications.

. Backup/Recovery scripts were written to backup the data.

. 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.

. As a DBA, involved in logical and physical database design.

. Supported online / offline table Reorgs during weekend maintenance.

. Supported in the areas of Installation, Upgrades, Performance Tuning,

Database Administration, User Administration, and Client Administration

of DB2 ESE and has good trouble-shooting skills.

. Managed service level against service level agreements (SLA), operational

level agreements (OLA), and key performance measurements.

[pic]

Contact this candidate