Oracle DBA

Deepak

Bangalore, Karnataka

E-mail: *******.**@*****.***

Ph. No.: +91 – 888-***-****

Summary

• Working as Senior Member of Technical Staff in Oracle, Bangalore.

• Responsible for overall test development, specs writing, installation, upgrade, migration, datapump, replication, and finding fault

• Worked on various Oracle releases and part of multiple Oracle Database releases 10.2.0.5, 11.2.0.1, 11.2.0.2, 11.2.0.3, 11.2.0.4 (Under development) and 12.1.0.1 (Under development)

• Worked on various EBS suites 11.5.10.2, R12.0.4, R12.1.1

• 11 Years of DBA experience (7 years KeystrokePro, New Delhi, 1 year Hewlett Packard,

Mumbai, and 3.7 Years in Oracle, Bangalore)

• 5+ years experience in leading teams and managing multiple projects.

• ~1 year experience in Banking domain

Relevant Skills

10 years of experience in the field of Oracle database administration and implementation. Good analytical and design skills.

• Database creation on Unix and Windows.

• Installing Oracle 9i/10g/11g/12c on OEL, RHEL, AIX, Solaris, NT.

• RAC configuration Oracle 9i/10g/11g/12c.

• ASM configuration

• Expert in Oracle security related feature, Oracle DV, TDE, ASO/ANO

• Consolidated database creation in oracle 12c using multiple PDBs.

• Expertise in Oracle datapump.

• Expertise in cross platform database migration

• Transportable Tablespace and Transportable Database

• Data replication using Golden Gate

• Expert in RMAN backups.

• Expert in Manual Recovery & Backup techniques.

• Performance & tuning tools such as STATSPACK, AWR, TKPROF.

• Database Cloning from hot & cold backups.

• RMAN database cloning to same/different server.

• Hands on with Oracle 9i DataGuard (Physical Standby database).

• Oracle 9i Database patching using opatch.

• Expert in Oracle Database Minor and Major Upgrade (Patchset Upgrade).

• Good hands on with Oracle Software cloning to a different Unix Server.

• Simulation of production database transaction in test environment using Oracle Record and Replay (RAT).

• Good exposure to Unix Shell Scripting.

• Basic monitoring and maintenance of MS SQL Server 2003

• Installing and configuring the Oracle11i/R12 Applications on Single & Multi node / system.

• Oracle11i/R12 Applications Upgrading, Cloning and Patching both middle tier as well as db tier.

• Oracle Application tools for maintaining applications like adpatch, adadmin, adctrl etc.

• Can support 24x7 environments.

• Good understanding of Performance Tuning for Oracle databases.

• Understanding about how to work with Oracle Support to resolve issues.

• Good exposure to Unix/Linux OS environments and tools.

• Stress testing of Database

• Monitoring data using Oracle Application Manager, TOAD, OEM and HP Open View

• IT Service Management (ITSM) based on ITIL best practices

• ITIL Service Support areas of Incident, Problem, Change, Release, Configuration Management and Service Desk, creating and managing manuals (SOP, TOM, TAM etc)

• ITIL Service Delivery areas of Service Level, Availability, Capacity, Financial, and IT Service Continuity Management

Educational Qualification

Bachelor Of Engineering, Metallurgical Engineering, Regional Engineering College, Bhartidashan University, Tiruchirapalli, Tamil Nadu, India, in year 1999.

Professional Experience

1. Senior Member Technical Staff – Oracle India - Server Technologies (ST) – Bangalore, February 2009 – till date

Description

The Database Server Group in Server Technologies Division is the crown jewel of Oracle Corporation, creating the best database software in the industry used by hundreds of thousands of Enterprise and SMB customers worldwide.

System Testing Group within the Database Server division is a well respected, highly coveted group with a long track record of success. The group focuses on improving Reliability, Availability, Scalability and Performance of Oracle Database Server, Oracle Internet Application Server (iAS) and

Oracle Collaboration Suite (OCS) by Designing, Developing and Carrying out Multi-Tier

Stress/Integration/System/Performance tests which simulate complex concurrent real world scenarios.

Job Description

Server Technology System Testing group work on Developing/Executing Database system tests on a variety of platforms and also to develop tools/framework to automate this process. As a member of this group, we implement new database features as they are designed (in 11g and beyond) and managing very large databases with thousands of concurrent users.

