Abhiram Mallarapu

Oracle DBA

SUMMARY

• Over eight years of experience in the IT industry involving Production Database Administration.

• Oracle Database Administration experience in variety of different environments like HP-UX, SUN

SOLARIS, AIX, RedHat Linux and Windows.

• Proficient in database administration, production support, installation, configuration, upgrades,

patches, performance tuning, backup and recovery, cloning, space management, database security,

auditing, troubleshooting, Unix shell scripting and documentation.

• Experienced in installing and setting up Oracle 11g, 10g, 9i, 8i databases.

• Planned and implemented high availability solutions using Oracle 10g RAC, Oracle 11g

RAC Standby Database (Oracle Data Guard).

• Good Knowledge of Installation, configuration, Monitoring and maintenance of Oracle Databases,

ASM, CRS cluster ware administration.

• Worked with team to support 24/7 production environments.

• Demonstrated ability to identify root causes of problems, consider both long and short-term impact

of proposed solutions and develop workable solution. Ability to manage multiple project tasks with

changing priorities and tight deadlines.

• Expertise in Oracle performance tuning using STATSPACK, TKPROF, Explain plan.

• Effective troubleshooting of database and performance problems.

• Experience in SQL, PL/SQL.

• Worked with development teams and data administration staff to enhance Database and

application performance.

• Monitoring, identifying areas that need to be improved in the application and database.

• Management of schemas, objects and partitioning the tables, indexes.

• Experience in managing Very Large Oracle Databases (VLDB) which includes OLTP as well

as DSS. Experience in Data warehousing and ETL

• Excellent experience in Partitioning which includes List, Range, Hash and Interval

partitioning.

• Experience in administration of large Oracle databases running in SAN environment, setting up

databases for bank environment.

• Proficient in Logical Database Design, Physical Database Design and Normalization.

• Experience in Data Migrations using oracle export/import, datapump, sqlldr.

• Performed backups and tested crash recoveries using conventional hot & cold backups

and RMAN.

• Proficient in using OEM and RMAN.

• Excellent experience in OLTP/DSS database systems, implementing and managing Very

Large Oracle Databases (VLDB) of size multiple TB. Expertise in data warehousing design and ETL.

• Demonstrated ability to work well with a wide variety of people at various levels, foster

cooperation and collaboration among individuals in the work unit, help team resolve conflicts

constructively and ability and willingness to communicate when help is needed.

• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of

challenges. Strong listening, interpersonal and analytical skills.

TECHNICAL SKILLS:

Operating Systems HP-UX 11,11i Sun Solaris 8(5.8),9(5.9),10(5.10) AIX 5.2,5.3,6.1,

Red Hat Linux RHEL 4,5,6

RDBMS Oracle8i, Oracle 9i, Oracle 10g (RAC), Oracle 11g (RAC)

Languages SQL, PL/SQL, C, PERL, UNIX Shell

Tools RMAN, OEM, SQL*Loader, EXP, IMP, EXPDP, IMPDP, ERWIN, TOAD

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Web Tools HTML,XML

Education:

• Bachelor of Technology

PROFESSIONAL EXPERIENCE:

OCIO/OCFO (DC Gov’t) - Washington DC June ’11 – Till Date

Sr. Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize up to 45 Oracle

Production Databases running on Linux/Solaris environment.

• Performed database cloning to setup test and development databases.

• Installation, Configuration and Maintenance of 5 node Oracle 11g RAC databases with ASM

• Upgraded databases from Oracle 9i, 10g to Oracle 11gR2.

• Applied patches to Oracle RDBMS in Development, Test and Production environment

• Converted to Oracle RAC 3 node from Single Instance database using rconfig.

• Cloned/Refreshed Oracle Databases for development and testing.

• Perform SQL tuning and assist developers with coding PL/SQL.

• Installed and Implemented Backup & Recovery procedures.

• Implement Hot, Cold backup (user managed and RMAN) plans.

• Setup of recovery catalog for RMAN.

• Performed workload balance by configuring services based on application priority.

• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using

RMAN and automated RMAN backup using scripts.

• Set up Cronjobs to monitor file systems usage, archive logs and cleaning up of these file systems

periodically.

• Set up local listeners on each node for high availability solutions.

• Performed block recovery using RMAN. Performed backup validations using RMAN.

• Oracle Database monitoring, troubleshoot and resolve the issues.

• Management of schemas, objects partitioning the tables & indexes.

• Automation of data load using Korn shell scripting and SQL*Loader.

• Responsible for setting up and managing user accounts, granting required privileges to users.

• Perform other regular DBA activities including space management and performance

monitoring.

• Optimization and tuning using TRACE FILE, TKPROF, EXPLAIN PLAN, AWR, ADDM.

• Involved in process improvement, Oracle Server Installations/Upgrades/Patches,

Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application

Tuning, Security Administration, Data Warehousing, Data Guard, Real Application Clusters.

Environment: Oracle Server11g RAC, 10g RAC/9i, SQL, PL/SQL, HP-UX, Sun Solaris, OEM, SQL

Plus, SQL Developer

AMEX - Phoenix, AZ October ’10 – May ’2011

Oracle DBA

Responsibilities:

• As a part of a team of seven DBAs, I am responsible for the support of a life cycle development

systems running oracle 10g and 11g on windows and unix based environment.

• 24X7 Production database administration, support and monitoring to ensure a proactive problem

