Rushi Katragadda

adnpqw@r.postjobfree.com

616-***-****

PROFESSIONAL SUMMARY:

Diversified IT professional with 8 years of experience in Information Technology as Oracle Database Administrator.

Worked on Installation and Configuration of Oracle 11gR1, 12cR1, 19c on UNIX, Sun Solaris, and Linux.

Worked on high availability database environments such as RAC, Data Guard, and Golden Gate replication.

Experience in Golden Gate installation, configuration, and troubleshooting.

Created Oracle Data Guard for disaster recovery and maintenance.

Implemented ASM for data storage in RAC environments.

Good knowledge in Hot/Cold and RMAN Backup, Recovery and Cloning.

Performed RMAN full and incremental backup.

Expertise in loading data from flat files using SQL*Loader.

Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER.

Experience in data loading utilities for logical backups using export, import and data pump

Worked on performance tuning, backup and recovery, cloning, space management, database security, auditing.

Used features like AWR, ADDM, ASH, and OEM for database monitoring and tuning.

Experience in maintaining security using security compliance auditing.

Hands on experience in writing complex SQL queries.

Good knowledge on shell scripting.

Exposure to REMEDY, JIRA Tracking/HP QC Ticketing tools for tracking defects for Change Management.

Provided 24*7 on call support. Good team player with excellent communication skills, ability to produce & maintain documentation.

Worked closely with Project manager, Development, Testing, Pre-Production and Production teams to align project deliverables within due dates and reporting issues.

Ability to effectively prioritize and handle multiple tasks and projects utilizing IT process knowledge and full System Development Life Cycle (SDLC).

TECHNICAL SKILLS:

Operating Systems

RHEL, Solaris, IBM-AIX

RDBMS

11gR2, 12cR1, 12cR2, 19c

Languages

SQL, SQL*Plus, PL/SQL, Unix Shell Scripting

Data Replication

Oracle Golden Gate 19c, Export/Import, DataPump

Network Protocols/Services

TCP/IP, UDP, HTTP/HTTPS, SMTP, IMAP, POP3, NFS, DNS, and DHCP.

Tools

OEM 11g/12c, RMAN, EMPDP/IMPDP, AWR/ASH, SQL*Loader, SQL Developer

Monitoring Tools

OEM

Ticketing tools

HP QC, Remedy, JIRA.

EDUCATIONAL QUALIFICATION :

Bachelor of Technology (Electronics and Communication Engineering) from Jawaharlal Nehru Technological University, Hyderabad, India.

PROFESSIONAL CAREER:

T-Mobile(AMDOCS)

Atlanta, Georgia.

Database Administrator November 2014 – Till Date

Responsibilities

Installation, Configuration, Administration, Troubleshooting, Upgrade, Patching, and Migration of Oracle 11gR2/12cR2/19c databases.

Installed and configured Golden Gate on 12c database for data replication.

Involved in solving Golden Gate issues like abended, lagging issues.

Setup standby database for disaster recovery using Data Guard for high availability.

Worked in RAC environment with ASM for data storage.

Implemented Hot, Cold, and RMAN backup, Recovery, and cloning of databases.

Worked with logical backups using data pump, export/import utilities.

Used SQL*Loader to load data from flat files.

Monitored and Tuned database using OEM, AWR, ADDR, and ASH.

Monitored various database activities such as backup, error logs, space, performance, user and session monitoring to ensure proper capacity and availability.

Involved in user management and database security by granting appropriate Roles, Privileges, and Profiles.

Monitored availability of listener, database, alert log file, trace file.

Co-ordinate, consolidate and report the status of high priority task to management.

Experienced in production support with quick response time

Experienced in writing SQL, PL SQL queries

Experienced in writing cron jobs in UNIX, Linux.

Setting up QAT, DEV, PRE-PROD environment by following the standard practices as followed by T-MOBILE.

Environment: Oracle 11gR2/12cR1/12cR2/19c, RAC, ASM, Golden Gate, SQL, PL/SQL, SQL Developer, OEM, Linux, IBM-AIX, WebLogic 11g/12c, JIRA, Remedy.

RECKON IT SERVICES Ltd

Database Administrator Nov 2009 – Nov 2010

Responsibilities:

Monitoring and Troubleshooting Oracle error logs, various scheduled DBA server agent jobs, maintenance plans.

Setup and maintain all database backups for all production Oracle servers.

Monitor all production Oracle Databases for disk usage to plan future disk space needs per database.

Maintain Oracle service patch levels on all production Oracle servers based on the client requirements.

Database user administration and security management and database cloning.

Problem and Incident management.

Monitor all production Oracle database servers for performance bottlenecks.

Installation, management, and administration of 11gR1.

Managing day-to-day basic database administration.

Maintenance of database like rebuilding indexes.

Environment: Oracle 11gR1/11gR2, SQL Developer.

Contact this candidate