Data Maintenance

KARTHIK DHARMARAJU

Summary:

. Over * years of IT experience in complete life cycle of Design,

Construction, Analysis, Databases Administration, Development,

Installation, Configuration, Testing, Maintenance and Support, with

major focus on Database Applications and Data Warehousing.

. Experience in working with DB2 UDB Utilities like Export, Import,

Load, DB2LOOK and DB2MOVE and other maintenance utilities like BACKUP,

RESTORE, REORGCHK, REORG and RUNSTATS.

. Have worked on various database migration projects.

. Have worked extensively on physical and logical design of DB2 Data

warehouse, performance monitoring and maintenance, query analysis,

optimization, backup and recovery, replication, migration, information

integrator, DB2 utilities and tools.

. Worked on different platforms including HP-UX, Linux, AIX, Solaris and

Windows, in EE, ESE, DPF and EEE environments.

. Pro-active involvement in continuous performance improvements for

existing OLAP systems and OLTP systems.

. Designed efficient disaster management plans for maximum uptime and

minimum recovery time.

. Experience as a report developer with Business Intelligence tools such

as MicroStragety, WebFOCUS configured reports for end users in

MicroStrategy Desktop, MicroStrategy Web, Narrowcast Server.

. Experience using ERWIN 4.0, DBArtisan, ERStudio as data modeling tool.

. Actively involved in database migration and version migration

processes.

. Followed and enhanced best-practices in terms of design, development

and documentation standards.

. Extensive experience in Maintenance, performance monitoring, fine

tuning and Application support.

. Experience with Perl, Awk, Bash, Ksh and Sed scripting in automating

various DBA tasks.

. Created and maintained UDB/DB2 instances, databases, schema and

objects across development, testing and production environments.

. Extensively used TOAD, Control Center, Replication center, Quest

Central for database activities.

. Upgraded numerous DB2 subsystems to latest versions.

. Assisted DBAs with several application performance bottlenecks in

subsystems.

. Managed a team of junior DBAs and worked with application developers

on OLTP and development servers.

. Excellent communication skills and professional demeanor gained

through extensive interaction with public, team work and leadership

roles.

Database Administration Activities:

. Installation of DB2 UDB for UNIX/AIX/Solaris/Linux/NT server.

. Experience working with data maintenance utilities like IMPORT,

EXPORT, RUNSTATS, REORG, LOAD, QUIESCE, DB2MOVE, DB2LOOK, INSPECT,

DB2TOP and Design Advisor.

. Extensively worked on maintenance of database: backup, recovery,

performance monitoring and security and disaster recovery planning.

. Developed shell and PERL scripts for running database scripts,

automating database tasks and scheduling in cron.

. Experience in designing and implementing database security, stored

procedures, triggers and UDF.

. Performed 24/7 supports for Production Databases.

Certification:

. IBM Certified Database Associate -- DB2 Universal Database V8.1 for

Linux UNIX and Windows

. IBM Certified Database Administrator -- DB2 Universal Database V8.1

for Linux UNIX and Windows

TECHNICAL SKILLS:

Business intelligence, ETL tools, Operating Systems, Databases,

