NILENDU RAHA

MS (COMPUTER SCIENCE, NYIT, US)

Sr. ORACLE DBA

EMAIL ID: ad4xui@r.postjobfree.com

CONTACT NUMBER: 917-***-****

PROFESSIONAL SUMMARY

Experienced Oracle Database Administrator with strong skills in Oracle Implementation, delivering maintenance related tasks, several application automation and performance optimizations, thereby providing excellent support to customers for almost 18 years working on various Oracle Database versions from 9i to 19c along with Windows and Linux platforms. Strong knowledge in MySQL and GoldenGate implementation in UNIX platform along with all maintenance tasks like monitoring, troubleshooting, performance tuning and more. Worked intensively and closely in various application related projects in the SDLC process for Oracle and MySQL. Strong Leadership quality for training Junior DBA’s guiding them through the entire Oracle related topics such as DB performance tuning, troubleshooting features, managing projects, dealing with clients.

TECHNICAL ENVIRONMENT

Operating Systems

Windows 95/98/NT/2000/XP,2003,2007, 2010, VISTA, UNIX, Windows server 2003, AIX, Solaris

RDBMS

Oracle 19c, 12c (OCP), 11g, 10g, 9i (OCP), SQL Server 2000, 2005, 2012, 2016

Languages

SQL, PL/SQL, C, C++, Python

Document DB

MongoDB

DB Management

Enterprise Manager Console

Cloud Platform

Snowflake, AWS, GCP

Tools/Utilities

RMAN, OEM, SQL Navigator, Oracle Management Service (OMS), SQL*Loader, SQL Developer, TOAD, Power BI

Export/Import, Data Pump

Replication

Golden Gate 11g, 12c

Version

Oracle Database - 9i (Release 1 and 2), 10g (Release 1 and 2), 11g (Release 1 and 2), 12c Release 1 and 2, 19c

Tuning Tools

TKPROF, EXPLAIN PLAN, SQLT, AWR, ASH, ADDM, SQLHC, SQL Tuning Advisor, SQLHC

CERTIFICATION:

Oracle 12c Oracle Certified Professional

Oracle 9i Oracle Certified Professional

EDUCATIONAL QUALIFICATION

Master of Science in Computer Science, New York Institute of Technology, New York, US.

Bachelor of Engineering in Computer Science, Krupajala Engineering College, BBSR, India.

PROFESSIONAL EXPERIENCE:

Employer: Technosoft Corporation

Client Name: Deloitte, Little Rock, AR.

Period: From Jul’2018 to Present.

Role: Sr. Oracle Database Administrator

Environment: Oracle 12C R1, 12C R2, 19c (Linux, AIX, Solaris), MYSQL

Responsibilities:

Managing and maintaining Oracle databases from 12c as well as 19c of 1 TB of data.

Supported Developers in their SDLC process, also troubleshoot for any issues in this process as well as in the designing of new software products and tools to aid in the growth of the company in various aspects.

Strong knowledge in MYSQL implementation, maintenance, troubleshooting assisting the application team in SDLC Life Cycle.

Experience in taking MYSQL database backup and restoring the environment to resolve any issues.

Experience with VMWare Application and VirtualBox.

Strong experience in UNIX operating system and its installation in VMware and Virtual Box.

Strong knowledge of using SQL Developer and TOAD to perform Database activities.

Experience in refreshing MYSQL database to resolve any data issues.

Automated the refresh of Oracle Database from Higher environments to Lower environments while maintaining data security through effective role implementation.

Worked on DB Upgrade from Oracle 12c to 19c across all the database in Oracle.

Worked on DB cloning as part of maintenance and support activity.

Strong knowledge in managing databases in Snowflake in cloud and load data from

AWS S3 storage and GCP storage bucket.

Basic working knowledge in Amazon Web Services and Google Cloud Platform and loading data into Snowflake.

Worked on tuning the performance of the application to make it faster thereby resolving bottlenecks.

Worked on applying Database Security patches Quarterly basis.

Possess knowledge in writing programs in Python.

Worked on setup Standby database, standby rebuild, and have also resolved Standby Lag in Production environment.

Worked on restoring Databases from Backup from tape as well as from disk.

Worked with System Admin, Application Developers to implement successful DR Testing.

