Oracle Customer Service

SRI HIMESH BOBBILI Email : abqaem@r.postjobfree.com

Sr. Oracle DBA Voice : 425-***-****

PROFILE

* ***** ** ********** ** Oracle Database Administration, Migration, Monitoring, Performance Tuning, Database Backup and Recovery.Hands-on experience with Oracle 11g/10g/9i/8i/7.3 Installation on Linux, Sun Solaris, IBM AIX, HP-UX and Windows NT/2000/2003.Excellent track record in providing 24/7 on-call support for both production and development databases in result-oriented, time-critical environments.Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.Demonstrated competence in using various Oracle 11g features such as Data Pump, Mean Time to Recover (MTTR), AWR, ADDM, Grid Monitoring and Recycle Bin.Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, and Contention Resolution and Defrag scenarios across diverse environments.Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).Strong experience in Hot/Cold Backups and Point-in-time Recovery procedures using RMAN.Experience in Design and Development of Data warehousing (OLAP), Transactional Database (OLTP) applications on Oracle 8i/9i/10g/11g, Oracle Designer 6i, Sun Solaris, HPUX, & Windows NT/2000/XP platforms.Worked extensively on Oracle RDBMS. Comfortable with SQL, PL/SQL, and developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.Performance tuning expertise, specializing in OS tuning, SQL tuning, Database/Instance tuning.Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g.Experience in Migration of Databases from 9i to 10g, 10g to 11g.Performing cross-platform migration tasks like:Migration of Databases from RHEL 4 to Sun Solaris.Migration of Databases from a SOLARIS platform (ver 9 and above) to AIX platform.Experience in installing, configuring and maintenance of Oracle Golden Gate and Veridata Performed bi-directional replication from source to target Database using Oracle Golden Gate.Experience in building Standby databases. Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Datagaurd. Also proficient with new 11g features such as Active Datagaurd and Snapshot standby database.Implemented partitioning on large tables, expertise in using composite portitioning, local indexes, global indexes, indexes of Hash partitions, Reverse key Indexes, Indexes with smaller block size and Index Rebuilding through automated procedures.Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.Adept at using tools such as SQL Developer and TOAD for database administration. Written KORN shell scripts in UNIX and scheduled the job using CRON and Tivoli scheduling.Good experience in SQL Server Clustering and MSSQL Server 2000/2005, Log Shipping, and Database Mirroring.Transferring compressed files on FTP servers, on UNIX platform.

EDUCATION

Bachelor of Technology from Jawaharlal Nehru Technological University, Hyderabad, India

TECHNICAL SKILLS

Databases

Oracle 8i, 9i, 10g, 11gR1, 11gR2, MySQL

DB Management

TOAD 7.6/7.5, OEM 9.2/10G (10.1/10.2) Grid control (RAC), RAT.

Tuning/Monitoring

RAC 11gR1/R2, RAC 10gR2, Data-Guard 9i/10g/11g, DB Cloning, Standby Databases, RMAN 9i/10g/11g, TKPROF, EXPLAIN PLAN, STATSPACK

Programming

Unix Shell Scripting, PERL, Bourne, Korn, AWK-SED, PHP, JavaScript, SQL, PL/SQL, HTML, DHTMLC, C++, Java, FORTRAN 77/80.

Operating Systems

HP-UX 10.x/11.x, AIX 4.3.x/5.1/5.2,WINDOWS NT/2000/2003 Server, RED HAT LINUX 9/8/7.2/7.1/6.2, RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10, VMware ESX Server 3.0.x/3.5.0.

PROFESSIONAL EXPERIENCE

Baxter International Inc., Westlake village, CA Jan 2010 – Present

Baxter International Inc is an American health care company with headquarters in Deerfield, Illinois. The company primarily focuses on products to treat hemophilia, kidney disease, immune disorders and other chronic and acute medical conditions. The project group deals extensively with the financial data warehouse of the company and are responsible to maintain the data and the flow of data to and from various applications.

Job Description: Sr. Oracle DBA

Project Undertaken: Biolife 7.3, MCU (Migration, Consolidation & Upgradation)

Technical Environment: Oracle 11g,10g, 10g RAC, OLTP, EMC Storage, Windows 2000,

Oracle Golden Gate LINUX –Redhat, UNIX – AIX, Grid Control, AWR,

Spotlight,TOAD, OSW, SQLT and SQL Backtrack. Import/Export

Datapump

Responsibilities:

Involved in the installation, configuration and support of Oracle 11g R2 databases.Supported 40 production and 300 plus development and testing databases with database ranging from 100GB to 2TB.Installed Oracle 10g on Production DB Servers, applied Opatch to fix the known bugs.Demonstrated experience in managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools.Actively participated in installing of 11g RAC on Linux environment with two nodes and ASM as storage.Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.Worked with Golden Gate to move large volumes of data between oracle servers.Installing ASM environment and migrating database from NON-ASM to ASMPerformed advanced replications using Oracle Streams.Worked on Distributed Database Configuration, Creation of Database links and Snapshots used Streams for 2 way replication of data.Extensive experience in GoldenGate installation/setup/administration/troubleshooting and tuning.Used GoldenGate in moving large amounts of transactional data with minimal impact to online systems and performing GoldenGate on process of extract and replication of single instance as well as RAC Databases.Performed documentation for Clusterware installation, RAC RDBMSinstallation, RACDatabase creation, Grid Control installation, Oracle 11g Standby Documentation.Highly experienced in using STATSPACK, AWR reports to check health of database & hardware.Good Intensive Knowledge in using operating system command line utilities like SAR, TOP, MPSTAT, VMSTATProficiency in using tools such as TKPROF; EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries. Performed database Cloning using hot backup and cold backup to setup test and development database.Conducting sizing & capacity planning for Oracle databases.Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques, and other methods, including the use of automated tools.Created Parameters and Environment variables to run the same job for different schemasExperienced with all kinds(Status, Performance, Trend Analysis) of DB MONITORINGExperienced with SRVCTL for monitoring and configuring RAC Environment.Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances..Designed and Generated shell scripts to automate the processes and to proactively monitor the database.Creating and dropping of users, granting and revoking permissions to users/roles as and when required.Applied critical patch updates (CPU) released by oracle quarterly.Experienced with DATA GUARD implementation and Point in time Recovery.Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.Importing data from flat files into database using SQL loader and External Tables.Designing and implementation of database backup/restore methodologies, Troubleshooting performance and networking issues. General OS administration. Developed scripts for startup/shutdown, Disk Monitoring health check of databases and scheduling of backups.

Merck & Co., New Jersey Sep 2008 – Dec 2009

Merck & Co. is one of the world’s largest pharmaceutical companies, Merck & Co. Research, develop, manufacture and market a broad range of innovative products to improve human and animal health, directly and through its joint ventures. Based in Whitehouse Station, NJ, Merck operates in 140 countries.

With increased traffic in the use of Merck’s Electronic Lab Notebooks (ELNs), Oracle database deployment emerged as the logical solution.

Job Description: Oracle Database Administrator

Technical Environment: Oracle 9i (9.0.1.2.0 & 9.2.0.4.0), Oracle 10g, 10g RAC, Oracle Clusters,

Oracle Goldengate,SQL*LOADER, RMAN, Oracle Goldengate,Datagroup,

Import/Export

Project undertaken: Oracle database 10g, Oracle Exadata deployment

Responsibilities:

