Senior Oracle Disaster Recovery

Sruthi A Email: ******************@*****.***

Senior Oracle Database Administrator Mobile: +1-832-***-****

Professional Summary:

Over 10+ years of experience as DBA and managing databases providing 24/7 support of both development and production Oracle 19c/18c/12c/11g/10g databases on Various Platforms.

Proficient in Database Administration activities such as Upgrades, Patches, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.

Conducted interviews and made recommendations for new hires, consultants or replacement for the personnel.

Developed and executed strategic plans and training to achieve goals, and improve SLAs.

Built and maintained strong, long lasting customer relationships.

Communicated, presented and influenced all levels of the organization, including executive.

Strong at maintaining, automating and improving the processes for database administration.

Excellent experience in Installation, Setup and configuration of Oracle 10g, 11g, 12c, 18c, 19c UNIX/LINUX WINDOWS environment.

Poses strong Administrative skills in RHEL

Provided DBA support with proactive monitoring, identifying areas that need to be improved in the application and databases using Statspack, AWR, ADDM, and OEM Grid Monitoring.

Over 5 years of experience working with Oracle Dataguard & have successfully completed projects using Oracle Dataguard and GOLDENGATE– Implement & support.

Good experience working with Cluster Server Management (Real Application Cluster) & have successfully completed projects on Oracle RAC – Install, Configure, implement, and support.

Good experience in performance tuning of production and development databases.

Strong experience in database backup & recovery procedures using conventional cold, hot & RMAN backups

Highly proficient in SQL, PL/SQL, bash

Experience in Installation and configuration of Oracle 10/11g/12c/18/c/19c Linux and Windows

Experience in Installation, configuration of Oracle 11g, 12c, 19c RAC & also used Oracle features like – Memory Management, Reorganization / Rebuild Indexes, Gather statistics / Automatic Statistic Collection, SQL Baselines, SQL Profiles, invisible indexes.

Excellent experience in using OEM, TOAD, Data Migrations using export/import

Excellent experience in cloning of databases using RMAN duplicate database feature.

Implemented DATA GUARD (Standby) for high availability/disaster recovery support

Management of schemas, objects & Partitioning the tables & indexes.

Proficient in performance tuning using Explain Plan, STATSPACK, SQL_TRACE, TKPROF, ADDM

Good Interpersonal communication skills and Documentation skills.

Provided On-Call support.

Good experience in User and security management using Grants, roles, privileges.

Experience in setting up DR solutions using RMAN, scripts, Data Guard

Setup Oracle 11g, 12c GoldenGate for replication needs.

Poses strong DBA knowledge on SQL Server 2005 and 2008.

Poses strong knowledge on RAID levels, NAS and SAN.

Worked extensively with SAN admins for ASM disks and Diskgroups.

Involved in disaster recovery planning detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.

Developed and implemented Materialized views for better performance of daily reports.

Good Knowledge on Exadata database machines.

Expertise in using Oracle Enterprise Manager (OEM) and Grid control and its components.

Excellent experience on Microsoft Azure cloud, Creating VM’s,storage accounts, Container

Knowledge on Key Vaults and Blob fuse mount points.

Created RDS databases on AWS Cloud.

Technical Skills:

Programming

SQL, PL/SQL, Shell Scripting, bash

Database

Oracle 10g/11g, 12c,18c, 19c

Operating Systems

Windows, RHEL

Tools

SQL*Plus, PL/SQL, Oracle Enterprise Manager (OEM) 13c, SQL*Loader,, data pump, export, import, DBVerify, SQL loader, statspack, TkProf, Data Pump, Grid-control, Database control, RMAN, Toad, SQL Developer, Golden gate, RAC, Patching Linux, Performance tune, ServiceNow,ASM,Exadata

Networking

LAN, WAN, TCP/IP, DNS

Cluster

Real Application Cluster (RAC)

Cloud

AWS, Microsoft Azure

Education:

Masters in Computer Application JNTU University in 2013.

Bachelors in Computer Science Kakatiya University -2010

Professional Experience:

Client: Biogen, MA, Cambridge Jul’ 2020 – Present

Role: Sr Oracle Database Administrator

Responsibilities:

Collaborated with the IT Infrastructure team, the IT Planning & Execution team, Oracle and third-Party Vendors, and other Business Groups in the development for project deliverables.

Configure and Oracle 19c dB instances on Amazon RDS, ensuring proper parameter settings, character sets, and other dB-specific configs in AWS Cloud

Developed a strong Oracle DBA techniques and effective methodologies.

Participated in the maintenance of the various Oracle instances.

Built strong analytical and problem-solving skills.

Managed, and resolved Oracle SR's support system.

Responsible for providing backend support for the development, testing and Production environments for Oracle and SQL databases as well as other new projects.

Managed the deployments for Coding, Cloning, Refreshing, Patching, Backups, and Purges.

Implemented RMAN for Cold and Hot backups and Recovery including Point in time recovery.

FRA and Flashback Technology were implemented. Implemented Data Guard for backups.

Security and Privacy of database: - Audit.

Applied CPU and PSU patches.

Managed Disaster recovery exercises.

Configured DDL and DML Replications in Golden Gate.

