SUMMARY

• More TEMPthan 11 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, Upgrade (9i to 11g, 10g to 11g), Cloning Oracle Database for critical applications.
• Experience working on Table and Index partitioning.
• 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 noledge on teh Gloden Gate Technology setup and monitoring for version 11.2.
• Installed Oracle Text Option in teh database for teh AMERICAN language.
• Recovered Production environment in ZERO Backup availability scenario by taking Backup from Standby Database Replication environments on NAS and SAN setup.
• Worked on Implementing Continuous Integration and Continuous Deployment for supporting Application release using Automation.
• 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 noledge 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.
• Worked on MSSQL server version (2012, 2014) performing daily maintenance activities and scheduled activities like applying patches, storage management.
• Provide support to application team in their code deployment for their monthly releases.
• Experience working on ASM administration. Creating disk groups, adding disks to teh disk groups in an ASM environment for 10g and 11g Database also includes monitoring of teh environment using dynamic views.
• Experience in implementing database backups using RMAN (Recovery Manager), recovery of teh data files, tablespaces, and databases using RMAN and test teh backups regularly.
• Used Flashback Database, Flashback table feature to recover teh Oracle10g, Oracle 11g Database, also monitored teh 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 teh Standby environment on Oracle Database 10.2.0.4. Also spend time resolving issue with teh 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 teh 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 2003AIX

RDBMS: Oracle 11g/10g/9i (OCP), SQL Server 2000, 2005, 2012

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

DB Management: Enterprise Manager Console

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

Replication: Gloden Gate v11

Application Server: 10gAS, 9iAS

Version: Oracle EBS (E-Business Suite) - 11i & R12,Oracle Database - 9i (Release 1 and 2), 10g (Release 1 and 2), 11g (Release 1 and 2), 12c Release 1

Tuning Tools: TKPROF, EXPLAIN PLAN, SQLT, AWR, ASH, ADDM, SQLHC, SPA

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

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Lead 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 ), 12C R1, 12C R2Linux, AIX, Solaris, MSSQL Server 2012

Responsibilities:

• Working as Lead Oracle Database Administrator for our client Confidential Group supporting their various database environments on a 24/7 basis.
• Worked on teh Grid architecture setup for both 10g and 11g environment.
• Worked on different database versions like Oracle 9i, 10g, and 11g on teh installation, maintenance, and configuration, troubleshooting of 9i, 10g (Real Application Cluster), 11g (Real Application Cluster) on Linux and AIX environment of sizes up to 150 TB.
• Worked in Data upload using SQL* loader oracle utility and has extensively used Data Pump on various environments.
• Worked on Patching, Upgrading (9i to 11g, 10g to 11g), Cloning, and Refreshing of Oracle Database across different platforms.
• 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.
• Worked on RAC and ASM environments setup on 11g (11.2.0.2.0 , 11.2.0.3.0 , and 11.2.0.4.0 ), extensively doing troubleshooting and monitoring teh environments.
• Strong working experience on Linux, AIX, Solaris environment writing scripts in order to provide support for Performance Tuning using various tools and methodologies, and implementing TEMPeffective Backup & Recovery solutions.
• Worked on Replication technologies like Gloden Gate on version 11g implementation, troubleshooting different issues, monitoring teh environment, patching and patching. Currently working on upgrade to version 12c. Extensively used Gloden gate Veridata tool to compare teh source and target and resolve any issues.
• Worked with application team on teh software development life cycle to install scripts on Development, Test, UAT and Stress environments as requested by and Application Developer team. Daily monitoring setup of all teh environments (Production and Non - Production).
• Setting up Data Guard environment along with Data Guard Broker for Standalone as well as RAC on 11g R2.
• 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.
• Enabled partitioning option on teh Database level and has worked on Table and Index partitioning. Assisted Developers on implementing partitioning to improve query performance.
• Migrated databases from AIX to Linux, Linux to Linux in UAT and Production environments.
• Sound noledge on Oracle 12c environment and setting up new Database Configuration in ORAAS.
• Good Knowledge on Oracle Database 12c like patching, upgrading, installation, configuration.
• Working noledge on teh Gloden Gate Technology for teh Oracle Database supporting for heterogeneous environments.
• Basic noledge on Virtualisation.
• Installed Oracle Text Option in teh database for teh AMERICAN language.
• Use of Flashback Database, Flashback table, feature to recover teh Oracle10g, 11g and also monitor teh flashback logs on a daily basis.
• Worked on MSSQL server version 2012, performing daily maintenance activities and scheduled activities like applying patches, storage management.
• Worked with Oracle Support on troubleshooting some of teh Database and Application server issues.
• Worked on performing Switchover from Primary to Standby and reverse on UAT and Production databases.
• Applying Critical PSU patch on all teh databases to meet teh standards of all teh environments.
• Creating new Database Home for 11.2.0.3, 11.2.0.4, applying Critical PSU Patch on teh databases and releasing to teh end users.

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 teh High Availability Architecture for teh Oracle Database of several TB’s of size as well as on teh Data Guard environment for Oracle 10g and 11g. Worked on teh Grid architecture for both 10g and 11g environment of size up to 100 TB..
• 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 teh environments.
• Strong experience on UNIX environment writing scripts in order to provide support for Performance Tuning, Backup & Recovery.
• Monitor all teh environments (Production and Non - Production) on 24/7 basis by customizing teh scripts to run as cronjob.
• Regular installation of scripts on QA and Production environments as requested by and Application Developer team.
• Worked on Replication technologies like Gloden Gate version 11g installation, monitoring and troubleshooting.
• Worked with team setting up Data Guard environment along with Data Guard Broker.
• Setup databases to Archive log Mode and Flashback mode.
• Monitor teh space for all teh databases on a daily basis and to add datafile when required or resize teh tablespace.
• Enabled partitioning option on teh Database level and has worked on Table and Index partitioning. Assisted Developers on implementing partitioning to improve query performance.
• Worked with SA / Network Administrator to increase teh space in /oradata directory where Database is actually stored.
• Regular Monitoring of teh archive gap on Production environments and fixed them if their was archive gap available.
• Supported Oracle E-Business Suite environments for various applications, worked on resolving outages.
• Use of Flashback Database, Flashback table, feature to recover teh Oracle10g, 11g and also monitor teh flashback logs on a daily basis.
• Worked with Oracle Support on troubleshooting some of teh 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 teh RMAN settings.
• Excessive use of Data Pump in Production, Development databases.
• Decommission QA and Development databases in order to upgrade teh cluster.
• Basic noledge on Exadata.

