We provide IT Staff Augmentation Services!

Dba Resume

Atlanta, GeorgiA

SUMMARY

  • DB2 & IMS DBA wif around 17.5 years of experience in domains such as Banking, Insurance and Health care.
  • Expertise in DB2 & Confidential ; IMS database designing.
  • Expertise in setting DB2 system parameters.
  • Expertise in creation of databases manually/through tools in different Environments.
  • Expertise in backup and recovery strategies using IBM/BMC utilities.
  • Expertise in running DB2 IBM and BMC utilities.
  • Expertise in Performance tuning of IMS Programs and DL/I Calls.
  • Expertise in Performance tuning of DB2 programs.
  • Expertise in setting - up randomizer parameters for IMS DBs for better performance
  • Expertise in troubleshooting DBA and other technical issues in DB2.
  • Expertise in cloning of DB2 and IMS database.
  • Experience wif migrating mainframe data from production to test databases for DB2 & Confidential ; IMS.
  • Experience on performance monitoring tools for DB2 and IMS.
  • Experience wif DB2 QREP and DB2 federation services
  • Experience working wif MDM applications on DB2 UDB
  • Experience wif UNIX shell scripts and PERL scripts for DB2 UDB automation.
  • Experience wif installation of DB2 UDB EE and Fixpacks on Linux,UNIX and Windows machines.
  • Experience in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
  • Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production.
  • Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
  • Facilitated data requirement meetings wif business and technical stakeholders and resolved conflicts to drive decisions.
  • Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
  • Practical understanding of teh Data modeling (Dimensional & Confidential ; Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Comprehensive noledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
  • Experience in Storage management and System administration/Operations of IBM mainframe system covering Server Pack Installation, Console operations, DFSMS Management, space management using DFSMShsm
  • Experience wif migrating mainframe data for DB2/IMS.
  • Experience in IBM copy services like PPRC, Flashcopy and concurrent copy techniques
  • Experience wif DS8800 and SAN environment
  • Experience in DFSMSdss
  • Extensive experience in working wif TSO, JCLs.
  • Has experience in IMS DB/DC.
  • Hands on experience wif setting up CICS regions
  • Experience in Oracle database
  • Hand-on experience wif Big Data technologies such as Hadoop, HDFS, MapReduce, Pig, Hive, HBase, Oozie, Zookeeper
  • Expertise in RFI, RFP work.
  • Expertise in DB2 mainframe competency setup and trainings.
  • Good leadership qualities and people management skills.
  • Good communication skills.
  • Experience in working wif clients wif different geographical orientation: Australia, USA, UK and India.

TECHNICAL SKILLS

Platforms: Mainframes (z/OS), RHEL 6, Windows 95, 98, 2000, XP

Dbms: DB2 z/OS V12, IMS DB V15, DB2 UDB V11.5, Oracle

OLTP: CICS

Tools: BMC Catalog Manager, BMC Change Manager, BMC Mainview, BMC Logmaster, BMC Apptune, BMC DASD Manager, IMS DBRC, Strobe, Omegamon, C.A Insight, RC Migrater, RC query, Endevor, DBXPERT, Dbeaver

Languages: REXX, JCL.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

DBA

Responsibilities:

  • Working on database designing for DB2 databases
  • Managing DB2 z/OS and IMS environments for production releases and projects.
  • Creating and modifying DB2 and IMS databases and database objects
  • Running & Confidential ; supporting all Critical and High incidents related to IMS & Confidential ; DB2 issues in Production. This happens on live bridge calls.
  • Planning and supporting all major IMS & Confidential ; DB2 related upgrades/fixes such as a) IMS/DB2 Version upgrades b) BMC IMS/DB2 utility upgrade/fixes c) RSU maintenance etc
  • Utility support including Copy, Reorg, Load and Modify jobs
  • Monitoring, trouble-shooting and resolution for DB2 issues
  • Recovering DB2 objects as and when required
  • Granting/Revoking privileges on DB2 objects
  • Planning and implementing DB2 software upgrades
  • Doing capacity planning for DB2 environment
  • Writing and scheduling various DB2 maintenance utility jobs
  • Planning and supporting quarterly mainframe DR activities/drill.
  • Supporting MDM application on DB2 UDB 10.1
  • Performing performance monitoring and tuning for MDM application
  • Performing DBDGEN, PSBGEN. ACBGEN for new/old IMS objects
  • Performing IMS DL/I call tuning and DB2 SQL tuning.
  • Setting up Randomizer parameters for IMS DBs for improved performance
  • Performing IMS DB recoveries through DBRC GENJCL
  • Running both BMC and IBM utilities for IMS and DB2 DBs as per requirement
  • Supporting IMS DBs such as HDAM, HIDAM, HALDBs, DEDB.
  • Performing IMS Batch backout when ever need arise.
  • Coding DFSDDLT0 statements for testing and DBDs and PSBs.
  • Performing IMS HALDB conversions
  • Performing quarterly 360-degree review of Top 13 IMS and DB2 applications and take actions appropriately
  • Performing on-site coordination wif offshore teams for teh project deliverables
  • Running weekly meetings wif teh clients on day to day operations

