Oracle Database Administrator and Architect

Aayush Mittal **** Sunnyvale Saratoga Rd, Apt # **

Sunnyvale, CA – 94087

Phone: 408-***-****

Email: ******.*********@*****.***

Career Summary

• Oracle Performance engineering expert with an overall experience of 6 years in Oracle

Performance Tuning and Database Administration.

• Working with a Fortune 500 listed company, Apple Inc., from last 3 years, as our client. Being a

part of Oracle Database Engineering group (Performance & Architect).

• Leading Performance Engineering team, both at onsite and offshore.

• Experience handling client escalations, client facing interactions, delivering resolutions to business

impacting technical/non technical issues.

• Architect & setup various Active/Active HA oracle database environments through replication

technologies like Oracle Streams along with Oracle Golden Gate.

• Enriching and Stabilizing database environments through automations, reducing human errors as

well as improvising database monitoring standards, following a pro-active approach.

• Designed Performance Metrics Collector by centralizing AWR data to be fed to Splunk (Log

Analytics Tool) for Log Analytics, Trend Analysis, Performance Monitoring, Capacity Planning.

• Good hands on exposure over Oracle Database Administration.

• Exposure to Big Data/NoSQL technologies like Vertica, MongoDB.

Technical Skill Set

Skill Set/Technology Name/Version

Oracle Database Administration 10g, 11g, 12c

Oracle DB & SQL Tuning 11g

Oracle Replication Technology Oracle Streams, Oracle Golden Gate

Oracle RAC and Exadata 11g

Programming Languages Unix Shell Scripting, C, C++

OS Linux, Unix (AIX, HP-UX, Sun), Mac OS

Tools Splunk (Web based Log Analytics), OEM, Toad

Project History

Company: Tata Consultancy Services Ltd. Nov’ 2011-Present

Designation: IT Analyst

Client: Apple Inc., CA, USA

• Part of Apple’s Oracle Database Engineering group (Performance & Architect). Leading Oracle

Performance Team of TCS both onsite and offshore.

• Oracle Database Performance Optimization across IS&T for Apple providing performance

improvement recommendations to tune Applications that are end user facing.

• Architect & Support Active/Active Replication through technologies such as Oracle Streams to

setup Zero Downtime Environments.

• Designed Performance Metrics Collector that helps directly pointing out areas that are cause of

performance issues by centralizing AWR data to Splunk (Log Analytics Engine).

• Introducing, Maintaining & Writing shell scripts for Monitoring & Reporting things like DB

Health Checks, BHR Reporting, Session Wait monitoring etc., improving Pro-activeness in DB

environments

Company: Tech Mahindra Ltd. Sept’ 2008 – Nov’2011

Designation: Technical Associate

Client: MTS (Telecom Provider), Jaipur, Rajasthan.

• Handling client escalations and offering solutions for regular database related admin issues.

• Oracle Database 10g & 11g Administration involving Upgrades, Installations, Backup &

Recovery, Dataguard etc.

• Database migration cross platform. Like windows to Unix/Linux.

• Performing database switchovers, failovers etc.

• Database monitoring during load tests, running advisories, recommending improvements.

• Automating monitoring by writing shell scripts for health checks, tablespace growth trend etc.

Education

• Bachelor of Engineering in Computer Science (2004 - 2008), University of Rajasthan, India.

Certifications

• MongoDB 2.4 Certification conducted by MongoDB University (Sept 2013)

• Oracle 11g Certified Professional (Sept 2012)

• Oracle 10g Certified Professional (Aug 2011)

Achievements

• Awarded Star of the Quarter for FY2012-13 Q2 by Tata Consultancy Services

• Awarded Rising Star for FY2011-12 by Tech Mahindra Ltd.

• Awarded On the Spot kind of Award named as Cookie, twice in Tech Mahindra Ltd. FY2010-11

(Q2, Q3)

Contact this candidate