SUMMARY

• Dedicated and hardworking professional with 13 years of industry experience in the field of enterprise wide DB2 Database Administration for Z/OS, LUW Systems.
• Expertise with the design and administration of large scale databases on DB2 v7, v8, v9, v10, v11 for Z/OS in data sharing environment.
• Experience with the installation, upgrading, migration and patching of large scale DB2 LUW Databases, creation and configuration of Database Instances and Databases of DB2 UDB v8.1, v8.2, v9.1, v9.5, v10.1, v10.5 on LUW systems for OLTP environments.
• Experience in the successful implementation of High Availability (HA) and Failover of Databases using High Availability Disaster Recovery (HADR) and Microsoft Clustering.
• Expertise with the installation and configuration of DB2 clients and DB2 Connect Gateways
• Expertise in Performance Monitoring, Performance Tuning of Database systems and SQL Tuning.
• Expertise in design and implementation of Database Backup and Recovery procedures
• Expertise in creating and maintaining Database objects/structures like Tablespaces, Tables, Indexes, Views, Synonyms, Aliases, Procedures, Packages etc.
• Expertise in moving the data across different databases using data movement utilities like EXPORT, IMPORT, UNLOAD, LOAD etc
• Expertise in Designing and implementing Database Replication technologies like Q Replication.
• Expertise in the design and implementation DB2 Federated databases
• Design and Schedule database maintenance utilities such as RUNSTATS, REORG, and REBIND etc.
• Manage DB2 Database licenses at the enterprise level as per IBM licensing policies.
• Expertise with the SQL Performance analysis using EXPLAIN utility and tuning the SQL.
• Expertise in supporting (24/7) Highly Available, high - volume and large scale environments.
• Highly experienced in Infra Structure Optimization activities to reduce MIPS and storage of Databases and Database Applications
• Expertise with Database Administration Utilities and Performance monitoring tools from various vendors like IBM, BMC, CA, Platinum, Toad, Oracle etc.
• Develop and Manage JCL, REXX and Shell Scripts

TECHNICAL SKILLS

• Computer/Hardware Systems Mainframe
• AIX
• Intel
• LinuxOperating Systems Windows XP
• NT
• 2000
• 2003
• OS/390
• Z/OS
• AIX
• LinuxDatabase Management Systems DB2 v7.1
• DB2 v8
• DB2 v9 v10 on Z/OS and OS/390 DB2 UDB V 8.1 v8.2 v9.1 v9.5
• V10.5 on Linux
• AIX Oracle 9i
• 10g Databases for Windows
• Solaris and AIXProgramming Languages SQL
• PL/SQL
• COBOL
• Java
• REXX
• C/C++
• JCLSpecial Software Tools IBM DB2 Admin tools
• Visual Explain
• Query Governor
• BMC DB2 Admin tools
• CA Platinum DB2 Admin tools
• Detector
• Plan Analyzer
• Omegamon
• Log Analyzer SQL Analyzer
• Toad for DB2
• TMON for DB2
• SSIS
• ETL Scripting Languages HTML
• Shell
• VB
• JCL Professional Certifications

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. Database Administrator

Responsibilities:

• Design and implement database administration processes of DB2 v10 Z/OS databases
• Administration and maintenance of IBM Info Sphere Q Replication Architecture involving DB2 Z/OS, Oracle and SQL Server databases
• Support DB2 v11 migration project
• Install and configure Q Replication dashboard for monitoring replication topology
• Streamline Flash Copy backup and recovery procedures for DB2 Z/OS databases
• Install and configuration of DB2 Connect, IIDR and CDC servers
• Design and implement DB2 Federation architecture involving multiple data sources like DB2 Z/OS, Db2 LUW, Oracle and SQL Server
• Performance Monitoring and optimization of database processes
• Migrate some DB2 Z/OS databases into MongoDB

Environment: DB2 v10 for Z/OS, Q Replication, DB2 Federation, Oracle, MongoDB, DB2 LUW v10.5, Linux, Data Studio, Toad for DB2, IBM Qmon, Omegamon for DB2, CA RC/Query

Confidential, Milan, IL

Sr. Database Administrator

Responsibilities:

• Design and implement Database solutions for JDLink Databases on DB2 v9 and DB2 v10 in data sharing environment on Z/OS.
• Design and administer large scale databases of around 50TB with high volume distributed workloads.
• Evaluate new database technologies and features in designing the database architecture
• Support database upgrades, fixes and maintenance releases of vendor products.
• Create processes to automate database maintenance tasks across all the databases in node architecture.
• Work as DBA SME to support and lead DBA team members in US and India.
• Support database developers and application programmers in Agile software development environment.
• Design and Implement Disaster Recovery procedures for Business continuity Plan (BCP). Use of traditional object level image copy and system level flash copy backups for recovery of databases.
• Design and deploy database changes dynamically without impacting the applications.
• Design and Implement Database Administration and Maintenance procedures like Backup, REORG, RUNSTATS and REBIND Process.
• Schedule Database maintenance batch Jobs and processes using ESP scheduler
• Involve in infra structure cost optimization to reduce MIPS consumption and storage.
• Capacity Planning for Disk, Tape storage, Memory and CPU. Generate current utilization reports.
• Publish database design standards, new technology guidelines, optimization opportunities across the enterprise.
• Monitor the health and performance of DB2 Databases and Applications using Omegamon for DB2, BMC Apptune, Omegamon for MVS and Data Studio.
• Create and implement best Practices in the design of databases, Application Programming Standards and Guidelines.
• Design and manage complex LOB database objects like BLOB, CLOB and XML.
• Design the process of large amount of Data refresh across various environments using BCV5 and DSN1COPY utilities.
• Design the migration process to migrate DB2 LUW databases on to DB2 Z/OS
• Work with BMC tools like Catalog Manager, Log Master, and Apptune in maintaining the Databases.
• Review application SQL and recommend tuning opportunities. Used EXPLAIN and Data Studio tools to evaluate the performance of SQL and provide recommendations.
• Provide on-call support to maintain the high availability of databases in 24X7 environment.
• Support DB2 Z/OS database migration on to AWS Postgres databases
• Install and configure DB2 Clients, DB2 Connect Gateway Servers, and DB2 LUW Database servers.

Environment: DB2 v9 for Z/OS, DB2 v10 for Z/OS, Z/OS v1.11, Data Studio, Toad for DB2, BMC Apptune, Omegamon for DB2, Omegamon for MVS, BMC Catalog Manager, Flash Copy, DB2 Data Sharing, JCL, SAS, REXX, DB2 LUW v10.

Confidential, Woodbury, MN

Sr. Database Administrator

Responsibilities:

• Design Database solutions for Databases on DB2 v8, v9 for Z/OS, DB2 UDB v9.1, DB2 UDB v9.5
• Design the Installation, Upgrade and Patch/Fix pack procedures for DB2 Subsystems, DB2 UDB Instances, DB2 Gateway Servers, DB2 Clients, Third party vendor tools from BMC, CA Platinum.
• Design and Implement High Availability of Databases using Data sharing Groups, DB2 Replication Procedures, Microsoft Clustering and Failover mechanisms.
• Design and Implement Disaster Recovery procedures for Business continuity Plan (BCP). Used BMC Recovery Manger tool for creating and managing Recovery Groups.
• Design and Implement Database Administration and Maintenance procedures like Backup, Recovery and Archival process, REORG, RUNSTATS and REBIND Process.
• Capacity Planning for Disk, Tape storage, Memory and CPU estimation for Database Servers.
• Design logical and Physical data models and involve in the normalization of Databases.
• Monitor the health and performance of DB2 Databases and Applications using Omegamon and Omega view Tools. Generate and analyze Performance Reports from DB2 PM and RMF.
• Design and Implement the process of Enabling ZIIP for BMC Products. This has reduced 40% of MIPS on regular Processors.
• Design Database Maintenance Automation Procedures, Best Practices in the Design of Databases, Application Programming Standards and Guidelines.
• Design and Implement Database Security procedures, Auditing, Encryption solutions.
• Troubleshoot database issues in production environment. Coordinate with IBM tech support in resolving PMRs. Participate in War room bridges in resolving the database locking issues, deadlocks and performance issues.
• Design and Implement Database Objects Tables, Tablespaces, Indexes, Views, Synonyms, Packages, Plans, Triggers, Procedures and Functions etc.
• Analyze IBM, BMC and CA Tools functionality and Performance; recommend appropriate tools depending on Client requirement.
• Design and Implement IBM Utilities UNLOAD, LOAD, REORG, COPY, RECOVER, REBUILD INDEX, QUIESCE, Export, Import Utilities. Design and Implement BMC Utilities like Unload Plus, Load Plus, Reorg Plus, Copy Plus, Recover Plus, Recovery Manager.
• Install and Apply fix packs to the DB2 Connect Gateway Servers and DB2 Clients with v9.1, v9.5. Configure Database Managers and DB2 Clients. Install and configure Oracle Databases on Test servers.
• Design the process of Data Move across different databases. Use the data movement utilities EXPORT, IMPORT, UNLOAD, LOAD etc. Refresh the development and test databases with production data. Move the data between UDB databases on LUW and DB2 on Mainframe.
• Work with BMC tools Catalog Manager, Log Master, DASD Manager, Main view, Recover Plus, Recovery Manager in maintaining the Databases.
• Review database access code and recommend tuning opportunities. Used EXPLAIN and Visual EXPLAIN tools to evaluate the performance of SQL and provide recommendations.
• Support Oracle Database Administration in Dev and Test Environments
• Design the approach for migrating Changeman tool to Endevor.
• Design and Implement procedures to migrate BMC DB2 Tools to CA DB2 Tools
• Work with CA DB2 Tools like Fast Unload, Fast Load, Rapid Reorg, Quick Copy, Fast Recover, Log Analyzer, RC Query, Platinum Detector, Database Analyzer, Subsystem Analyzer.
• Design and Implement DB2 Connect Monitoring Process.