Summary:- 
An Oracle certified DBA with well over 8 years of experience in application and production databases. Tasked with handling multi-disciplined aspects of oracle binaries and utilities along with upgrading, patching, configuration, tuning and maintenance, is capable of offering support and consultation on various concerns pertaining to databases.

• Experienced in handling VLDBs sized from 150GB to 5TB
• Worked mostly with but not limited to Production servers along with development and testing servers.
• Experienced in creating Physical Standby Databases using DATAGUARDfor the purpose of disaster recovery.
• Usage ofDatapump of oracle 10G & 11Gfor exporting and importing logical data of the databases.
• Taking Hot and Cold backups using RMAN, along with Online and Offline backups and recovery
• Profuse hands on experience in setting up and maintaining multi node RAC clusters with the underlying ASM technology.
• Significant experience in using the RMAN and Flashback technologies for backup and recovery purposes.
• Managed and configured DATAGUARD with two physical standbys for the most recent project. Also worked with Golden Gate on previous projects.
• Hands on experience in configuring and monitoring Enterprise Manager Grid Control 12c.
• Involved in multiple projects that required installing, upgrading and quarterly patching with the help of Opatch utility for the databases assigned under my applications.
• Experienced in taking Cumulative and Incremental backups.
• Extensive experience in handled data migrations with the aid of expdp,impdpand RMANutilities.
• Dealt with performance issues in previous projects, which involved managing the size of table spaces, redo log files and archived redo log files according to the production environment.
• Successfully delivered resolution ideas for critical database conflicts involving user roles and privileges, database network connectivity etc.
• Frequent use of SQL loader for loading external data in flat files into the oracle database.
• Strong experience in creating user, roles, privileges, accounts and profiles in the database.
• Authoritative grasp on Oracle database architecture.
• Well experienced with the concepts of AWR, ADDM, OEM, explain plan for the purpose of performance tuning.
• Experienced in upgrading Oracle databases from 9i to 10g and from 10g to 11g.
• Applied CPUs and PSUs to the databases.
• Experienced in writing shell scripts and using crontab for job creation & monitoring.
• Successfully dealt with disaster recovery circumstances with maximum reduction in MTTR.
• Experienced in effectively troubleshooting issues concerning network problems, instance startups, taking backups and recovering database files etc.
• Worked in 24/7 production environments.
• Worked with PL/SQL procedures, cursors, functions, triggers, varrays.
• Knowledge over data replication tools of Golden Gate and Shareplex.
• Worked in a team with large production databases that spanned up to 10TB of data.
• Excellent communication skills, a good team player and punctual in meeting project deadlines.
• Worked on large OLTP databases spanning up to 20TB.
• Worked on multi platforms AIX, HP-UNIX, Sun Solaris, RHEL,Windows.
• Knowledge over SQL Server 2000/2005/2008/2008R2.

Technical Skill Set:-

Linux, SunOS, CentOS, RHEL, HP-UX, Windows, iOS

DB Utilities& Technologies-

SQL Plus, expdp/impdp, RMAN, DATAGUARD, RAC, ASM, AWR, ADDM, Goldengate, OPatch

Tools-

SQL developer, OEM, TOAD, Putty, TOAD Spotlight, BMC patrol

Languages-

C, C++, Java, SQL, PL/SQL, HTML

Unix Shells -

Bash, korn

RDBMS-

Oracle 11g, 10g, 9i, SQL Server 2005, 2008

Scripting-

Shell Scripting, Crontab Jobs, Perl Scripting

Others-

MS Office, Open Office, Adobe products, FTP, SFTP, TCP/IP, Eclipse, Visual Studio,

Certifications/Education:-

• Oracle Certified Associate Database 11g Administrator.
• Bachelors of Technology (B.Tech)

Professional Experience:-

Confidential, Cherry Hill, NJ November 2012 – Present
Oracle DBA

Confidential is an IT firm, which provides technical services to financial institutions. It has wide range of banking clients stretching from east coast to pacific and Canada. Its product DNA, previously known as TCBS (The complete Banking Solution) is its trade mark product which is indigenous to Open Solutions by which they provide the IT assistance to their clients.

Responsibilities:

• Providing database support to the development and programming staff.
• Monitoring the database filesystem space and adding the necessary amount of space to avoid clogging.
• Using Datapump to export and import logical data across servers to developers who requested the respective data.
• Cloning and refreshing the test databases from production to a point in time, using RMAN Duplicate from backup tapes as per the client requirement.
• Korn Shell scripting to automate tasks for database and OS filesystem maintenance.
• Responding to email alerts for long running sqls, and taking necessary precautions through sql tuning to reduce the run time of sqls.
• Creating Oracle recommended SQL Profiles and Baselines for sql tuning.
• Generating AWR, ASH and SQL Health Check reports to Client Care and programming departments for reviews.
• Creating new copies of existing development databases for the off shore development team.
• Installing Oracle Grid Control 12c. OMS in one server and OMA in both production and testing servers.
• Clearing database locks generated by core users to release the table records.
• Resolving the issue of hanging databases caused by Shared Pool fragmentation and TNS Listener errors.
• Increasing the size of the SGA_TARGET for better performance of large databases.
• Verifying the space of the database file system for the database’s product upgrade.
• Bringing down the listeners in 10g and bringing up the listeners in 11g for the databases upgrade from 10g to 11g.
• Verifying successful daily backup runs. Manually running the backup scripts if backups failed.
• Running the Oracle Licensing scripts.

Environment:Oracle 10g/11g, AIX 6, Toad 11.5, Putty, OEM 12c, Windows Server 2000, Smitty, FTP, DATAPUMP, SQL Server 2005/2008, DB2.

Confidential, Ontario, CA February 2012 –September 2012
Oracle DBA

Confidential is a leading health care provider in supplying health insurance and medical facilities, with its headquarters located in Ontario, California. Prime Healthcare was recognized as a Top 15 Health System in the nation in 2012. It also earned the distinction in 2009.
The mission of Prime Healthcare is to provide comprehensive quality healthcare in a compassionate, convenient and cost-effective manner.

Responsibilities:

• Updating the databases from Oracle 9i/10g database to Oracle 11g R1 & R2, since the support for most of the features of the 9i is discontinued by Oracle.
• Managing andMigrating databases from non-ASM to ASM.
• Supporting large databases in a 24x7 environment in the data center and providing online support to the personnel stationed with the local server at their respective locations.
• Installation, Configuration and deployment of Oracle 11g databaseswithRAC on different nodes on Sun Solaris platform.
• Using DBMS_JOBS and DBMS_SCHEDULER to schedule the tasks.
• Utilizing the recovery manager in cloning the production database into the test environment.
• Automation of the Flat file extraction into the database with the help of SQL*Loader & shell scripts.
• Implemented stand-alone database using Oracle DATAGUARD feature for High availability configuration. Only one physical standby is created and maintained.
• Implemented database refresh with the hot backup using DUPLICATE or full export.
• Used RMAN for Backup & Recovery, since the database is a 24/7, only hot backups are taken.
• Tuning SQL Queries, Partitioning and Indexing large tables. Gathering performance statistics through Statspack and AWR reports.
• Reviewing performance stats and recommended changes for tuning database, server, and storage configurations, as well as application SQL.
• Participating in periodic backup audits, including test restores, ensuring all databases and associated logs are being backed-up
• Performing day-today DBA activities like Patching, Performance Tuning, Space Management,Backup&Recovery, Users&Security Management, Query Optimization, testing, implementation and Shell scripting.
• Coordinate interaction with vendors in critical database problem situations, where in they had problems connecting to the databases because the listener was down or the database archived log files are filled and were needed to be migrated to different disk locations.
• Migrating data across servers running on HP-Unix and Sun Solaris.

Environment:Oracle 9i/10g/11gR1, Solaris 8/9/10 64 bit, HP-UX 11i v3, Windows 7, OEM, BMC Patrol, Grid Control 10g/11g, TOAD 8.6, FTP, putty, SQL Developer, SQL Plus, DATAGUARD, ASM, SQL Server 2008.

Confidential, Madison, WI April 2011 – January 2012
Oracle DBA
Confidential is a telecommunications industry that sells the services of Internet and Telephones. Confidential Communications is a subsidiary of Telephone and Data Systems, its headquarters is located in Madison, Wisconsin, USA. During the last project I was assigned to the sales and services team for maintaining the databases for their applications.

Responsibilities

• Creating user accounts, roles and privileges for the purpose of DB operations and security maintenance.
• Configured 2 node RAC cluster and converted single instance database to multi node instance.
• Monitoring the oracle instances using the OEM and Grid Control to monitor the users, tablespaces, memory structures, rollback segments, logs and alerts.
• Configured GOLDENGATE for replicating databases.
• Making use of SASBI tool to gather data from different subsidiaries of the company and generating a report on the collected data.
• Taking hot backups every Wednesday and Saturday using RMAN.
• Daily work involved migrating data from production servers to the testing servers.
• Extensive use of Crontab to automate the scheduling of daily routine tasks
• Using AWR, ADDM, OEM and control plan to improve the performance of the applications.
• Assisting the development team with issues regarding the database connectivity, User expiration, password resetting etc.
• Analyzing the statistics from the information gathered from the DBMS_STATS.
• Using v$ views, STATSPACK, TKPROF, OEM for gathering statistics.
• Partitioning large tables for higher performance.
• Aided in the disaster recovery process, when one of the production server crashed due to a physical anomaly. The MTTR has been reduced drastically since the last server crash.
• Monitoring the increased records and purging the old and unnecessary records.
• Using business objects to support end users, application developers and creating reports
• Analyzing the alert log file for error tracing.

