Ravi Kumar C

Contact: 469-***-****

Email: ac02wj@r.postjobfree.com

PROFESSIONAL SUMMARY:

•Around 2+ years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, Disaster recovery management.

•I strive to be a pillar with a strong foundation for my future and all this comes with a great opportunity.

•Excellent experience in Installation and configuration of Oracle11g, 12c, EXADATA in UNIX/LINUX and Windows environment.

•Good knowledge on usage of Logdump for debugging.

•Oracle DBA proficiency in installation, upgrading, patching, administration of multiple Oracle Enterprise Edition 11g, 12C databases.

•Building Databases, Standby databases on Oracle 12c.

•Good at installation, upgrade, administration, backup, recovery, performance tuning, patching, network administration of oracle (RAC and grid control) OEM 12c, 11gR2, 11gR1, 10g primary and standby databases using data guard, enterprise manager and shell scripts.

•Good experience in installation, configuration and administration of Oracle 11g RAC, Standby Databases for High Availability and Disaster Recovery purpose.

•I've involved in migration of Database and up gradation from Oracle 11g to 12g.

•Exceptional Knowledge of various states of Software Development Life Cycle (SDLC) i.e. System Analysis, Applications Design, Development, Integration & System Testing Support of Oracle 10g, 11g, 12c in Production, Staging, and Development environments.

•Developed backup and recovery policy and used new features/technologies to optimize system maintenance and extensive knowledge on Partitions

•Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges), space management of logical structures (i.e. table spaces, rollback segments) and auditing of users.

•Proficient in using Oracle utilities like export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.

•Expert in effective troubleshooting of production, development database environments on daily basis with Proactive performance monitoring for better performance in applications database using AWR and Oracle Enterprise Manager (OEM).

•Experienced in performance tuning of various aspects of the database by using oracle utilities like TKPROF, EXPLAIN PLAN, SQL_TRACE, TOAD and Automatic Database Diagnostic Monitor (ADDM).

•Expert in Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements

•Ability to restore and recover databases from file system backup in order to bring to the original state as per the business and user requirement.

•Applying latest versions or releases of database patches to minimize the bug issues which caused by the previous versions of patches.

•Excellent Communication and responsible team player.

•Quick learner with ability to master new concepts and applications.

Technical Skills:

Databases: Oracle 12c, 11g R2 RAC, 10gR2 RAC, and EXADATA

Operating Systems: Linux and Windows,

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, TOAD

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Data pump, Share Plex.

EDUCATION:

Masters in Computer Science, Southern Arkansas University, 2016 (Arkansas, USA)

Bachelors in Electrical & Electronics, Jawaharlal Nehru Technological University, 2014 (Hyderabad, INDIA)

Professional Experience:

Client: Wells Fargo, NC Jan 17 – Till date

Oracle Database Administrator

Responsibilities:

•24x7 Oracle Production Database Application support.

•Good knowledge on usage of LogDump.

•Building Databases, Standby databases on Oracle 12c.

•Created new users, Roles, Profiles and assigning the required privileges to the users.

•Experience using Export/Import and Data pump for migration of databases.

•Table Partitioning, Creating Locally managed Table spaces.

•Applying Oracle recommended patches.

•An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.

•Proficient in using Oracle utilities i.e. export/import, Data Pump, Data Guard, ASM and OEM.

•Actively involved in Switchover/ failover processes.

•Installed, configured and maintained Oracle Databases and Applications.

•Used Diagnostic & tuning packs along with AWR, ASH & ADDM reports.

•Creating and maintaining Views on Database objects.

•Tuning heavy data loads. Monitoring and Performance tuning.

•Upgraded Dev and Test instances to 12c.

•Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.

•Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.

•Responsible for continuous database monitoring and reorganization for ensuring performance.

•Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

Environment : Oracle EXADATA, 12C, 11g, OEM (Grid Control), Oracle Data guard, performance tuning, ASM, RAC, RMAN, Data pump, Import Export,

Client: SP Technologies (Intern) Aug 2016– Dec 2016

Oracle Database Administrator

Responsibilities:

•24x7 Oracle Production Database Administrations.

