Tarakarama Raju Nepala

Linkedin: www.linkedin.com/in/tarakarama-raju-oracle-dba

SUMMARY

• Self driven Oracle DBA (416-***-**** ) with 13+ Years of IT experience in Database Administration, Backup-Recovery, Performance Tuning, Monitoring, Documentation, Security, cloning, capacity planning, space management and in-depth knowledge of oracle internals and architecture and hold extensive experience in Datacenter migration

• Expertise in deplyoing and supporting Oracle High Availibility environments like Oracle RAC, ASM, Data Guard, Standby Databases.

• Proficient in installing / maintaining / upgrading / patching of Oracle databases / software on various Unix and windows operating systems like Solaris/HP-UX/AIX/Linux/Windows etc.

• Possess excellent interpersonal and communication skills aiding in understanding customer requirements and coming up with relevant resolutions.

• Good in implementing data encryption (TDE) ( from vendors like Luna & Safenet)

• Good in coding using SQL & PL/SQL, shell scripting, SED & AWK

COMPETENCIES

• Operating Systems : AIX, Solaris, Linux, HP-UX, Oracle Enterprise Linux (OEL), Windows NT / Advance Server 2000/2003.

• Languages: SQL, PL/SQL, Shell scripting, SED, AWK

• Databases: Oracle 8,8i, 9i,10g, 11g, 12c

• Schedulers: Crontab, OEM 12c Cloud Control, Grid control

• Clusters: Oracle RAC

• High Availability: Oracle 10g / 11g / 12c RAC, Standby Database, Data Guard, ASM (Automatic Storage Management)

• Oracle Tools: exp / imp, RMAN, Datapump, TOAD, Pl/Sql Developer, OEM12c Cloud Control

• Security: TDE (Transparent Database Encryption) - Luna & Safenet

• Domain: Banking, Insurance, Manufacturing, Utilities and High Tech Sector.

CERTIFICATION

• Oracle 12c Certified Professional

PROJECTS ANNEXURE

Project The Co-operative Bank (Manchester, United Kingdom)

Company IBM

Role Sr. Oracle DBA, Migration Expert

Duration Jun' 2015 – May’ 2018

Responsibilities

• Worked onsite at Manchester, United Kingdom as part of team migrating 250+ databases of Oracle version 10g & 11g from one datacenter to another with insame version of AIX platform using tools like IBM TDMF, Dataguard etc with minimal downtime and managing them post migration. And also built new RAC & Non-RAC (Standalone) with ASM & Filesystem based setups of Oracle version 11g & 12c.

• Managing Major Incidents / Severity 1 incidents and Customer escalations. ( 416-***-****.)

• Strong analytical and problem solving skills with ability to work independently and within a team.

• Patching Software version 10g, 11g, 12c and Work with various state holder in coordinating the same.

• Plan and execute database upgrades to latest release ( Oracle 12c).

• Configure TDE (Transparent Data Encryption) for Oracle 11g & Oracle 12c databases which includes creating local wallet, migrating local wallets to HSM modules based on business demanded.

• Scripted and Configured RMAN backups including TDPO configuration for TSM backups.

• Scripted and Configured logical backups using Datapump for schema and database level backups.

• Created and configured physical standby database for mission critical databases to ensure maximum continued business availbility.

• Installing and configuring Oracle RAC 11g & 12c, Oracle DataGuard.

• Perform database architecture design reviews to identify any enhancements and recommend appropriate changes based on business requirements.

• Work with various teams/stake holders during different phases of projects for any new code deployments.

• User management and Privilege management.

• Online Table movement and Online Index rebuild.

• Good in Team management as Team Lead.

• As part of change management process, understand the impact of changes, coordinate with concerned parties in plementing the changes.

• Capacity planning using various methodolgies, Automation of various DBA tasks using shell scripts including proactive monitoring of databases.

• Troubleshoot complex issues including Database performance, SQL tuning etc. using AWR / ASH / ADDM reports

• Installed OEM Grid Control 12c, configured with high availability, administration, patching and agents installation on client servers.

• Automated various reports including backup and day-to-day monitoring reports for top management.

• Unix Shell scripting & Windows batch scripting.

• Create and maintain overall database related documentation which includes backup recovery policies, SLA (service level agreements), Change management, Production access, Risk management and maintain them periodically.

Project Celestica (Ontario, Canada)

Company IBM

Role Senior Oracle DBA

Period Jan’ 2013 – May' 2015