MicroStrategy 6x, 7x, 8x (Micro\ UNIX (Sun Solaris, AIX, HP-UX),

Informatica, SQL* Loader, DB2, Oracle 9i/8i/7.x, Teradata,

MicroStrategy Desktop, LINUX REDHAT 7, 8, 9,

Intelligence Server, Narrowcast, Windows 95/98/ME/2000/

Server\ NT/XP\

Languages and Database tools:

SQL, C, Visual Basic 6.0, Perl, Awk,

Erwin, DBArtisan, Visual Explain, Quest

Sed, Shell programming in UNIX

Bash, Central, Data factory, BMC Patrol

Ksh, Oracle SQL*Plus, PL/SQL

PROFESSIONAL EXPERIENCE:

Verizon Data Services:

Verizon, Piscataway NJ (Full time) May 2011 - July 2014

Title: Production Support Database Administrator

Responsibilities:

. Worked as a production support DBA supporting several databases which

were OLAP, OLTP, Data-warehouse and DSS systems.

. Extensively worked on database performance tuning using tools like DB2

Explain facility, DB2advis, DB2TOP.

. Worked on system 5 packaging where DB2 install packages were built

with Verizon standards.

. Implemented DB2 audit facility on most of the applications to enforce

security requirements within Verizon.

. Developed scripts to process auditing and send out reports.

. Extensively worked on data center move out projects involving hardware

recommendations, file systems layouts for database, DB2 installations,

database creation, functional IDs and environmental scripts set up.

. Attended IBM training sessions for various new upcoming DB2 features.

. Implemented DB2 security procedures to tighten security.

. Implemented DB2 trusted context to restrict database connections to

trusted hosts.

. Designed the databases to conform to verizon standards.

. Extensively worked on DB2 v9 installation.

. Developed environmental scripts using ksh for database maintenance.

. Monitored production databases for their health checks as a first

thing every morning to avoid any avoidable issues pertaining to the

database.

. Experience in DB2 Optim Performance Manager and data studio to tune

expensive queries.

. Managed production databases with HADR set up.

. Extensively worked on setting up Qreplication and managed production

databases with Qreplication set up, both Unidirectional and Bi-

directional.

. Managed production databases with Veritas clustering and HACMP set up.

. Experience with Perl, Awk, Bash, Ksh and Sed scripting in automating

various DBA tasks.

. Experience in working with DB2 UDB Utilities like Export, Import,

Load, DB2LOOK and DB2MOVE and other maintenance utilities like BACKUP,

RESTORE, REORGCHK, REORG, RUNSTATS, DB2INSPECT and DB2DART.

. Did performance tuning by analyzing snapshots and access plans.

. Worked extensively on database migration projects, DB2 to Oracle.

. Involved in planning efficient disaster management plans for maximum

uptime and minimum recovery time.

. Provided 24/7 production support on a rotation basis.

Environment:

DB2 UDB V8.2,V9.1, V9.5, V9.7, EEE, ESE with DPF, Sun Solaris, AIX, Linux,

Windows

Marlabs Inc

Verizon, White Plains, New York (client) Sep 2006 - May 2011

Title: Database Application Developer/Administrator

Responsibilities:

. Developed and tested RDBMS applications.

. Extensively involved in performance tuning of the databases by

updating configuration parameters, resizing buffer pools, tablespaces.

. Performed SQL tuning on regular basis for better performance of the

applications, using explain and db2 advisor utilities.

. Monitored the databases and instances using tools like health monitor,

snapshot monitor and event monitor.

. Experience using ERWIN 4.0 as data modeling tool.

. Extensively used utilities like load, import, export, db2move, db2look

for database migration among various environments.

. Used CASE tools for Database development, Data modeling, Data mapping,

Data analysis, and Data validation.

. Took precautionary measures in monitoring database and operation

system for various issues, on daily basis, by automating scripts and

sending to emails, for the same purpose.

. Opened PMR with IBM support to avert negativity on business impact, at

critical situations.

. Worked on sql peer to peer data replication and Websphere Q-

replication.

. Worked on setting up HADR and supported the same.

. Monitored database Backups on daily basis.

. Plan and execute customization of Database systems.

. Implemented database cleanup through automated scripts, sufficing

business requirements.

. Devised perl and shell scripts to automate database tasks and

extensive data parsing.

. Involved in database designing along with the database engineers and

data modelers so as to fit the business requirements.

. Created databases and database objects such as bufferpools,

tablespaces, tables. Also altered the same when required.

. Experienced in writing and implementing test plans.

. Cataloged remote databases as per required.

. Ran REORCHK, REORG and RUNSTATS utilities to optimize the overall

performance of the system, to counter the diminished performance, due

to changes in the database objects.

. Ran db2support, db2dart, db2inspect report utilities to observe and

understand the root cause of the issues with the database.

. Constantly examined db2diag.log and db2inst.nfy for any possible

errors in the database.

. Periodically used Control center to perform certain operations like

viewing the explain graphs for the queries in question, running

configuration advisor and design advisor for the databases.

. Successfully upgraded the version, after recommending the client to

upgrade from V8.1 FP 6 to V8.1 FP 12.

. Created stored procedures as per business logic.

. Extensively devised complex queries against the database tables as per

required by business logistics.

. Involved in trouble-shooting various issues associated with the

application.

. Involved in the migration of Sybase database to DB2 database, by

providing support to a team, whenever required.

. Interacted with the users and executed the workflow according to the

requirements.

. Supported the production databases on 24/7 basis.

. Worked on DB2 verison upgrades from V8 to V9 and also fix pack

upgrades with the special builds from IBM.

. Extensively worked on data migration project where servers were built

from the scratch.

Environment:

DB2 UDB V8.1 FP 4,6,12,V9.1 FP 6, ESE with DPF, Sun Solaris, AIX, Sybase

ASE 12.5, Windows XP

Propelsys

CVS (client):

PharmaCare Management Services, Pittsburgh PA Dec'2005- Apr'2006

Sr. MicroStrategy Developer

Responsibilities:

. Used Erwin tool process Data Modeling as per the requirements.

. Interacted with users concerning with the Business Requirement

Documentation.

. Worked on database development.

. Identified Primary Keys, Alternate Keys, Foreign Keys from the

physical data model for the project.

. Based on the data model, created attributes, attribute form

expressions, facts and metrics, for report creation.

. Analyzed the relationships among the attributes and facts, which was

essential for generating a series of required reports.

. Worked on data modeling techniques and assessed star and snowflake

schema based on the data requirements.

. Created database objects for reporting purposes.

. Designed Prompts and Filters to generate reports in grid and graph

mode. Auto prompt filter feature gave end-user a choice of different

filtering criteria each time they run the report.

. Generated documents for all the reports created and formatted the

document design and metrics as per the business requirement.

. Performed testing of all reports for the final deployment.

. Deployed and administrated reports on MicroStrategy web.

. Developed services, subscription sets, publications on the Narrowcast

administrator console and scheduled the services which enabled

multiple delivery ability.

Environment: MicroStrategy Desktop 8.0.1, MicroStrategy Intelligence Server

8.0.1, MicroStrategy Web 8.0.1, Narrowcast Administrator 8.0.1,

MicroStrategy Intelligence Server 8.0, MicroStrategy Report Services 8.0,

Oracle 9i, Windows 2000,

Education:

Master of Science in Electrical Engineering: Wilkes University, Wilkes-

Barre, Pennsylvania.

. GPA 3.75/4.0

Bachelor of Technology in Electronics and Communications Engineering:

Jawaharlal Nehru Technological University, India.

Contact this candidate