Manager Management
Resume:
NAGASIVESH
SUMMARY
Over ** Years of experience as Oracle DBA on Linux Red Hat, SUN/Solaris, IBM/AIX, HP-UX and Windows supporting Oracle Databases on RAC and non RAC versions from 12c(12.1.0.2),11g, 10g, 9i.
Excellent working experience in administrating Oracle 9i/10g/11g/12c databases, which includes database creation, configuration, development, security and backup/recovery.
Configured and supported Oracle 9i, 10g, 11g, 12c on Linux (RH-3.0 to 7.2)
Experience with setup and configuration of Oracle Data Guard / logical Standby and physical Standby databases
Monitored and optimized the Performance of the database, Tuning Management, capacity planning, created new technologies and SQL tuning using utilities/tools like explain Plan, TKPROF, Auto trace, AWR reports and STATSPACK.
Database upgrade and migration experience on various versions of Oracle Database (from 9i to 10g, 10g to 11g, 11g to 12c)
Oracle Server Installations/Upgrades, Space Management, Capacity Planning, Backup & Recovery using Manual and RMAN, Disaster Recovery, Database Performance Tuning, Memory Tuning, Security Administration, Data Architecting, normalization/de-normalization, Data Warehousing, Multithread Servers, Distributed Databases for Oracle 9i/10g/11g/12c Databases, table partitioning and Oracle Standby Server.
Experience in many systems development lifecycles (SDLC), from requirement development, architecture design, testing, and post implementation revisions.
Install/setup/configure Oracle Enterprise Manager (OEM) tools for monitoring of Oracle Databases.
Proficient with monitoring tools, Grid Control, generating AWR reports.
Creating users, roles and profiles, granting and revoking privileges and access for database object proactively using events and fixit jobs from OEM to monitor database high water marks.
Working skills in managing with features like Undo Management, Managing tables, indices, views, tablespaces, redo logs, etc using sqlplus, OEM.
Proficient in PL/SQL and Shell Scripting, SQL query tuning, Database performance tuning and Ebiz performance tuning
Good experience in platform migration from AIX to LINUX
Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
Extensively worked on Import/Export and Data Pump Import/Export tools.
Excellent knowledge in SQL, PL/SQL, Partitioning, Data modeling with utilities like ER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database Triggers.
Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).
Very good knowledge of Oracle Database architecture, SGA, PGA, Background Processes, Listener and TNS Names configuration and Data Dictionary.
Involved in Disaster recovery planning, execution and testing of production databases.
Expert in packages Oracle Enterprise Manager, TOAD, SQL Navigator, RMAN, Apache, HTML, Schema Manager. Working in environments constituting iAS, Oracle Self Service Web Applications, XML.
Worked On-call providing 24*7*365 days Support for production databases across organization.
Certification
Oracle 10g Certified Associate – DBA
Technical Skills
Operating Systems
Solaris, HP-Unix, Linux, Windows, AIX
Languages
SQL, PL/SQL
Databases
Oracle 12c, 11g, 10g. 9i.
Tools
Toad, Oracle Sql Developer
Project #6:
Client: Cisco Systems Inc. Apr-2013 to Till Date
Location: Sanjose, CA
Role: Sr Oracle DBA
Responsibilities:
Involved in upgradation of more than 20 Databases each sizing at least 200GB to 40TB from 11g (11.2.0.3) to 12c (12.1.0.2) & also involved in migration oracle databases from windows to Linux and 32-bit to 64-bit.
Installed, Implemented and configured Oracle 12c RAC Databases with ASM on Redhat7.2 as per Business requirement.
Day-to-Day Activities Include promotion of customization code, patching, cloning, and pre clone Activities, General Database Tuning, Troubleshooting, Providing client with solutions for Backup & Recovery
Worked with Application Team for Cisco Private Could estore for services Schema as a Service, Database as a Service
Providing solutions and inputs on enhancements to application team for Cisco Private Cloud estore.cisco.com.
Tablespace growth monitoring and day to day proactive monitoring of the databases.
Installation, Configuration and Administration of Oracle 12c RAC.
Converted a single instance database to Oracle RAC 12c.Configured the
Public Network/Private Interconnect for Oracle 12c RAC.
Performance Tuning of the database at memory level, SQL level, OS level.
Performing backups and recoveries using RMAN Backups.
Developed multiple automation scripts using shell script
Used Grid Control and OEW Tool to monitor regular day to day dba activities
Extensive experience on indexing and partitioning
Cloning/Refreshing production databases using RMAN.
Generated AWR reports via OEM Grid Control to investigate database workloads.
Project #5:
Client: American Airlines Inc. Jul-2012 to Apr-2013
Location: Dallas, TX
Role: Sr Oracle DBA
Responsibilities:
Developing Backup strategies (Snapshot, Hot, Cold) for weekend backups of important environments.
Cleaning the udump, cdump, bdump directories of large core files, user dumps.
Extensive Unix Shell Scripting to automate maintenance and configuration of tech stack components, Cron jobs to automate the backups, monitoring Alerts
Managing Change management, Release Management, performance issue queues.
Installation and Setting up of 11gr2 RAC with ASM on Red Hat 5.
Performing day-to-day database administration tasks like Tablespace usage, Monitoring alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.,
Worked on Automatic Storage Management (ASM) for managing Data Storage.
Performing the Yearly Standby- Dataguard Tests(Fail-over/Switch over) using DG Broker.
Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle installation, upgrading according to the standards & Quality assurance.
Experience ensuring the high availability and integrity of databases to applications.
Working on change management all configuration tasks, pre Configuration analysis and Pre State Analysis
24x7 Support for production Instances across organization.
Project #4:
Client: Ford Motor Company Mar 2009 to Jul 2012
Location: Dearborn, MI
Role: Sr Oracle DBA
Responsibilities:
Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
Involved in the process of tuning and refining queries of various applications.
Involved in team management, team building exercises for the Oracle team.
Installed Oracle 11g Data guard.
Wrote several shell scripts for checking Oracle errors in alert file and database backup log files.
Cloning of application from production environment to test environment and application of patches.
Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
Involved in installing, implementing 32 bit and 64 bit 10g/11g RAC on linux servers with ASM storage manager.
Performing hot and cold backups,Restoration and recovery from backup.
Conducting sizing and capacity planning for oracle databases.
Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.
SQL issues and Tuning Considerations for Different Applications.
Converted a single instance database to Oracle RAC 11g.Configured the
Public Network/Private Interconnect for Oracle 11g RAC.
Project #3:
Client: Johnson & Johnson Inc. Mar 2008 to Feb 2009
Location: Philadelphia, PA
Role: Oracle DBA
Responsibilities:
Database Installations, Creations and Upgrade from 9i to 10g on Redhat 5
Analyzed the structures using Analyze command.
Involvement in all phases of the project life cycle
Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
Worked with developers in Designing Schema / tuning PL*SQL/ SQL code
Performed Database Tuning for Oracle 9i/10g servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
Project #2:
Company: Visa Inc. May 2007 to Feb 2008
Location: Woodbridge, VA
Role: Oracle DBA
Responsibilities:
Backup Script creation and Standardization.
Implementad Oracle security features and audit mechanisms for Fine grained access control.
Maintained RMAN repository and customized recovery catalog.
Performed database tuning for daily loads and slow response issues.
Used Triggers for database activities, like delete, update triggers.
Used Statspack, perf stat and TKPROF utilities for Tuning and analysis.
Involved in session management and monitored critical wait events of database.
Involved In query optimization and using rule based optimizers and cost based optimizers.
Used SQL Loader * for data import from remote databases
Written control files in SQL*Loader to load files in database tables.
Project #1:
Company: Murfreesboro City Schools Jan 2007 to Apr 2007
Location: Murfreesboro, TN
Role: Oracle Developer
Responsibilities:
Writing stored procedures, stored functions, Packages, Exception handlers.
Writing Sql queries for front end developers.
Performance tuning to existing queries
Involved in Query Level Performance tuning using Explain Plans
Unit Testing, Module Testing and integration testing for existing Screens
Writing sql queries for Adhoc reports requested by Business management team.
Writing Data fix up Sql queries for production data
Contact this candidate