SUMMARY

• Around 7 years of experience using DB2 LUW, Teradata, Erwin, Informatica and data warehousing experience in teh areas of data administration, physical database design, system architecture, database performance tuning, and ETL design and development.
• Expert knowledge converting logical data models into physical database designs using IBM Data Architect, Erwin, system implementation, performance tuning, and support.
• High availability (HA) and disaster recovery (DR) experience with DB2 HADR, offline transaction log shipping, data replication.
• Skilled in large - scale multi terabyte initial database load and ongoing update techniques, backup and recovery requirements, SQL, etc.
• Database utility experience including reorg, runstats, rebind, export, import, load, auto-load, backup, restore and recover database utilities.
• Hands on experience with IBM MVS Mainframe environment using JCL, TSO and ISPF.
• Expertise in development support activities including installation, configuration and successful deployment of changes across all environments
• Knowledge in Informatica, Datastage ETL tool and UNIX Shell scripting.
• Experience in Data Modeling using Dimensional Data Modeling techniques like Star Schema Modeling, Snowflake Modeling.
• Expertise in collecting, analyzing and performing system level tuning of databases.
• Strong experience in SQL, PL/SQL, Procedures, Functions, Triggers.
• DB2 system, instance, and database security and auditing experience using table definitions, triggers, data replication, and automated monitoring and alerting of security events recorded by teh DB2 Audit Facility.
• Extensively worked with OLAP tools such as Business Objects 6.5 and Cognos
• Experience in providing production support to various ETL jobs and developing various UNIX shell wrappers to run database jobs.
• Demonstrated ability in grasping new concepts (Both Technical & Business) and utilized as needed.
• Excellent communication, interpersonal skills and has a strong ability to work as part of a team and as well as handle independent responsibilities.

TECHNICAL SKILLS

Operating System: Unix, Windows and MVS

Databases: DB2LUW, Teradata, Oracle and SqlServer

Languages: SQL, JCL, Shell Scripting, C, C++

Tools: & Utilities: SQL Assistant, Business Objects, IDA, Data Studio, IBM Data studio, db2top, db2fodc, db2dart, db2mon, db2pd, db2expln, db2exfmt, db2trc, db2mtrk, db2diag, BTEQ, FastLoad, MultiLoad, TPT, Arcmain, Teradata Administrator, PMON, Teradata Manager, NetBackup, NetVault, nmon, top, topas, vmstat.

PROFESSIONAL EXPERIENCE

Confidential, Menands, NY

Sr. DB Administrator

Responsibilities:

• Involved in developing conceptual, Logical and Physical Data Model for Plan Management, Eligibility & Enrollment and SHOP modules using IBM InforSphere Data Architect.
• Extensive experience in execution of utilities & tools such as LOAD, EXPORT, REORG, REORGCHK, RUNSTATS, db2advis, db2expln, Data Studio, Optim performance Manager.
• Analyze complex and long running SQL queries using Visual explain and optimize them using Design advisor and other tools.
• Performed DB2 LUW Database backup and recovery with online full and incremental backups, online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.
• Involved in recommending db2 dbm and db configuration settings to improve performance.
• Involved in capacity planning and storage recommendations to support 24/7 shop.
• Maintain and Tune NYHBE Production and Development systems. Supported application development time lines by implementing designs as well as incremental changes to database definition in a timely manner into production and non-production systems.
• Involved Creating and maintaining database objects like Schemas, tables, tablespaces, Storage groups, views, Stored Procs, MQTs, Indexes etc
• Developed shell scripts to capture benchmarks for performance of database. Captured and maintained capacity planning reports including CPU, MEMORY, me/O, Disk Space, and Projected utilization based on future business requirements.
• Developed NYHBE database security strategy to provide access to large number of users in production environment.
• Involved in Converting hCentive MySql database to DB2 LUW.
• Involved in developing database naming standards, DBA operational guide for NY-HBE DB.
• Performed and monitored deployments to Prod and Non-Prod Environments.
• Involved in upgrading DB2 servers to latest fix pack levels, migrating servers, instances, and databases to DB2 v10.1.
• Implementing DB2 high availability disaster recover (HADR) across data centers.
• Involved in implementing DB2 STT (system-period time temporal tables) to capture historical data.
• Involved in weekly, monthly and Annual Reports design and development using IBM Cognos.
• Involved in meetings to gather information and requirements from teh clients and created mappings for eMedNY Data Warehouse.
• Involved in Data Modeling using Erwin Data Modeling tool.
• Implemented access rights mechanism using restricted views, macros and roles
• Manage and monitor TD databases using Teradata Manager & Teradata Administrator.
• Creating and modifying Teradata objects like Databases, Users, Profiles, Roles, Tables, Views, Indexes, Macros, and Stored Procedures etc.
• Space management including PERM, TEMP and SPOOL space for teh users and databases. Calculating teh capacity and forecast teh space proactively.
• Monitor and maintain a production Teradata database environment, including runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities.
• Create various cntllibs, Proclibs, Jcllibs programs and datasets in mainframe TSO ISPF 6.0.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Involved in detail design documentation as per teh client requirements.
• Provide 24/7 & 365 production Teradata System’s troubleshooting support

