SUMMARY:

• Around 10 years of strong experience in Oracle DBA working on Production and Non Production environments. For both standalone databases as well as RAC clusters in ASM storage as well as non ASM.
• Responsible for training Junior DBA’s and well as training them guiding them with DB performance tuning, troubleshooting features in Oracle 9i, 10g, and 11g Release 1, Release 2.
• Worked on 9i, 10g, and 11g RAC (Real Application Cluster) installation, maintenance, configuration, troubleshooting of 9i, 10g, 11g RAC on Linux and AIX environment. Worked in Data upload using SQL* loader oracle utility. Worked on Patching, Upgrading (9i to 11g, 10g to 11g), Cloning Oracle Database for critical applications.
• Worked on DB migration to DbaaS (OraaS) from physical servers. Worked on migrating databases to Cloud. Applied DB patches on Cloud and OraaS for both Non - Prod and Prod.
• Good Knowledge on Oracle Database 12c like patching, upgrading, installation, configuration.
• Working knowledge on the Golden Gate Technology setup and monitoring for version 11.2.
• Installed Oracle Text Option in the database for the AMERICAN language.
• Recovered Production environment in ZERO Backup availability scenario by taking Backup from Standby Database Replication environments on NAS and SAN setup.
• Experienced in troubleshooting for Database related issues like Performance Tuning using ADDM, AWR, ASH and other Oracle Diagnostic Tuning Pack like SQLT, SQL Tuning Advisor, SQL Health check tool. Good knowledge of dynamic performance views in Performance Tuning.
• Experienced in upgrading database from (9.2.0.8 to 10.2.0.4), (10.2.0.4 to 11.1.0.7), and (11.2.0.3 to 11.2.0.4) standalone and RAC environments.
• Provide support to application team in their code deployment for their monthly releases.
• Experience working on ASM administration. Creating disk groups, adding disks to the disk groups in an ASM environment for 10g and 11g Database also includes monitoring of the environment using dynamic views.
• Experience in implementing database backups using RMAN (Recovery Manager), recovery of the data files, tablespaces, and databases using RMAN and test the backups regularly.
• Used Flashback Database, Flashback table feature to recover the Oracle10g, Oracle 11g Database, also monitored the flashback logs on a daily basis. Responsible for writing Shell Scripts (ksh) in aid to Backup & Recovery, Performance Tuning operations on Oracle Database.
• Worked on Rebuilding the Standby environment on Oracle Database 10.2.0.4. Also spend time resolving issue with the Standby environment causing MRP to stop working. Worked on Configuration and troubleshooting Data guard resolving archive gap resolution. Configured DATA GUARD and performed troubleshooting Data guard to resolve archive log gap.
• Experience in implementing database security solutions like audit and encryption using TDE.
• Worked on Snapshot Standby Database on 11g R2 environment, converting physical standby to snapshot standby and reverse. Worked on Active Data Guard setup to perform real time applying.
• Created and maintain Database Objects like Tables, Views, and Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link.
• Expertise in maintaining several Database instances running on UNIX, Linux, Solaris, and AIX & Windows Servers.
• Worked extensively on the High Availability Architecture and on Enterprise Manager GRID Control.
• Created Development environment by taking Cold Backup from QA. Experience in handling and Troubleshooting of Operating System, WINDOWS 95\98\2000\XP, UNIX, Linux, Solaris, AIX.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/NT/2000/XP,2003,2007,VISTA, UNIX (korn shell), Windows server 2003, AIXRDBMS: Oracle 11g/10g/9i (OCP), SQL Server 2000, 2005

Languages: SQL, PL/SQL, C, C++.

DB Management: Enterprise Manager Console

Tools: RMAN, OEM, SQL Navigator, Oracle Management Service (OMS), SQL*Loader, Export/Import, Data Pump, ODBC, Forms

Application Server: 10gAS, 9iAS

Version: Oracle EBS (E-Business Suite) - 11i & R12,Oracle 10g & 11g Database

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK.

Web Language: VB.NET, ASP.NET, XML

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Sr. Oracle Database Administrator

Environment: Oracle 9i (9.2.0.8), 10g (10.2.0.2.0, 10.2.0.4.0 ), 11g (11.2.0.2.0, 11.2.0.3.0 ), Linux, AIX, Solaris.

Responsibilities:

• Working as Sr. Oracle Database Administrator for our client Confidential supporting their databases on a 24/7 basis.
• Worked on the Grid architecture for both 10g and 11g environment. Worked on 9i, 10g, and 11g RAC (Real Application Cluster) installation, maintenance, configuration, troubleshooting of 9i, 10g, 11g RAC on Linux and AIX environment. Worked in Data upload using SQL* loader oracle utility. Worked on Patching, Upgrading (9i to 11g, 10g to 11g), Cloning Oracle Database.
• Working on RAC and ASM environments on 11g (11.2.0.2.0, 11.2.0.3.0, 11.2.0.4.0 ), extensively doing troubleshooting and monitoring the environments.
• Strong experience on Linux, AIX, Solaris environment writing scripts in order to provide support for Performance Tuning, Backup & Recovery.
• Regular installation of scripts on Development, Test, UAT and Stress environments as requested by and Application Developer team. Daily monitoring of all the environments (Production and Non - Production).
• Setting up Data Guard environment along with Data Guard Broker for Standalone as well as 11g R2 RAC.
• Migrating databases from AIX to Linux, Linux to Linux in UAT and Production environments.
• Good Knowledge on Oracle Database 12c like patching, upgrading, installation, configuration.
• Working knowledge on the Golden Gate Technology for the Oracle Database supporting for heterogeneous environments.
• Installed Oracle Text Option in the database for the AMERICAN language.
• Use of Flashback Database, Flashback table, feature to recover the Oracle10g, 11g and also monitor the flashback logs on a daily basis.
• Working with Oracle Support on troubleshooting some of the Database and Application server issues.
• Schema refresh of a Development database from Production.
• Performing Switchover from Primary to Standby and reverse on UAT and Production databases.
• Applying Critical PSU patch on all the databases to meet the standards of all the environments.
• Creating new Database Home for 11.2.0.3, 11.2.0.4, applying Critical PSU Patch on the databases and releasing to the end users.
• Extensive use of Data Pump to perform migration in lower and higher environments.
• Successfully upgraded database from (9.2.0.8 to 10.2.0.4), (10.2.0.4 to 11.1.0.7), and (11.2.0.3 to 11.2.0.4) standalone and RAC environments.
• Sound knowledge on Oracle 12c environment and setting up new Database Configuration in ORAAS.

Confidential, Coraopolis, PA

Oracle DBA

Environment: Oracle 9i (9.2.0.8), 10g (10.2.0.2.0, 10.2.0.4.0 ), 11g (11.2.0.2.0, 11.2.0.3.0 ), Linux, AIX.

Responsibilities:

• Worked on the High Availability Architecture for the Oracle Database of several TB’s of size as well as on the Data Guard environment for Oracle 10g and 11g. Worked on the Grid architecture for both 10g and 11g environment.
• Worked on RAC and ASM environments on 10g (10.2.0.2.0, 10.2.0.4.0 ), 11g (11.2.0.2.0, 11.2.0.3.0 ), extensively doing troubleshooting and monitoring the environments.
• Strong experience on UNIX environment writing scripts in order to provide support for Performance Tuning, Backup & Recovery.
• Monitor all the environments (Production and Non - Production) on 24/7 basis by customizing the scripts to run as cronjob.
• Regular installation of scripts on QA and Production environments as requested by and Application Developer team.
• Worked with team setting up Data Guard environment along with Data Guard Broker.
• Setup databases to Archive log Mode and Flashback mode.
• Monitor the space for all the databases on a daily basis and to add datafile when required or resize the tablespace.
• Worked with SA / Network Administrator to increase the space in /oradata directory where Database is actually stored.
• Regular Monitoring of the archive gap on Production environments and fixed them if there was archive gap available.
• Use of Flashback Database, Flashback table, feature to recover the Oracle10g, 11g and also monitor the flashback logs on a daily basis.
• Worked with Oracle Support on troubleshooting some of the Database and Application server issues.
• Schema refresh of a Development database from Production as asked by Development team.
• Remove database from SQL Backtrack to RMAN environment, modifying the RMAN settings.
• Excessive use of Data Pump in Production, Development databases.
• Decommission QA and Development databases in order to upgrade the cluster.

Confidential

Oracle DBA

Environment: Oracle 10g (10.2.0.4), Linux, SQL Server 2005 (Enterprise edition).

Responsibilities:

