SUMMARY

• 9 years of IT experience in Database Administration of Oracle (8i/9i/10g/11g), DB2 UDB (8.1/9.X/10.1/10.5) EE/AESE/ESE EEE, DPF DB2 systems and Postgres Plus Advanced server 9.2 which includes designing, developing, deploying, managing and tuning of databases on SUN Solaris, Linux, AIX, HP - UX and Windows operating systems.
• Responsible for both managing and supporting all Production, Development and Staging instances.
• Experience in full software development life cycle (SDLC) of database administration.
• Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning, Fix pack’s and software upgrades on both OLTP and Data warehouse environment.
• Developed logical and physical data models using Erwin.
• Expertise in the high availability and disaster recovery features such as HADR (Automatic failover using TSA) and Power HA (HACMP).
• Extensive experience designing and implementing backup and recovery strategy for disaster management using the conventional Hot/Cold Backups and using TSM, Oracle RMAN, NetBackup & EMC
• Experience in SQL replication and Q replication.
• Expert in writing Shell Scripts for database monitoring scripts.
• Experience in administration tools like Control center, IBM Data studio, Toad, Quest central and also Command line processor.
• Good exposure to Purescale & PDTX environment.
• Expert in Real Application Cluster (RAC) environment with Auto Storage Management (ASM) and Oracle DATAGUARD.
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import, Datapump and Flashback Technologies.
• Experience on Streaming replication for WARM and HOT standby in Postgres.
• Experience with Database SQL tuning and query optimization tools like TKPROF, SQL Trace, Autotrace, Explain Plan, and STATSPACK.
• Troubleshoot Database performance issues in Oracle using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Expert in Cloning /Mirroring of databases across different platforms.
• Strong skill in SQL, PL/SQL packages, function, stored procedure, triggers, Materialized view, to implement business logics of oracle database
• Managing Security, User groups and Users by using roles, grants, privileges and profiles.

TECHNICAL SKILLS

Databases: DB2 UDB 9.5/ 9.7/10.1/10.5 , Oracle 8i/9i/10g/11g, RACSQL Server 2005/2008/20012 , PostgreSQL Plus Advanced server 9.2

Operating System: Red Hat Linux 3.x,4.x,5.x,6.x AIX 4.3.3,5.1,5.2, Sun Solaris 5.6,5.7,5.8,5.9,5.10, HP-UX 10.x,11.x,Ms-Dos, Windows / 2000/2003/2008/20012 R2, XP, UNIX.

Database Tools: Toad, Sql Developer, Postgres Enterprise Manager, IBM Data studio, SQL Server Management studio, MS SQL server Visual explain, Erwin, QUEST, BMC Tools, SQL*PLUS, SQL*Loader, SQL*NET, netasst

DB Utilities: EXP, IMP, EXPDP, IMPDP, RMAN, SQL*LOADER, OEM, TOAD, db2top, db2fodc, db2dart, db2mon, db2batch, db2pd, db2expln, db2exfmt, db2trc, db2mtrk, db2diag, nmon analyzer, TSM

Languages: Shell Scripting, Perl Scripting, AWK, SED, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Oracle DB2 UDB

Responsibilities:

• Installation & Configuration of DB2 UDB 9.7/10.1/10.5 and upgrade from DB2 UDB 9.7 to 10.1 and 10.1 to 10.5 on RHEL 6.5 and applied Fix packs as and when required.
• Installation, administration and 24/7 production support for OLTP and Data warehousing databases.
• Define Holistic Monitoring Requirements, Generated Runbook documentation and performed 24x7 production performance monitoring/alerting and on call support.
• Implemented and configured FIPS using SSL for DB2.
• Implemented db2audit for auditing instance and databases. Wrote shell script to automate archiving the audit files and loading into audit tables
• Installed & configured TSA and implemented HADR with automatic failover using TSA.
• Created NFS shared directory to handle load commands in HADR along with copy yes.
• Automated Daily PROD to STG database refresh using REDIRECT RESTORE in HADR environment.
• Wrote shell scripts and automated health checks, HADR monitoring, backups, transaction logs monitoring, long running queries/top sql’s, OS resource utilization
• Migration of databases from Oracle 10g to UDB DB2 9.7 using IBM DB2 MTK tool kit
• Migration of from Windows UDB DB2 9.7 to Linux UDB DB2 9.7.
• Generating Data dictionary from logical and physical data model using ERWIN and modify the comments, physical name, logical name using bulk editor feature as per client requirement.
• Setting up multiple new environments as per development and migration need.
• Extensively used different Data movement utilities like IMPORT, EXPORT and LOAD utilities to load data.
• Implemented SQL-replication and Q-replication for reporting databases purpose.
• Automated Performing Reorgchk, Reorg, Runstats and rebind as and when necessary to eliminate the defragmentation.
• Worked with IBM on several PMR’s to troubleshoot and resolve critical issues.
• Monitor CPU, Memory, Paging space, Disk I/O and analyze those using top, nmon and other tools.
• Designed and implemented backup and restore procedures, operations, maintenance and technical documents.
• Implemented capacity planning and provided Archive/Purge solutions using Range partitioning for very large and fast growing tables.
• Monitored databases using database monitors, snapshot monitoring and event monitoring. Generated reports of database structure using DB2LOOK.
• Worked with developers in writing stored procedures, triggers and functions.
• Performing Backup/Recovery of all the DB2 & Oracle databases and purging them after retention period.
• Monitoring the Diag logs, Alert Logs and User Trace Files for improving database performance and detecting any suspicious activities.
• Provided Instance/Database/OS level tuning as well as Application Improvement recommendation.
• Interacted with oracle PL/SQL developers in developing efficient applications
• Generation of various reports (AWR, ADDM, ASH) and using them for tuning the ORACLE database.
• Worked on Oracle Grid Control Environment to monitor and Administer Oracle databases.
• Performed Deployment & data fixes across multiple environments in Postgres EnterpriseDB.
• Troubleshooting of WAL replication issues and managed streaming replication between primary and WARM/HOT standby.
• Replication/Cloning of databases to create new environments in Postgres EnterpriseDB.
• Monitoring servers, applications, and network using xymon for Postgres EnterpriseDB.
• Monitoring of Database health and database server utilization with Postgres Enterprise Manager.

Environment: DB 2 9.7/10.1/10.5 , HADR, Purescale, Oracle 9i/10g/11g, Postgres plus Advanced Enterprise server 9.2, Red Hat Enterprise Linux 5,6.5, ASM, OEM (Grid Control), RMAN, Data Guard, Explain Plan, PL/SQL, Data Pump, Windows 2008/2012, MS SQL Server 2008/20012.

Confidential, Durham, NC

DB2 UDB DBA/Oracle DBA

Responsibilities:

• Created and configured the new instances/databases and as well as all the objects (tablespaces, tables, views, indexes, triggers, store procedures, etc.) and assigning proper authorities for the DB2 and ORACLE databases.
• Migrated DB2 version to 9.7 from version 9.5 as well as migrated DB2 databases from Solaris to Linux OS.
• Migrating 20+ databases (11gR2, 10gR2, R1, 9i, 8i) from Legacy environment to Oracle 10g R2 using Export/Import, SQL Loader, Database links, Data pump based on their business rules and migrated from 10g to 11g.
• Defined DBMS Physical Design Standards (File system design, tablespaces, instances)
• Defined DBMS Configuration and Infrastructure Standards.
• SQL tuning, instance tuning and database tuning on DB2 and ORACLE.
• Closely interacted with the Data modeler and business analyst for getting the ER- Diagrams and business rules and involved in Designing logical and physical Data Models using ERWIN.
• Migrated RDBMS instance to ASM instance with normal redundancy.
• Setting up HADR environment for DB2 and Oracle Data Guard for Oracle database for High Availability.
• Wrote Shell Scripts to automate the Data Loading process and for automation of various Database-Monitoring activities.
• Worked on Cloning, Replication and Mirroring of Databases.
• Worked with developers in writing stored procedures, triggers and functions.
• Converted and Loaded data from MS Excel and MS access to Relation database ORACLE.
• Performing Backup/Recovery of all the DB2 & Oracle databases using TSM & RMAN, also setup RMAN catalog for the same and Oracle Enterprise Manager (OEM) for various maintenance tasks like backing up of database, restoration and recovery of database
• Migrated database in cross platform environment like SQL Server, MS ACCESS to Oracle.
• Support and Performance Tuning of Oracle Real Application Clusters (RAC) which is 2 node cluster using ASM as storage Performed capacity planning and sizing of databases based on input from business.
• Production Support and Database Monitoring for performance of Databases.
• Monitoring the db2diag logs, Alert Logs and User Trace Files for improving database performance and detecting any suspicious activities.
• Tuning database server and application logic for performance improvement by using Explain Plan and TKPROF.
• Interacted with oracle PL/SQL developers in developing efficient applications
• Generation of the AWR (Automatic Workload Repository) Reports, ADDM (Automatic Database Diagnostics Monitor), ASH (Active Session History) and using them for tuning the database.
• Worked on Oracle Grid Control Environment.

