SUMMARY

Professional experience of around * years in Information Technology as a Database and Application Administrator.

Hands-on experience in installation, configuration, upgrades, performance tuning, backup and recovery, cloning, migration with Oracle databases.

Experienced in configuring, troubleshooting Golden Gate, Data Guard and Fusion Middleware Products like WebLogic, OBIEE & OAC of different versions

Possess knowledge on Oracle Analytics Cloud, Oracle Cloud Infrastructure (OCI) and OCI-Classic

EDUCATION

Jawaharlal Nehru Technological University, Hyderabad, India May 2012 Bachelor of Technology in Information Technology

First Class with Distinction

PROFESSIONAL EXPERIENCE

Deloitte India, Hyderabad, India July 2016 – May 2018

Database and Fusion Middleware Administrator

•Configured Fusion Middleware Products like WebLogic server and OBIEE

•Configured DBCS (Database Cloud Service) on Oracle Cloud & OAC (Oracle Analytics Cloud) on trial versions.

•Configured & upgraded OBIEE, BIAPPS and ODI of different versions from 11.1.1.9 -12.2.1.4.

•Knowledgeable on OCI concepts like regions, availability domains, storage, network, identity and access management

•Performed lift and shift of On-premise database to DBCS on OCI-Classic trial version

•Installed and configured new databases of different versions (10g, 11g and 12c) on different OS (Linux, Unix and Windows) platforms

•Configured SSL and Active Directory or LDAP integration

•Performed upgrade of oracle databases from Oracle 11g to Oracle 12c

•Worked on database migrations, cloning, expdp/impdp to setup identical databases in the production and development environments

•Possess hands-on experience in performing backup and recovery of databases using user managed backup (Data Pump) and recovery manager backups (RMAN) and ASM.

•Implemented High Availability (RAC) for Oracle 11g databases

•Setup and configured oracle physical standby database (Data Guard) for disaster recovery and replication using Golden Gate

•Installed and configured Oracle enterprise manager Grid and cloud control

•Expertise in performance monitoring and troubleshooting/tuning by analyzing the SQL statements, TKPROF, AWR, ASH, ADDM reports and trace files

•With hands on experience in bash and shell scripting, automated daily backups and created alerts for any tablespaces or database issues

•Regularly performed PSU and quarterly CPU patches on databases/WebLogic and OBIEE to minimize the security issues and provide bugs fixes

•Worked on performance tuning of WebLogic and OBIEE

Automatic Data Processing (ADP) Private Limited, Hyderabad, India Jan 2014– April 2015

Member Technical – Oracle DBA

•Created, administered and maintained different versions of Oracle databases

•Configured and monitored RMAN & export backups

•Worked on different RMAN backup and recovery scenarios using hot backup and point in time recoveries

•Provided resolutions for day-to-day admin related issues/activities

•Performed daily and weekly backups for production database

•Provided detailed level documentation on Oracle DBA routine activities

•Worked on upgrade/downgrade of Oracle databases to different versions

•Hands on experience in installing, configuring Golden Gate and troubleshooting Golden Gate issues

•Supported in configuring RAC setup for Oracle 11g databases

•Raised service requests with Oracle on priority basis and followed up with them to get the issues resolved in timely manner and provided on-call support for P1/P2 (Prioritized) databases.

•Experienced in working in a production support environment to be able to understand and appreciate the criticality of issues and troubleshoot quickly to meet SLAs to avoid service downtime

•24*7 on-call production database support, worked on support tickets, change controls and maintenance including remote database support assisting in implementation of change control process in production

HCL Technologies Limited, Chennai, India Jun 2012 to Jan 2014

Analyst - Oracle DBA

•Monitored and maintained database activities for both development and production environments

•Installed and Configured oracle databases of different versions on Linux and Windows OS

•Configured RMAN and user managed backups for Oracle databases and scheduled them to run daily/weekly

•Regular health checks of databases were performed using OEM 11g and 12c

•Worked on day to day DB admin activities such as user creation, export/import and other DB alerts

•Hands on experience in BMC Remedy ticketing tool

•Worked on troubleshooting the DB issues and addressed them with a quick turnaround time.

AWARDS AND INVOLVEMENT

Awarded outstanding performance for my work on disaster recovery setup for Oracle Databases.

Recognized as a team’s top performer for Q1 2017 at Deloitte

CERTIFICATIONS

Oracle Autonomous Database Cloud 2019 Specialist

Oracle Cloud Infrastructure Foundations 2020 Associate

TECHNOLOGIES

Operating Systems: Windows 2008, 2012, 2016, PowerShell, Unix- Linux (RHEL, OEL), Sun Solaris, AIX

Web: SQL, HTML, ASP.NET & Apache Tomcat server

Database: Oracle 9i, 10g, 11g RAC & 12C databases, SQL server, Golden Gate, RMAN, Data Guard, DBCS

FMW products: WebLogic, OBIEE

Cloud: Oracle Cloud Infrastructure, Remote Data Gateway, OAC, RDC

Tools: Oracle Enterprise Manager (OEM), SQL Developer, Toad and Tableau

-Legally authorized to work in the United States for any employer.

Contact this candidate