•Building Databases, Standby databases on Oracle11g.

•Created new users, Roles, Profiles and assigning the required privileges to the users.

•Experience using Export/Import and Data pump for migration of databases.

•Table Partitioning, Creating Locally managed Table spaces.

•Applying Oracle recommended patches.

•An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.

•Proficient in using Oracle utilities i.e. export/import, Data Pump, Data Guard, ASM and OEM.

•Used Diagnostic & tuning packs along with AWR & ADDM reports.

•Creating and maintaining Views on Database objects.

•Tuning heavy data loads. Monitoring and Performance tuning.

•Upgraded Dev and Test instances to 11g.

•Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.

•Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.

Environment : Oracle 11g, OEM (Grid Control), Oracle Data guard, Sun Solaris, performance tuning, ASM, RAC, RMAN, Data pump, Import Export, HP-UX, and Red Hat.

Client: Sports 195, Hyderabad, India Dec 2013 – Dec 2014

Oracle Database Administrator

Responsibilities:

•System Study & Analysis, Design &Development.

•Worked on Oracle RAC with SRDF Implementations for cross data center replication.

•Installed, configured and maintained Oracle 10g/9i.

•Complete the work in given time frame without missing any SLA

•Tuned SQL statements to implement 55 concurrent connections to load historical data into the Siebel schema.

•Refresh the data warehousing application on a daily basis.

•Created Production, Stage and Dev Enterprise data warehouse.

•Implemented weekly cold backup.

•Backup plan designing and implementation using cold/hot backups for database.

•Expertise in Database Performance Tuning and SQL Tuning.

•Implemented backup and recovery strategy and performed full, incremental and cumulative backup using RMAN.

•Responsible for CPU and PSU patch management.

•Support application admin and developer groups to define SLA’s, Incident Management and Dashboard reports

•Used export/import utilities and applied patches.

•Worked on PL/SQL packages, stored procedures, functions and triggers and assisted in generating reports using crystal reports.

•Coordinate with UNIX administrators for space management on various servers.

•Did Installation, Configuration and Maintenance of Oracle RDBMS Software.

•Generated regular Stats-Pack reports for the performance tuning of the databases.

Environment: Oracle 9i, 10g,11g,PL/SQL, Windows 2000,Linux, Solaris Toad.

Achievements:

•Won 1st prize in POSTER PRESENTATION in CONSORTIUM TECHNOFEST 2K13 in 2013 on topic RENEWABLE ENERGY RESORSES.

•Won 1st prize in CONVERGENCE2K12 in PAPER PRESENTATION as well as in PROJECT EXPO topic namely HYBRID ELECTRICAL VEHICLES

•Won 2nd prize in ESPARTO2K13 in PROJECT EXPO topic namely UTILIZATION OF LED BULBS INSTEAD OF MANY OTHER BULBS AND THEIR CONSTRUCTION.

•Conducted a NATIONAL WORK SHOP ON TRANSFORMERS in ESPARTO2K13

•Organized an event called ELECTRICAL PARTS EXHIBITION in ESPARTO2K13

•Won 2nd prize in POSTER PRESENTATION in SAMVIKSHAN’12-techinical fest by VBIT on topic LOW SMOKE CABLES.

Cultural & Sports:

•Won SILVER medal in 2nd-NATIONAL CHESS BOXING CHAMPIONSHIP in 2013 and I am a JNTU university player for boxing

•Won 1st place in DANCE competition in DRUVA COLLAGE OF MANAGEMENT and 2ND place in BITS HYDERABAD.

Organizer:

•Organized an event called ELECTRICAL PARTS EXHIBITION in ESPARTO2K13

•Organized BLOOD DONATION CAMP in my collage by associating with REDCROSS BLOOD BANK.

•I am the lead organizer of my college NATIONAL LEVEL TECHNIAL SYMPOSISUM that is ESPARTO2K13

•Organizer for PROJECT EXPO at ESPARTO 2K13 Conducted by HYDERABAD INSTITUTE OF TECHNOLOGY AND MANAGEMENT, Hyderabad.

Contact this candidate