Oracle Manager
Resume:
Naveen Chava
Sr. Oracle Database Administrator
**********@*****.***
Over 9 years of experience as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security. Experience with enterprise-scale data warehouse systems Experience in the design, maintenance, and administration of ORACLE 12c/11g/10g/9i.
PROFESSIONAL SUMMARY
Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.
Experience in Configuring and tuning of Oracle Real Application Cluster (RAC), CRS & ASM for high availability database.
Development and implementation of Enterprise database services standards, guidelines, processes & procedures, and best practices.
Good Experience in upgrading cluster to 12c and databases from 11g to 12c.
Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms.
Configure high availability systems like Data Guard and RAC environments.
Installation, Configuration and Maintenance of Logical/Physical standby databases in Data guard.
Installed and maintained Oracle 12c/11gR2/10g/9i, RAC with ASM & Oracle Cluster File system.
Providing DBA support to multiple Cluster, Non Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid) and Experience with Real Application Testing (RAT).
Experience in Implementing BACKUP and RECOVERY strategies using RMAN.
Responsible for data loading, security, capacity planning and backup and recovery.
Installation and configuration of Recovery Catalog for multiple Databases.
Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
Experience in Oracle Patching for 9i, 10G, 11G and 12C using opatch and opatch auto.
Implementing user level security, object level security, data encryption, data masking, fine Grained auditing using DBMS_FGA package.
Upgraded and migrated Oracle databases from 10g to 11g and 11G to 12C.
Hands on experience in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACTS, PUMPS and REPLICAT issues and migrated databases with ZERO downtime.
Having good experience working on EXADATA X4-2 Half Rack smart flash cache, storage indexes, storage management and migration.
Worked on calculating celloffload efficiency for sql statements running on Exadata databases.
Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA and the basic, low, high compression methodologies.
Experience working with IBM-TIVOLI.
Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment.
Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
Managed testing, assisted Developers, and created backups by Exporting and importing tables when needed.
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
Experience in handling Oracle features such as table partitioning-sub partitioning, Oracle Streams (Replication) Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases.
Experience in maintaining Extraction Transformation and Loading (ETL) tools for Reporting Solutions.
Developing Unix shell scripts (cron and Perl) to extract data from ETL database environment as reports and importable delimited data sets.
Applying PSU Patches and interim patches whenever required to make the database software up to date.
Proficient in SQL, PL/SQL, Perl Scripting, Shell Scripting, ERwin Data modeling, OLAP, Oracle Data Dictionary – meta data, Logical and Physical Database Design.
Written shell scripts to monitor Oracle services, Golden Gate processes, to upgrade databases from 10g to 11g, to automate startup/shutdown of Oracle database, to migrate database from one server to another.
Expertise in developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
Extensively used BMC Remedy, HP Quality Center ticketing systems & HP Java ITO (OVO) Console for monitoring.
Responsible 24x7 production operations (incident break/fix, change, service requests, management) and On-Call rotation
PROFESSIONAL EXPERIENCE
DELTA AIR LINES, Atlanta, GA Oct’15 – Till present
Sr.Oracle DBA
Responsibilities:
Worked as Application DBA and operation database administrator (ODBA) and Responsible to provide 24x7 database administrative activities over 2500+ databases.
Writing documentation for Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g and 12c Dataguard Standby Documentation.
Worked on RAC and ASM, building and supporting 11GR2 / 12C RAC clusters using ASM storage.
Successfully setup 2,3,4 Node 12c RAC Cluster and RAC dataware house as ASM and ACFS.
Up gradation of GRID infrastructure from 11.2.0.2 and 11.2.0.3 to 11.2.0.4 and troubleshooting Issues using Clusterware logs in 12c and 11g RAC Environments.
Upgraded GRID infrastructure from 11.2.0.4 to 12.1.0.2 and Performed Health checks of Ocr, Voting Disks and Interconnect for better performance in RAC environment (11GR2 and12CR1).
Worked on Tuning the RAC interconnect, Finding RAC wait events & resolving issues in environment.
Responsible for provisioning, maintaining and improving upon server infrastructure, split between physical data centers and AWS.
Adding a New Node to 3 Node cluster and Installed Oracle RDBMS software on new node of cluster.
I migrated my department from a physical data center environment to AWS.
Upgraded Databases from 11.2.0.2 to 11.2.0.4 and 12.1.0.2 with Minimal Downtime.
Administrating ASM using asmca and asmcmd, creating diskgroups, dropping and adding disks.
Created ASM Volume using ASMCA and Created ACFS for Golden Gate v12 and Installed Golden Gate on ACFS.
Installed and configured Golden Gate 11g and 12c on AIX 6.1 and RHEL 5.8,6.7 platforms.
Configured Integrated Extract and Replicate on Oracle multitenant database 12.1.0.2.
Configured Extract and Replicate pumps for golden gate replication 11g/12c and Troubleshooting issues in GOLDENGATE Environment using report files & log dump.
Performed Cross platform migration and used Oracle Golden Gate to migrate databases from Aix to Linux as a part of Oracle Phase3 migration project.
Performed Zero-Down Time migration from AIX to RHEL using Expdp and Golden Gate.
Installed Oracle Golden Gate Veridata and Agents and created jobs compare data between instances and Used Log dump Utility to Investigate data on the trail.
Configured BI-DIRECTIONAL replication and replicated tables between instances and used CDR parameters to resolve conflicts.
Worked in Build Team, installed and configured Container Databases and Non container in 12c Environments and Deployed Trigger to Open Pluggable database and Cloning the pluggable databases on CDB$ROOT.
Creating services using dbms_service on pluggable databases in both RAC and NON RAC environments.
Installed OEM 13c on database 12.1.0.2 and Monitoring databases using Grid Control 10g/11g/12c and 13c for Configuration of error notifications and adding them to the grid control.
Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using dbms_scheduler.
Configured Physical Standby databases using data guard in maximum performance & availability.
Converted Physical standby to Snapshot Standby 11g according to Business Requirement.
Configured Active Data guard 11g Troubleshooting Out of sync issues in Data Guard environment.
Configured Data guard Broker and used for switchover and stopping and Starting Media recovery process and performed disaster recovery testing.
Applied PSU quarterly on 11g/12c GRID & RDBMS homes and Up-gradation of 11g/12c databases.
Implementing catalog backup from RMAN using Oracle Enterprise Manager.
Implemented Flashback technology and Supported DDL and DML changes in environment.
Performed Data Refresh from Production to Test and Development environments using RMAN Backup and RMAN Duplicate Database.
Used RMAN for backups and recovery and configured databases in Catalog server and involved in backup of Catalog database.
Performed Block Recovery and Data file recovery and configured Full, Incremental and cumulative backups using RMAN for prod, test and dev Environments.
Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing at different levels, and analyzing security problems.
Implemented 12c Oracle Advanced Security using TDE (Transparent Data Encryption) and Enabling Auto Login for the Keystore for cdb$root and Pluggable databases.
Used Expdp and Impdp for exporting and importing of database objects between databases.
Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls.
Performance testing and monitoring database sql queries to meet Service Level Agreements (SLA).
Trouble Shooting of performance and tuning problems by Generating AWR, ASH, ADDM Reports, and OEM GRID Control for Database Issues & Used TKPROF to analyze the trace files.
Performance Tuning for the SQL queries by Created SQL-Tuning sets and SQL BASELINES for plan stability and change execution plan of BAD SQL’s statements running on databases.
Analyzing database performance and tuning 12c databases using Real Application Testing (RAT).
Used ADRCI for creating IPS packages for incidents on database and Alert Log Monitoring for critical databases every day in the production environment.
Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
Provided support to Application Database Administrators in designing the database
Coordinated with developers and Users connecting to different databases, setting policy for database maintenance, backup and recovery.
Worked with offshore team and coordinating with databases, scheduled and attended day to day meetings as part of Agile methodology.
24x7 production DBA support, Application and development DBA.
Environment: Oracle 11g/10g/12c, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.7, Windows 2008, OEM11G/12c, RAC11gR2/12c, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL, Database10g/11g/12C, RMAN, DATAPUMP, 10g/11g, Goldengate11g, 12c, Oracle Golden Gate Veridata, Veridata console, WebLogic console, Datagurd11g/12c, Explain-Plan, SQL-T, SQL-HC, FLASHBACK, AWR, ADDM, ASH reports, Oracle Patching OPatch, SQL Developer, Migration, dbms_profiler, dbms_scheduler, PL/SQL Tuning, Data Pump, Business Objects, putty, TOAD 11.6, Oracle-Wallet-Management.
PEPSICO/HCL AMERICA, Plano, TX July’14 – Oct’15
Sr.Oracle DBA
Responsibilities:
Installation, configuration and maintenance of Oracle 10g, 11g and 12c databases on AIX.
Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups, scheduling the databases backup using Cron tab.
Functioned on databases ranging from 500GB to 5 TB and handled over 300 databases and 60 Applications.
Taking the RMAN incremental and cumulative backups.
Monitoring the Oracle Instances, Users, Tables, Table spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
Expertise in moving databases to Exadata and Involved in migration strategies.
Implemented several new features in Exadata concepts like Hybrid Columnar compression (HCC), Smart Cache, Storage indexes and cell offload processing.
Familiarity with CellCLI tool to manage the Exadata storage cells.
Designed and developed Packages, Procedures, Functions and Triggers to handle errors and exceptions at database level.
Configuration of Listener and Net Service names using NETCA.
Expertise in Installing and configuring ASM and RAC for high availability databases.
Worked on Multiple 12c RAC clustered, converting single node instance to 12c RAC and adding instance to the existing 5 Node 11g RAC.
Involved in migrating databases from single instance to 12c RAC environment.
Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability.
Responsible for capacity planning, recovery planning and installing patches.
Developed Unix / Windows scripts for Primary / Standby switchover and failover, RMAN backup / recovery, Data pump export / import, purging archive log files, old backup files etc.
Installed 12c agents on hosts and discovered targets.
Worked on Oracle Advanced Security provides standards-based network encryption for protecting all communication to and from the Oracle Database.
Configured and implemented Oracle Golden Gate replication.
Resolving the conflicts between the target and source database in Oracle Golden Gate.
Comprehensive knowledge in Database Architecture & Implementation, Data Models, Database design.
Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
Proficient in using SQLT, Oracheck, raccheck, Sql360, OEM Advisory utilities for Performance tuning.
Extensively used AWR, ADDM, AWR Sql Report, SQLT, and EXPLAIN PLAN for performance tuning of the database and perform Root-cause-analysis for any issues.
Install, maintain and monitor Web Logic server as part of OEM Grid Control setup.
Responsible for creating Heterogeneous Network links to DB2, Sybase and Teradata databases.
Proficient in working with Stored Procedures, Functions, Views, Cursors, and Triggers in Oracle 10g, 11g, 12c and MYSQL databases using T-SQL and PL/SQL.
Handled all daily DBA activities and excellent experience with PERL/SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
Involved in 24x7 production database maintenance and on-call support.
ENVIRONMENT: Oracle12c/11g/10g/9i,Oracle EXADATA X4-2 HALF RACK, Sun Solaris, Red Hat Linux, RMAN, SQL server, Data Guard, Golden Gate, OEM 12c, Grid Control, Oracle Transparent data Encryption, Toad 10.X, STATSPACK, AWR, Explain Plan.
PNC BANK/ EMC Corporation, Chicago, IL Jul’13 - June’14
Sr.Oracle DBA
Responsibilities:
Installed and configured Oracle Enterprise Manager Grid Control 12c on RED HAT LINUX.
Experience in Administering Oracle Databases 10g, 11g and 12c using Oracle Enterprise Manager (OEM).
Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
Installation, configuration and maintenance of Oracle 11g and 12C RAC / OLTP database and OEM Agent. Applied CPU patches suggested by Oracle.
Configured Physical Standby database using Oracle Active Data Guard for disaster recovery, business continuity and reporting purpose.
Grid Control installation and setup, created monitoring templates, User Defined Metric for customized monitoring.
Comprehensive knowledge in Database Architecture & Implementation, Data Models, Database design.
Experience in Design, Creating and maintaining the Oracle Databases 11g from the scratch on UNIX and RHEL.
Experience in backups and recovery using RMAN Shell Scripts.
Developed the Perl and Shell scripts to automate the finance-billing file.
Upgrading database from version 10.2.0.4 to version 11.1.0.7.
Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2.
Involved in the migration of huge databases of sizes ranging from 100GB to 7TB. Experience in moving the data from one server to another server using SFTP and SCP.
Installed and configured Golden Gate replication and Migrated databases with Zero down time using Golden Gate and Data guard.
Tuning of SQL queries using AWR, ASH, SQL Tuning Advisor, ADDM, Explain Plan, Stats gathering etc.
Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
Responsible to provide 24 x 7 database administrative activities over different database servers.
Creation of database objects like Tables, Indexes, Views, Users, and DB Links using Sql scripts.
ENVIRONMENT: Oracle 10g/11gR2/12c, OEM, Data guard, SQL Loader, RMAN, Data pump, MS*SQL, Netapp, Oracle 12c RAC LINUX, ASM, PL/SQL, GOLDEN GATE.
AMERITAS, Cincinnati, OH Jun’12 - July’13
Sr. Oracle DBA
Responsibilities:
Oracle database installation, patch installation, configuration, and maintenance. Installed and configured enterprise manager agent using Oracle Universal Installer (OUI).
Installation and configuration of OEM 12c Grid Control for various databases for centralized monitoring and administration of hosts / databases.
Migrate Oracle 9i databases to Oracle 10g and 11g RAC databases.
Configuration and maintenance of logical and physical standby database, Oracle 10g and 11g RAC 3-node cluster database and regular databases.
Involved in construction of DR sites for all the Production databases.
Created and modified existing Unix scripts for Oracle 10g. Migrate local file system database to ASM database.
Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
Scheduling the databases backup using Cron tab and VERITAS net backup.
Backup and Recovery using RMAN, Datapump Export and Import using Oracle 10g new features.
Involved in implementing load balancing and testing failover on RAC database.
Configuration of Listener and Net Service names using NETCA.
Performance and Tuning of database by identifying bottleneck in SQL queries and batch processes using Explain plan, AWR reports and Grid control.
Responsible for capacity planning, recovery planning and installing patches.
ENVIRONMENT: Oracle 11g/10g, OEL, HP-Unix 11.11, Red Hat Enterprise Linux, RAC, ASM, SQL*Plus, OEM, PL/SQL, SQL Developer, Data Pump, TOAD.
ANNTAYLOR, New York City, NY Feb’11 - May’12
Sr. Oracle DBA
Responsibilities:
Involved in monitoring the Database related activities using Oracle Enterprise Manager 11g Grid Control (OEM Grid) and monitoring the backup jobs scheduled in OEM Grid.
Setting Dataguard Physical Standby database.
Worked with ETL and Reporting team for tuning of complex data warehouse queries and batch processes.
Tune the SQL queries by creating proper index, using hints and changing database parameters.
Installed, configured and monitored Oracle RAC11gR2 and 10g with ASM.
Migration of databases from MS SQL server 2008 and Oracle 11g.
Involved in applying CPU and PSU patches for Oracle Server.
Configured and implemented Oracle Golden Gate replication.
ENVIRONMENT: Oracle 9i, 10g & 11g, RHEL 4.2, IBM AIX 5.2, Windows XP, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, Import/Export, Tuning Advisors, TOAD, Oracle 10g RAC, Sybase, SQL Server 2005.
CHARTISINSURANCE, Jersey City, NJ Jan’10 - Feb’11
Jr. Oracle DBA
Responsibilities:
Performed full and incremental Backup Using RMAN Utility for Production databases.
Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
Upgrade Production/development databases from Oracle 8.1.6 to 8.1.7.4 to 9i with Installation, Applying patches, Parameter Setting.
Involved in deployment and configuration of system on client/server machine.
Extensively coordinated database and OS support with global vendor support team of Oracle, HP-Unix and EMC SAN Storage.
Creation of schema owners and all other database users.
Planning future storage requirement for the database.
Monitored ALERT Log files to keep tracking the Oracle Errors and make necessary actions to rectify them.
ENVIRONMENT: Oracle 9i/10g, Sun Solaris 11.x, AIX 5.2, Windows XP, GRID, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, RMAN, Import/Export, Tuning Advisors, TOAD.
HDFC BANK, Bangalore, India Jun’08 - Nov’09
Oracle Developer/DBA
Responsibilities:
Developed PL/SQL packages, stored procedures, functions, Cursors and Triggers.
Responsible for installing, upgrading and configuring the Oracle server.
Creating databases, Objects, Roles and privileges.
Partitioned large tables to increase the performance.
Responsible for optimizing the queries and application tuning.
Implement Hot, Cold and Logical backup plans.
Use TOAD tool to access the database.
Involved in development of application functions, triggers, PL/SQL and packages.
Involved in checking the status of listener and restarting listener.
Grant and Revoked user privileges and roles as per requirement and killed blocking session.
Performed auditing on user activities on request and per organization policies.
ENVIRONMENT: IBM AIX 5.3, RHEL, Oracle 9i/10g PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software (5.0), VERITAS Cluster, RMAN.
EDUCATION
Bachelors of Technology in Electrical and Electronics Engineering, India.
Contact this candidate