SUMMARY

• Over 7 years of experience in IT industry in Designing, Administration, Implementation of Oracle 8i/9i/10g/11g Database on Unix/Linux/Solaris/Aix/Windows platform.
• Excellent Project management/Leader Ship skills. Ability to work effectively while working as a team member as well as individually.
• Primary areas of expertise include Administration and Implementation of Oracle8i, 9i, 10g and 11g, Performance Tuning (Database and Application), TOAD, Data Pump, Database Backup, DB - Auditing, DB-Cloning, Unix Shell Scripting, and expert in dealing with large volume of data and data migration.
• Good experience in 24/7 Production Environment Support and managing Oracle in High Availability environments using Real Application Cluster (RAC), Failovers, Data Guard, Cloning and Replication technologies using Golden Gate.
• Managing Very Large Database with size more than 15 Terabytes.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Developed Logical and Physical Backup and recovery strategies.
• Regular Monitoring of Alert log Files on Day to Day Basis and Performing Database Recovery if there is media failure.
• Security administration: This includes adding and removing users, profiles, roles, administering and checking for security problems.
• Installation, Configuration and Automation of Oracle DBA Monitoring tools.
• Supporting Oracle databases, with experience including requirements definition, data modeling, and logical/physical design.
• Well versed with client server environment & tools like TOAD and SQL*LOADER.
• Installation of Patch and fix bugs and worked on Database Performance Tuning and Optimization.
• Worked on New Environments setups include Standalone, ASM, RAC Databases Installations.
• Good experience in applying Critical Patch Update on Databases, Application Servers and Middle Tiers.
• Working experience with SQL, PL/SQL other tools including creating database objects like tablespaces, tables, views, indexes, constraints, sequences, functions, procedures, trigger and partition tables.
• Mentored and provided oversight and backup for the production Databases.
• Maintaining data integrity and tune database for optimum performance and availability.
• Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.
• Ability to interact effectively with clients, understanding their requirements and providing optimum solution and support.

TECHNICAL SKILLS

Operating Systems: RHEL 3.x, 4.x, 5.x, 6.x Sun Solaris 5.8/5.9/5.10 , AIX 5.1, 5.2, 5.3 and Windows NT/95/98/00/XP/03

Languages: C/C++, Perl, Shell Scripting, HTML, XML, JavaScript, CGI Scripting, PHP, SQL, PL/SQL, SQL*Plus, and Java

Databases: Oracle 9i, 10g and 11g with Real Application Clusters, Data Guard, MS Access, Mysql

Oracle Tools/Utilities: OEM 10g, 11g and 12c, Datagrid control, SQL*Loader, Stored Procedures, Triggers, DataGuard, RAC, Replication, Import/Export, Log Miner, VMware, Putty, Golden Gate, Erwin, Datapump, TKPROF, STATSPACK, VERITAS Net Backup, Data Domain backups, Data Stage, Foglight, Precise, Autosys, Data Modeler, Transportable tablespaces, Blade logic and Toad

Interface Tools: TOAD, SQL Developer, SQL*Loader

UNIX Utilities: Vi, crontab

File systems: Real Application Cluster (RAC), ASM

Backup Tools: RMAN, Expdp/Impdp, Cold, Hot, Export/Import

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

Sr. Oracle Database Administrator

Responsibilities:

• Primary DBA supporting 8 applications with 40+ Oracle database servers.
• Designed and built more than 20 databases for GRITT team that includes Standalone on local disks, ASM and CHP systems.
• Setup Data Gaurd Physical Standby/DR databases for production systems.
• Upgraded 2-node RAC environments, standalone ASM and standalone CHP databases from 10g to 11g.
• Migrated 10g and 11g databases from Solaris to Linux and AIX to Linux.
• Performed storage level migrations from Clarion or DMX arrays to EMC VMAX.
• Migrated 10g databases on 4-node RAC to standalone ASM on 11g.
• Migrated legacy 10g databases on file systems to Standalone ASM on RHEL 6.2 with 11g.
• Migrated 8+ TB databases from Solaris to Linux and from Oracle 10g to 11g.
• Created customized reports using OEM grid control, which are helpful to the users, dba’s and management, primarily focusing on Pro-active monitoring.
• Built Active Datagaurd physical standby database for 2-node RAC.
• Installed and configured OEM agents across all servers in GRITT domain.
• Installed and configured monitoring tools like Foglight and Precise.
• Scheduled backup jobs, cleanup jobs and monitoring jobs using Autosys and Crontab.
• Configured RMAN tape backups to Data Domain.
• Streamlined data refreshes from prod to non-prod environments.
• Provided 24X7 production support for critical environments where Primary DBA intervention is required to resolve the issue.
• Installed ESM (Enterprise Security Management) Agents to perform daily scan across all databases to keep the environment risk free.
• Configured and maintained Oracle Active Data Guard for disaster recovery exercises using ART (Application Recovery Tool).
• Performed database replication on Standalone ASM and RAC databases through Golden Gate.
• Used oracle configuration assistants like DBCA for creating databases, DBUA for upgrading databases and NETCA for creating a Client-Server environment using Listener, TNSnames etc.
• Implemented Data Guard / Standby using both physical and logical standby database.
• Worked in Operations team supporting both prod and non-prod environments.
• As part of Operations team handled complex refreshes using RMAN duplicate and data pump tools.
• Creatingand managing the database objects such as tables, indexesand views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Unix Shell scripting for automating startup/shutdown of databases and getting system alerts.
• Applying quarterly PSU patches both manually and using BBDA(BMC Bladelogic Database Automation) Tool.
• Database Sizing, Tablespace Management, Rollback Tablespace Management, Transaction Management and Security Administration
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Managed users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
• Installed and Implemented Backup & Recovery procedures using RMAN for Oracle 11g/10g RAC and ASM databases, as part of new builds.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, ADDM, ASH, EXPLAINPLAN, and optimizer hints.
• Clear documentation was prepared on all the processes like Application contacts/details, db/server names, design, storage allocation and backup strategies for future reference.

Environment: Oracle 12c/11g/10g/9i, Oracle 11g/10g RAC, Sun Solaris, AIX, RHEL 6.x/5.x, TOAD, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader, SQL server, DataGuard, OEM, Grid Control, Data Guard, STATSPACK, AWR, ADDM, ASH and Explain Plan.

Confidential, NYC

Sr. Oracle Database Administrator

Responsibilities:

• 24X7 production support for several mission critical systems which utilize multiple Oracle databases.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Administration and support of Oracle Application Server 11g and 10g.
• Performed installation and configuration of Oracle 11g/10g RAC databases on SQL Server.
• Managing backup and recovery of Oracle 11g/10g RAC databases.
• Installed ASM into various storage parameters like SAN and NAS.
• Configured and maintained Oracle 10g Data Guard for disaster recovery.
• Performed database replication through Golden Gate.
• Used oracle configuration assistants like DBCA for creating databases, DBUA for upgrading databases and NETCA for creating a Client-Server environment using Listener, TNSnames etc.
• Implemented Data Guard / Standby using both physical and logical standby database.
• Performed switchover/failover and monitored using Data Guard manager command line and GUI.
• Upgraded databases to Oracle 11g from Oracle 10g.
• Creatingand managing the database objects such as tables, indexesand views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Unix Shell scripting for automating startup/shutdown of databases and getting system alerts.
• Applying patches both Server side and Client side.
• Database Sizing, Tablespace Management, Rollback Tablespace Management, Transaction Management and Security Administration
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Managed users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
• Installed and Implemented Backup & Recovery procedures.
• Implemented Hot, Cold and Logical backup plans.
• Worked on import/export and SQL*Loader.
• Setup backup and recovery procedures using RMAN.
• Involved in designing logical and physical data models using Erwin.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Performed Explain Plan analysis for Query Optimization and SQL tuning
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.

Environment: Oracle 11g/10g/9i, Oracle 11g/10g RAC, Sun Solaris, Windows 2000/2003, RHEL 4.4, TOAD, ASM, ERWIN 7.2, RMAN, SQL*Plus, PL/SQL, SQL*Loader, SQL server, DataGuard, OEM, Grid Control, Data Guard, STATSPACK, AWR and Explain Plan.