Worked with Oracle Support on troubleshooting some of the Database and Application server

issues.

Worked closely with the application, writing Shell Script to automate many projects codes.

Worked closely with the Application team and Business Intelligence team and have good knowledge to generate reports using Power BI tools and display the current business trends with the Business stakeholders and clients.

Possess working knowledge in MS SQL server and its concepts to implement in real world.

Worked with data migration from MS SQL Server 2016 to Oracle Databases using SQL Developer Tool.

Employer: Wipro Ltd

Client Name: Citi Group, Jacksonville, FL

Period: From Dec’2013 to Jul’ 2018.

Role: 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 R2, Linux, AIX, Solaris, MSSQL Server 2012

Responsibilities:

Strong Leadership quality for training Junior DBA’s guiding them with DB performance tuning, troubleshooting features in Oracle 9i, 10g, 11g, 12c.

Worked on the Grid architecture setup for both 10g, 11g and 12c environment.

Worked on different database versions like Oracle 9i, 10g, 11g and 12c on the installation, maintenance, and configuration, troubleshooting of 10g (Real Application Cluster), 11g (Real Application Cluster) on Linux and AIX environment of sizes up to 100 TB.

Worked with data migration from MS SQL Server 2012 to Oracle Databases using SQL Developer Tool.

Worked on MSSQL server version 2012, performing daily maintenance activities and scheduled activities like applying patches, storage management.

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) and Oracle 11g to 12c 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 the environments.

Strong working experience on Linux, AIX, Solaris environment writing scripts to provide support for Performance Tuning using various tools and methodologies and implementing effective Backup & Recovery solutions.

Worked on Implementing CI/ CD for supporting Application release using Automation.

Strong knowledge on Golden Gate on version 11g, 12c implementation, troubleshooting different issues, monitoring the environment, patching, and patching. Extensively used Golden Gate Veridata tool to compare the source and target and resolve any issues.

Configured Data Guard environment along with Data Guard Broker for Standalone as well as RAC on 11g R2.

Worked on migrating databases from physical servers to Cloud. Applied DB patches on Cloud.

Enabled partitioning option on the Database level and have worked on Table and Index partitioning. Assisted Developers on implementing partitioning to improve query performance.

Used Flashback Database, Flashback table, feature to recover the Oracle10g, 11g and monitor the flashback logs daily.

Worked with Oracle Support on troubleshooting some of the 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 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.

Employer Name: Apex Technology Group

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

Worked on the High Availability Architecture for the Oracle Database of several TBs 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 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 the environments.

Strong experience on UNIX environment writing scripts to provide support for Performance

Tuning, Backup & Recovery.

Monitored 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 an 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 daily and add datafile when required or resize the tablespace.

Worked with SA / Network Administrator to increase the space in oracle mountpoints.

Regular Monitoring of the archive gap on Production environments and fixed them if there 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 the Oracle10g, 11g and monitor the flashback logs daily.

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 and Development databases.

Decommission QA and Development databases to upgrade the cluster.

Employer: Computers Guru INC

Client Name: InterBoro AutoOne Insurance

Period: From Feb’2012 to Sept’ 2012.

Role: 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 of side 10-15 TB.

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 to provide support for Performance

Tuning, Backup & Recovery.

Worked extensively on installation, maintenance, backup, and 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 daily. 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.

Employer: Technosoft Corporation

Client 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, Solaris

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 solutions for OnDemand customers.

Day to day activities involves the following responsibilities,

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

Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging On Demand Customer environments.

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

Experienced working on Oracle RAC (9i, 10g, 11g) environment.

Experienced 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 in UNIX environment writing scripts to provide support for Performance Tuning, Backup & Recovery.

Experience working in ASM environment. Creating disk group, adding disks to the disk groups. Monitoring the environment as well as performing troubleshooting on 10g ASM instances.

Worked extensively using OEM monitoring multiple databases for any alerts, checking for AWR reports, ADDM reports and running jobs for the Backup.

Identifying, analyzing, and resolving technical problems related to Oracle software systems.

Restored 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 monitoring 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 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 a 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 by using AWR Report in Oracle Database and 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, 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, it was never a problem for me. Undoubtedly the database was large, and we used to monitor it 24/7, writing RMAN scripts, performing 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 my students are currently employed by 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 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.

Contact this candidate