We provide IT Staff Augmentation Services!

Db2 Luw Database Administrator Resume

Torrance, CA

SUMMARY:

  • 8+ years of IT industry experience in DB2 UDB Database Administration & Infrastructure Services with good knowledge & Exposure towards AIX, Windows.
  • Managed Both SAP & Non SAP Databases of more than 20TB Database size.
  • Key Skills: DB2 UDB DBA, SQL DBA, Infrastructure Management, ITIL\ITSM Methodologies, Practice Building, Competency Development, Project Management, Team Building, Team Leadership, Product Development.
  • Hands on Experience in migrating DB2 UDB databases from old to newer versions (V9.1, v.9.5 to v.9.7, 10.1, 10.5) and applying FIXPAKS to keep DB2 at most recent level.
  • Experience in Capacity planning, Backup, Restore and log Shipping. Conduct RCA for Database outages.
  • Experience in using DB2 Movement Utilities like Export, Import, Load and db2move.
  • Creation of user roles and granting/ revoking necessary permissions to users and roles.
  • Work with the application development teams in fine - tuning of Queries, tuning performance of Queries\Jobs.
  • Experience in setting up and maintaining disaster recovery methods High availability disaster recovery (HADR).
  • Good experience in creating DB2 database data objects like table spaces, tables, Views and Indexes.
  • Highly involved in performance tuning like performing REORGS, RUNSTATS on the database tables frequently and tuning SQL Queries.
  • Monitored databases using snapshot and event monitoring for troubleshooting.
  • Experience in requirement analysis, coding and testing various modules of SDLC.
  • Involved in all phases of the project (Requirements, Designing, unit testing and defect fixing)
  • Monitoring and resolving Blocking/deadlock issues.
  • Good knowledge on Support guidelines and SLA deadlines.
  • Exhibits strong teamwork and individual drive - highly motivated, articulate and eager to learn, Good Communication and Interpersonal skills.
  • Involved in Query tuning \Performance tuning.
  • Experience in database backup online, Offline backup, Snapshot backup, flash copy backup.
  • Implemented standby database for high availability using HADR utility.
  • Troubleshoot production DB2 issues and problems (db2diag.log, db2 traces).
  • Provided on-call 24/7 DB2 DBA support for DB2 production environments.

TECHNICAL SKILLS:

Database: DB2 UDB 9.x, 10.x SQL Server

Database Tools: DB2 Data Studio, DB2 Connect & Query AnalyzerOperating System AIX, Windows, Linux.

Ticketing Tools: Service Now, Maximo, Remedy

Monitoring Tools: Tivoli Monitoring

Languages: Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

DB2 LUW Database Administrator

Responsibilities:

  • Involved in building new instance Database, Database Objects and users creation.
  • Good Exposure in DB2 UDB Installations, Configurations and Administration on Aix, windows machines.
  • Managing 200 database instances and 500 databases
  • Migration and Up-gradation (Fix Packs) on existing database servers.
  • Hands on experience in maintaining DMS Table spaces, Tables in DB2 databases running on UNIX platforms.
  • Experience in implementing Backup and Recovery strategies.
  • Good Experience on restoring the database from one AIX server to another AIX server using Redirect Restore method.
  • Expertise in using DB2 Movement Utilities like Export, Import, Load and db2move.
  • Expertise in getting entire DDL’s for a database using db2look and creating those objects structure in Target database based on the DDL script.
  • Hands on experience in cataloging the Data Bases.
  • Experience in using DB2 Maintenance Utilities like Reorgchk, Reorgs and Runstats.
  • SQL Query Tuning using db2advisor, db2explain and db2exfmt tools.
  • Troubleshooting database issues using db2diag, db2pd, db2top, Snapshot and event monitors.
  • Worked with IBM support in various occasions by raising PMR and collected info using db2support to assist in troubleshooting.
  • Primary Knowledge on HADR (High Availability Disaster Recovery).
  • Good knowledge on Incident / Problem and Change management process as ITIL framework.
  • Experience on preparing project related documents, Knowledge Articles.
  • Tuning of db and dbm configuration parameters.
  • Created views and granted privileges to the users as required to their access.
  • Good experience in 24/7 production environment support and involved in on call support on rotation basis.
  • Resolution for the user queries for all above tasks and application errors, which are affected due to database, level issues in day-to-day basis.
  • Resolving locking issues at the application, by giving recommendations to make changes in the application to reduce/avoid deadlocks and lock timeout.