Confidential, OH

Sr. Oracle Database Administrator

Responsibilities:

• Performed all the Database Administration activity like space management, user and roles administration, schema management and checking alert log of all the databases using OEM.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache and redo mechanisms
• Migrated databases from Sun Solaris to Linux.
• Created database design according to the requirement of Application Software, monitored and configured databases.
• Configured Oracle data guard and Streams.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools like Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager (OEM).
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Estimate the size of the database and its objects (in large databases of 10 to 12 Terabyte).
• Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Backup using RMAN (Recovery Manager) as a media management layer.
• Used SQL*Loader for loading legacy systems database data.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Responsible to troubleshoot both Oracle applications and backend database errors.

Environment: s: Oracle 9i/10g with RAC, Java, J2EE, SQL, PL/SQL, Toad, OEM, PL/SQL Developer, Erwin, RHEL 4.2, HP UNIX, Sun Solaris and Windows 2003.

Confidential, Wayne, NJ

Oracle Database Administrator

Responsibilities:

• Managing users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backups with Database Refresh.
• Proficient in installation and creation of Oracle 9i, 10g databases in development, Production and QA environments including configuration, backup & performance tuning.
• Refresh/Cloning of the databases from Production to the Test and Development environments.
• Upgraded database from Oracle 9i to Oracle 10g.
• Installation and Configuration of Oracle 10g RAC and Standby Databases for high availability and disaster recovery.
• Migrated databasesfrom Unix to Linux Environment.
• Applied CPU, One-off patches using Opatch utility and performed RDBMS patch set Upgrade (PSU).
• Used Oracle 10g grid control utility.
• Planned and implemented Backup & Recovery using RMAN.
• Implemented Cold Backup and Hot Backup depending on the requirement.
• Refreshed development and test databases from production using Logical Backups (Export and Import).
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, AWR and STATSPACK.
• Daily Health Check Up of the Database using ADDM with the help of AWR report.
• Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth.
• Performed Space Management which includes table space creation and adding new data files.
• Maintaining Database Security by Creating Roles, Privileges, Quotas, and Passwords.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Supported test and development environments to ensure smooth transition of applications.

Environment: s: Oracle 9i/10g with RAC, RHEL 4.0, HP UNIX, Sun Solaris, SQL, PL/SQL, UNIX Shell Scripting, RMAN, Oracle 10g Grid control, Data Guard, SQL*Loader, OEM, ASM, EXP, IMP, TOAD, Datapump, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Confidential, TX

Oracle Database Administrator

Responsibilities:

• Involved in creation of Test and Production databases of Oracle Enterprise Edition 9.
• Created materialized views, table partitions for tuned databases.
• Migrated databases from Sun Solaris to AIX.
• Used Triggers for database activities like delete and update.
• Maintained the RMAN repository and customized recovery catalog.
• Performed database installation and upgradation.
• Monitored the growth of the database objects for capacity planning.
• Performed database tuning for daily loads and slow response issues.
• Used STATSPACK, PERFSTAT and TKPROF utilities for tuning and analysis.
• Improved the performance by using Indexes, Explain Plan, SQL Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data.
• Involved in query optimization using rule based optimizers and cost based optimizers.
• Responsible for database backup strategies, database recovery and validation & reporting database statistics.
• Monitoring and management of various database components (logical & physical) like table spaces, segments (tables, index, rollback).
• User creation and enforcing security using privileges and roles.
• Export and import of database objects.
• Validation of SQL and PL/SQL scripts before deploying into the production database.
• Conversion of database from file system to Oracle RDBMS using tools like SQL*Loader and UNIX shell scripting to automate the process.
• Responsible to troubleshoot both Oracle applications and backend data base errors.
• Built database links to connect users on different databases.
• Creation of cluster indexes, bit-map indexes and creation of index organized tables to enhance performance.
• Documentation of Data Base Setup.

Environment: Oracle 9i/10g, RHEL, Sun Solaris, Windows2000, UNIX AIX 5.1, RMAN, SQL*Loader, SQL*Plus, SQL Server 2000, OEM, Toad, Cronjob, Veritas Net Backup, PL/SQL and UNIX scripting.