Dbms: DB2 z/OS V12, DB2 UDB 11.5, IMS V 15

Tools:TSO, FILE-AID, BMC Catalog Manager, BMC Change Manager, Omegamon, BMC Apptune, Dbeaver, All BMC/IBM utilities for IMS & Confidential ; DB2

Confidential

DBA

Responsibilities:

  • Managing DB2 z/OS environments for production releases and projects.
  • Creating and modifying DB2 databases and database objects
  • Maintaining and populating Test/Prod Databases
  • Storage allocations utilizing SMS and Stogroups
  • Utility support including Copy, Reorg, Load and Modify jobs
  • Monitoring, trouble-shooting and resolution for DB2 issues
  • Recovering DB2 objects as and when required
  • Granting/Revoking privileges on DB2 objects
  • Planning and implementing DB2 software upgrades
  • Doing capacity planning for DB2 environment
  • Writing and scheduling various DB2 maintenance utility jobs
  • Involved in setting up DB2 QREP between operational database and reporting database.
  • Troubleshooting issues related wif QREP control and source tables
  • Set-up CICS regions to support Production Releases
  • Designed SMS policies for DB2 environment
  • Performance improvement for VSAM clusters in DFHSM environment and Migration of datasets to tapes
  • Defined migration policies for DB2/IMS
  • Management of ACS routines and SMS constructs
  • Done capacity planning for DB2/IMS storage environment
  • DASD volume initialization using ICKDSF
  • Coordination wif vendor in resolving issues related to switches and DASD storage.
  • Backups using flashcopy services
  • Managing Oracle databases

Rdbms: DB2 z/OS V9, DB2 z/OS V10, IMS V10, Oracle

OLTP: CICS

Tools: Inhouse tool, Endevor, TSO, FILE-AID, QREP and related products

Confidential

Data Modeler/DBA/Technical specialist

Responsibilities:

  • Studied in-house requirements for teh Data warehouse to be developed
  • Conducted one-on-one sessions wif business users to gather data warehouse requirements
  • Analyzed database requirements in detail wif teh project stakeholders by conducting Joint Requirements Development sessions
  • Developed a Conceptual model using Erwin based on requirements analysis
  • Developed normalized Logical and Physical database models to design OLTP system for insurance applications
  • Created dimensional model for teh reporting system by identifying required dimensions and facts using Erwin
  • Used forward engineering to create a Physical Data Model wif DDL dat best suits teh requirements from teh Logical Data Model
  • Worked wif Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate teh developed models
  • Managing mainframe environments for production releases.
  • Performs all structural changes to DB2 and IMS databases.
  • Performing DBDGEN, PSBGEN. ACBGEN for new/old IMS objects
  • Maintaining and populating Test/Prod Databases.
  • Storage allocations utilizing SMS and Stogroups.
  • Utility support for DB2 and IMS databases.
  • Monitoring, trouble-shooting and resolution of IMS/DB2 issues.
  • Refreshing DB2 UDB test databases from Prod Data using Export/Load
  • Masking Prod data in test environment before handing over teh same to testers in DB2 UDB.
  • Created various shell scripts to automate database maintenance such as Load/reorg/runstats and backup/restore/snapshot monitors.
  • Performed Load, Import and Export Utilities for DB2 UDB.
  • Optimized buffer pool configurations on DB2 UDB server. Interact wif teh System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems.
  • Created UDB instances and Databases for Test, QA, DR and PRODUCTION environment
  • Implementing ITIL processes to manage DB2 mainframe environments.
  • Monitoring DB2 production servers for potential problems.
  • Applying upgrades to DB2 in test and production.
  • Assist all development work on IMS/DB2. This includes helping wif application development, designing and creating database objects, migrating from test to production, and implementing batch schedules wif teh appropriate IMS/DB2 utilities.
  • Works wif Security Administration to ensure dat proper security is in place for DB2 data.
  • Analyse and correct problems dat occur in teh IMS/DB2 environment. This includes nightly support for teh batch environment.
  • Administer teh data server on which DB2 resides: monitor disk space and teh DB2 log, backups, protect teh integrity of teh data.
  • Set-up of offshore team for IMS/DB2 environment support.

Dbms: DB2 z/OS V8, DB2 z/OS V9, IMS V12, DB2 UDB 9.7

Tools: Inhouse tools, Erwin, ER Studio, Endevor, TSO, FILE-AID, DBXPERT

Confidential

DBA and Technical Support