As a member of the Data Warehouse Team, designed and develop very large databases and stressful workloads to test Scalability and Performance of Oracle RDBMS Data Warehousing, Data Mining features and Oracle E-Business Suite. The role also involves developing scenarios to test Scalability of different Oracle Features like SQL Execution/Query Optimizer, Partitioning, Parallelism, RAC and Database Server Perfomance . Responsibilities include Schema design, Application workload design, coding to generate data and load, executing the automated stress tests to exercise different kinds of database features.

Detailed Responsibilities

- Design & Develop Highly automated Multi-tier stress test workloads simulating real-customer

scenarios including Database DB schema design, data generation, load generation .

- Reviewing New Functionality/features in Oracle Products, Develop Test Specs/Architecture,

Design, and Implement Complete Test Suite simulating real-production systems.

- Execute Test Suites to discover defects in the products.

- Collaborate closely with development teams to resolve problems encountered in test simulations.

- Develop Automation tools, Simulation Apps and Re-usable Framework for efficient System Testing.

2. Delivery Lead – Hewlett Packard India – Mumbai, March 2008 to February 2009.

Client: Small Industrial Development Bank of India – Mumbai

SIDBI is an apex institution for promotion, financing and development of industries in the small-scale sector SIDBI is operating through its Head Office at Lucknow and a network of 4 Zonal Offices and 76 Branch Offices in all over India, which are connected through VSAT and LL links.

Job Profile

Working as Lead DBA for DataCentre at Mumbai, managing a team of DBAs and looking after Maintenance and upkeep of Oracle Database running on 9i, 10g and MS SQL Server 2003 on AIX 5L/RHEL AS/Windows2003 hosted on IBM and HP Servers and looking after allocation of system storage and planning future requirements, database backup and recovery, user & security management, performance tuning. Migrated all databases from 9i to 10g and AIX 5.2 to AIX 5.3 and monitoring and maintenance of Disaster Recovery Site (DR Site) at Chennai. Database include FARM, HRMS, PAYROLL, MIS, HOOPS, HPOV, MMOPS, EBS.

I was also involved in other site visits as and when needed for customer interactions, taking interviews for DBAs.

3. Manager – Engineering Database, Key Stroke Pro India Pvt. Ltd., New Delhi, April 2001 to March 2008.

Company Profile

The company is a fully owned subsidiary of ILI, UK (www.ili.co.uk), is now part of SAI Global Ltd. (www.saiglobal.com) (ASX: SAI), a 53 year old multinational company and the world’s leading in the field of Engineering Databases with offices across Europe and America. These databases are available through online subscriptions as well as on Info disks. The company has also ventured into IT enabled services and Business Partner in Outsourcing in multidisciplinary projects with clients across Europe, America and Africa.

Job Profile

As a Database Administrator I am responsible for installing and upgrading the Oracle Server/Client and application tools. Allocating system storage and planning future storage requirements for the database. Creating primary database storage structures (table spaces). Creating primary database objects (tables, views, and indexes, synonyms). Modifying the database structure, as necessary, from information given by application. Controlling and monitoring user access to the database. Monitoring and optimizing the performance of the database. Planning for backup and recovery of database information. Maintaining archived data on appropriate storage devices. Performing complete and incomplete recovery. Operating databases through Oracle enterprise manager console. Assist developers in designing tables and queries for high efficiency. Provide necessary support and guidance to the end users. Configure Network for end users who have connectivity problems. Linux server installation and administration, network configuration includes bonding, multihoming and network aliases. RAID configuration hardware as well as software level.

I was promoted to Manager from Project Lead in year July 2004, which came with extra management responsibility include day to day team management, Project management, Vendor management, Performance evaluation and appraisals. Also designed and implemented Business Continuity Plan as per ISO 27001 and heading a team of ERT.

4. Engineer Trainee - Hindustan Malleable and Forging Ltd., Dhanbad, India, Dec’1999 – Jan’2001

Company Profile

An ISO 9002 company concentrated in production of high quality precision castings of malleable and graded iron ranging from 20 gms to 100 kgs. Specializing in Automotive, Railways, Heavy and light engineering casting components.

Technology

Operating Systems : AIX 4.3.3/5L, RHEL AS/ES, Solaris 10,

OEL 5.0/6.0, Windows NT/2000/2003/2008

Databases : Oracle 12c/11g/10g/9i, MS SQL 2003

Applications: Oracle 11i (11.5.10.2) R12 (R1204/1211)

Database Management Tool : Oracle Enterprise Manager/Grid, Veritas

NetBackup 5.1, TOAD 8.6, Oracle Application Manager, TKPROF, Autoconfig, Adadmin, Adpatch, SQL Loader.

Languages : SQL, PL/SQL, PEARL, Shell Scripting, FORTRAN 77

Groupware : Lotus Notes4.6/R5

Packages : Lotus SmartSuite, Microsoft Office, Sun Open

office

Projects

1. EBS Test

Description: Project is based on Oracle EBS suite version 11.5.10.2, R12.0.4 and R12.1.1. Its internal database and need to tested with Oracle’s latest database before implementation.

Role: DBA, Designing Test spec, writing scripts, Upgrade from various version of Oracle to newer version, cloning from one version to another version and test the functionality using Winrunner.

Technical Environment: Oracle 10.2.0.5, 11.1.0.7, 11.2.0.1, 11.2.0.2, 11.2.0.3, 12.1.0.1, Apps11i, and R12 on Oracle Enterprise Linux 5.0/6.0, Solaris 10.

2. FARM DB

Description: Farm database is SIDBI’s banking database, it is used for daily transaction by all of the SIDBI branches in India.

Role: Delivery Lead DBA

Technical Environment: Oracle 10.2.0.4 four nodes RAC on AIX and same environment for physical standly.

3. MIS

Description: MIS database is Management reporting database which is sync with FARM database using dblink. Data pumped to MIS DB using nightly crontab jobs.

Role: Delivery Lead DBA

Technical Environment: Oracle 10.2.0.4 two nodes RAC on AIX and same environment for physical standby.

4. HRMS DB

Description: HRMSDB is SIDBI’s employee HR database, which holds all employee related details.

Role: Deliver Lead DBA

Technical Environment: Oracle 10.2.0.4 single node on AIX

5. SIDBIPAY DB.

Description: SIDBIPAY is account database of SIDBI

Role: Delivery Lead DBA

Technical Environment: Oracle 10.2.0.4 single node on AIX

6. MMOPS DB

Description: MMOPS is used for SIDBI Marketing Management and operations

Role: Delivery Lead DBA

Technical Environment: Oracle 10.2.0.4 Single node on AIX

7. HOOPS

Description: HOOPS is used for head office operations.

Role: Delivery Lead DBA

Technical Environment: Oracle 10.2.0.4 Single node on AIX

8. HPOV

Description: HPOV is used for data generated from HP Open View.

Role: Delivery Lead DBA

Technical Environment: SQL Servier 2008 on windows 2003.

9. ILI Transcription Database

Description: ILI Transcription Database is an application for automating transcription process. The system helps to maintain online voice data files and client details; it enables online tracking of clients files, porting them to the right manager.

Role: Project Leader/DBA

Technical Environment: VB 6.0, Oracle9i, RHEL AS 4.0

10. Metals Management System

Description:

Metals Management System is a GUI based application and is used to aid the Data-Processing team to Add, Edit and Delete the data with ease and also allows them with various kinds of references. The database maintains worldwide metals standards & its grades and metals suppliers. The front end of the application is developed using the Borland’s C++ Builder. The program uses the Oracle 9i database at the backend.

Role: Project Leader (System Analysis & Design)/DBA

Technical Environment: Borland C++ Builder 6.0 (IDE), Red Hat Linux 7.2 for the Database and Windows 98 Second Edition for the GUI Clients, C++ for front end GUI forms and Oracle 9i server for the database.

11. Material InfoBase

Description

The software handles details of proprietary materials from world wide chemical industry and their suppliers. The front end of the application is developed using the VB 5.0 and Oracle 9i as backend.

Role: DBA

Technical Environment: VB 5.0, Oracle 9i, Windows NT

12. ILI Standards Database

Description

The ILI standards database is the leading bibliographic standards database. It covers over 520,000 worldwide standards. User can locate standards using many different fields depending on the piece of information user hold. User can search standards by Number, Title, Text, Publisher, Document Type, Equivalency or any combination of these.

Role: DBA

Technical Environment

Borland C++ Builder 6.0 (IDE), Windows NT 4.0 for the Database and Windows 98 Second Edition for the GUI Clients, C++ for front end GUI forms and Oracle 9i server for the database

Contact this candidate