PROFESSIONAL SUMMARY:

• Over 8 years of experience providing full DB2 DBA supports on LUW and z/OS during application life cycle, including database change requests and business processes analysis
• Worked on database release changes and supported migration changes from test environments to pre - production and production environment
• Experience in problem analysis and troubleshooting database related issues.
• Provide performance tuning support to development teams in SQL Tuning and application monitoring
• Monitor CPU, Memory, Paging space, Disk I/O and analyze those using topas, nmon and other tools
• Installation of DB2 software and Fix Packs
• Creation of Instances and Databases
• Database maintenance activities like REORG, RUNSTATS, LOAD, IMPORT and EXPORT
• Created Database objects like Tables, Table spaces, Indexes, Views, and Aliases.
• Grant and Revoke access of database objects to users.
• Changing Instance level and Database level configuration parameters for database.
• Backup & Recovering Database, Online Database Backup, Offline Database Backup, Redirect restores.
• Full database recovery and roll forward recovery to end of logs for no transaction loss or to specific point in time recovery.
• Executing the Scripts, which are developed by Application team.
• Troubleshooting of FS related and Database related issues.
• Change Management like Change requests understanding, Analysis of Implementation, Impact analysis, Implementation, Feedback solutions.
• Excellent Interaction skills with proven experience in building Client Relationships.
• Knowledge in UNIX Shell Scripting for database prospective.
• Monitoring the schedule tasks using the control link Task scheduler.
• Excellent Communication, Logical and Problem Solving Skills with Quick Adaptability to environment.
• Worked with Automation of recovery process.
• Exposure to application development, maintenance and support.
• Highly adaptable in a changing technical environments and ready to accept the changes as per the organizational requirements.
• Experience with High Volumes of OLTP environments.
• Experience in working with mainframe Z/OS environment.
• Exposure to Buffer Pools BP4K0, BP16K0 and BP32K0 for space allocation of data.
• Having exposure to work in heterogeneous environments.
• Hardworking and committed with an unflinching and relentless dedication.
• Good analytical, problem solving skills, conceptual insight and a very good team player.
• Knowledge to work with Cloudant fully approach to database provisioning, configuring and maintenance.
• Cloudant databases can pick up and resume when they left off at the time of a replication job is interrupted.
• Knowledge to Work with Cloudant clustering and Quorum parameters.
• Exposure to work with batch jobs.
• Applied standard procedures to approve the user’s data.
• Knowledge with cloudant operators for turnoff and maintainence mode.
• Excellent customer service manner and able to build good relationships with the customers/clients.
• Ability to effectively interpret technical and business objectives and challenges, and articulate solutions.
• Ability to think abstractly and deal with ambiguous/under-defined problems.
• Demonstrated willingness to learn new technologies.
• Ability to work on own un-supervised and deliver on time to budget.
• Proven success as a professional technical worker in similar technical areas.
• Have broad knowledge and understanding of IT concepts and architectures with proven experience of successfully managing and maintaining IT services.
• Excellent Communication, Logical and Problem Solving Skills with Quick Adaptability to new environment.
• Exposure to application development, maintenance and support.
• Highly adaptable in a changing technical environments and ready to accept the changes as per the organizational requirements.

TECHNICAL SKILLS:

Languages: C, C++, Core Java Basics, C# Dot Net, JCL

Platforms: IBM AIX,Red hat / Suse Linux, OEL, Sun Solaris, HP-UX, Windows

Database: DB2 UDB LUW 9.7,10.1&10.5,Mainframe (z/OS)DB2 V8,V9,V10 and MYSQL

Technologies: HP QTP, IBM RFT, MATLAB, Mainframes

Tools: Toad (SQL), Data Studio 4.1.1, Putty, Quality Center v11, Service Center Simulink, AUTOCAD, MS Office, ATG Business Control Center, Commerce

WORK EXPERIENCE:

Confidential, Seattle, WA

DB2 DBA / LUW - z/OS

Responsibilities:

• DB2 LUW DBA Involved with monitoring, mentoring, tuning database and queries, and upgrading servers.
• Creating monitoring scripts. Got db2top to work with a db2 Windows server. Created method to extract hundreds (or more) select statements from cache to run controlled stress tests.
• Documented and performed health checks for numerous DB2 LUW databases
• Responsible for all aspects of DB2 support including installation, maintenance, configuration, performance/tuning, troubleshooting, and installation of DB2 and related software’s.
• On-call 24x7 Support for Production Environments for DB2 batch jobs and online regions.
• Experience in supporting multiple large scale development, QA and production database environments.
• Start and Stop Subsystems and Databases.
• Check for the currently running threads and cancel them if required
• Developing & maintaining naming standards for database objects such as table spaces, Tables, Indexes &Views.
• Working knowledge of DB2 data sharing/Parallel Sysplex.
• Proficiency with Main View, File Aid, Endevor and DB2 Administration Tool for z/OS is highly desirable.
• Participate in an IMS to DB2 conversion project for the Agency group.
• Preparation of jobs for Load and Unload utilities and its execution.
• Termination of utilities and maintaining the status of databases.
• Backup and Recovery of Table Spaces.
• IMS restores from production LPAR to test using DBRC.
• Database refresh from production to non-prod systems.
• Worked to increase the performance of the server by applying the performance tuning.
• Recover database as part of the Backup and Recovery procedures.
• Move database objects between physical structures.
• Creating storage group, database & different types of table-spaces for users.
• Cloning DDLs of DB2 objects for non-prod regions from production.
• Creating Plan & Packages and Granting BIND, EXECUTE PLAN Access.
• Setting authorization to the newly created databases.
• Using both On-line utilities & Stand-alone utilities.
• Experience with logical and physical database design.
• Controlling access to DB2 Objects like Grant, Revoke and Database.
• Increasing size of an active log datasets.
• Used various tools like DB2Move and Connecting and Disconnecting CICS and other services from DB2.
• Adding a new active log dataset to BSDS.
• Working with the Buffer Pools BP4K0, BP16K0 and BP32K0 for space allocation of data.
• Modifying DSNZPARM parameters.
• Having knowledge on SMPE stuff to upgrade DB2 related products as per the check list
• Working knowledge on utilities like DSNJU003, DSNJU004, DSNJLOGF & DSNJCNVB etc.
• Maintaining Active and Archive logs.
• Maintaining Boot strap dataset (BSDS), Bufferpools requirements.
• Ordering, customizing and applying DB2 preventative maintenance.
• Have worked in new DB2 Subsystem builds.
• Have knowledge on DB2 Installation/Migration jobs.

Environment: Hardware: z-Series Z196 & Z10 Operating System: z/OS 1.13 Software: JES2, TSO, JCL, ISPF, SDSF, SMF, RMF, SMS, DFSORT, RACF, DB2, CICS Tools: SMP/E, Ca7, CA-Solve, RC-update, CA-insight, QMF

Confidential, NYC, NY

DB2 DBA / z/OS

Responsibilities:

• Perform Online DB Maintenance - Alter space, perform Reorgs, Run Stats, Backup, Rebalance.
• Preparation and delivery of daily status to Onsite/Offshore.
• Start and Stop Subsystems and Databases.
• Designing & creating relational database objects such as tables, views & indexes.
• Check for the currently running threads and cancel them if required.
• Perform online and offline backups for both incremental and full copies depending on the application updates/inserts.
• Implement new database objects Modify existing objects, Drop database objects.
• Execute DCL, DDL, and DML on database objects using JCLs and SPUFI.
• Worked on IBM Utilities like COPY, MODIFY, REORG, RUNSTATS, QUIESCE, REBIND etc.
• Security audits which includes granting and revoking privileges, authority to users, plans & packages, collections.
• Supports and advises Mainframe developers with programming and database related issues.
• Managed a team responsible for the physical design for the conversion of 30 trade databases from VSAM to OSAM and implemented.
• Expertise in performance tuning of bad SQL's using BMC Apptune Refresh data from production to test environment on request from application team.
• Increasing size of an active log datasets.
• Documentation of best practices, procedures followed in the organization.
• On call on shift basis to attend problems in production, development and test region.
• Involved in many project releases in production, testing and development environments.
• Involved in migration activities from DB2 V8 to V10.
• To execute validation scripts to test new features of DB2 Version 10.
• Root cause analysis on the jobs running for long time.
• Solving Production On-calls on the job abends.
• Creating the maintenance jobs like MODIFY, COPY, REORG, RUNSTATS, QUIESCE and schedule them in Production through CA-7.
• Solving the change requests through BMC Remedy system for UAT and Production.
• Solving the change requests through Emails in UNIT and INTG.
• Full database recovery and roll forward recovery to end of logs or to specific point in time recovery.