• Worked on the High Availability Architecture for the Oracle Database as well as on the Data Guard environment for Oracle 10g and 11g. Worked on the Grid architecture for the 11g Database.
• Worked with Development Team during the Production Release (1203 and 1204).
• Played a major and key role during the Data Center Movement. Made sure proper valid backup is available for all Production environments before initiating shutdown of all the environments during the Data Center Movement.
• Restored the Database services first followed by all Application Services for Production environments as well as Non Production environments.
• Recovered Datafile for Data Warehouse Production Database from getting to size ZERO due to DATAFILE Corruption. This recovery procedure was initiated from taking backup from DR Database as there was no valid backup available for Production Database environment.
• Worked on RAC and ASM environments on Oracle 10g R2, 11g R1 extensively doing troubleshooting and monitoring the environments.
• Strong experience on UNIX environment writing scripts in order to provide support for Performance Tuning, Backup & Recovery.
• Worked extensively on installation, maintenance, backup, troubleshooting of SQL Server. Daily monitoring of 5 SQL Server Databases.
• Worked with Oracle Development teams working in their coding. Also helped them to get the connectivity with the database. Worked with Oracle Support on troubleshooting some of the Database and Application server issues.
• Performed Standby Rebuild for Data warehouse DR environment by taking L1 Backup from Primary also worked on Standby Replication in 10g and 11g environment.
• Daily monitoring of all the environments (Production and Non - Production). Performed troubleshooting on Standby environment to resolve issue with wrong datafile name causing MRP to stop.
• Created all the Development Databases by taking cold backup from QA databases.
• Worked on Application services of Development / QA Databases to make changes in the appropriate files or directories to get them ready for daily batch.
• Performed troubleshooting on any kind issues on Application environment. Monitored the space for all the databases on a daily basis. Added space to tablespaces if required to Production as well as Non Production Databases.
• Worked in tandem with offshore team during the restore after Data Center Movement.
• Restored all the Production as well as Non - Production databases (Oracle and SQL Server) along with their application services from complete Power Outage 2 times.

Confidential, CA

Oracle DBA

Environment: Oracle 10g, 11g, PeopleSoft, Siebel, Linux, AIX, Solarix

Responsibilities:

• Supporting Oracle OnDemand Customers running various versions of Database (Oracle 8i, 9i, 10g and 11g) with database size of size 100G’s to 4TB.
• Responsible for training Junior DBA’s and well as training them guiding them with DB performance tuning, troubleshooting features in Oracle 9i, 10g, and 11g.
• Oracle Applications (11.5.8, 11.5.9, 11.5.10 and R12.x), Tech Stack (Discoverer, IAS, Discoverer, JDK, Jinitiator, and Developer6i) and Oracle Application Server.
• Worked on outages on Forms issue for release (11i, R12).
• Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging On Demand Customer environments.
• Supporting different products apart from EB-Suite are Siebel, Hyperion, Retail, PeopleSoft and many more.
• Expertise in working with SAN and NAS storage environments for Oracle 9i to 11g Databases.
• Supported Oracle Grid Architecture environments for 11g R1 and 11g R2 RAC environments.
• Used Flashback Database, Flashback table, feature to recover the Oracle10g, Oracle 11g also monitored the flashback logs on a daily basis. Also used Flashback query feature to restore the data to a previous point of time.
• Sound knowledge on Configuration and Troubleshooting of 10g, 11g Data guard resolving archive gap resolution, worked on Snapshot Standby Database environment also worked on Standby Replication in 10g and 11g environment.
• Experience working on Oracle RAC (9i, 10g, 11g) environment.
• Experience working on Oracle Grid Architecture for 11g RAC environments.
• Worked with Financial environments for customers like Confidential, Confidential, Confidential, Confidential and many more.
• Strong experience on UNIX environment writing scripts in order to provide support for Performance Tuning, Backup & Recovery.
• Experience working on ASM environment. Creating disk group, adding disks to the disk groups. Monitoring the environment as well as performing troubleshooting on 10g ASM instances.
• Troubleshooting of Weblogic server, Apps server, SOA suite, BAM server, and monitoring the status of Composites in Production and Non - Production environment.
• Experience in troubleshooting, support of OBIEE (10.1.3.3, 10.1.3.3.1 ), DAC, and Informatica in Production environment.
• Daily responsibilities include trouble shooting and restoring Oracle Applications components Apache,
• Forms, Reports, Concurrent Managers, Workflow Managers, Discoverer plus/viewer, iAS, Single Sign-on.
• Worked extensively using OEM monitoring multiple databases for any alerts, checking for AWR reports, ADDM reports and also running jobs for the Backup.
• Identifying, analyzing and resolving technical problems related to Oracle software systems.
• Restore failed services; find workarounds to reduce business outage situations.
• Worked on multi-node RAC Database and mutli-node Mid-tier Apps and DB Performance Tuning for Non Production as well as Standby on 24/7 on call support.