Responsibilities:

  • Managing teh team of DBAs and technical support.
  • Create and modify DB2 databases and database objects.
  • Maintaining and populating Test/Prod Databases.
  • Storage allocations utilizing SMS and Stogroups.
  • Utility support including Copy, Reorg, Load and Modify jobs for IMS & Confidential ; DB2 z/OS
  • Utility support including Export, Import, Load, Runstats, Reorg for DB2 UDB.
  • Use tools like db2advise, db2look, db2move and db2adutl to monitor, analyse and make changes in DB UDB database.
  • Taking Snapshots and gathering other information related to DB2 UDB database and teh system during stress tests or performance tuning.
  • Troubleshooting and resolving environment issues related to Linux, Windows, UNIX, databases and storage devices.
  • Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases
  • Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities
  • Monitoring, trouble-shooting and resolution.
  • Provide day to day technical support to project teams/developers/testers.
  • Planning and implementing DB2 software upgrades
  • Managing DB2 to Oracle data migration
  • Creating IMS Objects such as DBDs, PSBs and ACBs
  • Troubleshooting issues wif DB2, IMS DB/DC and CICS
  • Managed following projects 1) Upgrade of DBA specific tool DBXPERT(Compuware) to support DB2 V8 features. 2) Worked on Data masking project so dat sensitive customer data can be masked and sent to offshore for teh testers to work on.
  • Worked on migration of DB2 plan/Packages from DBPROTOCOL(PRIVATE) to DBPROTOCOL(DRDA)
  • Worked on installation of DB2 V9 on z/OS
  • Worked on setting-up DB2 DSNZPARM parameters for optimum performance.

Dbms: DB2 z/OS V8, DB2 z/OS V9, IMS DB V10, DB2 UDB V9.5, Oracle

Tools: In-house tools, BMC Catalog Manager, BMC Change Manager, Endevor, TSO, FILE-AID

Confidential

DBA

Responsibilities:

  • Creating and modifying DB2 databases and database objects
  • Maintaining and populating Test/Prod Databases
  • Storage allocations utilizing SMS and Stogroups
  • Utility support including Copy, Reorg, Load and Modify jobs
  • Monitoring, trouble-shooting and resolution for DB2 issues
  • Designing SMS policies for DB2 environment
  • Creating IMS databases objects such as DBDs, PSBs, ACBs.
  • Using DBRC to perform Backup/Recovery of IMS objects
  • Doing capacity planning for DB2 environment
  • Recovering IMS & Confidential ; DB2 objects as and when required
  • Monitoring and fixing IMS & Confidential ; DB2 performance issues
  • Implementing ITIL processes to manage DB2 mainframe environments

Dbms: DB2 z/OS V8, DB2 z/OS V9, IMS DB

Tools: BMC Catalog Manager, Change Manager, Endevor, SMART, Task Tracker

Confidential, New Jersey

Data Modeler/DBA

Responsibilities:

  • Conducted major stakeholder interviews involving SME’s, Business Analysts and other stakeholders to determine teh requirements.
  • Translated teh business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
  • Identified and compiled common business terms for teh new applications dat become central part of communication among project stakeholders to avoid ambiguity
  • Worked at conceptual/logical/physical data model level using Erwin according to requirements.
  • Involved in exhaustive documentation for technical phase of teh project and training materials for all data management functions
  • Used Reverse Engineering approach to redefine entities, relationships and attributes in teh data model as per new specifications in Erwin after analyzing teh database systems currently in use
  • Enforced referential integrity in teh OLTP data model for consistent relationship between tables and efficient database design
  • Create and modify databases and database objects
  • Maintaining and populating Test/Prod Databases
  • Reviewing of DB2 access paths.
  • Running DB2 IBM and BMC utilities for Test/Prod databases.
  • Worked on converting BMC reorg utilities to IBM reorg utilities.
  • Mainframe Training head. Released 10 batches. Prepared DB2 DBA courseware.
  • Built DB2 DBA competency.
  • Recruitment for Mainframe Unit.
  • Providing DB2 DBA trainings.
  • Providing trainings on DB2 certifications (612, 617) to DBAs.
  • Prepared reference documents on various topics such as “DBA best practices”, “DB2 utilities best practices” “DB2 stored procedure”, “Common DB2 abends and their resolution” etc to be used by DBA/developer as reference material.
  • Worked on POCs and supported various customers in pursuit of offloading costly Mainframe Batch workload on to Hadoop ecosystem. Technologies used are Hadoop, HDFS, MapReduce, Pig, Hive, HBase, Oozie, Zookeeper. This unit level initiatives is aimed at reducing mainframe MIPS cost for many Infosys customers.

Rdbms: DB2 z/OS V8, DB2 z/OS V9, Oracle, SQL server, DB2 UDB

Tools: Erwin, BMC Catalog Manager, Change Manager, C.A Insight, Endevor.

Hire Now