Lead Db2 Dba On Z/os Resume
Lisle, ChicagO
SUMMARY
- A total of over 16 years of experience in teh IT industry. Working experience includes
- Working experience in DB2 Database Administration on z/OS platform and DB2 LUW
- Knowledge in HADOOP & MONGODBAs a DB2 Database administrator has a wide exposure in teh following areas like
- DB2 Application maintenance support
- Setup and managing multiple DB2 test and staging environments.
- Plan and Manage User Acceptance Testing and Functional Testing and Operations Acceptance Testing.
- Manage teh DB2 tasks to provide consistent performance improvements in teh applications by incorporating tasks such as RUNSTATS, REORG, REPATITIONING, IMAGECOPY, CHECK DATA.
- Maintaining DB2 related objects.
- Designing new databases, as per customer requirement using BMC change manager and Query Manager.
- Data modeling using CA - Erwin tool.
- Performance monitoring using CA- Detector, Omegamon, BMC Main view, IBM Data studio
- Knowledge in IMS Database Backup, Reorg.
- Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
- Train teh new recruiters.
- Willing to learn & support new technologies.
- Leading other DBA areas like SQL Server, Informix, RDB, Progress, DB2 LUW, Websphere MQ/MB, IMS.
- Providing technical direction to offshore team after discussing with customer manager and ensure dat teh project is completed on time.
- Attend technical meetings for other DB areas with Vendors, Application team, customer DBA manager.
- Ensure process management requirements are met for assigned request in all my DB areas. This includes weekly status reporting, maintaining teh project work plan, ensuring Sharepoint lists are up to date (issues, risks, and deliverable acceptance), time reports for assigned resources are accurate and submitted on time, and project time tracking is completed per program guidelines.
- Obtain customer acceptance on teh deliverables
TECHNICAL SKILLS
Operating System: OS/390, z/OS OS/400, Windows 2000 & Win NT, AIX, UNIX, Redhat Linux, Centos 7, Ubuntu
Tools: DB2 Administration, QMF, DB2 PM, Tivoli OPC, OMEGAMON, BMC catalog manager, Change manager, Recovery Manager, Query manager, Main view.
Languages: JCL, RPGLE, and CL.
Transaction Processors: ISPF.
PROFESSIONAL EXPERIENCE
Confidential, Lisle, Chicago
Lead DB2 DBA on Z/os
Responsibilities:
- Over-all responsibility for all DB2 in production, UAT and test environments.
- Involved in all levels of system integration from development to production
- Designing, creating database objects, migrating from test to prod and implementing batch schedules with teh DB2 utilities.
- Create and reviews all data models for technical accuracy. This includes teh enforcement of all modeling and naming standards.
- Provide assistance for interfaces which access DB2.
- Analyze and correct problems dat occur in teh DB2. This includes nightly support for teh batch environment.
- Assist in capacity planning, space management and data maintenance activities for database system.
- Monitor databases and regularly to check for any errors such as existing locks and failed updates.
- Analyzing new application requirements and associated changes.
- Familiar in DB2 standalone & online utilities like
- Leading other DBA areas like SQL Server, Informix, RDB, Progress, DB2 LUW, Websphere MQ/MB, IMS.
- Providing technical direction to offshore team after discussing with customer manager and ensure dat teh project is completed on time.
- Attend technical meetings for other DB areas with Vendors, Application team, customer DBA manager.
- Ensure process management requirements are met for assigned request in all my DB areas. This includes weekly status reporting, maintaining teh project work plan, ensuring Sharepoint lists are up to date (issues, risks, and deliverable acceptance), time reports for assigned resources are accurate and submitted on time, and project time tracking is completed per program guidelines.
- Obtain customer acceptance on teh deliverables
Confidential
Lead DB2 DBA on z/OS
Responsibilities:
- Leading a team of 3 DBA’s.
- Maintain all DB2 related relation objects, including, Databases, tablespaces, indexes, tables, views, alias, plans, packages etc,
- Migrate databases across subsystems to create working environments for development, test and production
- Collaborate with programmers to resolve any test and production problems/issues.
- Datamodelling using ERWIN Tool.
- Knowledge in Visual Explain Tool.
- Monitoring and scheduling jobs in CA - PLATINUM tool.
- Monitoring and analyzing teh space report for teh databases.
- Repartitioning teh tablespace every year.
- Estimating teh space requirement for teh new databases.
- Mentoring new DBA’s.
Confidential
DB2 DBA on z/OS
Responsibilities:
- Migrate databases across subsystems to create working environments for development, test and production
- Collaborate with programmers to resolve any test and production problems/issues.
- Setup and managing multiple test and staging environments.
- Plan and Manage User Acceptance Testing and Functional Testing and Operations Acceptance Testing.
- Manage teh DB2 DBA tasks to provide consistent performance improvements in teh applications byincorporating tasks such as Runstats, Reorg, Repartitioning & Image copies.
- Maintaining DB2 related objects.
- Designing new databases as per customer requirement.
- Familiar in Computer Associates- ERWIN Tool.
- Knowledge in Visual Explain Tool.
Confidential
DB2 Administrator.
Responsibilities:
- Good in REORG, RUNSTAT, LOAD, UNLOAD, RECOVER, COPY, MERGECOPY, QUIESCE, REPAIR and other utilities.
- Controlling access to DB2 objects.
- Refreshing tables & Databases.
- Recovery of Dropped Objects using Stand-alone utility DSN1COPY.
- Resetting pending status.
- Using Performance Monitor to monitor threads & Kill teh jobs.
- Scheduling jobs in Tivoli OPC Scheduler.
- Knowledge in OMEGAMON.
- Client: AIR CANADA & IBM - CANADA
- Worked in IBM, Montreal (Canada) for 1 month for KT.
Confidential
DB2 DBA on OS/390.
Responsibilities:
- Conducted extensive DBA administration training.
- Preparing & maintaining documents like PDDS, ICP, and DEMP for IBM.
- Good in REORG, RUNSTAT, LOAD, UNLOAD, RECOVER, COPY, MERGECOPY, QUIESCE, REPAIR and other utilities.
- Controlling access to DB2 objects.
- Refreshing tables & Databases.
- Recovery of Dropped Objects using Stand-alone utility DSN1COPY.
- Resetting pending status using Check data Utility.
- Using Performance Monitor to monitor threads & Kill teh jobs.
- Using DB2 Administration tool & QMF.
- Client: Sure bridge, USA (Offshore Support)
DB2 DBA
Confidential
Responsibilities:
- SQR Migration.
- Project migration.
- Production data change.
- Applying Tax updates.
- Applying Patches & Fixes.
- People Tools upgrade.
- Working on REORG, RUNSTAT, LOAD, UNLOAD, RECOVER, COPY, MERGECOPY, QUIESCE, REPAIR utilities.
Confidential
DB2 DBA on OS/390
Responsibilities:
- Creation and administration of storage groups, databases and table spaces.
- Good in REORG, RUNSTAT, LOAD, UNLOAD, RECOVER, COPY, MERGECOPY, QUIESCE, REPAIR and other utilities.
- Backup and recovery of table spaces.
- Re-organizing table spaces.
- Controlling access to DB2 objects.
- Technical support for application development team.
- Recovery of Dropped Objects using Stand alone utility.
- Loading table spaces.
- Resetting pending status using Check data Utility.
- Identifying teh changes and enhancements in COBOL Programs.
Senior System Analyst
Confidential
Key Responsibilities:
- Designed Database using SQL/400 in DB2/400.
- Writing Stored procedures in DB2 /400 for Backend process.
- Supporting Software Engineers in teh Systems Development Lifecycle.
- Reviewing, recommending and Implementing Database changes.
- Writing Stored Procedures and Triggers
- Design and develop different modules like registration, presentation, payment, messaging, disbursement, etc.
- Develop Upload Program to handles various file formats like XML, CSV, etc, and upload teh data according to biller specification.
- Database Backups and Recovery (using VERITAS TOOL)
- Exporting and importing data from SQL Server.
- Reviewing, recommending and Implementing Database changes.
- Exporting & Importing data’s from SQL Server
- Database Backup’s and Recovery
- Development of CRM Engine to manage all teh customers subscribed to different Services like Call direct, Voice Direct, Callback, Fax Direct, etc.
- Create Audit trail files to log all changes made to customer records by CSR’s and generate reports on this audit.
- Developed Online Real-time Billing for customers mostly by backend stored procedures and triggers.
Environment: ASP, SQLServer, Visual Basic 6.0, Java, DB2/400, SQL/400
Confidential
Software engineer
Key Responsibilities:
- Developing teh applications using Microsoft technologies.
- Creating Databases.
- Implementing teh changes as per Customer request.
Environment:ASP, SQLServer, Visual Basic 6.0, Java
Software Engineer
Confidential
Key Responsibilities
- Developing applications using RPG/400 on AS/400 systems
- Administrating teh DB2/400 database.
- Creating stored procedures on DB2/400.
- Present and defend product designs and architecture to clients
- Work with QA to create test scripts and scenarios for enhancements and customizations to teh core product
- Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee teh acceptance and dissemination process
Environment:Java, AS/400, RPG/400, DB2/400.
Confidential
Software Engineer
Key Responsibilities
- Developing teh applications using Microsoft technologies.
- Creating Databases Using SQL Server.
- Implementing teh changes as per Customer request.
Environment:ASP, SQLServer, Visual Basic 6.0.