SUMMARY

• Lead level DB2 and Oracle certified Database Administrator with over 9 years of solid hands - on experience in handling multiple DB2, Oracle and Cassandra databases in heterogeneous environments such as Solaris, HP-UX and Windows.
• Well exposed to state of the art RAC implementations, HADR, DataGuard, GoldenGate, routine DBA production support, development and related database technologies. Received best performance awards on numerous occasions
• DB2 11.1, 10.5, 10.1, 9.7, 9.5 database administrator functions including, database object creation and alters implementation, reorgs, statistics collection and analysis.
• DB2 Recoveries, performance tuning, schedule and manage maintenance of production application databases, disaster recovery testing.
• Installation, Configuration, Fixpack Upgrade and Administration on V9.x, V10.x,V11.x of db2 environments.
• Experienced in managing large databases and large number of user population on 24x7 environments.
• Proficient in taking database backups and recovering the database with timestamps.
• Expertise in Using Export, Import and Load utilities to export and import the data.
• Database Migration /Cloning Across same platform using Redirected Restore, different platform using db2look and db2move.
• Strong hands-on experience for setting up PureScale and HADR.
• Installations, In-place and Side-by-Side Migrations of DB2 ESE and DPF databases.
• Experience in various table queries like create, alter and update. Managing user access to production and non-production environments based on the requirements.
• Database monitoring and tuning experience using DB2’s Snapshot Monitor, Event Monitor, db2advisor and db2explain tools.
• Expertise in troubleshooting tools - db2diag, db2support, db2pd.
• Good experience on maintaining DB Level (DB CFG) and DB Manager Level (DBM CFG) Parameters.
• Security Setting authentication, authorization and granting/revoking privileges on database objects to users.
• DB2 Performance Utilities - REORGCHK, REORG, RUNSTATS.
• Problem determination and resolution for supported application databases and maintenance utilities.
• Perform change management activities using standard change processes in support of application database related changes.
• Analyze and correct problems that occur in the DB2. This includes nightly support for the batch environment.
• Provided Support for application developers by providing SQL, testing SQL’s, Trouble shooting application problems.
• Expertise in Using Utilities like DB2look, Export, Import, Run stats, Reorg.
• Proactive and Reactive Database Health checks and server reviews for client DB and suggesting changes.
• Experience in managing and installation of 10g/11g/12c CDB/non-CDB Active Data Guard.
• Oracle DBA experience including building objects and maintaining production environments.

TECHNICAL SKILLS

Operating Systems: Oracle Solaris10,Red Hat Linux,AIX, Windows 2000/2003/2008 Server, Windows XP,Windows7/8.

Databases: DB2 V11.xV10.x, 9.x, HADR, PureScale, DPF, Oracle RAC (Real Application Clusters) 12c/11g/10g, Oracle Standalone databases 10g/11g/12c, Oracle ASM, Oracle Golden Gate, Cassandra.

Database tools: IBM InfoSphere Guardium, Data Studio, IBM Optim, Control Center, TOAD, BMC Tool,Pl/SQL Developer, OEM Cloud Control and OEM Grid Control, SecureCRT,IBM InfoSphere Data Architect, AllFusion Erwin Data Modeler, ETL, Spotlight,Microsoft Management Studio, DevCenter,OpsCenter.

Database Utilities: DB2look, DB2TOP, DB2PD, DB2move, DB2explain, DB2advisor, DB2load, RMAN, Exp/imp, Sqlldr.

Other Skills: VMWARE Server/Workstation, Web sites Development, Unix Shell scripting.

PROFESSIONAL EXPERIENCE

Confidential

Lead DB2 UDB/LUW DBA

Environment: IBM DB2 11.1,10.1,9.7, PureScale, HADR, DPF, Solaris10, AIX, Linux, IBM P795 Servers.

Responsibilities:

• Has overall responsibility for all DB2 products in production and test environments. These include the DB2 software itself, monitoring tools.
• Installation and configuration of the new DB2 9.7, 10.1 and 11.1 DPF and non DPF databases.
• Monitoring DB2 24x7 production servers for potential problems.
• Taking offline/Online backup and restore on PureScale and non-PureScale environments.
• Implementing and managing PureScale and HADR on production and test environments along with IBM InfoSphere Guardium.
• Good working experience on Q replication.
• Applying upgrades along with Business System Services to DB2 in test and production.
• Apply Fix packs on DB2 V11.x, 10.x, 9.x on HADR, PureScale and standalone environments.
• Along with Business Systems Services, installs and maintains software used for supporting and monitoring DB2.
• Used Utilities like DB2look, Export, Import, Run stats, Reorg.
• Assisting all development work on DB2. This includes helping with application development, designing and creating database objects, migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities.
• Developed and documented overall vision for DB2 in our environment.
• Provided information to developers and operators on all components of DB2 that are of interest through the Web, Infoshares etc.
• Administer the data server on which DB2 resides: monitor disk space and the DB2 log, backups, protect the integrity of the data.
• Serve as an overall DB2 resource and keep abreast of new developments in the DB2 world through journals, newsgroups, the Web, and the DB2 Users Group.
• Tickets handling based upon the Priority (Like High, Medium, Low).
• Proficient in performance tuning using Data Studio, DB2TOP, DB2PD, Monitor Traces.

Confidential, Bloomington, IL

Sr. DB2 UDB/LUW DBA

Environment: IBM DB2 11.1,10.5,10.1, PureScale, HADR, Oracle, Solaris10, AIX, Red Hat Linux.

Responsibilities:

• Has over-all responsibility for all DB2 products in production and test environments. These include the DB2 software itself, monitoring tools.
• Monitoring DB2 24x7 production servers for potential problems.
• Applying upgrades along with Business System Services to DB2 in test and production.
• Implemented database policy for backing up data on daily basis.
• Apply Fix packs and upgrades DB2 V11.x, 10.x, 9.x on HADR, PureScale and standalone environments.
• Assisting all development work on DB2. This includes helping with application development, designing and creating database objects, migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities.
• Strong hands-on experience for setting up PureScale and HADR.
• Strong experience for adding removing and maintaining PureScale members and CF.
• Upgrade PureScale cluster databases from V10.1 to V10.5.
• DB2 V10.5 to V11.1 upgrade and data migration on a Unix/AIX environment.
• Installations, In-place and Side-by-Side Migrations of DB2 ESE databases.
• Involved in setting up HADR,DPF, Range partitioning, Creating Role based Tables,MQT, MDC, Triggers, Fix pack up gradations etc.
• Performance Monitoring and Tuning SQL monitoring and tuning by rewriting SQL and using Snapshot, Table Function, Event Monitor and OS commands topas, vmstat and iostat, in addition to using EXPLAIN and running the reorgck, reorg, runstats and db2rbind commands.
• Design, Architecture and support of HADR for mission critical applications using DB2 HADR with TSA.
• Database creation using DDL and Maintenance of the Databases.
• Performed Database Replication on LDAP servers using HADR
• Performed all structural changes to DB2 databases.
• Worked with Security Administration to insure that proper security is in place for DB2 data.
• Monitoring the disk usage and system resources and scheduled the db2 utilities on time basis to assure the production systems will be available for 24x7.
• Used Utilities like DB2look, Export, Import, Run stats, Reorg.
• Handling deadlock and Library files issue.
• Administer the data server on which DB2 resides: monitor disk space and the DB2 log, backups, protect the integrity of the data.
• Working on SQL Performance tuning.
• Proficient in performance tuning using Data Studio, DB2TOP, DB2PD, Monitor Traces

Confidential, WoodCliff Lake, NJ

Sr. DB2 UDB/LUW DBA

Responsibilities:

