Mastan Reddy Nimmanapalli

+1-919-***-****

act90y@r.postjobfree.com

Profile Summary:

Mastan Reddy Nimmanapalli, A Lead Oracle DBA is an Information Technology Graduate having over 9 years of Experience in Oracle Databases 10g, 11g, 12c and Oracle Fusion middleware Products (11g).

Oracle rdbms Database Installation, Upgrade, Maintenance and 24*7 support for Oracle Database Server 12c,11g,10g on Linux, Solaris, Red hat Linux, AIX operating systems.

Migrating and maintaining Oracle database from Linux to Solaris Operating Systems.

Extensive experience in implementing and handling Replication technologies Oracle Golden Gate.

Experience in coordinating and implementing Oracle PSU, CPU Quarterly patching activates.

Extensive experience in handling Multi-Terabyte Database migrations/Consolidations with minimum/no downtime.

Applying patches to the RDBMS Oracle home using opatch utility.

Cloning oracle database from production to development instances using cold, hot and RMAN backup.

Proven Experience in implementing high Availability using Oracle RAC 11g, Oracle ASM & Oracle Cluster ware servers.

Experience on migrating oracle database to Amazon AWS instances.

Experience in Oracle Exadata Database Machines.

Experienced with all facts of Oracle DBA day-to-day activities like production database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.

Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM, Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.

Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.

Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, Public IP, SCAN IP and Virtual IPs.

Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.

Well experienced in managing data files, redo logs, tempfiles, contolfiles and archive log files.

Excellent knowledge of Oracle Architecture, SGA, Listeners, tnsnames, SQLNET.

Proficient in maintaining Data Integrity, Profiles, Resources, Password Security, Users, Privileges, and Roles.

Knowledge in SQL* PLUS, PL/SQL, UNIX Shell scripts (ksh and bash).

Responsible for monitoring and tuning the performance of queries and instances of production and stage databases using oracle features 10046 event trace files, hints, stored outlines etc.

Ability to function successfully in a highly stressful, 24x7 mission critical environment.

Exceptional communication and interpersonal skills. Ability to work efficiently as a part of the team and individually. Possessing excellent developmental and analytical skills.

Supporting a customer base & troubleshooting issues in production environment involving internet technologies.

Exporting & importing data into the databases using Oracle utilities such as exp / imp and data pump.

Interfacing with customers, analyzing their needs and providing recommendations on capacity planning, upgrades, migration of database, application architecture.

Accountable for database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, developer/integrator relations, script development, documentation and DBA training.

Creating table spaces, user maintenance, database security imposition by creation and granting of roles & privileges, performance tuning, backups, tuning of SQL statements and support for oracle toolsets and utilities.

Preparing & maintaining servers, documentation & procedures, addressing performance bottlenecks Ensuring that goals of the process are achieved, restoring normal service as soon as possible based on customer perspective and within defined SLA.

Integrating, Configuring and Maintaining Oracle database with applications.

Installation, Configuration of Oracle Enterprise Linux, Red hat Enterprise Linux.

Creating and maintenance of OS users and privileges, maintaining permissions for directories and files.

Using the Crontab in UNIX and Scheduler for Automatic Tasks.

Operating System administration activities like installing rpm packages and software’s.

Supporting to service requests with development team.

Code migration from development instance to production instances.

Upgrading oracle rdbms software from lower version to higher version on Linux operation system.

Experience on MS Office Word, Excel for documentation.

Education:

Bachelor of Technology (B.Tech.) in Information Technology (2005).

Professional Experience:

Client : REMO Inc. (California - US) Jun 2015 – Till Date

Role : Oracle DBA Implementation

Employer : Extol Group Inc.

Environments: Exadata, RHEL6, RDBMS 11.2.0.3, 11.2.0.4, Golden Gate 11g, RAC.

Responsibilities:

Installation, Configuring and Maintenance of Enterprise level Oracle 12c, 11g databases on Linux, Solaris and Windows Operating systems.

L3 experience in Database administration and management activities including re-structuring, optimization and performance tuning, export and import data, L3 troubleshoot and diagnose issues.

