SUMMARY

• Over 17 years of Experience in IT industry, out of which 15 Years as Oracle (7.3/8.0/8i/9i/10g/11g/12c) and Sybase (SQL Server 11.9.2,12.5 ) DBA Primarily in Production and Development environment, played different roles like Data Architect, Production/Development DBA and Unix System Administrator.
• Oracle 9i & 8i & 8 Certified Professional (DBA).
• HP - UX Certified System administrator.
• Experience in Database design, Functional design, ERD and Physical Design
• Experience in working with Financial Institution, Railways & Telecommunication industry.
• Expertise in handling Very Large Database (VLDB) and OLTP environment.
• Administered databases sizing 10 GB to 15TB
• Worked in 24x7 production environment and provided on-call and day-to-day support.
• Experience in Installation, Configuration & re-configuration of Oracle and Sybase for Large Database on Unix O.S.
• Configured and Implemented backup/restore/recovery technology using Omniback II/ RMAN integration with Omniback.
• Involved in the following Database Administration activities:
• Creating and maintaining the Oracle database.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Planning Backup/Restoration Strategy for 24x7 operation support
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
• Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage.
• Experience in Oracle Enterprise Manager (OEM), Oracle Management Server (OMS) & DBA Studio.
• Experience in Programming skill using SQL*PLUS, PL/SQL, Unix Shell Scripts.
• Implementing 10g/11g/12c Grid control, installing agents on AIX and Linux servers.
• Implementing 10g RAC on RHEL4/Solaris 10 using ASM.
• Implementing 10g OID.
• Implementing ASM and RMAN.
• Install create and Maintain EBS 11i and cloning using Rapid clone and administrating concurrent managers.
• Installation and configuring of HP-UX 10.20/11.00 and Sybase 11.9.2.4
• Tuning of kernel, configuring the new devices
• Data Transfer using BCP IN /OUT Sybase utility .
• Creating Devices, Databases, Segments and database objects on raw partitions.
• Creating logins, adding users, adding aliases to databases and grant and revoke permissions to users on databases and objects.
• Installation of DBCCDB database for execution ‘dbcc checkstorage’ and storage of statistics in the database.
• Automation of DBCC commands such as checkalloc, checkdb, checkcatlog, update statistics and scheduling as cronjobs.
• Create scripts to monitor processes in Sybase and to highlight blocking processes.
• Creating sysmons reports on regular basis using shell script and cron jobs.
• Monitor the frequently used tables/procedures and check for correct index usage using show plan commands.
• Optimize queries by setting the trace flag 302/310, show plan and I/O statistics.
• Run Update statistics periodically to rebuild the data distribution pages and density table.
• Periodically rebuild the indexes on frequently updated and deleted tables to increase performance.
• Recompile the stored procedure when new index is created.
• Setting thresholds to Monitor data and log space.
• Maintaining multiple databases.
• Backup database and transaction log at regular intervals, Restore database and log in case of damage or failure, Use of dump devices to take full or incremental backups as required, Manage Backup Server, Diagnosis of problems and remove database suspect status due to damage.
• Monitor the error log on day-to-day bases for error messages generated from running dbcc commands that are scheduled.
• Sybase backup integration with OMNI .

TECHNICAL SKILLS

Operating Systems: AIX 5.3L,HP-Unix (10.2,11), Sun Solaris (2.7,2.8,2.10),Linux RHEL6, Windows NT/2000

RDBMS: Oracle 7.x/8.0/8i/9i/10g/11g/12c,EBS 11i Sybase 11.x/12.5,Mysql 5.1/5.6, MSSql Server 2000

Application Servers: Oracle 9i/10g application Server

Tools: Oracle Grid Control 12c/11g/10g,Oracle Internet Directory,Oracle Enterprise Manager (OEM), Oracle Management Server (OMS), DBA Studio, DBVerify, DBArtisan, UTLSTAT, Explain Plan, TKPROFLogminer, Pro*C, SQL*Loader,Import / Export, RMAN, Erwin, Oracle Developer 2000/6i,Oracle Designer 2000/6i,Oracle Ware Housebuilder,Informatica, Business Objects,Shell scripts, SQL, PL/SQL,Oracle Developer 2000/6i,SQL Server, Web Logic, VB

PROFESSIONAL EXPERIENCE

Confidential, Maryland, MD

DBA Manager

Responsibilities:

• Upgraded 11g to 12C on AIX/Linux platforms.
• Implemented Oracle Golden Gate Unidirectional for reporting purposes.
• Teradata User Administration/Backup and Restore.
• Copy objects across the schemas in Teradata.
• Backup & Recovery of Teradata Database using ABU.
• Mysql Installation / Upgrade, Administration, Monitoring and Backup & Recovery.
• Configuring RMAN backups for Development /staging databases using Veritas Net backup 6.0/7.0
• Configure/Maintain Data Guard for DR.
• Configure 12c Grid control for monitoring the DB and setting alerts.
• Applying Oracle CPU patches.
• Tuning PL SQL programs by using DBMS PROFILER/SQL Profiles and Sql Plan Management.
• Installed and configured Oracle Applications 11.5. for Dev, Test, UAT, and Prod instances.
• Created DR using Data guard for EBS 11i.
• Mysql database creation/Backup and restore operations.
• Monitoring Mysql databases with Mysql enterprise Monitoring.
• Tuning Mysql DB parameters to resolve performance issues.

Environment: AIX 7.1. SUSE 11.1, Oracle 11G/11i,Teradata 14.0,Mysql Enterprise 5.1/5.6, Websphere 7.0, Veritas 7.0, EMC DD Boost 5.4.2 Hardware: P740, IBM V7000 SAN,Teradata 670c,Exadata X3-2, EMC Data Domain 5.4.2.

Confidential

Oracle DBA

Responsibilities:

• Migrated 10g Grid Control to 11g from solaris to Suse Linux.
• Installed 11gR2 RAC on M9000 running 3.3 Sun Cluster.
• Upgrading 10gR2 RAC database to 11gR2 RAC.
• Monitoring and Maintaining 10g RAC on Sun Cluster 3.1.
• Configuring RMAN backups for RAC Production /Development /staging databases using Veritas Net backup 6.0/7.0
• Applying Oracle CPU patches.
• Apply CRS Bundle patches.
• Data Movement using Transportable Tablespaces.
• Tune block level parameters to reduce contention across the nodes.
• Verifying RMAN Backups, tune backups to keep backup duration under 5 hours.
• Tuning PL SQL programs by using DBMS PROFILER.
• Migrate RAC database to DMX 4.
• Tuning RAC instances using ASH,ADDM.
• Creating SQL profiles to tune sql queries.
• Install and configure EBS 11.5.
• Cloning EBS test environments using Rapid clone
• Monitoring OAM to monitor Apps tier.
• Supported Oracle APPS 11i with 11gR2 for day to day activities.

Environment: Solaris 10.Sun Cluster 3.1/3.3,Oracle Clusterware, Oracle 12c/11G/10G/9i,EBS 11i, Websphere 5.0.2, Net Backup 6.0/7.0 EMC DMX 3/4, Sun V240,M9000/M5000/M3000

Confidential, Virginia, VA

Systems Analyst

Responsibilities:

• Managing an offshore team of five DBA’s at Chennai and coordinating the regular DBA activities.
• Migration of database from 8.1.7.4 to 9.2.0.6.
• Applying Critical patch updates to all databases.
• Setting up and maintaining Standby by Instances for all the Production servers.
• Implemented Oracle 10G RAC (4 Node Cluster).
• Migration project of from 9.2.0.6 to 10.2.0.3.
• Monitoring growth of tables and estimating future space.
• Tuning of SQL statements and improving the response time of queries.
• Refresh the test database on need basis from the production database, for the purpose development and testing.
• Implemented Cold and Hot backup procedures Using RMAN for all Oracle databases.
• Automated administrative tasks using UNIX shell scripting.
• Configuring ASM and migrating database from ASM to File system and vice versa.
• Implementing Replication server for Sybase database.
• Refreshing the test and dev instances with Sybase Production data.

Environment: AIX 5.3L, Oracle 8i/9i/10G, Websphere 5.0.2, Informatica 7.x

Confidential, Atlanta

DBA Lead

Responsibilities:

• DBA Lead for a offshore team of 10 and coordination with onsite team in Atlanta,GA.
• Up-gradation of Oracle 8.1.6 server to Oracle 8.1.7.4 on Sun Solaris 5.8.
• Performing database administrative jobs using 10g Enterprise Manager.
• Implemented procedures for calculating database growth.
• Implemented database alerts.
• Identified and resolved the disk subsystem problems.
• Creation of data marts in production by calculating the volumetrics from test database.
• Monitor index growth in the data marts and implement pre and post session scripts in informatica to drop and re-create those indexes to improve the load performance.
• Resolved oracle performance issues involving disk I/O, CPU usage.
• Tuning of SQL statements and improving the response time of queries.
• Refresh the test database on need basis from the production database, for the purpose development and testing.
• Implemented Cold and Hot backup procedures for all Oracle databases
• Automated Backup procedures using UNIX shell scripting.
• Tuning the Application and Database using oracle utilities TKPROF and EXPLAN PLAN.
• Documentation & presentation of the project.
• Troubleshoot app.-related issues and supporting offshore team.
• Volumetric estimations for the creation of new tablespace for data marts.
• Performance tuning of loads at informatica level.
• Rectifying rollback segment errors by setting informatica parameters.

Environment: Sun OS 5.8, Oracle 8.1.7.4, BO’s WebI 2.7.2, Iplanet 6.0.2, Brio, Informatica.

Confidential

Sr. Customer Support Engineer

Responsibilities:

• Reducing severe lock contention on the server due to inappropriate usage of tempdb and indexes.
• Preventing Lock contentions due to use of cursors was reduced by declaring the cursors intent, replacing the or and in lists with union and union all clauses and by keeping cursors open across transactions.
• Contention in tempdb was caused due to frequent creating and dropping of permanent tables in tempdb and their indexes. Hence hash tables were created in the beginning of the procedures and dropping them was eliminated. This solved the contention over the system tables in tempdb.
• Also larger caches were configured and pool size of 16k was made use of to reduce physical I/O thus improving the response time of queries on tables with clustered indexes, which used table scans and returned a large range of values.
• All stored procedures critical to the application were performance tuned to speed up the selects, Inserts and updates.
• Prevention of locks from being held for a longer duration and the transaction log from getting suspended.
• Automated night backups for oracle databases.
• Configured Oracle gateway for Sybase for migration purpose.

Environment: HP-UX 10.20, 11.00, Sybase ASE 11.9.2.4, Oracle 8.1.7, 8.1.5, 8.1.6, Kenan Billing Application (Arbor OM/BP), Fraud Management System HP N class (RP 7400), L class (RP 5400), K class servers (K 9000), HP Storage Area Network (VA 7400), HP Sure Store Tape Library.

Confidential

Database Consultant

Environment: Sun Solaris 2.8,Oracle 8.1.7,Forms 6i,Report 6i,Windows 98

Responsibilities:

• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export / Import utilities).
• Sizing the database for future growth.
• Creation of Table spaces, Storage Allocation/De-allocation, Table/Index (with free list groups), Rollback Segments, Constraints, Roles & Privileges
• Maintaining a Test & Development Databases.
• Configuring RMAN on Sun Solaris
• Reorganization of the database to remove fragmentation.
• Tuning & Monitoring the Database Performance

Confidential

Responsibilities:

• Installed Oracle 7.3.4.
• Team Lead: Lead of team of 2 Jr DBA’s and 5 developers.
• Created Development, Test & Production Database.
• Designer: Involved in RDBMS design related issues either physical or the logical layout. Designed the Functional Hierarchy, ERD, Entity Relationship Model, created Physical Database, logical design using Erwin tool.. Performed analysis, design/development activities associated with maintenance and production support.
• Data Architect: Performed Disk layouts, capacity planning, sizing of Database objects and created Physical Database.
• Backup & Recovery: Developed & implemented Backup procedures.
• Updating the ERD and physical database to reflect the latest specification as per requirement of the project.
• Suggested the Audit & Archive process for implementation in the System.
• Development: Written Pl/SQL Packages, Procedures, Functions to implement Business Rules.
• Guiding Developers in tuning SQL, suggesting the proper method of coding and explaining the Database design.
• Mentoring Junior DBA/Developers.

Environment: Sun Solaris 2.5, Oracle 7.3.4,Developer 2000 Sun Ultra Server Enterprise 3000

Confidential

Analyst Programmer

Responsibilities:

• Designing screens for taking the inputs such as inventory, product and sales information and Setting Standards regarding the Materials.
• Involved in Coding of the System

Environment: Windows NT,Oracle 7.3,Developer 2000

Confidential

Environment: Windows NT,Oracle 7.3,Visual Basic 6.0

Responsibilities:

• Designing screens for taking the inputs such as employees information for the purpose f calculating salaries and retirement benefits
• Setting Standards regarding the Materials.
• Involved in Coding of the System