ROHINI TIWARI

Mobile: (91-799*******

Email: adiu16@r.postjobfree.com

Experience Summary

• Having 8+ yr of total IT experience as Senior Oracle Cloud Database Administrator at Oracle India Pvt Ltd, Tata Consultancy Services and Cognizant Technology Solutions.

• Expert Knowledge on RAC, Oracle 10g/11g/12c/19c, Exadata, Golden Gate, Dataguard, RMAN, Datapump, SQL, PL/SQL, Linux.

• Good knowledge on MS-SQL, MySQL, Cassandra databases.

• Experience working with OCI, AWS and Azure cloud-based service provider.

• Extensive knowledge on Oracle Architecture, Goldengate architecture, Exadata Architecture.

• Experience in working with ASM, RMAN, Dataguard.

• Experience in Oracle Cloud Services (OCS, JCS, ICS, IoT, PaaS, IaaS).

• Knowledge on Amazon Web services and utilities like EC2, ELB, VPC, S3, CloudFront, IAM, RDS, Route 53, CloudWatch, SNS

• Experience in writing shell scripts to automation and monitoring using shell, python, and bash.

• Excellent knowledge on Cassandra Architecture, Cassandra Data Modelling and Monitoring using Opscenter.

• Worked as Team Lead and Lead administrator to manage the offshore team. Project 1: Organization: Oracle India Pvt. Ltd.

Client : Oracle Taleo (TEE and TSS)

Operating System : Unix/Linux

Tools : PRISM, RCC, DUMPMGR, Doodle, OEM,

Databases : ORACLE 300+ DB’s on Exadata Machine.

Period : August 2019 – Till Date

Role and Responsibilities

• Working on migrating oracle databases to OCI 19c, creating and managing databases on OCI.

• Working on Prism tasks like DB create/decommission, upgrades, patching, golden gate setup and gg upgrades and resolving the errors for failed jobs by understanding the underlying pl/sql code on 11g, 12c and 19c.

• Setting up Golden Gate replication, GG upgrades, Setting up Physical Standby setup, DG sync resolutions, Standby backups by converting to Primary role, Standby role conversions on 11g, 12c and 19c

• Creation of new Zones using SAR request using datapump utility and working on dumpmgr tool for exports.

• Working on Maintenance activities like backup, refreshes through PCN and RCC tool.

• Setting up Corrective Actions to automate tasks, writing Shell Script for automation, doing analysis on the alerts reports to perform automation.

• Working on tools update, testing the new versions on all environments of dev, pre-prod and lab.

• Guiding the L1 team on resolving alerts in OEM involving with Golden gate, Standby out of sync, OEM Metrics, sessions running long, jobs running long, blocking sessions, OBI job failed/running long.

Technical Expertise

OS – Linux/Windows

RDBMS – Oracle,

dMS-SQL, Cassendra,

MySQL

Cloud Platform –

AWS/OCI/Azure

Language –

SQL/PL/SQL,Shell

Scripting.

Tools – JIRA, BMC

Remedy, Toad, OEM,

SQL Developer,

Sqlplus.

Certifications

Oracle Autonomus

Database

Oracle Foundations

Architect

Project 2: Organization: TATA Consultancy Services

Client : Ericsson

Operating System : Unix/Linux

Tools : BMC Remedy, Oracle Enterprise Manager, SQL, PL/SQL.

Databases : ORACLE 300+ DB’s on Exadata Machine platform

Period : October 2015 – August 2019

Role and Responsibilities

• Working L2 Database Administrator for Exadata Ericsson IT

• Monitoring and managing 11g/12c RAC production databases on EXADATA Servers.

• Installing and creating new test databases using RMAN cloning and Data pumps.

• Refreshing Databases using Data pumps and RMAN incremental backups.

• Installed & configured RAC One Node and RAC databases using dbca utility.

• Discovering and adding instances, Scheduling backups, Creating Incident rules, generating AWR, ADDM reports in OEM.

• Monitoring ASM log file and disk groups status, taking ASM metadata backup using ASMCMD utility.

• Creation of pysical standby databases using rman from active databases.

• Performing switchover, failover and fast start failover (FAF) of databases using data guard.

• Performing Home movement activity for 11g, 12c primary and standby databases.

• Upgrading primary and standby databases from 11G to 12C manually and using DBUA utility tool.

• Taking OLR, VOTEING DISKS and OCR backups manually.

• Working on Reports and Tickets using BMC remedy tool. Project 3: Organization: TATA CONSULTANCY SERVICES

Project Title : British Telecom

Operating System : Linx/Windows

Tools : Nagios, AWS Management Console

Databases : Oracle,Mysql

Period : Jan 2019 – March 2019

Roles and Responsibilities

• Worked on Amazon Web Services ( EC2, ELB, VPC, S3, CloudFront, IAM, RDS, Route 53, CloudWatch, SNS,).

• Installed and Setup Web Servers ( Apache and Tomcat ), DB Server ( MySQL).

• Practical usage of Amazon Glacier for archiving data, monitoring resources, such as Amazon DB Services, CPU Memory, EBS volumes.

• Setup and manage Linux Servers on Amazon ( EC2, EBS, ELB, SSL, Security Groups, RDS and IAM), VPC and Subnets.

• Create and manage buckets on S3 (CLI) and store db and logs backup, upload images for CDN serve.

• Setup and Manage Databases on Amazon RDS. Monitoring servers thorough Amazon CloudWatch, SNS.

• Creating and Managing DNS records on Amazon Route 53 and go-daddy panel.

• Creating/Managing AMI/Snapshots/Volumes, Upgrade/downgrade AWS resources (CPU, Memory, EBS)

• Database backup (Hot/Cold) and recovery, security, creating users and managing permissions.

• Installed and Setup Nagios Server monitoring tools

• Installed and Setup Git/SVN Repository (Version Control System) at the client side.

• Monitor Production Server Health of different parameters (CPU Load, Physical Memory, Swap Memory, Hard disk, Mysql service, Http service and response time) via MRTG, Nagios.

Project 4: Organization: Cognizant Technology Solutions

Project Title : Nike DBA Managed Services.

Operating System : UNIX, Linux, HP-UX, SUN, Solaris, Windows.

Tools : Nagios, Clarify, Grid Control.

Databases/Versions : ORACLE 800+ DB’s /8i, 9i, 10g, 11g

Period : June 2012 – Oct 2015

Roles and Responsibilities

• Monitoring and maintaining Oracle cluster DB’s for their Optimal Performance and ensuing 100% availability of the and troubleshooting Jobs/alerts via Monitoring tool i.e., Netcool, Nagios and Autosys.

• Taking the backup of the database regularly using Logical, Cold and Hot Backups

• Monitoring and performing daily incremental backups, weekly backups using RMAN

• Check the performance of the database and tune as when requires using tools AWR, EXPLAIN PLAN.

• Managing tablespaces, users including storage and security issues

• Performed Schema Management, Index rebuilding, Analyzing the tables and indexes.

• Monitoring various database activities like user management, memory usage, alert log file, trace files.

• Distribution of Table spaces among different Disks and creation of Database objects.

• Performed Cloning Activity for Databases from Production to Testing Environment. Academic Profile

Course

Institution

University/Board

Pass Year

Grade %

B.Tech(ECE) BRECW JNTU- Hyderabad 2011 74%

Diploma QQGPT Board of Intermediate

Education

2008 81%

S.S.C Little Angels High

School

Board of Secondary Education 2005 82%

Personal Details

Marital Status : Married

Nationality: Indian

DOB : 12-01-1990

Passport : K6419518

Expires : 23-09-2022

Contact this candidate