Environment: Oracle 9i/10g/11g, DB 2 9.1/9.5/9.7 , Red Hat Enterprise Linux 4/5, ASM, AIX 5.3, OEM (Grid Control), RMAN, Data Guard, Explain Plan, Metalink, PL/SQL, Data Pump, Sun Solaris 5.10, windows 2003, MS SQL Server 2005.

Confidential, Columbus, OH

DB2 UDB DBA

Responsibilities:

• Data Modelling Tool Erwin used for Logical and Physical Database design.
• Performed upgrade from DB2 V9.5 IWEE to 9.7.
• Managed 1.5 TB per partition databases.
• Design and creation of database and database objects. Creating groups, users & giving privileges
• Giving authorities (SYSADM, SYSCTRL, and SYSMAINT) by updating the DBM and granting DBADM (maintaining database level security).
• Setting up & updating the environment variables, command options.
• Running scripts & creating user defined data types.
• Monitored database performance using Kornshell scripts and scheduling using Crontab
• Setting up a High Availability Disaster Recovery system (HADR). Maintaining and monitoring DATABASE REPLICATION periodically
• Running utilities like Copy, Load, Import, Export, REORG, RUNSTATS, Rebind, REORGCHK and Setting constraints (Check pending).
• Creating table spaces for DMS and SMS.
• Taking offline and online backups for Databases and table spaces.
• Restoring database backups into exiting database or creating new Databases with database backups.
• Creating EXPLAIN tables and running the visual explain utility on SQL statements.
• Database monitoring and tuning through snapshot and event monitors.
• UDB DB2 ESE V9.1 installation on AIX
• 24*7 Production support Configured the UDB ESE V9.1(with required fix packs)
• Designed, created and loaded the databases.
• Loaded the data using LOAD and db2split utility (for a database on UDB DB2 ESE) creating event monitors, analyzing the event monitor data for effective database tuning.
• Designed, implemented, and documented the DATAMART using OLAP integration server and Erwin.
• Automated the backups (Both Hot and Cold), Reorgs, Runstats, Space monitoring, moving the db2diag.logs, monitoring the size of the table spaces by setting up a threshold (70%) etc.,

ENVIRONMENT: UDB DB2 V 9.1/9.x ESE, IWEE, LINUX, AIX 5L 5.3, Windows NT, BMC Query Patroller, Quest System Catalog Views and Erwin

Confidential, Philadelphia, PA

DB2 UDB DBA

Responsibilities:

• Installed UDB DB2 EE/EEE on AIX and Windows NT including DB2 connect.
• Provided 24x7 On Call Production Support.
• Involved in software upgrade from DB2 8.1 to DB2 9.1(with required fix packs)
• Creation and Administration of databases.
• Database Monitoring and Tuning.
• Involved in supporting and maintaining DB2 databases for applications on AIX, and Sun Solaris
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.logs, monitoring size of table spaces by setting up a threshold (70%).
• Experience in data modeling using Rational Data Modeler, Erwin and ER Studio.
• Designed physical, logical layout and procedures for production, development, and testing quality servers.
• Did database Backup/Recovery on central database and file system backups.
• Automated administrative jobs using Script Center and Journal.
• Import and Export of data.
• Granting various authorizations to different users and groups.
• Security of the Database.
• Involved & Troubleshooting in Data Propagation.
• Data maintenance (Runstats, Reorgchk, Reorg and Bind)
• Performance tuning & Query optimization.
• Loading and Unloading of data.
• Controlling accesses, creation and alter database objects.
• Creating the database setting privileges, user logins, passwords (security)
• Performs high-speed bulk data unloads using BMC Patrol.
• Interacted with the customers and gathered the requirements and analyzed the data for the application.
• Installed and configured SQL SERVER 2000, Windows 2000 server NT and IIS.
• User Administration, Memory Management and Running DBCC for all SQL Servers.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for all the SQL Servers.
• Involved in Technical Documentation of the project.
• Created AIX Kornshell scripts to collect buffer pools and tablespaces utilization data on a regular basis to calculate DB2 UDB and system performance trends.