Implemented Oracle Golden Gate replication project on production databases for DR and replication purposes.

Introduced advanced queuing in oracle 12c and 11g for the performance enhancement.

Installed 12c and 11g Oracle Software Release 2 on their UNIX and Windows platforms.

Experienced in Oracle versions from Oracle 19c\18c\12c\11G

Implemented the ticketing system to support Database system 24 by 7 and track the activities for Pro-active approach solutions.

Upgraded 11g to 19c grid infrastructure and oracle databases with physical and transportable table spaces.

Upgraded 11g, 12c to 19c RAC having dataguard. Used physical, logical and using transportable table spaces.

Worked on Golden gate replication architectures and performance tuned the processes.

High Availability: Implemented Data Guard (physical) for maximum protection, performance and availability.

Scheduled crontabs to automate jobs as required.

Managed 13c OEM migration project.

Built excellent communication skills and customer relation.

Built solutions on cloud AWS with oracle 19c databases.

Performed multiple AWS migrations on EC2, VPC, EBS, and RDS installed O/S configured storage and installed oracle databases.

Environment : Oracle DB 19c/12c, 11g,Linux, Windows Server, Golden gate, AWS Cloud, DATAGUARD, TOAD

Client: UPS, Washington Apr’ 2018 – Jun’ 2020

Position Title: Oracle Database Adminstrator

Responsibilities:

Installed 11g Oracle Software Release 2 on their UNIX and Windows platforms.

Build 2 node RAC cluster on Linux.

Upgrade databases from 10g to 11g R2

Cloned Databases

Created Azure Virtual Machines .

Created scripts to Export Backups into Azure storage accounts.

Used Oracle Golden Gate for Basic Data Replication.

Worked on Uni-Direction Golden Gate setup

Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose

Handled Administration, Backup & Recovery using Recovery Manager (RMAN) tool.

Implemented Oracle 11g RAC within the Organization for various departments, Migrated existing single instance databases to RAC environment

Extensively used Oracle 11gR2 new features Data Guard, Replication, automatic SGA tuning, enhanced RMAN with flash recovery area, Oracle data pump, Database Control, AWR, ADDM, SQL Tuning/Access Advisors, Flash Back Database and several others.

Performance Tuning and monitoring statistics of production databases and doing capacity planning for database growth and load.

Administered the database and its users through Oracle Enterprise Manager (OEM) Tool.

Technically reviewed, developed, tested & documented all the batch scripts that update the database on their scheduled run in the UNIX CRON.

Shouldered a project which dealt with documenting the data sources and the architecture of Oracle database.

Developed UNIX Shell Scripts and modified the existing ones to meet the organizations specific requirements.

Extensively worked on 11g Grid Control.

Provided support to Development team in SQL tuning and database design.

Worked in on-call rotation and provided off hours support to both production and non-production databases.

Worked with UNIX, Firewall and storage team for DR migration.

Environment : Oracle DB 10g/11g R2 with RAC, RMAN, 12c, 11g Data Guard, TOAD, Microsoft Azure

Client: Honeywell Technologies,India Jun’ 2017 – Mar’ 2018

Role: Oracle DBA

Responsibilities:

Installed Oracle Software 11g Release 2

Created and configure RAC and Non RAC standalone database.

Created and designed database for new projects

Provided 24/7 support for all production databases

Database Cloning & Advanced Queuing Concepts

Created shell scripts for automating various database tasks in UNIX platform

Performance and Tuning of databases

Creation and maintenance of standby databases

Creating new users and manage roles and privileges

Managing Rollback Segments, Redo logs, Control files, and Table spaces.

Developed and fine tuned PL/SQL & UNIX shell scripts that update the data warehouse on their scheduled run

Performed the Pre-migration task for RAC & Standalone Database.

Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.

Involved in performance monitoring and tuning of the database by fine tuning the database implementation.

Designed and Implemented database security using Oracle roles and privileges.

Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.

Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.

Apply the required patches, test (unit test/ system test) and roll out and implement the patches into production.

Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies

Managed Data Guard between Primary and Standby

Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues disasters from happening.

Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.

Successfully configured the databases to switchover, failover and fallback scenarios.

24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

UNIX Shell scripting for backup and monitoring of databases.

Written scripts to automate repeated tasks

Environment: Oracle DB 11g/10g, Sun Solaris 10, AIX, Linux, Windows Server, RAC, DATAGUARD, TOAD, Exadata

Client: EPFO, India Jul’ 2013 - May’2017

Position Title : Jr Oracle DBA

Responsibilities:

Install Databases using scripts

Ran deployment scripts

Installed Oracle client

Installed OEM clients on Windows XP

Worked on TNS networking issues

Created user

Setup backups via RMAN

Created documents and put on SharePoint.

Shadow Sr. DBAs to learn new topics in DBA wor

Created Database links

Used export import to clone users

Worked on grants, permissions, roles and user security.

Used TOAD

Used Putty, Secure CRT and exceed

Unlock users

Installed databases using DBCA.

Learn how to manage databases using 11g Grid Control.

Worked on Memory management

Worked on Table space management.

Environment : Oracle DB 10g/11g, Linux, Windows Server, RAC, 10g DATAGUARD, TOAD

Contact this candidate