NILENDU RAHA

MASTER OF SCIENCE (COMPUTER SCIENCE)

ORACLE DBA

EMAIL ID: aczbdt@r.postjobfree.com

CONTACT NUMBER: 516-***-****

PROFESSIONAL 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.

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.

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 ENVIRONMENT

Operating Systems

Windows 95/98/NT/2000/XP,2003,2007,VISTA, UNIX (korn shell), Windows server 2003,

AIX,

RDBMS

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

Languages

SQL, PL/SQL, C, C++.

DB Management

Enterprise Manager Console

Tools/Utilities

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:

Name: Wipro Technologies, Jacksonville, FL

Period: From Dec’2013 to Present.

Role: 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 Citi Bank 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.

Name: FedEx Ground, Coraopolis, PA

Period: From Nov’2012 to Oct’2013.

Role: 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:

As a Oracle Database Administrator in FedEx Ground the list of responsibilities performed by me includes the following,

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.

Name: InterBoro AutoOne Insurance

Period: From Feb’2012 to July’ 2012.

Role: Oracle DBA

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

Responsibilities:

As an Oracle Database Administrator and SQL Server Database Administrator worked in InterBoro AutoOne Insurance Company. The list of responsibilities performed by me during this time period which includes the following, Installation, maintenance, troubleshooting of Oracle Database 10.2.0.4 and 11.2.0.1 as well as Application Servers.

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.

Name: Oracle Corporation (Oracle On Demand Command Center), CA

Period: From Sept'2010 to Sep’2011

Role: Oracle DBA

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

Responsibilities:

Worked as an Oracle Database Administrator in Oracle On Demand Command Center. Command Center team specializes in expert level host system and application restoration to minimize outage downtime and maximize system availability. Command Center is also responsible for first level outage reporting, root cause analysis, and corrective action identification. Command Center develops and promotes long term solutions in the areas of operations process improvement, configuration management, and product enhancements to increase overall system reliability. The team develops, tests and executes (if needed) disaster recovery solution for OnDemand customers.

Day to day activities involves the following 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 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 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.

Name: New York Institute of Technology, Old Westbury, NY

Period: Sept’2008 to Dec’2009

Role: SQL Server (2000, 2005), (Oracle 10g, 11g),

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.

PROJECTS (New York Institute of Technology):

Project Title: Customer Support System, NY

Place: New York Institute of Technology

Period: From Sept'2008 to Dec'2008

Role: 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.

Name: Toyota Dealer, NY

Period: From Jan'2009 to May'2009

Role: 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.

Name: New York Institute of Technology

Period: From May'2009 to Dec'2009

Role: 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.

Name of Company: NIIT, India

Period: Sept ‘2004 to Dec’2007

Role: Oracle DBA

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

Industry: IT Training Industry.

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 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 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 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 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.

CERTIFICATION:

Exam 1ZO-007 - Introduction to SQL - Oracle 9i – In this paper I have learned basic stuffs related to oracle database like SQL statements and its different operations.

Exam 1Z0-031 - Oracle 9i Database Administration Fundamentals I –This is the most important section of this training program. Here we get a chance to know in complete details how an Oracle database works. How it utilizes the memory, its processes, backup operation, physical and logical structures of the database, how it stores records and how to manage users and its resources.

Exam 1Z0-032 - Oracle 9i Database Administration Fundamentals II – This paper was completely on the different types of backup and recovery operation used in Oracle databases whether it is by using RMAN or even user managed. I was also able to learn about import and export operation using SQL Loader.

Exam 1Z0-033 - Oracle 9i Database Administration Performance Tuning – This is the most vital section of each and every DBA. Here I got a chance to handle the Oracle database in my own hands. I could even tune the base according to my requirements. As I started working with the Oracle database I adapted myself to these changing requirements so that I never go out of memory space. I also learned how to tune the SQL statements, use TKPROF utility, and determine statistics about the database by using STATSPACK. There are also different dynamic performance views that actually help a lot to tune the database which actually helped me to work in future in my office as well as in my school projects. I also learned how to allocate resources to users or to a group of users. More importantly it was the ultimate training that I received to gain my knowledge regarding Database Administration.

EDUCATIONAL QUALIFICATION

Masters of Science in Computer Science, New York Institute of Technology, New York, US. Bachelor of Engineering in Computer Science, Krupajala Engineering College, BBSR, India

Contact this candidate