24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.Installed and configured Oracle 10g, RDBMS on UNIX and Windows environments on which the new Oracle exadata system was later deployed.Assisted System and Network Administrators in Setting up the hardware for installing 10g RAC.Involved in the installation of Oracle 9i on Windows NT and Linux. Developing programs for automating the execution of Hot, Cold and RMAN backups and recoveries.Developing, Testing and Implementing Sound backup and Recovery Strategy. Maintenance of all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.Creating primary database storage structures (table spaces, rollback segments, etc). Planning for storage spaces requirements and placing them for optimum I/O performance.Tuning the databases for optimal performance and monitoring CPU performance.Creating and managing tablespaces.Implementing range, list partitions, hash partitions.Creating and refreshing materialized views.Partitioning tables by determining the suitable methodology to improve performance and manageability.Cloning environments to create patch test, development and QA environments.Replicated databases using Oracle Golden gate software.Developing a Disaster recovery plan and conducted Disaster Recovery Drills.Performing all daily Maintenance tasks. Interacting with Oracle Customer service as required.Responsible for setting and managing user accounts, Granting required privileges to users.Applying High priority, security patches downloaded from Metalink.Monitoring the Database storage and other Day to Day activities.Creating custom concurrent requests to perform database maintenance.Developing SQL scripts to monitor tablespace and extent growth.Developed many PL/SQL functions, procedures, packages and triggers.Effectively utilized ADDM, AWR, and ASSM, AMM features of 10g and performed ASM implementation & maintenance.OS level activities like space monitoring of mount points.Automation of data load using shell scripting and SQL*Loader/Installed and configures OEM for monitoring and performance tuningDeveloped scripts for the automation of analyzing of tables.Hands-on experience in using Oracle Application Server 10g, in deploying and integrating enterprise’s applications

ACS, Schaumberg, IL Jan 2007 – Aug 2008

Affiliated Computer Services (ACS), Now A Xerox Company, is a global leader in business process and information technology services. That covers a lot of ground, from finance and accounting and transaction processing to IT outsourcing, human resource services and customer care. They provide services to diverse industries like communications, Finance, Healthcare, Manufacturing and retail.

Job Description: Oracle Database Administrator

Technical Environment: Oracle 10g, SQL Developer, Toad, Erwin and Windows 2003,

Sun Solaris 2.5, 2.6, Linux,UNIX

Project undertaken: Consolidation and Management of Employee data

Responsibilities:

Worked concurrently with an offshore team while providing 24x7 production database support.Gathered information from different data warehouse systems and loaded into One System Consolidated model.Responsible for trouble shooting, identifying and resolving data problems, SQL problems, Worked with analysts to determine data requirements and identify data sources.Responsibility for the service infrastructure and customer test systems.Creation of documentation and scripts for the maintenance and monitoring of the systems.Monitoring and performance observation of Oracle environments on both Customer productive systems and in house test systems.Evaluated projected hardware/software needs, and coordinated the installation of new operating systems and built databases upon them.Allocated system storage and planning future storage requirements for the database system.Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.Established and maintained sound backup recovery and procedures.Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.Configured Data guard 10g R2 for physical standby database and managing data guard configuration via DGMCRL tool.Created and managed both system level, object level roles and granted privileges for various users. Killing sessions and reinstating user privileges and roles.Cleaning the ORACLE_HOME files system by cleaning the log files, alert log file and listener.log files.Enrolling users and maintaining system security, ensuring compliance with database license agreements.

UTI Bank, Hyderabad, India Feb 2005 - Dec 2006

Job Description: Junior Oracle DBA

Technical Environment: Oracle Server 8i/9i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting

Responsibilities:

Installing and configuring Oracle databases. Optimizing queries and performed application tuning. Creating roles, profiles and privileges and assigning roles to users.Executing physical database changes required by applicationsCreating Public Synonyms, DBlinks, Ref Cursors, Raise_Application_Error, Parameterized Cursors.Installing and Implementing Backup & Recovery procedures. Implementing Hot, Cold and Logical backup plans.Implemented Stored Procedures and Triggers based on business plans using PL/SQL.Analyzing, designing and implementation of the Database for e-commerce system. Other duties included applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.Developed some forms and reports using Forms Builder and Reports Builder.Cross platform migration using export import from windows to Linux.

Contact this candidate