Responsibilities

• As part of 4 DBA team worked towards supporting DBA operations including Customer escalations and handling Sev-1 issues.

• Performing various database health checks and identifying any potential Risks and work towards mitigating them.

• Installing Oracle Standalone 10g and 11g and creating databases.

• Data guard configuration & implementation

• Troubleshooting various Performance issues including SQL tuning etc.

• Monitor physical standby database and automated scripts for any log shipment failures and ensure archive logs are shipped and applied to minimize data loss in case of a failover.

• Troubleshooting various database issues. Suggesting workarounds if needed.

• Troubleshoot performance issues and promptly resolve them as they arrise with necessary actions and workaround as needed.

• Proactively analyzing AWR / ASH / ADDM report for any potential performance issues

• Installing Oracle RAC 11g & creating database as per application requirements.

• Capacity Planning for current and future requirements.

• Performing Test/Staging database refresh from Production

• Work with Project managers during new code deplyments and advise best practices as applicable.

• Creating new users and assigning privielges to the users as per their role.

• Preparing relocation plan for Database migrations and finalizing the migration strategy based on database size, Customer requirements etc & Migration them from one Data center to another using cost - effective methodologies and with lowest possible downtime/outage to Customer.

• Patching software version 10g, 11g.

• Upgrading databases from Oracle 10g to Oracle 11g

• Configure RMAN & logical backups (Datapump) etc. Monitoring them and take appropriate action in case of failure.

• Good at SQL & Pl/Sql coding for vaious DBA and Non-DBA tasks.

• Proficient in tools like PL/SQL Developer and TOAD.

• Creating scripts for various purposes like backups, reports, alerts etc

• Automation of various every day DBA tasks which includes proactive monitoring.

• Shell scripting, batch scripting based on requirement

Project Cloud Services

Company JDA SOFTWARE

Role Senior Oracle DBA

Duration Jan’ 2008 – Nov' 2012

Responsibilities

• Installing Oracle RAC and creating database using ASM storage.

• Data guard configuration & implementation

• Troubleshooting various Performance issues like Database performance, SQL tuning etc.

• Troubleshooting various database issues. Suggesting workarounds if needed.

• Migration of databases from Windows to Linux (accross Endians) including RAC databases using RMAN utility with minimal downtime.

• Online table redefinition using Oracle DBMS_REDEFINITION.

• Configured Physical standby databases for mission critical applications ensuring maximum availability of databases.

• Analyzing and solving various complex issues including performance issues during migration

• Active role in preparing the relocation plan and finalizing the migration strategy based on database size

• Analyzing AWR / ASH / ADDM report

• Automated Standalone database software installation and database creation using shell scripts as part of Test/Development environment provisioning.

• Capacity Planning

• Proactive database health monitoring.

• Performing Test/Staging database refresh from Production

• Patching software version 10g, 11g.

• Upgrading databases (within same Oracle release & to higher release)

• Backup configuring RMAN, logical etc. Monitoring them and take appropriate action in case of failure

• Written SQL & Pl/Sql codes for vaious DBA and Non-DBA tasks.

• Creating scripts for various purposes like backups, reports, alerts etc

• Shell scripting, batch scripting based on requirement

Project IS & T

Company MINDRIVER INFORMATION TECHNOLOGIES PVT. LTD

Client i2 Technologies

Duration Jan’ 2007 – Jan’ 2008

Responsibilities

• Employed with MindRiver Technologies and deployed at i2 Technologies India Pvt Ltd. Role and responsibilities include resolving/trouble shooting various database issues filed by various business departments. Proficiency in installing, upgrading, patching and implementation of Oracle 9i, 10g, 10gR2 version. Very comfortable with installing 10g Grid Control / DB-Control / OEM and talking advantage of these tools. Proficiency in unix shell programming using SED, AWK. Written and maintained several Database backup and monitoring Shell scripts to provide backups on demand. Looking after Lenovo Database issues. Auditing database usage on all the database machines. Database Creation/upgradation, implementing database security.

EDUCATION

Bachelor Degree in Commerce

Profession Diploma in Network Centered Computing Applications (GNIIT Program)

ACHIEVEMENTS

CoE Pillar Individual Award : Reducing impact to customer by restoring services back to normal within given time by recovering the database from corrupted clone database copy

CoE Pillar Team Award : For Datacenter Migration of mission critical databases with minimum impact

References available upon request

Contact this candidate