Manager Database Administrator

SRI HIMESH BOBBILI

Oracle Database Administrator

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

Phone no.: 201-***-****

SUMMARY

• 3 years of experience as an Oracle database administrator..

• Experience working with Oracle 12c/11g/10g/9i on platforms like Linux, HP-UX and Windows XP/7.

• Worked on Oracle Binaries installation, Capacity planning, Database design & builds, Application specific Object

creation, User Access/security administration, Performance Monitoring & tuning, Consulting developers in

resolving issues and general database troubleshooting.

• Managed Database backup/recovery using strategies like Hot backup, RMAN and Cold Backups.

• Handled Medium to high scale Data migration and Advanced replication tasks using tools like export/import,

datapump, SQL Loader and Oracle Streams. Performed Database, Schema and Metadata migrations from 9i

to 10g and 10g to 11g And MS SQL server 2008 to 11g. Setup Cron jobs to automate Data pump

exports/imports.

• Experience working with Real Application Clusters (RAC) with Automatic Storage Management (ASM) and

utilizing features like Log Miner and Flashback data Archive, Data guard in Oracle 11g

• Well versed in administration activities like Application specific Component Configuration, Databases

Upgrades using DBUA, CPU & quarterly Patching, TAR support and Cloning binaries.

• Proficient in Shell scripting, SQL, PL/SQL coding, Partitioning, Data modeling and SQL tuning using

Explain plans and Performance tuning i.e. tuning SGA, I/O distribution using AWR & ASH

reports/STATSPACK

• Worked with tools such as OEM, TOAD and SQL developer for Database monitoring and for dispatching

day-to-day database administration tasks..

TECHNICAL SKILLS:

Sun Solaris 5.10, Sun Solaris 5.9, HP-UX 11i v1.5, AIX 4.3, AIX 5.3, RHEL 3, RHEL 4, RHEL 5,

Operating Systems

6, Windows 2000/2003/XP/7

Databases Oracle 12c,11g RAC, 10g, 9i, MS SQL server 2000/2005/2008,

SQL*LOADER, export/import, Datapump exp/imp, RMAN, TSM, Opatch, TK Prof, Statspack,

DB Utilities

SQL server, AWR, ASH, Streams

Scripting Shell Scripting Korn & Bourne

Oracle Enterprise Manager, TOAD 8.5/10.6/11.6, SQL Developer 3.2,, Putty, Xming, Moba

Tools Xterm, Hummingbird, SQL*PLUS, WinSCP, SQL Data modeler, SQL- Navigator, MS Visio,

Red Gate and Flashback data Archive.

Languages SQL, PL/SQL for Oracle, C/C++

EDUCATION / CERTIFICATION:

• Masters of Science in Mechanical Engineering(Design /Control Systems) from New Jersey Institute of

Technology Newark, NJ – Dec 2011

• Bachelors of Engineering in Mechatronics Engineering from JNT UNIVERSITY, INDIA - 2009

WORK EXPERIENCE

EMPLOYER : Infolob Solutions

CLIENT : Centurylink – Monroe, LA

DURATION : Apr 2012 - Present

ROLE : Oracle Database administrator

PROJECT : National Inventory Consolidation (NIC)

National Inventory Consolidation is a project kicked off in 2012 after Centurylink acquired Qwest communications. The

Objective is to Deliver a unified inventory and provisioning workflow for data services to enable market leadership in

both service activation interval and new product time to market The current program scope covers all local affiliate

inventory and provides a NextGen inventory system for nationwide consolidation.

Roles and responsibilities

• Responsible for administration of Multiple development, test, End-to-End and reporting Databases and

Application releases on them.

• Daily/Weekly Health Check of the Databases. And database sanity tests after each release.

• Database design, capacity planning, Creation and Management Of over 30 databases across 6 different

applications.

• Responsible for all Oracle 10g/11g/12c binaries installations across the 6 applications. And Oracle Client

installations and Creating scripts for Database builds and all the pertinent objects like application specific

schemas, tables, roles etc

• Responsible for Creating,managing user accounts, roles, Granting required system/object privileges to users,

Managing security and Network access to the databases.

• Installed Application specific components like JServer Virtual machine, XDK, XML database, LDAP client.

Recompiling and Validating application specific packages.

• Maintained Hot Backups for Test databases and restored them as necessary for the release operations.

• Setup of RMAN backups and recovery, Oracle Enterprise Manager agents and Recycle bin purge

procedures for production Databases.

• Responsible for Quarterly Patching,Upgrading and other maintenance activities as necessary.

• Worked on large scale data migration and consolidation from multiple legacy Qwest sources and

consolidated them into Newly created, dedicated Centurylink NIC environments.

• Responsible for decommissioning of Legacy Qwest databases, after performing the necessary Data

migrations After a successfully release.

• Daily/Weekly Health Check of the Databases. And database sanity tests after each release.

• Performed cross platform migration of data from MS SQL server 2005/2008 databases to Oracle.

• Used Repository manager and also set up Datapump parfiles for importing Metadata.

• Set up conversion databases and pushed data into them using A Custom Data load tool.

• Assisted The UNIX team in performing Failover tests for databases running on 3 & 5 node Linux clusters.

• Created Materialized view refresh functions for specific schemas in reporting instances to have the data

from production available for developers.

• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE and assisted

developers with improving the code. Approval of queries or tuning them as necessary before promoting them

to production.

• Partitioned large tables to increase the performance . Implemented Range, List Partitions, Hash, Sub

Partitions

• General monitoring of database performance during peak and non-peak loads using STATSPACK. Also used

AWR and ASH reports to identify bottle necks when the test teams kick off a Load and Performance test.

• Identifying slow running queries during peak hours using AWR reports and Root cause analysis.

• Upgradation and Migration of Database from 10g to 11g and performed CPU and SCN escalation patching.

• Responsible for Maintaining documentation for each release cycle, Tracking Database changes by utilizing

custom in-house tools.

ENVIRONMENT: Oracle 9i/10g/11g/12c, RedHat Linux 5.X,6, HP-UX, Windows XP/7 MS SQL Server 2005/2008,

RAC, ASM, Datapump, Dataguard, RMAN, OPatch, PL/SQL, EXPLAIN plan, TKPROF, STATSPACK, AWR &ASH

reports,

EMPLOYER : New Jersey Institute of Technology

LOCATION : Newark, NJ

DURATION : Dec 2010-Jan 2012

ROLE : Graduate Student assistant-Testing Co-ordinator

Roles and Responsibilities:

• Analyzing Mathematics and Reading Levels of newly admitted Undergraduate students.

• Identifying students that required Bridge courses based on cut off scores.

• Contacting students who require placement testing and scheduling test appointments based on volume.

• Organizing and Conducting Math and English tests to analyze Math, Reading and Writing level and assign

courses to incoming students

• Utilized PERL scripts to modify and filter student data

• Entering student data and test scores into the Registrar’s system .

• Produced reports using test scores and made them available for analysis by counselors.

Environment:, Java Apps, PERL, MS Excel and Windows XP

Contact this candidate