DB2 LUW Senior DBA Resume MN DB2 LUW Senior DBA - Hire IT People

SUMMARY

DB2 installations, configurations, patching and upgrades in Production, Q/A, Test and Dev environments
Experience on DPF environment.
Experience on creating the new database and maintaining database objects
Create DB2 database online/offline backups
Experience on creating the new Table Space on DPF environment
Hands on experience in maintaining Table space spaces, Tables in DB2 databases running on LUW platforms
Experience on maintaining Database Manager and Database Configuration Parameters
Expertise in using DB2 Movement Utilities like Export, Import and Load
Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors
Generating DDL using DB2LOOK utility
Catalog databases and install DB2 Client on application servers
Performance tuning by monitoring, taking snapshots
Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database
Installed DB2 V10.5 Fix Pack 7 on AIX, Sun Solaris and Z Linux Servers
Performed HADR setup with TSA cluster
Table space management - Adding, dropping, extending, reducing and resizing table space containers
Backup & Recovery of Database, Online database backup, archived log files and Offline
Granting / revoking various authorizations to different Users/Groups
Implemented DB2 Security, Locking and Concurrency Control
Performed POC installing and Configuring Pure scale on db2 v10.5
Strong collaboration, team building, interpersonal, communication skills with proficiency at grasping new technical concepts quickly & utilizing the same in a productive manner.

TECHNICAL SKILLS

Operating System: Windows 2003/NT, AIX P6, Sun Spark, Linux, Unix.

Database: DB2 UDB, SQL Server 2005, Oracle, Data stage, CDC

Reporting Tools: Service Now, PPM

PROFESSIONAL EXPERIENCE

Confidential, MN

DB2 LUW Senior DBA

Environment: DB2 V11.1, V10.5 FP 7, V9.7, v10.1 AIX, L Unix

Responsibilities:

Installed AESE on database servers and data server client on Application servers
Experience on creating the new database and maintaining database objects
Worked on migration from v10.1 to v10.5 version and v9.7 to V11.1.
Performed snapshot backup setup on critical system
Hands on experience in maintaining Table space spaces, Tables in DB2 databases running on LUW platforms
Performed database utilities like redirect restore, backup etc by developing shell scripts
Experience in performing the SQL replication from Mainframe to db2 LUW databases
Working and troubleshooting on day-to-day problems via incidents, requests and changes and closing tickets
Experience on maintaining Database Manager and Database Configuration Parameters
Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors
Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database
Worked on EXPORT, IMPORT and LOAD utilities, moving Data between servers and HADR environment
Granting / revoking various authorizations to different Groups as per standards
System crash and hang analysis - collecting stack trace, running db2support and uploading the same to IBM Support to investigate PMR
Creating Client instances for Application users, Data stage and Cog-nos servers and cataloged the required databases

Confidential

DB2 LUW DBA

Environment: DB2 v10.1, V10.5 FP 7 REHL Linux, Unix

Responsibilities:

Installed AESE on database servers and data server client on Application servers
Experience on creating the new database and maintaining database objects
Worked on migration from v10.1 to v10.5 version
Performed po installing and Configuring Pure scale on db2 v10.5
Hands on experience in maintaining Table space spaces, Tables in DB2 databases running on LUW platforms
Performed database utilities like redirect restore, backup etc. by developing shell scripts
Scheduling online database backups on daily basis
Experience in performing the replication of the databases using IBM’s IIDR (CDC Replication)
Monitored Replication and configured environment when performing database Redirected Restores
Working and troubleshooting on day-to-day problems via incidents, requests and changes and closing tickets
Experience on maintaining Database Manager and Database Configuration Parameters
Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors
Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database
Generating DDL using DB2LOOK utility
Data Replication, Migration & refresh from Production to Test environment.
Database redirect restore from production to Non-prod environment
Worked on EXPORT, IMPORT and LOAD utilities, moving Data between servers and HADR environment
Granting / revoking various authorizations to different Groups as per standards
System crash and hang analysis - collecting stack trace, running db2support and uploading the same to IBM Support to investigate PMR
Creating Client instances for Application users, Data stage and Cognos servers and cataloged the required databases

We provide IT Staff Augmentation Services!

Db2 Luw Senior Dba Resume

Mn Db2 Luw Senior, DbA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship