BHAVANI SANKAR ALLAM
Summary
I have 4 years of experience as an Oracle Database Administrator with a robust background in installation, administration, and troubleshooting of various Oracle Database versions including 11g, 12c and 19c. I excel in managing high availability, disaster recovery solutions, and performance tuning, ensuring optimal database performance and reliability across different environments. My expertise in AWS services, underscoring my commitment to leveraging technology for business success
Database professional with extensive experience in Oracle database management, optimization, and troubleshooting. Skilled in database performance tuning, backup and recovery, and SQL scripting. Strong focus on team collaboration to achieve project goals and adapt to evolving technical requirements. Reliable team player with commitment to high standards and delivering impactful results.
Overview
4
4
years of professional experience
3
3
Languages
Work History
ORACLE DBA
INVENTZO SYSTEMS
01.2023 - Current
- Client /project: Gap Fashions
- Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements
- Applied PSU patches and interim Patches to maintain the software up to date in both Standalone and Cluster environments
- Upgraded the database from 12c to 19c manually
- Created physical Standby databases and added them into FSFO setup
- Maintained Data guard to ensure high availability, data protection and disaster recovery for enterprise data
- Installed agent 12c, 13c on the server. Added high availability database like CRS, scheduling backups through OEM 12C, 13C
- Generated and analyzed performance-related reports like AWS, ADDM, and ASH
- Experienced in taking Rman L0 backups, incremental (L1) backups and performed restore and recovery
- Experienced in scheduling jobs through DBMS Scheduler and Cron tab
- Performed Schema refreshes from prod to QA env in both Standalone and RAC servers
- Created Indexes and performed online Index rebuilding to improve performance benchmarks
- Experience in Cloning the databases from prod to QA environment using RMAN
- Migrated On-prem Oracle to RDS and configured Replication between MASTER and STANDBY
- Performed Switchover/failover activities on a quarterly basis
- Configured streaming replication and monitored ongoing replication
- Implemented solutions that utilize RDS Multi-AZ, Snapshot replication, EC2 with Data Guard
ORACLE DBA
Future Focus Infotech
03.2022 - 01.2023
- Client /project: Kotak Mahindra Bank
- Coordinated and led the definition of system and database backup/ recovery and security strategies
- Performed technical root cause analysis and outlined corrective actions for given problems
- Collaborated with development teams to assist with complex query tuning and support knowledge transfer
- Proactively analyzed, proposed, and developed solutions for technical problems impacting multiple teams
- Diagnosed and resolved database performance issues
- Gathered statistics for schemas and tables to improve query execution plans
- Managed DB users, granting roles and privileges as part of the Oracle User management process
- Identified problematic sessions in the database and cleared those sessions
- Collaborated with cross-functional teams to design and implement backup and recovery strategies
- Conducted regular performance tuning, monitoring, and capacity planning to optimize database performance
- Handled Oracle Database restoration using RMAN Full Backup and Incremental Backup strategy
- Monitored customer instances through EM alerts
- Administered ASM disk groups including adding, deleting, and rebalancing of disks
- Identified long-running jobs, blocked sessions, and manually killed session processes
Education
BSC - Computers
Arunachal university of studies
India01.2019
Skills
AIX
ASM
AWS
AWS RDS
AWS Services
CloudWatch
EC2
HP-UX
IAM
JIRA
Linux
OLTP
OLAP
Oracle Database
SERVICENOW
PuTTY
Accomplishments
- Database Downtime Reduction: Reduced database downtime through effective implementation of Data Guard and FSFO setup.
- Improved Query Performance: Enhanced query performance through effective tuning and schema statistics management.
- Database Upgrade Leadership: Led successful database upgrade for 5 large-scale projects from Oracle 12c to 19c.
- Database System Uptime: Achieved uptime for database systems by implementing robust backup and recovery strategies.
Timeline
ORACLE DBA
INVENTZO SYSTEMS
01.2023 - Current
ORACLE DBA
Future Focus Infotech
03.2022 - 01.2023
BSC - Computers
Arunachal university of studies
Languages
English
Advanced (C1)
Hindi
Intermediate (B1)
Telugu
Bilingual or Proficient (C2)