Confidential

DB2 LUW Database Administrator

Responsibilities:

  • Involved in building new instance Database, Database Objects and users creation.
  • Managed both SAP & Non SAP Databases. Managed 300 instances and 620 databases, Database size varied from 10 GB to 25Tb.
  • Expertise in getting entire DDL’s for a database using db2look and creating those objects structure in Target database based on the DDL script.
  • Handle Database Refreshes and respond to the DB related requests and Updates of operational procedure documents as necessary.
  • Experience in Flash copy backup and flash copy restores Activities.
  • Optimize SQL queries and analyze database performance issues
  • Database Installation, upgrade and fix pack implementations
  • Experience in using DB2 Maintenance Utilities like Reorgs and Runstats.
  • Analyze production failures and slow performance by db2 diagnosis tool such as db2top, db2pd and by snapshots
  • Participate in Cluster failover exercise and support database availability
  • Research and analyze database solutions for proposed business requirements with all alternative solutions in research labs.
  • Work with IBM lab via PMR for any production issue
  • Install db2 software and db2 client software
  • Experience in implementing Backup and Recovery strategies.
  • Hands on experience in cataloging the Data Bases.
  • Troubleshooting database issues using db2diag, db2pd, db2top, Snapshots and event monitors.
  • Good knowledge on Incident / Problem and Change management process as ITIL framework.
  • Experience on preparing project related documents, SOPS.
  • Created views and granted privileges to the users as required to their access.
  • Good experience in 24*7 production environment support and involved in on call support on rotation basis.
  • Resolving locking issues at the application, by giving recommendations to make changes in the application to reduce/avoid deadlocks and lock timeout.

Confidential

DB2 LUW Database Administrator

Responsibilities:

  • Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots.
  • Managed SAP & NON SAP Databases. Managed 120 instances and 140 databases
  • Creating and Monitoring Users, authorities and responsibilities and password management.
  • Enhanced application performance by running RUNSTATS, REORGCHK and REORG utilities.
  • Monitored and managed disk space, I/O contention.
  • Designed and implemented backup and restore procedures.
  • Monitored databases using database monitors, snapshot monitoring and event monitoring.
  • Generated reports of database structure using DB2LOOK Utility.
  • Recovered data to a prior point in time using ROLLFORWARD command.
  • Implementing capacity planning and partition table/index for very large and fast growing tables.
  • SQL tuning and query optimization.
  • Tuned application, database and system for best performance.
  • Day-to-day attending to the user queries in sorting out database problems.
  • Coordinating with user departments and attending their requirements for smooth functioning.
  • Upgraded instances regularly with latest fix packs and alternate fix packs.
  • Worked extensively with restores, redirected restores.

Confidential

DB2 LUW Database Administrator

Responsibilities:

  • Recovering DB2 databases whenever necessary.
  • Creation of DB2 objects like table spaces, tables, indexes and views.
  • Managed 100 instances and 130 databases. Database size varied from 20GB to 20TB.
  • Troubleshoot production DB2 issues and problems (db2diag.log, db2 traces).
  • Automated the health check for various databases.
  • Monitors replication server health, Database tuning and recommends system configuration changes to enhance the performance
  • Handle Database Refreshes and respond to the DB related requests and Updates of operational procedure documents as necessary.
  • Conduct root cause analysis for all database outages.
  • Perform administration tasks such as database backup and restoration, Monitoring database health in terms of memory, CPU utilization, disk space, and security.
  • Identifies bottlenecks in conjunction with application development team, attends and resolves batch abends.
  • Monitors replication server health, Database tuning and recommends system configuration changes to enhance the performance.
  • Responsible for running optimizer plans for slow performing queries, running trace and create standard reports on query performance and Database recovery
  • Perform both functional and performance/stress testing for the stored procedures created and database objects and generating load and will tune the databases accordingly and will move the code to production environment.

Hire Now