Confidential, Old Westbury, NY

Environment: Windows server 2003, LINUX

Responsibilities:

• Installation, configuration, maintenance, as well as monitor the database (SQL Server 2000, SQL Server 2005, Oracle 10g, Oracle 11g) in the central database. Maintained records for teachers, their schedules, personal details, student information and also administrative resources all stored in that database.
• Performed backup and recovery operations on a day-to-day basis.
• Used Oracle Flashback feature to perform recovery of the database environment.
• Extensively engaged in troubleshooting several scenarios like DB out of space, temp file system is 100% full, tablespaces out of size, DB audit trail issue, DB has crashed.
• Worked under the supervision of my Professor taking care of Technical issues for the Management Department inside our campus.

Confidential, NY

Oracle DBA

Environment: SQL Server 2005, Windows XP

Responsibilities:

• Installation, maintenance and configuration of SQL Server 2005.
• Designed a database in SQL Server to store customer records, including purchase information. As a DBA the role was to setup the environment for the project which was completed efficiently and created all the tables in SQL Server, loaded it raw data. Linked all the tables using Parent-Child relationship to give it a normalized look.
• Helped my teammates in designing the front end using ASP.NET to make it work in live environment.
• Checked the SQL Server database for performing the backup.

Confidential, NY

Oracle DBA

Environment: Oracle 10g, Windows Server 2003

Responsibilities:

• Installed Oracle Database 10g and proficiently designed distributed database connectivity of 3 or more systems located in different places. Connected these systems by using DB Links.
• Monitoring the performance of DB by checking through dynamic performance views, Active session history also checking for the SQL statement tuning.
• Creation of Database objects and checking their status on an hourly basis to check for an update.
• Monitored the database environment using OEM like creating objects if required, managing scheduled jobs.
• Online backup of the database with or without using RMAN.
• Performance Tuning on an extensive level.

Confidential

Oracle DBA

Environment: SQL Server 2005, Oracle 11g, Windows XP

Responsibilities:

• Installation, maintenance and configuration of Oracle Database, SQL server 2005 Enterprise Edition on Windows environment.
• Responsible for creating the database both on Oracle Database for few environments as well as on SQL Server for rest.
• Involved in backing up both the SQL Server and Oracle Database on a regular basis.
• Provided performance tuning my using AWR Report in Oracle Database and also provided tuning in SQL Server.

Confidential

Oracle DBA

Environment: Oracle 9i, 10g, 11g, Windows XP, SQL Server 2000, 2005.

Responsibilities:

• Have major role in the operations of our company. To be precise, our company used to deal with corporate clients all over India. So we used to keep track of all the records and the records used tokeep changing day by day. So in order to keep these records intact I installed Oracle 9i in that system. I then did one setup of the Backup in that system and have put several copies in different systems excluding one in our Head Quarter. As we know that we can keep up to 10 destinations in oracle 9i so it was never a problem for me. Undoubtedly the database was large and we used to monitor it 24/7, writing RMAN scripts, performed root cause analysis.
• Install, configure, maintenance on Oracle 9i, 10g, 11g Database and SQL Server (2000, 2005).
• Responsible for training Junior DBA’s and Mid level DBA’s and well as training them guiding them with DB performance tuning, troubleshooting features in Oracle 9i, 10g, and 11g.
• Responsible for coding in SQL and PL/SQL to aid developers whenever required in Oracle and SQL Server.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS. I took participation as a trainer and trained people to become a successful DBA, a few of them are really working for companies like Confidential, Confidential and Confidential.
• Worked extensively using OEM monitoring multiple database environments for any alerts, checking for AWR reports, ADDM reports and also running jobs for the Backup. Created objects manually on OEM if required. Performed troubleshooting as well on multiple databases.
• Trained students as well as corporate staff on entire Oracle 9i Database Administrator Track to Reliance Infocom, Steel Authority of India.
• Monitored and managed various database components (logical & physical) like tablespaces, segments.
• Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database.
• Knowledgeable in using OEM Features and worked with databases which have critical and BLOB data.
• Used TKPROF to find out tracing of which user has occupied more of the CPU time by executing longer queries, STATSPACK to find out the statistics of the database, worked on wait event based tuning, memory tuning, logical structure tuning, I/O tuning.