• Responsibility for all DB2 products in production and test environments.
• Monitoring DB2 24x7 production servers for potential problems.
• Applying DB2 V9.7 to V10.5 upgrades and fixpacks in test and production HADR environments.
• Perform database recovery and backup tasks on daily and weekly basis
• Implementing and managing HADR on production and test environments.
• Strong Knowledge and experience on HADR and Purescale enviornments.
• Performed splits on the DR environment at regular basis to keep it in sync with production.
• Performed all structural changes to DB2 databases.
• Implement and manage db2 databases on Purescale enviornment.
• Instances and Databases creation, Maintenance.
• Restoration of the Database on Multiple environments.
• Redirect Restoration of the database.
• Update DBM, DB and DB2set parameters.
• Altering the tables, constraints, stored procedures.
• Used Utilities like DB2look, Export, Import, Run stats, Reorg.
• Performance Monitoring and Tuning SQL monitoring and tuning by rewriting SQL and using Snapshot
• Extending Table space and bufferpool pages.
• Handling stored procedure, index issues, extending Table space and bufferpool pages.
• Monitoring the scheduled jobs like backups, Runstats, reorg etc.
• Tickets handling based upon the Priority (Like High, Medium, Low)
• Writing scripts for user security privilege, reorg, set integrity and runstats.
• Implemented database policy for backing up data on daily basis.
• Developed and documented overall vision for DB2 in our environment.
• Perform troubleshooting and maintenance of multiple databases.
• Proficient in performance tuning using Data Studio, DB2TOP, DB2PD, Monitor Traces
• Monitor databases regularly to check for any errors such as existing locks and failed updates.
• Job scheduling utilities, and database management tools and utilities.
• Installation, configuration, administration and tuning of Oracle 12c /11g Single Instance and RAC databases.
• Installation and administration of Oracle 12c CDB databases on multiple servers.
• Database Upgrade/migration from 10g to 11g/12c on NFS and ASM file systems.
• 12c OEM cloud control installation, configuration and administration.
• Proactive and Reactive Database Health checks and server reviews for client database and suggesting changes.
• Oracle 10g/11g Active/Physical Dataguard setup and administration.
• RMAN Backups setup and recommending performance improvement during hot backups.
• Deploying Logical backup scripts using export and data pump utilities on both Linux and Unix environments.
• Writing Unix Shell scripts for different database monitoring tasks.
• Providing 24/7 support to client databases. Coordinating and executing maintenance tasks on weekends and on-demand.
• Creating SR with Oracle Support on any issues and when needed.
• Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, ASH and 12c OEM cloud control.
• Performed backups using conventional cold, hot & RMAN backups.
• Performance tuning using Explain Plan, SQL TRACE, TKPROF, AWR, ADDM, ASH and 12c OEM cloud control.

Confidential

DB2 UDB\LUW DBA

Responsibilities:

• Fixation of all issue aroused during the upgrade process.
• Backup of the databases before and after the Upgrade.
• Preparation of the complete DB2 upgrade plan for Aix 6.1.
• RDBMS parameters setting as required running DB2 smoothly.
• Strong Knowledge on Purescale enviornments.
• Assists all development work on DB2. This includes helping with application development, designing and creating database objects, Migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities.
• Monitoring table space size, Increasing or adding table space size when it’s required.
• Implemented database policy for backing up data on daily basis.
• Implementing and managing HADR on Multiple production environments.
• Performed Database Replication on LDAP servers using HADR.
• Reviews all data models for technical accuracy. This includes the enforcement of all modelling and naming standards. Performs all structural changes to DB2 databases.
• Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.
• Cataloging Databases on various nodes.
• Monitor database performance and recommend improvements for operational efficiency.
• Perform database recovery and backup tasks on daily and weekly basis.
• Develop and maintain patches for database environments.
• Maintain database security and disaster recovery procedures.
• Perform troubleshooting and maintenance of multiple databases.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.
• Oversee utilization of data and log files.
• Manage database logins and permissions for users.