CAREER SUMMARY:

• Having around 5 Years of total IT experience in DB2 as a DB2 UDB (LUW)Administrator, And Oracle
• Experience on DB2 utilities, handling production and Development Issues, and I have a good knowledge on ITIL.I have good knowledge on SAP Basis.
• As a proactive team member able to handle good organizational, communication skills.
• 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
• Providing technical expertise to design most efficient and cost effective solutions for DB2 based database systems
• Automating repetitive tasks
• Advanced performance tuning, advanced troubleshooting and problem determination
• Create DB2 database online/offline backups
• Experience on creating the new Table Spaces (DMS) .
• 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
• Experience in replication (both SQL and QREP). understanding of HA,DR Database and storage technologies like Data replication, SRDF/non - SRDF
• Good knowledge of SQL replication .
• Knowledge of SQL programming, Database and SQL performance tuning
• Able to manage and deploy application database modifications
• Knowledge of LDAP role-based authentication usage within DB2 LUW environments preferred
• Experience with partitioned and non-partitioned environments preferred
• Able to resolve performance issues using various tools
• Participate in Database Maintenance and DR activities
• Build and configure multiple DB2 databases, clustered, non-clustered and virtual environments .
• Generating DDL using DB2LOOK utility .
• Strong Shell Scripting experience in Red Hat and SUSE Linux
• Performance tuning by monitoring, taking snapshots
• I have knowledge of Oracle Enterprise Manager(OEM)
• Opening PMR with IBM through phone or tickets in case of Database failures or any support required & driving them to closure
• I do have experience on Problem Resolution, Configuration Management, Capacity Management
• I have experience with TSAMP in a production environment
• I worked supporting DB2 in a WCS (Web sphere Commerce Server) environment
• Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database.
• 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 using Isolation levels.
• Good knowledge on Incident, Problem and Change management process
• Managing P1/P2 Bridge Calls
• May manage smaller projects/initiatives as an experienced individual contributor with specialized knowledge within assigned discipline
• Performs DB2 database testing
• Leverages understanding of database technologies and supporting technologies to build and maintain databases
• Strong collaboration, team building, interpersonal, communication skills with proficiency of grasping new technical concepts quickly.

TECHNOLOGY PROFICIENCY:

Operating System: Linux (SUSE and Red Hot),AIX, Unix, Sun Solaris, Windows

Languages: SQL, UNIX, Shell Scripting, awk, C

RDBMS: IBM DB2 UDB LUW V9.1, V 9.5, V9.7, V 10.1&V10.5,SQL Server 2005/2008/2012 , Oracle (OEM),Netezza

DBA Tools: Putty, IBM data studio,DB2 control center, Change Data Capture (CDC), Optim Performance Manager, DB2 Performance Expert, Erwin, ER/Studio, Rational Data Architect, DPROP, DB2 Replication Center, DB2 connect, and Quest Tools, VERITAS NetBackup, TSM, DB2 Federation, DB2 Query Patroller,DB2 Governor, db2top and db2pd,SRDF/non-SRDF

Application Server: WebSphere, WebLogic, JBoss,Cognos

Reporting Tools: Service Now, CA ( SDM ),JIRA

PROJECTS EXPERIENCE:

Confidential, New Jersey

Database Administrator

Environment : DB2 UDB V9.7, V10.1,V10.5 OS - AIX, LINUX

Responsibilities:

• Developed and Maintained Development, Test and Production DB2 UDB Linux/Unix/Windows(LUW).
• AIX / Linux / CRON job experience
• Performed SQL Tuning using EXPLAIN, tuning Database/ Database Manager configuration parameters for optimal database performance
• Created Database Objects like Schemas, Tables, Views, Stored Procedures, Indexes, Triggers, Table spaces, Buffer Pools, User Roles, User Defined Types (UDT) and functions.
• Maintained database security by Granting/Revoking users/role (v.10.1) authorizations and privileges
• I Do have a experience in UNIX with AIX 5.x/Linux preferred.
• Experience on DB2 Installation, Planning, Migration and Maintenance & upgrading activities.
• DB2 Cataloging Databases on various node directory / catalog configuration.
• Database performance tuning using DB2dart, DB2explain utilities.
• Maintained database concurrency by setting proper Isolation Levels and Locks for queries
• Extensive experience in fine tuning of long running queries.
• Worked on data movement IMPORT, EXPORT and LOAD utilities.
• Oracle Installation, Configuration and Upgrading Experience (AIX / Linux)
• Oracle Migration experience: 11.0 - 12g
• Oracle profiler / Operational Support experience
• Oracle RAC w/data guard experience
• I have a Knowledge on SQL and PL/SQL
• Experience on database physical and logical design principals
• Experience in DB2 High Availability (HADR, TSA, HACMP).
• Solid knowledge of high availability using Tivoli / TSAMP policies.
• Performed database maintenance tasks REORGCHK, RUNSTATS, REORG on daily/weekly basis
• Experience with RDBMS like Oracle or Microsoft SQL Server
• Experience in Performance monitoring/testing COGNOS applications
• Experience reviewing SQL to address performance problems
• The internal drive, intellectual curiosity, ability to learn, and desire to help the customers succeed.
• Experience on Trouble shooting database issues using db2diag and notification logs, snapshot, event monitor, db2hc or enabling hmon .
• Table space creation on DPF environment
• Experience with testing methods
• Experience in at least one DB2 database technology, technical or application area
• Design experiences, preferably with database architecture standards or frameworks
• Experience designing, modeling, creating and maintaining databases based on business requirements
• Writing and testing shell scripts for automating database activities
• I do have a experience Table space management - Adding, dropping, extending, reducing and resizing table space containers
• Identifies what needs to be done and accepts task responsibilities and is results-driven. in clustered environments, and full application SDLC.
• Done Backup (online and offline), Restore and Redirect Restore
• Experience installing and supporting DB2LUW on both Windows and Linux
• Experience database performance tuning is expected.
• Experience on Backup and recovery methods including point in time recovery.
• Setup and maintain documentation and standards.
• Perform defect prevention plan and continual improvement tasks.
• Resolve issues related to data propagator SQL replication.
• Experience in multiple operating systems like Red Hat Linux Advanced for DB2 (LUW).
• Experience with change control management for moving changes from Development to Production.
• Experience with Content Management, Business Intelligence systems,And with Big Data
• Experience Use of problem and change management tools & Managing Archive log files
• Involved in L2 and L3 activities.
• Attending Weekend calls with offshore and onsite teams
• Supported on-call DBA responsibilities in UDB off-hour (24/7).

Confidential

DB2 DBA

Environment : DB2 V9.5,V10,V10.5 Sun solarise, AIX, Linux, Oracle, IBM Data Stage and Netezza

Responsibilities:

• Create and Manage Servers, instances and databases
• Performed SQL Tuning using EXPLAIN, tuning Database/ Database Manager configuration parameters for optimal database performance
• Worked on Workload Manager to explicitly control and influence resources during execution by mapping all the queries to service classes.
• Maintained database concurrency by setting proper Isolation Levels and Locks for queries
• Worked on data movement IMPORT, EXPORT and LOAD utilities.
• Recovered database using crash, version and roll-forward recovery methods.
• Experience in setting up and maintaining High availability disaster recovery (HADR).
• Performed database maintenance tasks REORGCHK, RUNSTATS, REORG on daily/weekly basis .
• Implemented DB2 Performance Expert monitoring tool on Dev, QA and Prod servers.
• Used db2expln, db2ckbkp, db2look, db2move, db2pd, db2rbind and db2mtrk utilities
• Wrote shell scripts and setting up CRON jobs to take backup, runstats, reorg, disk space monitoring, I/O contention, log growth and rate of database growth.
• Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations.
• Maintaining and troubleshooting health parameters of the database such as Deadlocks, Lock timeouts/escalations, Buffer Pool/Catalog hit ratio, Utility/Database heaps.
• Monitoring Tablespace utilization, Diaglog, Disk I/O, CPU utilization on a regular basis.
• Establish standards and procedures to implement database security and auditing procedures
• Involved in applying latest fixpaks on all UDB databases.
• Troubleshoot database production problems and database connectivity issues
• Implement Business Continuity Solutions such as Database refresh, cloning, Database Backups, etc.
• Monitoring the database environment on a regular basis for performance and other issues
• Configure and maintain database high availability
• Monitoring all the database and Instance parameters using Foglight monitoring tool.
• Responsible for designing, implementing and testing Disaster Recovery procedures and processes
• Experience on that Computer Security Policies, General IT and SOX Controls are followed
• Experience on compliance with naming standards
• Participate as a team member in projects that require outages, upgrades and patches to databases
• Produce documentation and procedures regarding the proper use and operation of the DBMS
• Capacity Planning
• Coordinate the resolution of DBMS problems that require DBMS vendor intervention
• Opened PMR's and Service tickets to get the resolution from IBM for critical database issues
• Experience with change control management for moving changes from Development to Production.
• Supported on-call DBA responsibilities in UDB off-hour (24/7).

Confidential

DB2 DBA

Responsibilities:

• Tuning of DB and DBM configuration parameters
• Monitored the table space’s growth and added/extended the containers accordingly worked with data movement utilities IMPORT, LOAD, and EXPORT
• Reorganizing Tables and Indexes for improving performance
• Altered Buffer pool size and Threshold.
• Monitored Databases using Database monitors, Snapshot Monitor, and Event Monitor.
• Generating DDL using DB2LOOK utility
• Done Backup (online and offline), Restore and Redirect Restore
• Checked the database backup image's integrity using db2ckbkp
• Granting database privileges to the users
• Performance tuning the database for better and faster results
• Table space management - Adding, dropping, extending, reducing and resizing table space containers
• Exporting the data from production and loading it in test boxes
• Sending daily and weekly reports and handovers.