TECHNICAL SKILLS

Software: Oracle 7/8/8i/9i/10g/11g, IBM UDB/LUW DB2 EEE//ESE/AESE 6.x/7.x/8.x/9.x/10.x, Sybase 12.0,Oracle Grid, Data Guard, RAC11Rg, RMAN, MS SQL Server 2005, MS SQL Server 2008.

Scripting: Shell & Perl Scripting

Languages: SQL, PL/SQL, VB 6.0, XML, HTML, PHP, JSP, Java/Java scripts, C#

Operating Systems: MS DOS, Windows NT/2000/XP, Linux, VM Ware, RedHat Linux, HP - Unix, Sun Solaris 10

Hardware: IBM PC, Macintosh, Unix Hardware, Local Area Network (LAN), WAN

Tools: TOAD 10.5, Oracle Enterprise Manager,2.0/12, Erwin 7.0, Control Center, Command Center, CLP (Command Line Processor), Quest Central for UDB, Cognos 8.x, DataStage 8.x, Symantec i3,DBArtisan, Aqua data Studio, IBM Data Studio.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

LUW/UDB DB2 Database Administrator

Responsibilities:

• Installed and Configured UDB/LUWDB2 EE/ESE/AESE /9.x/10.x on Linux and Windows O/S
• Created UDB Databases (SMS & DMS) for Dev, UAT & PROD and created user accounts. Roles, privileges,
• Ran db2 utilities like runstats, reorg for tables to query improve performances. Done export/import
• Worked on monitoring, maintenance, patch upgrade, release management, issue/problem management,
• Worked on db2 backup and recovery strategies. Have an exposure to db2diag log file.
• Provided production support for critical applications running on 24/7 On-call basis.
• Created users, groups, roles, Schema, tables, views, stored proc, triggers and other DB objects.
• Installed, configured and monitored teh Postgress SQL database for a separate application.

Confidential, NY

LUW/UDB DB2 Database Administrator

Responsibilities:

• Working as Database Administrator for MDM(Master Data management) Project
• Installed and Configured UDB/LUWDB2 EE/ESE/AESE /9.x/10.x on Linux and Windows O/S
• Used Power Designer for Physical & Logical data modeling and Reverse Engineering
• Created UDB Databases (SMS & DMS) for Dev, UAT & PROD and created user accounts. Roles, privileges,
• Installed and configured IBM DB2 9.7/10.x and teh IBM Data Studio tool. Worked on HARD
• Resolved Data base connectivity issue for Linux/Unix client and Kerberos Connectivity
• Worked on monitoring, maintenance, patch upgrade, release management, issue/problem management,
• Worked on db2 backup and recovery strategies. Have an exposure to db2diag log file.
• Provided production support for critical applications running on 24/7 On-call basis.
• Created users, groups, roles, Schema, tables, views, stored proc, triggers and other DB objects.
• Generated different types of reports like user query, data analysis, performance, replication etc.,
• Created Buffer Pools, Indexes, MQT, Temporary Tables, Alias, Grants (select, insert, update, delete)
• Ran db2 utilities like runstats, reorg for tables to query improve performances. Done export/import
• Installed, configured, monitored and trouble shooted teh Postgress SQL database.
• me have done import/export, data refresh, Monitored transaction log, table space using db2top & db2pd tools
• Involved in database and query tuning, ran explain plan for long running queries and analyzed teh results
• Used snap shot monitor for locks, load, session etc, Have used db2pd and db2top tools for trouble shooting
• Used in house database tool “db2ts” for schema compare, import/export, to grant/revoke permission and T/O
• Have ran monitoring report to get teh threshold table spaces, data files, log file etc
• me have worked with infrastructure team to install and configure, DB server with instance, databases, deployed code into QA, UAT. Escalated critical issues with Infrastructure and Prod support team to resolve within SLA
• Worked on different level of support., Created ITSM tickets for issue/problem management Provided database support like monitoring different Autosys jobs, database scheduled jobs, etc.,

Confidential, NY

Database Administrator Lead

Responsibilities:

• Installed and Configured UDB/LUW DB2 EEE/ESE/AESE 6.x/7.x/8.x/9.x/10.x on Sun Solaris, Linux and Windows O/S
• Used Power Designer and Erwin for Physical & Logical data modeling and Reverse Engineering
• Created UDB Databases (SMS & DMS) for Dev, UAT & PROD, Created user accounts. Roles, privileges,
• Created and maintain database security (created & maintained users, group, roles, and grant privileges).
• Perform database tuning and performance monitoring. Performed Data Migration from UDB DB2 8.x to Oracle 9i DB.
• Extensive experience in DB2 client set-up. Created database triggers (Before & After Insert, Update, Delete) and stored Proc’s
• Created UDB Databases (SMS & DMS) for Dev, UAT & PROD, Created Backup and Recovery procedure. wrote Purge Shell Scripts - to Export/Archive/Delete records from set of tables for particular time slot
• Worked on Database Sizing information for UAT, Production and Dev databases.
• Performed Export/Import across different databases, wrote a conversion script to upload/download data between different Data bases (UDB/Oracle).
• Used Control Center, Script center, Quest Central tools for DB Administration, and SQL Visual Explain, Health Monitor, DB2TOP & DB2PD for Performance. Handled on experience in monitoring teh DB manager, databases, locks, applications, table spaces, active logs, and archive log using SNAPSHOT, and EVENT Monitors.
• Have used Database maintenance utilities using REORG, RUNSTATS, LOAD, UNLOAD, IMPORT, EXPORT, DB2LOOK, DB2MOVE, QUIESE etc. Exposure to DB2 HADR (High Availability Disaster Recovery). Wrote various SQL queries, scripts, triggers, stored procedures. Performed UDB Backups and recovery.
• Wrote scripts to automate & schedule teh maintenance jobs (REORG, RUNSTATS)
• Installation and Configuration of Oracle databases 11g, 10g, 9i, 8i on different O/S (Windows/Unix/Linux)
• Created and maintain database security (create and maintain users and roles, assign privileges).
• Involved in database Migration / Upgrade of 11g, 10g, 9i, and 8i.
• Handle Data Pump utility for teh high speed infrastructure data and metadata move
• Created DB Links and Materialized Views. Automated jobs using UNIX Shell scripts
• Worked with RMAN backup and recovery procedures and its operations
• Worked with development team in writing/assisting teh PL/SQL tuning using Query Plan for dynamic queries procedures and functions. Worked on Database Sizing information for UAT, Production and Dev databases.
• Used Power Designer and Erwin for Physical & Logical data modeling and Reverse Engineering
• Created user accounts, roles, and privileges. Created other database objects, rbs, tables, table spaces, and synonyms.
• Worked on Export/Import, Load data utilities and Cloning to move data between environments
• Worked on generate reports like SQLTRACE, TKPROOF, AWR/ADDM, STATSPACK for trouble shooting
• Support and work with Real Application Cluster RAC11g and ASM environment
• Developed Stored Proc/function/triggers/packages. Created Shell Scripts. Developed Purge/Archive Process
• Used SQL*Loader for Data conversion. Used Flashback recovery procedures for recover tables.
• Worked on Oracle Enterprise Manager (OEM), SQL analyzer and TOAD tools for monitoring
• Designed, developed, Implemented, teh automated Purge/Archive process
• Self-motivated, goal-oriented team player with excellent communication skills
• Provided technical expertise to development and deployment teams on integration/configuration of supporting infrastructure. Supported Unit, Integration, User Acceptance, Load, Performance and System testing efforts
• Created DB objects like tables, indexes, views, sequences, synonyms, table spaces, data files, user accounts, roles,
• Assisted different Build release management (INT, UAT, UXT, PROD) by running baseline comparison report using IBM clear case, extracted, deployed SQL scripts.
• Involved in Production Support, trouble shooting, maintain data base integrity, data base performance tuning.
• Provided production support for critical applications running on 24/7 On-call basis.
• Analyzed, designed, developed, Data Warehouse and Data Marts projects
• Exposure to Datastage (ETL tools) and Cognos 8.x (BI) while work on SLD WH
• Used Third party tools like Symantec i3, DBArtisan, Toad, Aqua data Studio and BMC
• Exposure to Online Analytical Processing (OLAP), DWH, DSS and OLTP environments.
• Experience in identifying Facts and Conformed Dimensions used in Data Mart.

Environment: Oracle 7/8/8i/9i/10g/11g, IBM UDB/LUW DB2 ESE/EEE 6.x/7.x/8.x/9.x, Shell, Perl

Confidential, Tampa, FL

Database administrator

Responsibilities:

• Installed and Configured UDB DB2 EEE 7.x/8.x on Sun Solaris and Windows O/S
• Performed Oracle Database backups. (Hot and Cold). Recovered databases using archived log files, Performed Data Migration from UDB DB2 7.x to Oracle 9i DB.
• Created and maintain database Security (create and maintain users and roles, assign privileges). Have strong analytical and troubleshooting skills. Created UDB Databases (SMS & DMS) for Dev, UAT & PROD,
• Created Backup and Recovery procedure. Performed UDB Backups. wrote Purge Shell Scripts - to Export/Archive/Delete records from set of tables for particular time slot
• Successfully restored teh database on Sun Solaris machine using Backup seed (which is from another machine) using Database build re-direct Mechanism Have used Database maintenance utilities using REORG, RUNSTATS, LOAD, UNLOAD, IMPORT, EXPORT, DB2LOOK, DB2MOVE, QUIESE etc. Wrote various SQL queries, scripts, triggers, stored procedures
• Created 250 database triggers (Before & After Insert, Update, Delete) and stored procedures.
• Performed Export/Import across different databases, wrote a conversion script to upload/download data between different Data bases (UDB/Oracle). Used Control Center, Script center, Quest Central tools for DB Administration, and SQL Visual Explain, Health Monitor for Performance Monitoring.