Environment:Oracle 10g/11g R2, RAC, Solaris 9/10 64bit, Windows XP, Oracle Enterprise
Manager (OEM), Grid Control 10G/11G, TOAD 8.6, Toad Spotlight, FTP, putty, SQL Developer, GOLDENGATE,AIX 5.3/5L, ASM.

Confidential, Austin, TX October 2010 – April 2011
Oracle DBA

Confidential is an American based corporation established in the year 1946 to provide financial services based on investments. It is considered to be one of the largest mutual fund & financial services groups in the world. As the Confidential is a financial sector, it was very important during the phase of our project to provide the utmost stability to our database.

Responsibilities

• Configured one extra physical standby database apart from the already existing two standbys, as a precautionary measure to reduce theMean Time to RecoverMTTR and for disaster recovery.
• Creating views,public and privatesynonyms on tables.
• Taking two incremental backups on Tuesday and Thursday and one cumulative backup on Sunday.
• Maintaining the already configured nodes in the RAC cluster.
• Resizing the data files to meet the server requirements on busy days, to prevent the database from freezing.
• For the purpose of improving the performance of queries, created Bit-map Indexes.
• Since most of the data pertains to the personal information of the customer, security is of the utmost importance, so naturally I was involved in designating the roles and privileges to the application developers.
• Extensive using of the flash back technology to get the accurate versions of the data in the times of partially completed transactions.
• Involved in creating a new database from scratch for an entirely new application that is being developed.

Environment:Oracle 10g and 11g R1, AIX, RHEL 3/4,Windows 7, Oracle Enterprise Manager– OEM, Toad, BMC Patrol, Solaris 9/10, DATAGUARD, Grid Control 10G/11G, ASM, Putty

Confidential July 2009 – August 2010
Oracle DBA

Confidential is an publicly traded American company involved in healthcare business services, such as providing practicing physicians with online practice management and electronic medical records storage software. As a part of the plan for business expansion in India, the project was moved offshore to Chennai, India.

Responsibilities

• Installing Oracle 10g on Sun Solaris 5.9.
• Creating and configuring four databases for two applications, two databases for each application.
• Implementing DATAGUARD on the server by creating one physical standby. Physical standby located in Hyderabad.
• Used expdp/impdp utilities to migrate data from the servers located in US to the servers located in India.
• Creation of users, roles and profiles for the application developers.
• Managing and troubleshooting database network connectivity.
• Taking cumulative backups every Saturday using RMAN.
• Loading data from the Oracle server to the SQL Server and vice versa.
• Upgrading the SQL Server 2005 to 2008.

Environment: Oracle 10g, Sun Solaris, RHEL, Windows2000, PL/SQL, TOAD, DATAGUARD, FTP, OEM, MobaXterm, SQL Server 2008

Confidential May 2006 – June 2009
Oracle DBA

Confidential is an American multinational computer technology corporation which designs, produces and sells its own brand of computer products ranging from small tablets, laptops, desktops to small enterprise servers. Was assigned to the sales, tech support and hardware management divisions of Pune, India

Responsibilities

• Upgrading the databases from 9i to 10g.
• Applying quarterly patches to the databases using Opatch utility.
• Assigning roles and privileges to the newly appointed members of the hardware development division. Maintaining the roles and privileges of the sales and tech support teams.
• Taking incremental backups on every Wednesday and cumulative backup on every Saturday.
• Maintaining the instance, online redo log files and archived redo log files for two nodes of the RAC cluster located in Hyderabad, India and Bangalore, India.
• Writing SQL Queries to support the applications.
• Writing PL/SQLprocedures, triggers and functions.
• Configured a second physical stand by database on remote server located in Chennai, India.
• Resolving developers’ issues regarding DB network connectivity.

Environment: Oracle 10g, Toad 8.5, Windows XP, Sun Solaris 5.6, RHEL 4, Data Guard
OEM, RMAN, Grid Control 10G, ASM SmartFTP, Putty