Summary
Overview
Work History
Education
Skills
Pronouns
Timeline
Generic

Usha Rani

Summary

Accomplished Sr. Database Administrator with a proven track record at BOTW-BMO, enhancing database availability/performance and implemented robust disaster recovery site. Expert in Oracle 19c and adept at leveraging Oracle Cloud technologies for optimal efficiency. Demonstrates strong analytical skills and a commitment to continuous improvement, significantly boosting system reliability and user satisfaction. Multi-talented database administrator with several years of expertise in designing, testing and coding database solutions in various environments. Motivated self-starter consistently meets deadlines and succeeds in high-pressure environments.

Overview

8
8
years of professional experience

Work History

Sr. Database Administrator

BOTW-BMO
09.2021 - Current
  • Installation, support of critical oracle 19c databases on RAC environment
  • Implementation, Configuration and Management of Data Guard on OEL
  • Experience with Data guard broker configuration and switchover
  • Experience in troubleshooting issues related to standby and production database sync using data guard
  • Expertise in database cloning 19c, 12c, patching using Opatch, apply CPU patches
  • Backup and recovery of Oracle Databases using RMAN
  • Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement
  • Managing database infrastructure using OEM for alerts and scheduled jobs
  • Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental)
  • Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import
  • Refreshed the PDB using the database link from production to non-production databases, including QA, Dev, and Test.
  • Handled day to day tasks with user tickets to create users, assign privileges, troubleshoot connectivity issues, etc
  • Supported Oracle RDS databases on the AWS environment with snapshot backups, parameter groups, option groups, alerts, etc.
  • Supported team with on call and coordinated with oracle for service requests
  • Environment: Oracle 19c/12c , OEL , OEM Grid Control, RAC, ASM, Amazon Web services (AWS), OEM 13c, Exadata, SQL server, Data Guard, OPatch, Stats Pack, TKPROF, OAV, AWR, ADDM, ASH, UNIX Shell scripting
  • Addressed runtime issues swiftly to maintain system performance.
  • Provided technical support for database users, troubleshooting issues as they arise.
  • Installed new software releases, patches and upgrades on production servers as required.
  • Designed and implemented disaster recovery plans in case of system failure or data corruption.
  • Partnered with project management teams on development of scope and timelines.
  • Assessed data processing proposals and requirements to determine project feasibility.

DBA

AIG insurance
TX
02.2019 - 08.2021
  • Company Overview: AIG is a leading global insurance organization
  • Worked as senior Consultant (Database and Systems Infrastructure)
  • My responsibilities included Oracle Technology Stack implementation support and upgrade of Oracle databases on VM (VMWare ESX ver 4.0) servers, RHEL and AIX platform
  • Implemented and supported oracle databases 19c and 12c for various business applications including informatica, agile PLM, etc
  • Migrated databases from AIX to RHEL
  • Installed one off patches on RHEL environment for quarterly security patches
  • Configured RMAN backups for all Production environments on ZFS storage and optimized backups
  • Enabled flashback for database/application maintenance activities
  • Performed code reviews for Software Development, Data Architects, and Business Intelligence teams and deployed on databases
  • Created 19c standby database using data guard method for high availability
  • Analysis/troubleshoot database performance with AWR, ADDM, ASH reports, optimized SGA/PGA sizes along with huge pages setting
  • Created multiple non-production environments using PDB hot clone, data pump jobs
  • Upgraded databases from 12.2 to 19c using DBUA
  • Supported team with on call and coordinated with oracle for service requests
  • Implemented advance security with oracle wallet and enabled encryption of databases
  • Supported end users with their requests and problems using HPSM ticketing tool
  • AIG is a leading global insurance organization
  • Environment: Oracle 12c, Red Hat Linux, AIX, OEM Grid Control, RAC, ASM, OEM 13c, Oracle Advanced Security, Data Guard, OPatch, AWR, ADDM, ASH, Shell scripting

Database Analyst

Invacare Corp
09.2016 - 01.2019
  • Installation and support of oracle databases (Prod, QA, Test) 12.1 and 12.2 for various apps on Exadata, RHEL and AIX environment
  • Configured RMAN incremental and full backups with catalog database
  • Worked on upgrade/migrating databases from 11g to 12c
  • Set up Disaster Recovery of database 12C using Data Guard method
  • Worked on 4-node RAC with ASM environment
  • Performed various administration tasks like creating users, managing tablespaces and other objects
  • Setup network, code drops, refreshing the environment with cloning using datapump
  • Created and Managed users, user profiles, tablespaces, data files, archive log
  • Performed database refresh from production data to lower environments for testing, development and quality analysis purpose
  • Administering database security, Creating Users and granting/revoking roles and privileges
  • Designed and created schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle
  • Managed the health of the Exadata environment by reviewing and fixing issues found in Exachk reports
  • Troubleshoot Exadata environment with Exawatcher and used TFA tools for diagnostics
  • Developed backup and recovery procedures, tuned the data, installed software upgrades, and monitored database activity, file usage, and removed obsolete files and processes to allocate resources for proper functionality
  • Good knowledge and hands-on experience of database administration for MS SQL Server databases, version 2008
  • On call rotation and after hours support

Education

Masters Degree -

Skills

  • Oracle Enterprise Linux
  • Redhat Linux
  • AIX
  • Windows server
  • Oracle X6/X7 Exadata machine
  • AWS
  • Oracle Cloud
  • VMs
  • SQL
  • PL/SQL
  • Unix Shell Scripting
  • Oracle 19c
  • Oracle 12c
  • PostgreSql
  • E-Business Suite application R12
  • Informatica
  • Agile PLM
  • Oracle Audit Vault
  • Microsoft SQL server
  • Export/Import
  • GITLAB
  • AWR
  • ADDM
  • Loader
  • Tkprof
  • RMAN
  • Datapump
  • ASM
  • Flashback Recovery
  • OEM
  • BMC Remedy
  • HP service management
  • MS Excel
  • Power Point
  • MS Word
  • Agile
  • SDLC model
  • Waterfall Model

Pronouns

She/Her

Timeline

Sr. Database Administrator

BOTW-BMO
09.2021 - Current

DBA

AIG insurance
02.2019 - 08.2021

Database Analyst

Invacare Corp
09.2016 - 01.2019

Masters Degree -

Usha Rani