DB2 UDB DBA Resume

SUMMARY:

Have, around 8 years of experience in teh IT industry in DB2 UDB Database administration, which ranges from setting up environments on teh Development, Test and Production layers ranging from windows to AIX servers and production support.
Project RFI preparation. Cost and resource estimation.
Consulting services for projects and project mentoring
Mentored and lead team of 6 members for successful delivery of services across 24*7 production and non production environments.
Achieved SLA 100% adherence during prime business hours for present client.
Capacity planning for new database infrastructure.
Architectural design of db2 systems. New environment provisioning.
Installation of DB2 on AIX system
Fix pack Upgrade and database migration
Instance & DB configuration analysis & tweaking as per performance
Database monitoring for troubleshooting teh application level performance issues
Control - M server administration and jobs maintenance.
Worked with Optim performance manager server
24X7 production support and change implementation/change control of databases.

PROFESSIONAL EXPERIENCE:

Confidential

DB2 UDB DBA

Responsibilities:

Building Development, Quality Assurance, Integration, Staging Database environments for teh customer.
Creating objects (Tablespaces, Tables, Views, and Indexes) based on teh application team request.
Backups and recovery whenever needed.
Restoring databases based on teh requirement
Working with export, import, load utilities to manage table data.
Creating Federated Servers to access different data source.
HADR Setup.
Replication setup.
Data movement from Mainframes to UDB. ETLs with customized scripts.
Using RUNSTATS, REORGCHK and REORG to enhance application performance.
Carrying out any performance analysis by taking snapshot in case of any performance degrades.
Supporting database issues for different environments which had been setup.
Installing db2 clients.
Fixpack was successfully applied for all servers.
Integration, Staging servers and was well planned and executed successfully.
Installation of DB2 instances on AIX test servers.
Creating EXPLAIN tables and running teh visual explain utility on SQL statements.
Creating Instances and databases and updating DB/DBM configuration parameters based on teh requirement.
Recovering data to a prior point in time.
Deployed all application releases in time and completed successfully.
Worked with Unix shell scripting to automate process of ETL
DB2 up-gradation from DB2 V9.7 to DB2 V11.1 and fine tuned many db, dbm and registry variable to best utilized teh advance features of databases.
Database backup, restore activities, common TSM activities like defining teh storage class and schedules etc
Enabling teh database for STMM, archive logging, analyses of database deadlocks and solving teh lock contention etc
Support for inbuilt homegrown replication environment.

Environment: DB2 UDB V9.7, V10.5, V11.2, AIX V6.1, Tivoli Storage Manager (TSM), CVS, Web Sphere.

Confidential

DB2 UDB DBA

Responsibilities:

Instance migration from one level to other level
Capacity planning for new database infrastructure.
Architectural design of db2 systems. New environment provisioning.
Basic AIX administration for security access and disk space allocation
Basic TSM administration activities and backup and archive pool maintenance and cleaning
Database snapshots and analysis of teh reports
Worked with deadlock event monitors to support development region
STMM vs Manual memory tuning, fine tuned many heap parameters for best results
Q-Replication environment setup, installation, administration and development
SMS to DMS conversion of tablespaces
AIX technology pack up gradation, Memory planning, analysis of AIX performance reports
Adding and maintaining new users and user group's to AIX and DB2 system
AWK, Shell and perl scripting for automating backup and restore operation
HADR setup, Federation setup, db2look data movement, Database/table recovery from log files, Log shipping
SQL reviews, re-write and tuning.
Generating and analyzing performance reports.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship