Oracle DBA

Kiran

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

SUMMARY:

Over 8+ years of diversified experience in High Availability Grid Infrastructure (RAC with ASM), stand

alonedatabase, RAT, Replication options known as Data Guard, Steams; In all of these expertise in

Installation, configuration, Administration tuning, design, installation, configuration, patches, upgrade,

migration, database security, capacity planning, data modeling, backup, recovery, cloning, auditing, SQL,

PL/SQL, troubleshooting and documentation.

Experience in Installation, Configuration and Maintenance of Oracle 11g/10gRAC with ASM and

•

single instance database.

Oracle Database Administration in a variety of environments like HP UX, IBM AIX, Sun Solaris,

•

RHEL, and Windows NT/2000/2003.

Experience in design of Backup and Recovery Strategies using RMAN, and Configuring Oracle Data

•

Guard.

Experience in Installation Procedures for 10.2.0.4 Patch, Documentation for Adding a node to Existing

•

RAC environment and Data Guard.

Experience in LOGICAL BACKUPS and Database migration (HP Unix to SOLARIS) using

•

with DATAPUMP, Export/Import and Transportable Table spaces.

Expertise in working backup, restore and recover scenarios using RMAN and Also expertise in

•

traditional export and import, advanced export dump and import dump.

Experience in upgrade ORACLE 11.2.0.X to 11.2.0.3 out of place upgrade.

•

Have good knowledge and experience in designing database schemas per business requirements.

•

Experience in monitoring, tuning database configurations for optimal performance.

•

Experience in Capacity Planning, Undo segments and Health check reviews.

•

Extensive experience in Oracle Upgrades, Critical Patch Updates (CPU), Patch Set Updates (PSU)

•

and other oracle patches.

Experience in Golden gate and Datagaurd.

•

Configured Physical, logical and Active Data guard and managed in 10gR2 and 11gR2.

•

Having good experience using oracle utilities such as DBCA, DBUA, ASMCA and NETCA

•

Installed and configured Grid Control OMS and OMA using this to monitored Oracle targets and setup

•

alerts to on call person.

Supported machine critical application databases by giving 24x7 supports.

•

Possesses excellent analytical, problem solving and learning skills as well as a keen interest in the

•

emerging technologies.

Experience in Performance Tuning and Monitoring Oracle databases.

•

Experience managing production OLTP and DSS database.

•

Experience in DBA activities which include Creating Users, Roles and Profiles, Privilege management

•

with role based security of databases, table spaces, indexing, data maintenance, roles, user

management, and maintenance.

Excellent communications skills with proficiency in Finance and healthcare in data management

•

with Oracle databases and applications integration.

TECHNICAL SKILLS:

RDBMS Oracle 7,8i, 9i,10gR2 and 11gR2

SQL Server7, 2000 and 2005.

Operating Solaris 9/10, Linux RHAT 4/5, 6, HP UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows NT,

2000/2003/2005.

Systems

Languages SQL, PL/SQL, C++, C, UNIX Shell Scripting

Web Tools HTML, Java Script, XML.

Tools Oracle Enterprise Manager and Embarcadero Performance Center, Toad, SQL Navigator, and

PL/SQL Developer, BMC Remedy, AWR, Humming Bird/xming(X windows), Remote desktop

Server, WebEx and Net Meeting, JDBC.

PROFESSIONAL EXPERIENCE:

Bank of America, Dallas, TX Jan’11 –Till date

Role: Senior Oracle DBA.

Responsibilities:

• Responsible for scheduling and holding design reviews as needed to support the development processes.

• Upgrade Database from 11.2.0.1/11.2.0.2 to 11.2.0.3 (RAC) using method “out of place upgrade”.

• Responsible for the administration, maintenance, monitoring, performance tuning and trouble shooting

of all the databases and Job Automation.

• Prepared Installation Procedures for 10.2.0.4 Patch, Documentation for Adding a node to Existing RAC

environment and Data Guard.

• Experience in the Design of Production Database design, Backup Strategies using RMAN, and

Configuring Oracle Streams.

• Migrated databases from HP UX to Sun Solaris, and Windows to Linux.

• Managing and providing support for multiple databases in 24x7 production environment (from few 100

GBs to 10s of TB in size).

• Configured user log on load balancing and failover on RAC database.

DBA activities which include Creating Users, Roles and Profiles, Privilege management with role

•

based security of databases, Tablespaces, indexing, data maintenance, roles, user management, and

maintenance.

Provide 24x7 on call support for remote clients per specified customer and business Service Level

•

Agreements.

Capacity planning for changes in the size of databases due to business growth.

•

Always ready to take initiative for troubleshooting the issues on Cluster software configuration across the

•

nodes, like session and Data base configuration issues.

Prepared backup strategy, disaster recovery management and schedule backups for the databases by using

•

RMAN with UNIX Shell Scripts.

Installed, configure and also setup monitoring on OEM 11.1.0.1

•

Participated in team meetings, change management board and project meetings. Comfortable working

•

remotely without supervision.

Environment: Oracle 11g RAC/10g RAC, HP UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM

(Grid Control), RMAN, Explain Plan, Data Pump, SQL*Loader, AWR, ADDM.

Medco, NJ Mar’09 – Dec‘10

Role: Sr. Oracle DBA.

Responsibilities:

• Installed Created and maintained 3 Node 10g RAC and created database for production, development

and test environment on HP UX platform & Solaris.

• Migrated databases from HP UX to Solaris.

• 24 x 7 production support group member supported by our team.

• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup

using NETBACKUP.

• Worked in up gradation of Database from 9.2.0.6 and to 10.2.0.2 (RAC)

• Converting data files across different platform using RMAN convert, Transportable Tablespaces (TTS),

Export/Import and Datapump (expdp/impdp).

• Manage and maintain database and user security using OEM Grid Control.

• Supported development by providing SQL statement tuning and optimizing ETL procedures and

removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF,

TOAD and Oracle Enterprise Manager (OEM).

• Worked with IT managers and application developers to ensure the database integrity, high availability

and security.

• Writing backend procedures, functions, packages and triggers using PL/SQL.

• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.

• Developed PL/SQL packages, procedures, functions and triggers to support application.

Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring

•

scripts to check reports for space, Max. Extents, coalescing etc which are kept in CRONJOB

Installed Oracle 11g database in the test environment and tested the upgrade from Oracle 10g to 11g.

•

Monitored production systems to establish status and conduct proactive maintenance

•

Monitoring and Tuning the CPU, memory usage, I/O contention, paging, network statistics on UNIX

•

servers using IOSTAT, NETSTAT, VMSTAT, TOPAS, and NMON.

Applying upgrade patches, maintenance and interim patches on all the databases.

•

Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures

•

ORACLE TAR Management: Raised and monitored TAR s with Oracle Corporation for issue

•

resolutions.

Installation and configuration of Oracle Client software and Tools.

•

Gathering schema stats and monitoring the index usage.

•

Documented backup and recovery plans and tuning procedures.

•

Environment: Oracle 10g/9i, Oracle 10g RAC, ASM, HP UX 11.x,Solaris 9/10, Windows 2003, IBM AIX, Data

Warehouse, Erwin, Net backup, OEM, SQL*Loader, Grid Control, RMAN, ASM, Dataguard, TOAD, Datapump.

World Fuel Services, Miami, FL Sep’07 – Feb ‘09

Role: Oracle DBA.

Project: Job role required Oracle Applications 11.5.4 installation, patching, maintenance, cloning and upgrade.

Standard Oracle DBA (8i, 9i and 10g) responsibilities for administration, backup, recovery and monitoring for

development teams and production support. And setup and monitor Oracle databases using Embarcadero

performance monitor.

Responsibilities:

• Improved database performance by reorganizing data in a heavily fragmented database.

• Oracle 11.5.4 administration, Cloning, System administration

• Application user creation and profile setup.

• Migrated databases from HP UX to IBM AIX.

• Print pool creation

• Concurrent jobs monitoring

• Installed Oracle software and its upgrades

• Database Performance Tuning

• Installed Security patches

• Oracle Problem analysis and resolution

• Responsible for the Administration, maintenance, monitoring and performance tuning of all the

databases and Job Automation, STATSPACK reports

• Migration of Databases from Oracle 8i to 9i, and some databases to 10g.

• Supported databases on Windows 2000, UNIX and Linux.

Monitoring databases using Embarcadero performance monitor

•

Experience on OEM.

•

Backup and Recovery using RMAN.

•

STDBY database creation for critical databases for machine critical applications holding databases.

•

Teradata weekly and daily backups using NCR Net backup utility.

•

Coordination between teams.

•

Architecture reviews, Change management meetings and Team meetings.

•

Environment: Oracle 8i, 9i, 10g and 11i; HP, IBM AIX, Sun Solaris 5.8; Linux, Windows 2000,XP; NCR

Teradata, Net backup, RMAN, Toad, PL/ SQL developer, Embarcadero Performance Center tool and DBA

Studio.

ICICI Bank, India June’05 – Aug ‘07

Work Location: Hyderabad/Chennai, India

Role: Oracle DBA as contractor (Unpaid project)

Project: ICICI Bank is the Leading Private Bank in India has great culture and highest order of regulatory

compliance. This project deals with the maintenance of finance database and customers profile.

Responsibilities:

• Provided 24*7 on call support for production and development databases.

• Installed, configured and managed Oracle 8i, 9i on HP UX and IBM AIX environments for production,

test and development.

• Establish and Document Backup and Recovery strategies and procedures after evaluating various options

including RMAN, Hot and Cold backups.

• Upgrade and Migration of production and development databases from Oracle 8i to Oracle 9i.

• Using TKPROF, EXPLAIN PLAN for the better performance.

• Performed physical and logical database design.

• Worked with database export/import to backup database structure

• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their

growth rate.

• Coding stored procedures, Packages and functions and well tuning the SQL in the application

• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.

• Involved in PL/SQL Coding, Scripting & Training Developers

• Maintained all areas of Oracle database environment, including networking, related OS and application

areas quickly and efficiently by troubleshooting.

• Delivered technical presentations on Oracle database operation.

• Creating users granting the permissions and coping with the day to day demands and troubleshooting

their connectivity, permissions and performance problems

• Responsible for creating tables and indexes, performance monitoring of queries, table space allocations,

and data striping.

Optimized INIT.ORA parameters like DB block size block buffers, shared pool.

•

Net8 Configuration for Clients Connection.

•

Environment: Oracle 9i/8i, IBM AIX, HP UX, Windows 2000, RMAN, PL/SQL, Shell Scripting, exp/imp,

SQL, SQL/PLUS.

EDUCATION:

• Bachelor of Technology, JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY, INDIA.

CERTIFICATION:

• Oracle Certified Professional (OCP) on 11g.

• Oracle Certified “Oracle RAC 11gR2 and Grid Infrastructure Administration”.

Contact this candidate