recognition and resolution of database issues.

• Install, Configure, monitor, administer, upgrade, troubleshoot and patch 10G/11G Oracle database

in Multi Node RAC Unix in a Development/Production Environment.

• Used RMAN to Backup/Recover Production/UAT/Training/Dev databases regularly.

• Proactive database monitoring using 10g grid monitoring tool.

• Assist the application developers in testing and debugging new programs to ensure

compatibility with existing server technologies.

• Performed oracle administration for 6 RAC clusters. Duties include checking node health,

resizing disks when needed, workload partitioning by creating services with preferred nodes

and available nodes, schema creation, mirroring OCR files.

• Developer Environment Setup, Support, Cloning and Refreshes.

• Fix data errors from the urgent tickets created by users/help desk.

• Performed database full, incremental, differential backups using RMAN.

• Implemented Dataguard technology and configured switchover and failover with physical

standby database on UNIX environment

• Performed database cloning to setup test and development database.

• Conducting sizing & capacity planning for Oracle databases.

• Upgrading development and production databases to Oracle 10.2.0.4

• Applied patches to Oracle Databases and Oracle Applications.

• Involved in meetings with the users and gathered necessary requirements for creation of

databases.

• Implemented password verify function and stored procedure for user profiles and safeguarded

database privileges and security

• Identified causes for the slow performance of cluster database and worked proactively to

do the necessary changes,created a snapshot of database statistics for future reference.

• Responsible for optimizing the queries and application tuning.

• Resolved database incidents to ensure database stability and availability.

• Created External Tables to access the data in external sources(flat files, LOB data)

• Moved the data (schemas, tables) among the development databases using datapump utility.

• Registered databases to RMAN repository for Linux and Windows servers.

• Code review to ensure that the new customizations were developed to meet requirements.

• Effectively communicate and assisted offshore application developers with various requests.

• Performed SQL tuning and assist developers with coding PL/SQL.

• Responsible for setting and managing user accounts, profiles, auditing user sessions.

• Generated and analyzed AWR and ADDM report for system performance enhancement.

• Code Promotions to UAT & Production environments

Environment: Oracle Server 11g, 10g RAC /9i, SQL, PL/SQL, AIX, Sun Solaris, Red Hat

Linux, SQL Plus, Toad.

AON Corporation – Atlanta, GA January ’09 – September ’10

Oracle DBA

Responsibilities:

• Primary responsibility to support several Production, Test and Development databases (10g, 9i)

running on HP-UX platform

• Configured the database for warehouse implementation, cloned schemas and databases

using RMAN.

• Applied PSU/CPU security patches to 19+ databases on six Dev, seven Test and six Prod

database environments.

• Deployed Profiles, Password Functions and DB hardening/lockdown process to database

accounts & environment to comply with enhanced security standards dictated under Baseline Control

Standards, audit vendor standards.

• Run Sql tuning set's exercise to identify any index recommendations to be implemented

• Created/rebuilt indexes and computed stats to decrease physical and logical i/o on the sql

executions and better execution plan selection (used v$ views and top to identify the problem sessions)

• Assisted developers in troubleshooting sql execution plan/performance using event 10046 setting

at the session level during performance tuning exercises. Rediscover new components created on the

database servers for monitoring

• Co-ordinate tasks with offshore DBA's for database work (running audit scripts, tasks assigned

directly by clients, etc.

• Recovered database on Windows platform due to disk and hardware problems

• Restored production databases for DR (Disaster recovery) exercise on Sungard servers using

previous hot backups and RMAN scripts. This included planning and execution of recovery with

assistance from Sys Admin and Storage administrators.

• Tuned database using statspack reports, creating new indexes, computing stats on tables - to

decrease the physical i/o(3k/sec to < 100/sec) and logical i/o (8k down to 3k)per second on sql

statement executions .

• Was awarded Geek of the Week award for working with technical teams, vendor and recovering

the production database

Environment: Oracle Server 10g/9i, SQL, PL/SQL, SQL Plus, AIX, HP-UX

Computer Associates – Hyderabad, India March ’06- November ’08

Oracle DBA

Responsibilities:

• Provided support for all the oracle databases as an operational database administrator.

• Installed and configured Oracle 8i databases.

• Other duties include applying oracle database patches, design and creation of databases as per

user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recovery.

• Responsible for optimizing the queries and application tuning.

• Worked with Sys admins, storage and backup admins to setup the oracle environment, backup

process using RMAN

• Run AWR and statspack reports to identify sql with large buffergets and physical reads per

execution.

• Created/rebuilt indexes and computed stats to decrease physical and logical i/o on the sql

executions and better execution plan selection

• Upgraded and patched databases (8.0.5, 8.1.6, 8.1.7.0 TO 8.1.7.x, 9.2.0.x) on Production, Test

and Development boxes

• Implement Hot, Cold and Logical backup plans.

• Created and maintained RMAN catalog on production environment

• Analyze, design and implementation of the Database for e-commerce system.

• Migrated data using export/import and loaded delimited flat file data using sql loader.

• Proactive database monitoring using automated scripts based on v$ views.

• Frequent Database audits to ensure the SOX standards were not violated.

• Developer Environments setup using database cloning and refresh procedures.

Environment: Oracle Server 8i, 9i, SQL, PL/SQL, SQL plus, Sun Solaris, Windows 2002.

Contact this candidate