Provide off hours support and maintenance as required, part of the 24x7 operations support on call rotations

Daily monitoring the oracle production databases and supporting to the oracle servers.

Cloning oracle database from production instances to development instances on Linux operating systems.

Taking cold, hot and RMAN backups of database and application.

Oracle Infrastructure management for managing the database.

Installation and Configuration of Oracle Database 11g on Amazon AWS instances.

Upgrading oracle database from 11.2.0.3 to 11.2.0.4 on Amazon AWS servers.

Migrating database into Amazon AWS instance Oracle databases using import and export utilities.

Installing and configuration of Oracle Golden Gate 11g for database replication.

Managing oracle database tablespace, archive logs for improving the performance of the database and operating system.

Configuration of Oracle Physical standby database for disaster recovery and reporting generation.

Working on Oracle Exadata database Machines which is providing high performance transactions.

Migrating database from non-Exadata database machines to the Exadata database machines.

Configuring the Oracle Database Vault 11g for database security.

Assisting in performance tuning production pre/post go-live on both database/applications level.

Design on How/When to run different concurrent requests and scheduled jobs accordingly to reduce load on the system and provide better performance.

Alert management, Created and setup alerts to send notification to Users from application wherever necessary.

Perform day to day activities like backup-restore, space management, monitoring database alerts, performance tuning.

Installation and configuration of Oracle 11gR2 RAC on Oracle Linux OS.

Applied PSU patches and other database related patches.

Configuring the Oracle Transparent Data Encryption for protecting the database.

Have a good experience in administering Oracle Cluster ware components.

Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.

Upgraded Oracle Databases from 11gR1 to 12c.

System administration activities like creating os users and providing proper permission and privilege for accessing different directories and files.

Monitoring operating system performance using top command.

Client : BILT Avantha. (Bangalore – India) Nov 2014 – May 2015

Role : Oracle DBA Implementation

Employer : Wipro ltd.

Environments: Exadata, RHEL6, RDBMS 11.2.0.3.

Responsibilities:

Upgraded Oracle Databases from 11gR1 to 11gR2.

Experienced with all facts of Oracle DBA day-to-day activities like production database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues.

Responsible for Installation and administration of Oracle RAC 10gR2 and Oracle RAC 11gR1 production and development databases.

Provided 24*7 Oracle product support.

Experience on Oracle 12c Oracle database.

Implementation of Oracle 11gR2 RAC on Solaris Operating System.

Performed cloning using cold, hot and RMAN backup to set up development and test databases from Production database.

Responsible for installing and maintaining the Standby database.

Hands on experience in administering Tablespace Management, User Management, UNDO management.

Used Data Guard broker to monitor Data Guard configurations on standby database.

Good working and implementation knowledge on Data Guard and Stand-by databases for fail-over and recovery.

Configured Net Backup with RMAN for database backups and restore. Also implemented logical, cold and hot backups.

Applied patches whenever necessary by downloading them from Metalink.

Rebuilt indexes for better performance of Oracle database.

Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.

Client : Sony Global Solutions. (Bangalore – India) Jan 2012 – Oct 2014

Role : Oracle DBA Implementation

Employer : Oracle India pvt.

Environments: Exadata, RHEL6, OEL5, Solaris, RDBMS 10.2.0.2, 11.2.0.3.

Responsibilities:

Day-to-day activities like production database monitoring, Backup using hot backup, Cloning and patching.

Install and configuration of Oracle rdbms database 10g and 11g on Linux Operating System environments.

Have good experience in administering ASM disk Groups.

Supporting to Oracle 11gR2 RAC production servers.

Responsible for all regular Database administrative activities.

Hands on experience in installing and administering Oracle WebLogic server 10.3.6.

Implemented Oracle Golden Gate installation, configuration, troubleshooting GG issues.

Building test strategies, backup & recovery models for Oracle. Refreshing test databases.

Going through the day-to-day user requests and troubleshooting the database related problems.