Confidential

Oracle DBA

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

Responsibilities:

• Worked on teh High Availability Architecture for teh Oracle Database as well as on teh Data Guard environment for Oracle 10g and 11g. Worked on teh Grid architecture for teh 11g Database of side 10-15 TB.
• Worked with Development Team during teh Production Release (1203 and 1204).
• Played a major and key role during teh Data Center Movement. Made sure proper valid backup is available for all Production environments before initiating shutdown of all teh environments during teh Data Center Movement.
• Restored teh Database services first followed by all Application Services for Production environments as well as Non Production environments.
• Worked on Oracle Applications (11.5.8, 11.5.9, 11.5.10 and R12.2), Tech Stack (Discoverer, IAS, Discoverer, JDK, Jinitiator, and Developer6i) and Oracle Application Server.
• Recovered Datafile for Data Warehouse Production Database from getting to size ZERO due to DATAFILE Corruption. dis recovery procedure was initiated from taking backup from DR Database as their was no valid backup available for Production Database environment.
• Worked on Gloden gate version 11g.
• Worked on RAC and ASM environments on Oracle 10g R2, 11g R1 extensively doing troubleshooting and monitoring teh 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 teh connectivity with teh database. Worked with Oracle Support on troubleshooting some of teh 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 teh environments (Production and Non - Production). Performed troubleshooting on Standby environment to resolve issue with wrong datafile name causing MRP to stop.
• Created all teh Development Databases by taking cold backup from QA databases.
• Worked on Oracle Applications (11.5.8, 11.5.9, 11.5.10 and R12.2), Tech Stack (Discoverer, IAS, Discoverer, JDK, Jinitiator, and Developer6i) and Oracle Application Server.
• Worked on Application services of Development / QA Databases to make changes in teh appropriate files or directories to get them ready for daily batch.
• Performed troubleshooting on any kind issues on Application environment. Monitored teh space for all teh 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 teh restore after Data Center Movement.
• Restored all teh Production as well as Non - Production databases (Oracle and SQL Server) along with their application services from complete Power Outage 2 times.

Confidential

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.
• Worked on Oracle Applications (11.5.8, 11.5.9, 11.5.10 and R12.2), 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 teh Oracle10g, Oracle 11g also monitored teh flashback logs on a daily basis. Also used Flashback query feature to restore teh data to a previous point of time.
• Sound noledge 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 GE, Bank of America, Church Pension Group, MF Global 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 teh disk groups. Monitoring teh environment as well as performing troubleshooting on 10g ASM instances.
• Troubleshooting of Weblogic server, Apps server, SOA suite, BAM server, and monitoring teh 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 teh 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

Responsibilities:

• Installation, configuration, maintenance, as well as monitor teh database (SQL Server 2000, SQL Server 2005, Oracle 10g, Oracle 11g) in teh 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 teh 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 teh supervision of my Professor taking care of Technical issues for teh Management Department inside our campus.

Confidential

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 teh role was to setup teh environment for teh project which was completed efficiently and created all teh tables in SQL Server, loaded it raw data. Linked all teh tables using Parent-Child relationship to give it a normalized look.
• Helped my teammates in designing teh front end using ASP.NET to make it work in live environment.
• Checked teh SQL Server database for performing teh 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 teh performance of DB by checking through dynamic performance views, Active session history also checking for teh SQL statement tuning.
• Creation of Database objects and checking their status on an hourly basis to check for an update.
• Monitored teh database environment using OEM like creating objects if required, managing scheduled jobs.
• Online backup of teh 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 teh database both on Oracle Database for few environments as well as on SQL Server for rest.
• Involved in backing up both teh 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:

• Has major role in teh 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 teh records and teh records used to keep 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 teh Backup in that system and has put several copies in different systems excluding one in our Head Quarter. As we no that we can keep up to 10 destinations in oracle 9i so it was never a problem for me. Undoubtedly teh 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 rally working for companies like IBM, TCS and COGNIZANT TECHNOLOGY SOLUTIONS.
• Worked extensively using OEM monitoring multiple database environments for any alerts, checking for AWR reports, ADDM reports and also running jobs for teh 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 teh DBA’s regarding teh status, performance and space management of teh database.
• Knowledgeable in using OEM Features and worked with databases which has critical and BLOB data.

• Used TKPROF to find out tracing of which user has occupied more of teh CPU time by executing longer queries, STATSPACK to find out teh statistics of teh database, worked on wait event based tuning, memory tuning, logical structure tuning, I/O tuning.