Environment: MVS-Z/OS, Windows XP, BMC Change Manager, Catalog Manager, BMC Apptune, Endeavor, File-aid, CICS Manager, IBM Mainframe: Cobol, CICS, JCL, VSAM, SQL Database: DB2 Version 10

Confidential

DB2 UDB DBA / z/OS

Responsibilities:

• Database (DB2 UDB) maintenance and support.
• Created test environments for the new database and populated test databases with relevant data from various production files and databases
• Actively involved in designing and implementing database objects.
• Worked with data movement utilities IMPORT, LOAD, and EXPORT under high volume conditions.
• Daily and weekly database Maintenance activities such as backup, restore, reorgchk, reorg, run stats.
• Involved in granting various authorizations and privileges to different users
• Tuning of db and dbm configuration parameters and performance tuning the database for better and faster results.
• Taking snapshots and creating event monitors for gathering necessary data
• Use tools like db2advise, db2look, db2move and db2adult to monitor, analyse and make changes in the database.
• Handling problem tickets and meetings the SLA':s and performing the changes on weekend as per the customer requests.

Environment: DB2 UDB V8.x, RHEL 5.0, Putty

Confidential, Eagan, MN

DB2 DBA/LUW

Responsibilities:

• Administered DB2 subsystems in Prod, Test and Development regions.
• Participated in design review meetings, involved in logical design and in converting logical model into a physical database model.
• Analysed index requirements and designed appropriate indexes.
• Performed SQL tuning and bind plan/package creation for enhancements and developments
• Prepared test environments and performed data refresh.
• Designed, debugged and implemented stored procedures and triggers
• Identified problematic SQL and optimized SQL queries that helped improve application performance.
• Installed DB2 9.5 LUW for AIX and LINUX servers.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs.
• Performed data maintenance using LOAD,UNLOAD,REORG,RUNSTATS
• Performed tablespace recovery, data set recovery and transaction recovery under various circumstances.
• Used RECOVER in zOS and RESTORE REDIRECT in LUW for databases that needed it.
• Investigated advantages of DB2 9 zOS over 8 as well as DB2 9.7 LUW over 9.5.
• Extensive IMS and VSAM file structure experience.
• Involved in capacity planning and storage management along with the system administrator.
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.
• Monitored and managed DB2 thread and locking issues.
• Involved in granting various authorizations and privileges to different users.
• Proactively monitored and performed daily maintenance activities.
• Produced and analysed DB2 performance reports.
• Provided 24*7 support on rotation basis.

Environment: z/OS, LUW, DB2, Endevour, IBM utilities, VSAM, JCL, CA Log Analyzer, IBM Admin Tool.

Confidential, Chicago, IL

DB2 SQL PL Developer

Responsibilities:

• DB2 UDB EE Database development and support
• Altered tables and added check constraints and referential integrity
• Created and maintained Databases, Tablespaces, Tables, Views, Stored Procedures, Triggers and Indexes
• Interact with business team and development teams for incorporating new functionality
• Participated in enterprise-wide application and database production releases
• Developed shell scripts to handle DBA tasks and alerting systems
• Documented plans and procedures in terms of backups, restores and disaster recovery
• Checking the consistency of the databases using different db2 commands
• Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT.
• Tuning application queries, databases and systems for best performance
• Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots

Environment:: DB2 UDB V8.x, DB2 Connect, DB2/ZOS, SQL Server 2000, AIX, Windows 2000, WIN NT, Web Sphere, Java 1.2, .Net, JSDK 2.0, JDBC, JavaScript, Apache Web Server EJB (J2EE), XML.