Responsible for Online/Offline database backups and managing Database recovery with RMAN.

Worked with Oracle Support during ORA-600 and ORA-7445 issues.

Wrote scripts to improve the performance of importing indexes.

Cloning of database for development and test environments.

Plan golden gate setup to achieve unidirectional replication.

Replication and Extracting data and applying on production using Golden Gate.

Implemented Change Synchronization Golden Gate Replication.

Prepare Golden Gate parameter files for Extraction and Replication.

Support performance testing team during weekend tests.

Control user access and monitor space consumption.

Applying patches using OPatch utility into Oracle Home.

Experience in using imp, exp, expdp/impdp, sqlldr, lsnrctl utilities.

Supporting to the development team for migrating the code from development to production database.

Reorganizing the tablespaces and indexes for improving the performance of database.

Integrating Oracle database with EBS applications and supporting to the application users.

.

Client : Electronic Arts. (Bangalore – India) Jul 2011 – Dec 2011

Role : Oracle DBA Implementation

Employer : Tata Consultancy Services.

Environments: RHEL, Solaris, RDBMS 10g.

Responsibilities:

Expert in Installation, Configuration and Maintenance of Oracle database 10g on Linux OS.

Migrated single instance database to multiple instance databases using export/import, data pump.

Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.

Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager.

Implementing 10g Data guard with one physical database.

Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.

Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purpose.

Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard).

Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.

Client : Oracle India pvt Ltd. (Bangalore – India) Mar 2010 – Jun 2011

Role : Oracle DBA

Employer : Kelly Services and Caritor Solutions.

Environments: RHEL, HP, Solaris, RDBMS 10g.

Responsibilities:

Expert in Installation, Configuration and Maintenance of Oracle database 10g on Linux OS.

Monitoring day-to-day activities like production database monitoring, backup using hot backup, Cloning and patching.

Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.

Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager.

Implementing 10g Data guard with one physical database.

Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.

Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purpose.

Weekend maintenance support for production instances.

Supporting to the development team for importing and exporting the database from production to development instances.

Client : Tata Consultancy Service. (Bangalore – India) May 2008 – Mar 2010

Role : Oracle DBA

Employer: SixSigma Soft Solutions Pvt. Ltd.

Environments: RHEL, AIX, Solaris, RDBMS 9i, 10g.

Responsibilities:

Performed administrative maintenance, monitoring Oracle Server database systems in a global 24x7 operational environment.

Supporting to the development team for importing and exporting the database from production to development instances.

Installed and Configured Oracle 10g databases on Linux.

Installed and configured Oracle Enterprise Manager 10g Grid Control.

Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.

Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.

Experience in setting up Oracle ASM storage for Oracle RAC databases.

Installed Oracle Data guard for Oracle Disaster recovery, High Availability and data protection.

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.

Created user accounts, roles and granting access permissions to the database.

Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups.

Role : Oracle Database Administration

Employer: Web2ph technologies pvt ltd. Aug’07 to Oct’07

Environments: RHEL, RDBMS 9i, 10g.

Responsibilities:

Day-to-day monitoring Oracle Server database systems and supporting for 24x7 operational environment.

Supporting to the development team for importing and exporting the database from production to development instances.

Supporting for Oracle 10g, 9i production databases on Linux.

Created user accounts, roles and granting access permissions to the database.

Weekend backup and administration activity on production and development instances.

Code migration from development to production instances.

Supporting with oracle product support service requests.

Role : Oracle Database Administration

Employer: iNetFrame Technologies Pvt Ltd. Jun’06 to Jul’07

Environments: RHEL, Solaris, RDBMS 9i, 10g.

Responsibilities:

Installed and Configured Oracle 10g, 9i databases on Linux.

Created user accounts, roles and granting access permissions to the database.

Weekend backup and administration activity on production and development instances.

Code migration from development to production instances.

Performed administrative maintenance, monitoring Oracle Server’s in a global 24x7 operational environment.

Supporting to the development team for importing and exporting the database from production to development instances.

Creating OS users and providing permissions for doing their daily activities.

Contact this candidate