Environment: DB2 LUW 9.7, 10.1, Teradata V2R6, SQL, Erwin, IDA 8.1, BTEQ, db2top, Fast Export, Multi Load, Fast load, TPT, Visual Explain, NetVault: Backup 7.4, Symantec Backup Exec 12.5, Oracle 10g, Sql Server, Unix and MVS mainframes

Confidential, Omaha, NE

Sr. Teradata Developer

Responsibilities:

• Involved in meetings to gather information and requirements from teh clients.
• Converting Logical models into physical models using data modeling software like Erwin.
• Involved in Designing teh ETL process to Extract translate and load data from OLTP Oracle database system to Teradata data warehouse.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching teh business requirements to Teradata RDBMS.
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart
• Developed scripts to load high volume data into empty tables using FastLoad utility.
• Used FastExport utility to extract large volumes of data at high speed from Teradata RDBMS.
• Created series of Macros for various applications in TERADATA SQL Assistant.
• Performance tuning for TERADATA SQL statements using Teradata EXPLAIN command.
• Creating Mainframe datasets, submitting JCL, check teh dataset files using File-Aid.
• Created Fast Load, Fast Export, Multi Load, TPUMP, BTEQ to load data from Oracle database and Flat files.
• Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into teh data mart.
• Used Informatica debugging techniques to debug teh mappings and used session log files and bad files to trace errors occurred while loading.
• Responsible for trouble shooting, identifying and resolving data problems, Worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Converting existing Oracle/SQL Server data into Teradata.
• Gather information from different data warehouse systems and loaded into warehouse using Fast Load, Fast Export, Multi Load, BTEQ, Teradata parallel transporter (TPT) and UNIX shell scripts.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Involved in 24x7 production support

Environment: Environment: Teradata V2R6/TD12, SQL, Erwin, BTEQ, Fast Export, Multi Load, Fast Load, TPT, TPUMP, SQL Assistant, QueryMan, Teradata Manager, Teradata Query Manager, Teradata Performance Monitor, Teradata Administrator, Informatica Power Center 7.1, Unix and MVS Mainframes

Confidential, Overland Park, KS

Teradata Developer

Responsibilities:

• Involved in meetings to gather information and requirements from teh clients.
• Involved in Designing teh ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Sorted teh Extraction from heterogeneous source systems, like Oracle, Teradata internal and external flat files and building of teh Transformations and Loading formatted data into teh Multi-file and Serial files during teh intermediate and teh final stages of teh processes (ETL) using Informatica.
• Technical expert in teh areas of relational database logical design, physical design, and performance tuning of teh RDBMS.
• Extensive knowledge in writing Unix shell scripts and experience in Data Warehousing concepts and Data modeling
• Creating Mainframe datasets, submitting JCL, check teh dataset files using File-Aid.
• Perform tuning and optimization of database configuration and application SQL, Define database backup & recovery strategies, implement and administer. Create and Maintain users for Production/Development Teradata Systems.
• Extensively used ETL to load data from Oracle database and Flat files.
• Responsible for trouble shooting, identifying and resolving data problems, Worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.
• Created Fast Load, Fast Export, Multi Load, TPUMP, BTEQ scripts for One Confidential Financial Information System.
• Converting existing Oracle/SQL Server data into Teradata.
• Gather information from different data warehouse systems and loaded into One Confidential Financial Information System Consolidated model using Fast Load, Fast Export, Multi Load, BTEQ, TPT and UNIX shell scripts.
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Involved in 24x7 production support

Environment: Teradata V2R5/V2R6, SQL, Erwin, BTEQ, Fast Export, Multi Load, Fast Load, TPUMP, SQL Assistant, QueryMan, Teradata Manager, Teradata Query Manager, Teradata Performance Monitor, Teradata Administrator, Unix and MVS Mainframes

Confidential, Wellesley, MA

Teradata Developer/DBA

Responsibilities:

• Involved in meetings to gather information and requirements from teh clients.
• Monitor and maintain a production Teradata database environment, including runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities.
• Technical expert in teh areas of relational database logical design, physical design, and performance tuning of teh RDBMS.
• Perform tuning and optimization of database configuration and application SQL Define database backup & recovery strategies, implement and administer. Create and Maintain users for Production/Development Teradata Systems.
• Created Fast Load, Fast Export, Multi Load, Tpump, BTEQ scripts.
• Dynamically set query priorities using Teradata scheduler. Capacity Planning: Re-size storage and spool space proactively, to accommodate growing data content.
• Involved in converting existing Oracle data into Teradata.
• Involved in production support

Environment: Teradata V2R5/V2R6, SQL, Erwin, BTEQ, Fast Export, Multi Load, Fast Load, TPUMP, SQL Assistant, QueryMan, Teradata Manager, Teradata Query Manager, Teradata Performance Monitor, Teradata Administrator, Informatica, Unix and MVS Mainframes.