Oracle DBA - RAC, Data Guard, Performance Tuning expert
Resume:
Ganipeta Srikanth
Mobile:709-***-****
E-mail:*************@*****.***
Career Summary:
Oracle DBA Professional with 6+ years of experience in Oracle Database Administration, RAC, ASM, PostgreSQL, and cloud database setups using Oracle Cloud Infrastructure (OCI). Skilled in performance tuning, AWR reporting, and high availability solutions. Experienced in backup/recovery strategies, database migrations, and providing on-call weekend support.
Professional Summary:
Provide Production, Test, Development and Training environment support
Creation of database instances of 11g, 12c and 19c versions for testing and development servers.
Creation of database instances of 11g, 12c, and 19c versions for testing and development servers, both on-premises and in OCI.
Have dedicatedly worked on upgradation of various size of databases (in-place, out-of-place upgradation) and also Oracle Software installation.
Applying latest PSU, CPU and one off bug fix patches to database software.
Refreshing the data between the environments using Data pump and traditional export and import.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Excellent experience in backup using the methods Cold backups, hot backups, Logical backups, RMAN backups (Full, Incremental Backups, Differential, Cumulative Backups).
Performance Tuning & AWR Report generation to optimize SQL queries, schema, and instance performance.
PostgreSQL administration and optimizationincluding backups, restores, and query tuning.
On-call support including weekends to ensure database uptime and resolution of critical incidents.
Performing RMAN recoveries and Oracle User managed recoveries.
Cloned/Refreshed Oracle databases for Development, Test, UAT and quality environments.
Working on OCI setup and database provisioning, including cloud architecture configuration, backup strategies, and performance monitoring.
Setting of Oracle Data guard for High availability and load offloading to Physical standby, Logical standby and snapshot standby.
Administering the Oracle cluster ware 11g/12c and RAC databases.
Managing RAC instance, non-RAC instances and ASM instances.
Worked on RHEL6 to RHEL7 database migration.
Database security, User access management, Audit trial setup, Tablespace management and maintenance (Tablespace and Database growth)
End user management – creating users, Roles and Profiles.
Monitoring and troubleshooting scheduled process or jobs and job scheduling through Job Scheduler and cron.
Working on incidents and change request opened by customers.
Tuning at the instance and SQL statement level.
Worked on Data guard configuration on ne RHEL7 AND RHEL 8 SERVERS.
Worked on data guard synch issues using service.
Worked on RAC environment.
Knowledge on WebSphere j-boss tomcat and coherence
Worked on installed OIPA instances in WebLogic application server and maintain the servers
Working together with My Oracle Support to fix database bugs, issues etc.
Worked on Real Application Testing (RAT)
Excellent experience in EXADATA and Golden Gate.
Worked on Oracle Enterprise Manager
Work Experience:
Working as Oracle DBA in E2OPEN SOFTWARE INDIA PVT LTD since November 2024 to January 2026
Working as Oracle DBA in NITYO INFOTECH PVT LTD since April 2024 to July 2024.
Working as Oracle DBA in NAYAGARA TECHNOLOGIES since May 2018 to September 2023
Educational Qualification:
Completed Graduation HGU University
Training and Certifications:
Oracle Certified Associatein Oracle 10g Database Administration.
Skill set:
Databases
Oracle 10g/11g/12c/19c
Operating Systems
Windows, RHEL & OEL
Databases
Oracle 10g/11g/12c/19c
Tools
Putty, Toad, SQL Loader,Expdp/Impdp, Oracle Enterprise Manager
Clusterware/Grid Infra
Oracle 10g/11g/12c/19c
Ticketing Tools
Service now,Jira
Project Details:
1.Project Name: -
Client
E2open Software India Pvt Ltd
Databases
11g,12c and 19c
Operating System
Redhatlinux
Start Date
Nov-2024
End Date
Jan-2026
Roles and Responsibilities:
Performed performance tuning and generated AWR reports to improve database efficiency.
Provided on-call weekend support for critical database incidents.
Managed Oracle 11g/12c/19c and PostgreSQL databases in production, development, and testing environments.
Conducted OCI setup and provisioning for Oracle databases in the cloud
Involved in configuring the Oracle database for high availability.
As a Team Member of DBA team involved in complete database design of the project which involves more than 200 terminals.
Project also involves successful implementation of Backup and recovery, Replication
Strategies,
Tuning of Databases at different levels like O/S, Application, database decided by team lead.
Performing installation of Oracle Database server and providing SQLNet connectivity toclients.
Creating an Oracle objects, table space and adding data file to the existing table spaces.
The following activities are done from the production database.
oSchema Level Backup.
oHot Backup
oCold Backup – weekly once.
oDefragmentation.
oReorganize the index to increase the database performance.
Done shell script to take schema level backup from the production environment.
Monitoring the Alert log file, Tablespace size, Database connections and Disk size.
Done standby configuration for the primary database.
Generate the statistics report for the production database two hours once by using Stats pack to find out the database performance.
Working on database & schema Decommission activities.
Working on migration 12 to 19c databases
Working on service transaction activities
2.Project Name: -
Client
Infosys
Databases
11g,12c and 19c
Operating System
Redhatlinux
Start Date
April-2024
End Date
JULY-2024
Roles and Responsibilities:
Involved in configuring the Oracle database for high availability.
As a Team Member of DBA team involved in complete database design of the project which involves more than 200 terminals.
Project also involves successful implementation of Backup and recovery, Replication
Strategies,
Tuning of Databases at different levels like O/S, Application, database decided by team lead.
Performing installation of Oracle Database server and providing SQLNet connectivity toclients.
Creating an Oracle objects, table space and adding data file to the existing table spaces.
The following activities are done from the production database.
oSchema Level Backup.
oHot Backup
oCold Backup – weekly once.
oDefragmentation.
oReorganize the index to increase the database performance.
Done shell script to take schema level backup from the production environment.
Monitoring the Alert log file, Tablespace size, Database connections and Disk size.
Done standby configuration for the primary database.
Generate the statistics report for the production database two hours once by using Stats pack to find out the database performance.
Working on database & schema Decommission activities.
Working on migration 12 to 19c databases
Working on service transaction activities
3.Project Name: -
Client
TCS
Databases
10g,11g,12c and 19c
Operating System
Redhatlinux
Start Date
Oct-2020
End Date
Sep-2023
Roles and Responsibilities:
Independent Production Support for ~ 520 databases (140 Applications) & on call Rotation support.
Database refresh/replication from Production to Testing, Development Environments using RMAN / Data Guard / Hot Back-ups and Schema level Exports / Data Pumps.
Providing backup and recovery strategies, setting up and implementing the backup & recovery procedures for Oracle9i/10g/11g/12c databases (RMAN, Hot & Cold Backups, Exports)
Database sizing, tablespace management and Rollback/Undo Tablespace management, high DML transactions.
Worked on RAT (Real Application Testing) for performance tunning.
Worked in conjunction with the development team to fine tune SQL and PL/SQL Code using Execution Plan, SQL TRACE, ANALYZE, DBMS_STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.
Create Database maintenance plans, including updating statistics, re-indexing, structure modification, and capacity planning and index analysis. Maintenance of system documentation.
Worked on database upgradation from 12c to 19c version.
Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
Resolve the issues in conflicts between the target and source database in Goldengate
Performing Database Administration and management activities in a safe, recoverable and professional manner that ensures the optimal operations of the database environments.
Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)
Oracle Security, User management, privileges, roles auditing, profiling, authentication.
Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
Responsible for monitoring and optimizing all database performance including the design, creation and structural integrity of database objects in the production environment.
Monitoring and optimizing the Performance of the database using AWR/ADDM/ASH tools.
Planned, Scheduled and assisted in implementation of Infrastructure enhancements, patches and upgrades from design, development, test, pilot, production and demo environments.
Monthly maintenance of few production databases (database bounce/OS reboot) and Creating& managing the Historical table data.
Worked on Planned Production deployments.
Involved in major outages (Severity 1) and Worked with Oracle support to fix the issues.
4.Project Name: -
Client
Tech-m
Environment
10g/11g/12c
O/S
Linux/solaris
Start date
May-2018
End date
Sep-2020
Roles and Responsibilities:
Oracle database installation of (11g, 12c& 19c) Homes and applying patch to Oracle Home.
Creation, configuration Databases using DBCA.
Configured dynamic listeners & monitoring of TNS service availability.
Exporting and Importing Tables, Schemas and Tablespaces.
Cloning of production databases using RMAN to test & development environment.
Adding data files to the tablespaces by Measuring space utilization of table spaces and mount point.
Performing databases health checks for space growth, mount point growth etc.
Managing Tablespaces, Data files, Control files, Redo Log files.
Databases Creation and space Estimation, Creating table spaces with storage parameters.
Creating Database objects, Users, Roles, Profiles for the databases.
Releasing blocking session & locks as per the user request.
Controlling and monitoring user access to the database for new and existing databases by assigning Profiles and Roles.
Attending login failures alerts for Users login issues, and unlocking user accounts.
Upgraded Oracle 9i release 2 to oracle 10g release 2 on Linux platform
Performing databases refreshes using Export and Import Data pump Utilities
Implemented Oracle Data guard (Physical standby databases) with Data guard Mode Maximum Performance.
Looking for invalid objects and compiling of invalid objects.
Configured Recovery catalog for RMAN.
Monitoring regular logical EXPORT backups no rows as part of backup and recovery plan.
Modified scheduled scripts that will send the database backup and archives logs from server to offline storage.
DECLARATION:
I hereby declare that all the information provided above is correct to the best of my knowledge.
G.Srikanth
Contact this candidate