Oracle Database Administrator and Data Analyst

Meticulous Oracle DBA and Data analyst by having acquired multiple skills through my previous work experience and graduate studies. Achieving a position in a profession where not only one can be challenged to reach goals and objectives that will render those skills and talents but at the same time allowing me to further expand my knowledge. Core technical skills include

Oracle Database administration and maintenance 12c, 11g, & 10g Oracle Enterprise Manager OEM RMAN Backup and Recovery Performance Tuning Real Application Cluster (RAC) ASM Proficient in Microsoft Office Suite: Advanced Excel Word Power Point

PROFESSIONAL EXPERIENCE

Shell (Jan 2014 – Dec 2016)

One of the world's major energy company that aims to meet the energy needs of society in ways that are economically, socially and environmentally viable, now and in the future.

SR Oracle Database Administrator

Provide level 3 and on-call support to mission critical, Production, Test and development databases in 24*7 environment that includes Oracle version 11g and 12c

Performance tuning and query optimization to enhance performance of SQL statements using explain plan, hints and indexes. Tuned existing process that reduced runtime from 8 hours to 5 minutes.

Provide support and database expertise to developers in all phases of Software Development Life Cycle (SDLC) for performance tuning, PL / SQL tuning and DDL / DML deployments

RMAN setup and monitoring

Golden Gate configuration and replication

Created excel dashboard and reporting that saved 8 man hours every day; enhanced various reporting

Implemented database partitioning

Perform compression and move activity and data warehouse database

Database cloning through Hitachi storage level replication and Data Pump Import and Export

Unix (IBM AIX) Shell scripting

ERCOT (Jan 2013 – Oct 2013)

The Electric Reliability Council of Texas operates the electric grid and manages the deregulated market for 75 percent of the state.

SR Oracle Database Administrator

Configured, installed, deployed, and maintain Oracle Enterprise Management (OEM 12c) and agent.

Setup monitoring template and job scheduling for Database and Server

Database backup, recovery and restore using RMAN.

Apply PSU patches and performed version upgrades.

Dataguard setup and monitoring.

Install, Configure and Administer Oracle Real Application Cluster (RAC) and Automatic Storage Management (ASM)

Create custom reporting solution using Information Publisher in OEM 12c

Deloitte Consulting India Ltd. (April 2006 – Aug 2010)

Their strategy and operations practice is consistently ranked #1 or #2 in the profession, achieving as much as double digit growth in select capability areas. Services include corporate strategy, customer and marketing strategy, mergers and acquisitions, social impact strategy, innovation, business model transformation, supply chain and manufacturing operations, sector-specific service operations and financial management

Oracle Database Administrator and Data Analyst

Provide level 1 and 2 to support mission critical database for 24*7

Administer Oracle Real Application Cluster (RAC)

Database cloning using Export / Import and RMAN.

Database Migration from Oracle10g to Oracle11g

Support developer’s with DDL / DML code deployment and collaborate with them to effectively create tables, views, packages, sequences, schema refreshes.

Resource Management (Create and manage Indexes, Tables), allocate and manage physical storage structures like Datafiles, Redo logs, Control files. Allocate and Manage logical storage structures like Tablespaces.

Data Guard monitoring and maintenance

Unix / Linux Shell scripting

EDUCATION

Master of Science in Computing & Information Science from Sam Houston State University.

Bachelor of Science in Computer Science from Osmania University

PERSONAL ATTRIBUTES

Strong analytical, conceptual, and problem-solving abilities

Good written and oral communication skills

Good presentation and interpersonal skills

Able to prioritize and execute tasks in fast-paced enviornments

Strong ability to work in a team-oriented, collaborative environment

Contact this candidate