SUMMARY

• Over Ten years of experience in Oracle and UDB DB2 Database Administration (DBA) in Windows, Solaris & Linux environment
• Experience wif all phases of Software Dev Life Cycle involving Systems Analysis, Design, Development, Testing and Implementation of projects.
• Expertise in working wif installation, configuration, Backup Recovery, Application support, Resource Management, User and Security Management
• Installed and configured Oracle 8i/9i/10g/11g DB’s on Windows & Linux/ Solaris
• Worked wif Data Guard and ASM configuration, operation, and monitoring.
• Experience in database Migration / Upgrade (11g, 10g, 9i, and 8i).
• Worked on database sizing information. Handle Data Pump utility for data move
• Support and work wif Real Application Cluster (RAC) environment
• Experience wif RMAN backup and recovery procedures and it’s operations
• Extensively worked wif development team in assisting the PL/SQL effectively using wif dynamic query, triggers, procedures and functions.
• Experience in Export/Import and Cloning to move data between environments
• Experience in generating reports like ASH/AWR/ADDM for trouble shooting
• Created and maintain database security (create and maintain users and roles, assign privileges). Perform database tuning and performance monitoring
• Experience in working wif Very large databases. (in terabyte databases)
• Performed database administration tasks required to support application devlpmnt, testing, deployment, Implement of patches, upgrades, migration and fixes.
• Created DB objects like tables, indexes, views, sequences, synonyms, table spaces, data files, user accounts, roles, Performed Import/ Export and load data utilities
• Performed SQL query performance tuning/optimization using explain plan, gathering statistics, index rebuilding. Performed Data Model using ER Studio and Erwin
• Developed Stored Proc/function/triggers/packages/ MViews/DB Links & Shell Scripts.
• Used SQL*Loader for Data conversion. Used Flashback recovery procedures.
• Performed Database backups. (Hot and Cold). Recovered db using archived log files
• Worked on Oracle Enterprise Manager (OEM) and TOAD tools for monitoring
• Designed, developed, Implemented, the automated Purge/Archive process
• Provided technical expertise to development and deployment teams on integration/configuration for supporting/testing (Unit/Sys/UAT/PROD)
• Assisted different Build release management (INT, UAT, UXT, PROD) by running baseline comparison report using IBM clear case/CQ, extract & deploy SQL scripts.
• Extensive experience in client set - up, installation and configuration of UDB DB2 on Unix and Windows servers. Migrating database from one version to another.
• Involved in Production Support, trouble shooting, maintain data base integrity, data base performance tuning. Experience in Data Modeling tools ERWIN.
• Developed and Documented the High-Level Database Procedures and Standards such as, Backup and Recovery, Physical and Logical Database Design.
• Installed and Configured UDB DB2 EEE 7.x/8.x/9.x on Sun Solaris/Linux/Windows
• Performed Data Migration from UDB DB2 8.x to Oracle 9i DB.
• Used Power Designer for Physical & Logical data modeling & Reverse Engineering.
• 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
• Successfully restored the database on Sun Solaris machine using Backup seed (which is from another machine) using Database build re-direct Mechanism
• Worked on Database Sizing information for UAT, Production and Dev databases.
• Created database triggers (Before & After Insert, Update, Delete) and stored Proc’s
• 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
• Have trained Users and IT Staff in Database Technologies. Hands on experience in monitoring the DB manager, databases, locks, applications, table spaces, active logs, 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.
• 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 to monitor our databases.
• Worked on Microsoft SQL Server 2008. Exposure to Online Analytical Processing (OLAP), DWH, DSS and OLTP environments.
• Experience in identifying Facts and Conformed Dimensions used in Data Mart.
• Experience in trouble shooting, problem determination and resolving breaks in the system connectivity and User connectivity. Monitored Database’s daily activities.
• Performed Capacity Planning, to work on Production and other Test Servers.
• Wrote scripts to automate & schedule the maintenance jobs (REORG, RUNSTATS)
• Self-motivated, goal-oriented team player wif excellent communication skills
• Provided production support for critical applications in 24/7 On-call basis.
• Performed a variety of duties and multi-tasks wif good communication skills, both verbal & written. Have strong analytical and troubleshooting skills

TECHNICAL SKILLS

Software: Oracle 7/8/8i/9i/10G/11i, IBM UDB DB2 EE/EEE 6.x/7.x/8.x/9.x, MS SQL Server 2005 - ‘08. Sybase 12.0, Power Designer 12.0. Data Guard, RAC,RMAN

Scripting: Shell & Perl Scripting, dos scripting

Languages: SQL, PL/SQL,VB 6.0, XML, HTML, PHP, JSP, Java/Java scripts, C# Transact/SQL, SQL Server DTS, Crystal Reports.

Operating Systems: MS DOS, Windows NT/2000/XP, Linux, HP-Unix, 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 Web Sphere 7.0. Crystal Reports.