DB2 DBA Resume NY - Hire IT People

SUMMARY

7+ years of IT experience in Database Technologies with various banking sectors as DB2LUW and Teradata DBA.
Strong application development skills in RDBMS, SQL, business analysis and programming.
Ability to improve financial performance of firms using Accounting and Financial knowledge and team management skills.

TECHNICAL SKILLS

Languages: JAVA, J2EE, SQL, JCL, C, C++

Web: HTML, JSP, XHTML, JavaScript

Databases: DB2LUW, Teradata, Oracle, JDBC connectivity for JAVAHighlight Section Title

Mainframe Tools: REXX, File - Aid, Omegamon, Changeman, CA-7, VSAM, ISAM

ETL tools: Informatica Power Center v7

Operating System: OS/390, z/OS, VM, Windows, Unix, Linux

Other: Microsoft Office

PROFESSIONAL EXPERIENCE

DB2 DBA

Confidential, NY

Responsibilities:

Conceptualized and authored courseware on DB2 and SQL optimization techniques.
Designed data warehouse architecture, data modeling & design including star schemas and data marts using data DB2 information integrator.
Creating Bufferpools and logical and Physical design of database storages using DMS/ SMS tablespaces across partitions in different page sizes.
Implemented numerous tasks with coordination and ease.
Performed backup and restore databases on DB2 and Oracle databases.
Tuned many DB2 tables and SQL queries for saving mainframe CPU.
Migrating and maintaining data with LOAD, EXPORT, IMPORT and DB2MOVE utilities.
Created db2 objects (tables, views, alias, indexes, and partitions), runstats, optimized queries and programs for better performance and running efficiently.
Successfully achieved a target of $10 million savings in optimizing DB2 version change.
Analyzed many key features in SQL and DB2 which saved many CPU seconds consumption for Mainframes.
Extensively used IBM/BMC/MVS utilities viz, SORT, IDCAMS, IEFBR14, LOAD PLUS, UNLOAD, IEBGENER etc.
Strong client relationship management skills.
Superior team building and troubleshooting skills with a proven record of success with flexibility, accuracy, speed and performance.

Environment: COBOL, DB2LUW, VB, DB2 stored procedures, SQL, Oracle, JCL, DB2 Connect, Mainframes, z/OS, UNIX, Linux.

DB2 & Teradata DBA

Confidential, FL

Responsibilities:

Trained experienced professionals and new hires on data warehouse techniques of Bank Of America
Developed key tools for automation of Teradata, SQL and Mainframe reports which saved more time in completing our daily tasks with ease.
Monitored periodic development and learning of new hires in the team.
Learned many technologies and cross trained all my teammates.
Configured and implemented multi-partitioned databases for DEV, UAT and PROD.
Planned, designed and implemented backup schedules and procedures of DB2, SQL and Oracle databases.
Developed test plan, executed test cases in integration and system test environments and documented test results.
Played a vital role in the formation of a strong team as our project was a new venture.
Actively tested more than 1000 production codes and ensured a 100% foolproof output.
Awarded best employer award for my contribution to the team and received appreciation from the client.
Design, development and execution of ETL process.
Creation and maintenance of JCL for disaster recovery.
Unloads, Loads, Recoveries, Check Data and Modify Recovery of the databases.
Maintenance and troubleshooting of DB2 and Oracle databases.
Database migration, capacity planning and ongoing performance monitoring, diagnosis and tuning.
Creation and deployment of DB2 mainframe databases to the windows server.
Migrated from DB2v8 for z/OS to DB2v9.1 for z/OS.
Creation and deployment of stored procedures.

Environment: JCL, COBOL, DB2LUW, z/OS, UNIX, Linux, SQL, Oracle, Mainframes