Summary
Overview
Work History
Education
Skills
Interests
Timeline
Generic
Rahul Tiwari

Rahul Tiwari

Oracle Database Administrator
Pune

Summary

Results-driven Oracle DBA with 7 years of experience optimizing database performance, implementing robust security measures, and executing seamless disaster recovery plans. Proven ability to work in fast-paced environments and collaborate effectively with cross-functional teams.
Seeking a challenging role to leverage expertise and drive organizational success through expert database management.

Overview

8
8
years of professional experience
4
4
years of post-secondary education

Work History

Senior Oracle DBA

Amdocs
Pune
11.2018 - Current
  • Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
  • Worked in Geographically distributed Onsite - offshore Model
  • Experienced Oracle DBA with 7 years of expertise in installation, configuration, administration, and troubleshooting of Oracle databases on different operating systems (Linux,AIX,Solaris)
  • Skilled in managing large and complex databases in mission-critical environments.
  • Setting up various automations using Jenkins and other tools for frequent DB tasks.
  • Experience in shell scripting and other Oracle tools and utilities like Oracle OEM, SQL developer and TOAD.
  • Involved in Performance Tuning, Backup and Recovery, Patching, Security, Oracle Enterprise Manager (OEM), Standby Database, Database Upgrade from 11g to 12g, troubleshooting and basic knowledge of networking and security.
  • Acquired knowledge in Oracle ASM diskgroup creation, disk addition disk removal and troubleshooting.
  • Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK
  • Creation of databases, instances, table spaces, data files, rollback segments.
  • Creating tables, indexes, synonyms, views, sequences, profiles, constraints, triggers, and procedures.
  • Design and implementation of Backup & Recovery using RMAN and SQL scripts.
  • Proficiency in using Log miner, SQL *Loader and Export/Import utilities.
  • Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.
  • Setting up Standby Database / Oracle DataGuard to protect against failures. Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.
  • Experience as 24x7 Production DBA.
  • Proactive and efficient in timely delivery of all assignments, always enthusiast to take up new challenges.
  • Collaborated with system architects, design analysts and others to understand business and industry requirements.

Oracle DBA

Allstate solutions pvt ltd
Pune
01.2015 - 11.2018
  • Provided resources and skill sets to support DBA functions for applications.
  • Proposed database changes to ease monitoring and administrative effort.
  • Established working relationships across various departments to understand existing and emerging IT requirements.
  • Code reviews of host and interface applications to ensure optimum database connections, resource usages, locks, query response times
  • Performed table reorg, table partitioning and timely table cleanups
  • Implemented and supported two node RAC environment.
  • Used Import/Export and SQL* Loader utilities to move data and objects
  • Monitored and maintained database growth and tablespace utilization
  • Applied patches in production and test instances
  • Monitoring night jobs and scripts for automation of backup and other jobs.
  • Used Import/Export and SQL* Loader utilities to move data and objects .
  • Perform installation, configuration and of Oracle databases on Solaris, Linux, HP-UX and AIX.
  • Added or altered the DB parameters at session and instance level dynamically and or in offline.

Education

Bachelor of Engineering - Computer Science

Shree Sant Gajanan Maharaj College of Engineering
Shegaon
03.2011 - 06.2015

Skills

    Oracle database

undefined

Interests

Cooking and Travelling

Timeline

Senior Oracle DBA

Amdocs
11.2018 - Current

Oracle DBA

Allstate solutions pvt ltd
01.2015 - 11.2018

Bachelor of Engineering - Computer Science

Shree Sant Gajanan Maharaj College of Engineering
03.2011 - 06.2015
Rahul TiwariOracle Database Administrator