Sivanath Reddy - Database Administrator - Dxc Technology and Javi systems

Summary

A Challenging position as an Oracle Database Administrator at a growth-oriented firm, which will allow me to both further utilize my skills, as well as to enhance my knowledge by dedication, hard work and acquire new abilities.
Having around 5 years’ experience as an Oracle Database Administrator in IT Industry. Involved in maintenance and hands on experience in Database installation, administration, backup and recovery Using RMAN, imp/exp, datapump. Experience in user profile administration, cloning, Dataguard (DR), Patching, Upgradation and a wide range of other database activities. Good exposure in setting up and executing the Data Guard. Experience in Oracle 10g, 11g ,12C & 19c Real Application Clusters (RAC). Ability to manage multiple tasks in a pressured environment. Monitoring of system health and performance, to ensure high levels of performance, availability, and security. Allocating system storage and planning future storage requirements for the database system. Controlling and monitoring user access to the database. Having experience on 11g and 12c and Migrate the Database in Cross Platforms. Having experience in Creating Container Database and Pluggable databases. Having experience on Configure listener and net services. Having experience on disaster recovery, Creating Physical standby database. Having experience on Configure Data guard Broker and performing switch over operations. Worked experience on Flashback databases. Good experience on Oracle Data-Guard. Proficient on maintaining Automatic Storage Management (ASM). Knowledge on database performance reports like AWR, ADDM, ASH
Database tuning, Application Tuning & performance monitoring. Experience in DR configuration and maintenance of standby databases. Experience in DR-drill using switchover-switchback. Experience with 11g,12c & 19c Data Guard features like Snapshot standby. Experience in refreshing DR using RMAN incremental backup. Monitored the production Oracle alert logs for database errors. Export/Import of Oracle database objects using traditional export/import and data pump in accordance with end user’s requirement and company policies. Gathering statistics of Database, Schema, tables and indexes. Basic Knowledge on Performance Tuning.

Overview

4

years of professional experience

1

Certification

Work History

Oracle DBA

Dxc Technology and Javi systems

11.2021 - Current

Working as an Oracle & PostgreSQL Database Administrator with Dxc Technology.
Operational Support involves effectively monitor and resolve critical issues of customers oracle instances.
Our team of support spans across database, technical, operating system with strict adherence to the predefined service level agreements in providing 365
24
7 remote support for critical production databases and development databases.
Resolve Incidents and Service requests in the ticket queue and proactively resolve DB related problems, based on alerts triggered.
Creation of Tablespaces, user maintenance, database security imposition by creating and granting of roles and privileges, performance tuning, backups (Hot/Cold/Logical) using RMAN.
Responsible for administration and supporting Oracle 10g, 11g ,12c and 19c Databases.
Cloning the database using RMAN and Hot backup.
Performance-tuning services for clients with ADDM, AWR, ASH and troubleshooting databases using oracle utilities.
Configure LISTENER & TNSNAMES files & troubleshooting.
Review alert logs files to check for any problems related to databases.
Working with Space Management Alerts (Data file, max extents and database file system alerts. Example: Archive log file system alerts.).
Performed RMAN Point in time Database recovery on oracle 11gR2.
Working with traditional and data pump utility for the selective data export and import on production/test/dev on client/online team request basis.
Written the shell scripts to automate the jobs as per business requirement.
Using STATSPACK/AWR to generate the report to check the performance and ADDM report recommendations.
Cloning of Oracle Databases for non-production environments using RMAN and User managed backups according to the client requirements.
Maintaining the process related documents up-to-date for important database activities such as Server down time, DR Activities, timing of RMAN backups, errors in the alert log files and Known Issues etc.
Performing database refresh with Prod copy as per the requirement using RMAN duplicate.
Implementation support to Installation of Oracle RDBMS software, client software in Production Servers and Development Servers in Linux platforms.
Production Database Support Monitoring sessions and DC to DR Log sync.
Applying CPU and PSU patches in oracle database.
Configuring Dataguard Setup Physical standby database.
Resolving archive log gaps using RMAN incremental backup.
Configuration Oracle Physical standby database using Hot backup and RMAN backups.
Physical standby database convert into Snapshot standby database for DR application testing.
Weekly once analyzing the index structure and rebuild it due to performance.
Monitoring and managing their Disaster Recovery (DR) server.
Responsible for the archive log shipping from Production to DR and the recovery of the same.
Physical Standby & ADG standby rebuild on affected databases performed.
Create database User, Profile, Role for security purpose.
Configured Auditing to audit information about database activity.
Cloning of Production to Dev/Test servers using hot backup and recovered the database as per the business requirement.
Rebuilding indices and gathering stats for better performance.
Applied Oracle RDBMS patches using opatch utility.
Proactively monitor 11g,12c &19c Oracle environments for multiple customers. Resolve database incidents to ensure database availability and stability.
Coordinated Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery.
Involved in Physical & Logical Backups (Export / Import)/data pump for Schemas based, Full Database.
Physical standby database converts into Snapshot standby database for DR application testing.
Configured Physical Standby Database 11gr2,12c and 19c.
Administrating RAC Database and cluster ware using SRVCTL and CRSCTL.
Configuring Dataguard Setup Physical standby database.
Performed hot and cold backups, logical backups and user managed recoveries and RMAN recoveries.
Performance-tuning services for clients with ADDM, AWR, ASH and troubleshooting databases using oracle utilities.
Monitoring and managing the Table spaces and data files.
Monitoring the performance of the databases viewing Alert log files & Trace files.
Rotation On calls support 24X7. Used HPMSchange managements and task requests for any changes performed on production.
Attending Major Incident calls and resolving issued within time period.
Monitoring production OEM support for performance and high availability.
PostgreSQL
Core Competencies:
Schema design and table creation
Data manipulation and advanced queries
Backup and restoration using pg_dump and pg_restore
Indexing and basic performance optimization
Role-based access control and permissions
Company: Dxc technology and Javi systems
Project: Bank of baroda
Technical Environment: Oracle 10G, 11G ,12C&19c / Red hat Linux
Role: Oracle DBA

Education

B.Tech - Electrical, Electronics And Communications Engineering

JNT University

Anantapur

04-2018

Skills

RDBMS: Oracle 10g, 11g, 12C &19c

Key Skills: Data Guard, Patching, Upgrading, ASM & RAC, EXP/IMP, Data pump, RMAN Backup/Recovery, RAC Performance tuning, DB Clone

Operating Systems: Windows, Red Hat Linux, AIX, Linux, HP Unix, Solaris Tools & Utilities: Putty, DBCA, SRVCTL, AWR Report & ADDM Report Database

Certification

OCP:-Oracle Certified Professional 19c

Declaration

I hereby declare that the information stated above is true to the best of my knowledge. (M. Shivnath Reddy)

Timeline

Oracle DBA

Dxc Technology and Javi systems

11.2021 - Current

B.Tech - Electrical, Electronics And Communications Engineering

JNT University