SUMMARY

• A total of over 16 years of experience in the IT industry. Working experience includes
• Working experience in DB2 Database Administration on z/OS platform and DB2 LUW
• Knowledge in HADOOP & MONGODB As a DB2 Database administrator has a wide exposure in the 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 the DB2 tasks to provide consistent performance improvements in the 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 the 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 that the 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 the 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 the 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. DB2 Control center, Configuration Assistant, Command center,Replication center, CA platinum, CA - Erwin, Pig, HIVE, HBASE, Ganglia

Languages: JCL, RPGLE, and CL.

Transaction Processors: ISPF.

ERP: PeopleSoft

Database Systems: DB2 V7.1, DB2/400, SQL Server 7.0/2000 and Oracle 9i

Other Skills: ASP, COM, and VB 6.0, ASP.Net, PL/SQL, Java1.2, Java Applets, Java Servlets, Java Swing, JSP, AS/400, RPG/400,SQL/400,RLU, SDU, COM, DCOM, XML, Crystal reports.

Data modeling: CA-ERWIN

Performance tool: IBM Data Studio, TSO Main view

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Lead DB2 DBA

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 the DB2 utilities.
• Create and reviews all data models for technical accuracy. This includes the enforcement of all modeling and naming standards.
• Provide assistance for interfaces which access DB2.
• Analyze and correct problems that occur in the DB2. This includes nightly support for the 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 REORG, RUNSTATS,IMAGECOPY, CHECK DATA, RECOVERY
• 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 that the 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 the 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 the deliverables

Confidential

Lead DB2 DBA

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 the space report for the databases.
• Repartitioning the tablespace every year.
• Estimating the space requirement for the new databases.
• Mentoring new DBA’s.

Confidential

DB2 DBA

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 the DB2 DBA tasks to provide consistent performance improvements in the applications by incorporating 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 the jobs.
• Scheduling jobs in Tivoli OPC Scheduler.
• Knowledge in OMEGAMON.

Confidential

DB2 DBA

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 the jobs.
• Using DB2 Administration tool & QMF.

Confidential

DB2 DBA & People Soft Application DBA

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

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 the changes and enhancements in COBOL Programs.

Confidential

Senior System Analyst

Responsibilities:

• Designed Database using SQL/400 in DB2/400.
• Writing Stored procedures in DB2 /400 for Backend process.
• Supporting Software Engineers in the 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 the 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 the 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