Nisha Basavaraj
Database Administrator
Summary
Over 10+ years of experience as an Database Administrator (Oracle & MySQL) - performing various tasks like database installation, administration, configuration, upgrades, patching, backup and recovery, performance monitoring, performance tuning, cloning, space management, database security and production support.
Vast experience on all releases of oracle database starting from 9i to 19c on various OS platforms also MySQL Databases versions from 5.6 to 8.1.
Overview
11
11
years of professional experience
4
4
years of post-secondary education
Work History
Reliability Engineer ( Oracle DBA)
AB InBev
09.2021 - 01.2024
- 24/7 support in managing critical databases in different zones ( NAZ/EUP)
- User & Role management. Space management at table space & filesystem level.
- Responsible for online/offline backups & managing database recovery with RMAN.
- Responsible for cloning of DB using export/import.
- Database Performance Tuning, AWR analysis, Query Optimization.
- DB patch management
- Individually worked on building physical standby for diaster recovery.
- Exposure in managing Oracle databases on Azure.
- Exposure in creating VM,RG & VNet's.
- Individual contribution in successfully migrating MySQL Single servers ( PAAS service) to MySQL Flexi server.
- Oracle database Healthcheck automtion using HTML/shellscripting
- Exposure in Oracle DB migration to CloudSQL for PostgreSQL
- PostgreSQL installation,create roles & permissions, perform backups
- MSSQL database basic administration
Senior Software Engineer
Huawei Technologies ( Client - MTN & TUK )
09.2018 - 09.2021
- 24x7 Oracle Production Database Administration including Oracle 11g/12c/19c RAC.
- Installation, configuration of Oracle 11g,12c,19c RAC.
- Implemented strategy for partitioning and management of historical data tables in RAC.
- Upgrade Oracle DB from 11g to 12c,19c, 12c to 19c.
- Creating/Managing users profiles and analyzing their privileges and tablespace quotas.
- Space management, raising storage request & adding space to ASM disk group & tablespaces.
- Resolving Data guard (physical standby) replication related issues.
- Monitoring Golden Gate processes and resolving related issues
- Resolving RMAN restore & recovery related issues.
- Regular monitoring of DB’s in OEM12c & 13c.
- Adding targets to OEM 12c & 13c for monitoring.
- Standby Database (Data Guard) setup using RMAN backup & restore.
- Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
- Installation and configuration of Oracle Client software and Tools.
- Single handedly completed Cross platform Oracle DB migration ( Windows to Linux) and upgradation from 11gR2 to 19c.
- Managing MySQL 5.7 in production/pre-prod/dev/test environments on Linux OS.
- Ensuring production data being replicated into slave node from master node without any abnormalities.
- User creation & Role management.
- Responsible for DB backups and resolving replication issues.
Operations Professional – Oracle DBA
IBM Pvt Ltd ( Client - 3UK )
07.2015 - 04.2018
- Supported oracle 9i,10g,11g/R2 with ASM on multiple OS.
- User/Role/Profile management
- Installation/Configuration & Maintenance of Oracle DB on different OS platforms.
- Managing ASM diskgroups
- Involved in analyzing database growth & based on that requesting for storage .
- Managing Table space Utilization based on the growth pattern & adding space to avoid table spaces reaching 100% utilization.
- Involved in space management like checking for table space fragmentation & shrinking the unused space in order to reclaim the space.
- Monitoring server, instances, database availability ( through OEM & HP- OV tool )
- Monitoring & confirming that database backups have been made and saved successfully in the defined location.
Software Analyst
Accenture Services Pvt Ltd ( Client - KPN & Pfizer)
02.2013 - 07.2015
- Analyzing AWR/ADDM/ASH reports for critical applications like CRM / Custom profiling.
- Suggesting tuning solutions for SQL queries and Database using SQL tuning advisors,ADDM, Profiling, Indexing.
- Individually built a Client dedicated tool called as ATM (Any Time Monitoring) using HTML & JavaScript which acts as a centralized place that provides the health check status of all the Productions Databases.
- User & Profile Management/ Export backups /Database Monitoring using OEM. creation of metrics/incident rules in OEM
Education
Bachelor of Engineering - Computer Science
East West Institute of Technology
01.2008 - 04.2012
Skills
Oracle - 9i,10g,11g,12c,19c
Oracle Enterprise Manager (Version 10g,12c,13c ) - Monitoring Tool
Azure
MySQL - 56 , 81
Languages - PLSQL, HTML, Basic Shell scripting
Operating System -AIX, Linux, Sun Solaris, Windows
Postgresql
MSSQL
Timeline
Reliability Engineer ( Oracle DBA)
AB InBev
09.2021 - 01.2024
Senior Software Engineer
Huawei Technologies ( Client - MTN & TUK )
09.2018 - 09.2021
Operations Professional – Oracle DBA
IBM Pvt Ltd ( Client - 3UK )
07.2015 - 04.2018
Software Analyst
Accenture Services Pvt Ltd ( Client - KPN & Pfizer)
02.2013 - 07.2015
Bachelor of Engineering - Computer Science
East West Institute of Technology
01.2008 - 04.2012