VEERA PRASAD BATTINA

Santa Clara, California-**051

E-mail: acgcm8@r.postjobfree.com

Ph: +1-408-***-****

Objective:

A Challenging Position as an Oracle DBA and Cassandra SRE in Professional

and Dynamic Organization that encourages growth and excellence.

. 8+ Years of experience in database administration managing large size

databases. Production support DBA for databases with Oracle Data

Guard, ASM, RAC, Data Guard Broker, Recovery Manager on Solaris, Linux

& Windows environments.

. Experience in Cassandra Projects like expansion of

clusters,upgrades,repairs and cleanup instances.

. 24x7 Production support of Oracle 11g/10g/9i databases. Managed very

large (Multiple TB) size databases.

. Experience in setting up and maintaining Oracle Data Guard for

production databases.

. Installed, configured, upgraded, migrated and patched Oracle databases

in heterogeneous environments.

. Hands on experience with ITIL process. Change, Release, Incident and

Problem management processes.

. Experience in working with ticketing tools Espresso & HP Service Desk.

. Involved in upgrading more than 300 databases from Oracle 9i to Oracle

10g Release 2 and in upgrading databases from Oracle 9i, 10g to Oracle

11g Release 2.

. Good knowledge on Oracle ASM Automatic storage management.

. Provided 24x7 Oncall support for production databases in various

projects.

. Good hands-on experience in Performance Tuning.

. Cloning/Refreshing databases from production for development, testing

purpose.

. Experienced with Oracle backup and recovery by both manual and using

RMAN.

. Worked with other infra teams during weekend and after-hours

maintenance windows to apply database changes.

. Has very good team leadership, technical, presentation and

interpersonal skills.

. Experience in working with Oracle support (metalink) to resolve

critical issues.

. Ability to work in a team and as an individual. Possess strong

communication and interpersonal skills.

TECHNICAL SKILLS:

Databases: Oracle 11g, 10g, 9i, 8i, Microsoft SQL Server, MYSQL

Operating systems: Sun Solaris, Linux, HPUX, Windows

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: Toad, Oracle Enterprise Manager, Oracle Grid Control, ASM,

Oracle Data Guard, Golden Gate, RMAN Oracle Recovery

Manager, HP DataProtector, HP Servicedesk

Experience Summary:

Working in APPLE Inc through Infosys from (Sep 2010 to till date)

Apple Inc. previously Apple Computer, Inc. is an American multinational

corporation that designs and markets consumer electronics, computer

software, and personal computers. The company's best-known hardware

products include the Macintosh line of computers, the iPod, the iPhone and

the iPad. I am employed in this role for the end-to-end support of

production and non-production databases.

. 24x7 production support for several mission critical systems, which

utilize multiple Oracle 10g & 11g databases.

. Maintenance of Cassandra clusters.

. Upgrade of Cassandra.

. Grow of cluster size in Cassandra.

. Doing repairs ad cleanup in Cassandra.

. Host Replacement of failed hosts in Cassandra.

. Familiar with GIT commands.

. Enable acess control in Cassandra clusters.

. Creating keyspaces

. Updating Replication strategy.

. Enabling Rolling Repairs.

. Set up, configured and maintained Oracle Data Guard to ensure disaster

recovery, high availability and data protection.

. Switch over and Fail over between Primary and Standby whenever needed.

. Migrated Databases from Solaris to Linux using Oracle Golden Gate.

. Creation and maintenance of Active Dataguard in 11g.

. Regular database administration, space management and day to day

database operations.

. Performance-tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE,

AWR, ADDM, Grid Control.

. Dataguard Broker setup, which would help in Fast Start Fail Over.

. Worked on data loading and extract using Export/Import, Data Pump, SQL

loader and External Tables.

. Implementing changes on various environments as per the change

management process.

. Working on automatic generated alerts, warnings and space related

issues.

. Setting up disaster recovery using Oracle Data Guard and making sure

the databases are in sync with primary databases.

. Refresh qualification and development databases/schemas/tables with

production data as on required.

. Worked on Shell scripts to automate routine tasks.

. Coordinating with Unix administrators during the server, hardware

maintenance activities.

. Following ITIL processes for the release, change, incident and problem

management areas.

. Assisted developers and application support people in day-to-day

activities and solving performance issues related to the database.

Worked in HP India (on pay rolls of E-Logic Tech) from (1 Aug 2006 to Sep

2010)

> Worked for Andhra Bank Data Center Project as an Oracle L2 DATABASE

Administrator (HP-UX DBA) on HP-UX production boxes clustered

environment. Maintaining the 70 databases of more than 35 TB of data

on 24/7 environment.. Taking Backup's and monitor in daily basis and

troubleshooting. Managing table spaces and rollback segments storage

requirements for tables and indexes. Delivering Database Services

(ensuring availability as per the SLA) to the customer with 24x7

production support.

. Creating and maintaining the Oracle databases.

. Delivering Database Services (ensuring availability as per the SLA) to

the customer with 24x7 production support.

. Creating User Accounts, Roles, Profiles and monitor users access to

database

. Create and maintain the Database structures like Table Spaces,

Rollback segments, Tables, Indexes and modify the database

structures as necessary.

. Upgradation of database from 9i to 10g

. Maintaining MS-SQL Databases.

. Check the SQL Error logs for any errors that may of occurred

overnight.

. Check available physical Disks pace (stored procedure)

. Installation of oracle clients.

. Check the jobs for failed completion in MS-SQL Databases

. Taking statspack report and analyzing the queries.

. Check backups and log sizes in MS-SQL Databases

. Resolving issues raised by L1's.

. Follow-up issues escalated to L3's.

. Write Scripts for automation of DB tasks.

. Carryout periodical activities and other activities assigned by

seniors.

. Plan shift schedule for L1's.

. Analyze all database segments on weekly basis and checks analyze

script logs for other special analyze activities.

. Identify SQL Queries utilizing more resource and help the Application

team to tune the query.

. Analyze statspack on periodic basis and study the performance behavior

and take appropriate actions.

. Generate and analyze Database Audit report.

. Manage capacity planning for future storage requirements

. Responsible for regular Backups & Recoveries and we are using HP-DATA

PROTECTOR for taking Backups and Restores.

. Monitoring CPU, MEMORY, DISK and SWAP Utilization by using GLANCE

command.

. Extensively used Export/Import Utilities for Backups, transferred

tables between Oracle instances and also for de-fragmentation.

. Synching and splitting the Database and taking Cold Backup.

. We are also taking the Online Backup by using the BCV (Business Copy

Volume).

. We are using the HP-Service Desk to lock the incident calls. For

Performance and File system issues.

> Worked for Bank of Baroda Data Center Project (Aug2006-Mar2008) as a

Shift Engineer (Support DBA Admin) on HP-UX production boxes

clustered environment. And giving support to Senior DBA & UNIX

Admin's.Maintaining the 50 databases of more than 35 TB of data on

24/7 environment.

Education:

> Professional

V Oracle Certified Associate, ORACLE Database Administration.

V HP-UX Certified Administrator

> Academic

EXAMINATION PERIOD OF STUDY BOARD/COLLEGE

B.tech (CSE) 2003-2006 JNTU

Aditya Engg College

Diploma in 2000-2003 SBTET

Computers Yvs&BrmmPolytechnic

Xth standard 1999-2000 SSC

Model High School

[pic]

[pic]

Contact this candidate