Background

• Oracle DBA with 5 years of experience in Oracle as Oracle 11g Database Administrator (DBA) on Operating Systems viz. HP-UX, client-server based databases and applications Server in 24x7 basis for Production, Development and Test Environments.
• Specialize in Oracle, advanced PL/SQL queries, installations, upgrade & performance tuning
• Managed Backup & Recovery using Export & Import, Data pump, Hot backup, & RMAN
• Used SQL Loader for text files, flat file to load data.
• Experience as a Database Administrator for Oracle 9i, 10g, 11g under UNIX, Windows NT.
• Created and Administered Oracle 11g RAC Databases using OEM GRID control.
• Real Application Clusters (RAC) monitoring, tuning, load balanced.
• Upgraded databases from 10g to 11g environment for multiple applications.
• Configure networking for oracle databases, tnsnames.ora, listener.ora
• Managing Database Structure, Storage Allocation, Building objects Table/Index segments, Views, Constraints, Database Access, Security Roles and Privileges.
• Acquired and nurtured the skill of computer programming, posses a natural ability and talent for dealing with computers and software related issues.

Education:

Bachelor in Engineering

TECHNICAL SKILLS

Advance DBA Tools: Oracle Enterprise Manager, Oracle Replication Manager,
RMAN, RAC
Development Tools: Forms 6i Reports 6i
Operating Systems: Windows NT/2000, UNIX, Linux red hat
RDBMS: Oracle 9i/10g/11g
Languages: SQL, PL/SQL, C, C++, Java, VC++.

Confidential,Cincinnati, OH Duration: Apr’10-PRESENT
Role: Oracle DBA

Responsibilities:

• Installations of Oracle11G, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Windows and Linux Servers
• Configuring RMAN and refreshing/Cloning databases using RMAN.
• Migration of system and applications from Oracle 10g to Oracle 11g. Install and maintain the application software at server and client end.
• Create and maintain multiple databases. Extensive experience in working in multi-site environments.
• Used IMP/EXP, IMPDP/EXPDP utility for export and import.
• Constant monitoring of database space and space management
• Setting up Oracle Standby and Oracle Data Guard.
• Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Table Partitioning, Creating Index Organized tables, Creating Locally managed table spaces.
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (RMAN)
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Tablespace creation, adding data files, allocated quotas to user and managed Disk space
• Writing database triggers, packages, procedures, functions, utilities for application development for the applications
• Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance of the SQL

Server
Environment: PL/SQL, SQL, SQL*Plus, Oracle 10G

Confidential,Princeton NJ Duration: Jan’09-Mar’10
Role: Oracle DBA

Responsibilities:

• Upgrading databases from 10g to 11g oracle for multiple Applications for different business units.
• Refreshing/Cloning databases, export and import data using oracle imp/exp utility,

Sql*loader, Data pump.

• Install Oracle RAC with Data Guard implementation for along with standby and Dataguard for availability and disaster recovery.
• Upgraded Oracle from 10g to 11g RAC.
• Typically involved in to configure RAC environment on Oracle11g.
• Create and maintain multiple databases.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 11g
• RMAN configuration and doing backup/recover & database clone using RMAN.
• 10G RAC configuration, implementation, and testing.
• Worked on Setting up, troubleshooting & tuning of RAC (2 nodes) on Oracle 11g.
• Monitor database performance and resolve performance related issues.
• Created password verifies function profiles and users for security.
• Monitor database health on daily basis and monitoring table-space growth periodically.
• Helping user community and resolving user errors and improving performance of queries.
• Building table indexes for improving performance.
• Expert in oracle sub programs (Procedures/Function/Packages & Triggers).
• Monitor Stand by Database.
• Table space creation, adding data files, allocated quotas to user and managed Disk space.
• Worked on 24X7 production support on large databases.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 11g, RAC, HP Unix, Windows XP, NT, Oracle Reports 11g, Oracle Enterprise Manager grid control.

Confidential,Dallas, TX Duration: Apr’08-Dec’08
Role: Oracle DBA

Responsibilities:

• Troubleshooting and performance tuning, development consultations, production database tuning, production system maintenance management. Monitoring system implementation.
• Created tables, inserted data with CSV, txt files using sql loader
• Worked in 24X7-distributed environment ready to support any time required by the IT team.
• Developed shell scripts to execute and automate to run Sql loader & pl/sql packages and added in crontab file for daily, weekly and Monthly cronjobs
• Modified and added new database triggers, packages, procedures, functions, utilities for application development for the applications for better performance.
• Wrote scripts for scheduling hot backups and table space management.
• Implemented Data Guard, maintain primary and standby databases.
• Changed passwords for privilege users and changing links (Dropping & recreating) with new passwords for security.
• Perform Export and Import of User, Tables, Schemas and Database
• Managing Table spaces, adding data files/resizing for the Table spaces filling up, coalesce the table space, managed extents.

Environment: Oracle 9i UNIX & Windows XP

Confidential,India. (Sep 2005 - Mar 2008)
Database Administrator

Responsibilities:

• Conducting Installations of Oracle9i, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation (including index design)
• Migration of system and applications from Oracle 8i to Oracle 9i. Install and maintain the application software at server and client end.
• Configuring and using the Oracle Enterprise Manger for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Used IMP/EXP utility for export and import.
• Constant monitoring of database space and space management
• Setting up Oracle Standby and Oracle Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (RMAN)
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Table space creation, adding data files, allocated quotas to user and managed Disk space
• Writing database triggers, packages, procedures, functions, utilities for application development for the applications
• Performance analysis and evaluation of queries and Databases in a slow running

application and monitoring / optimizing / tuning the performance of the SQL
Server
Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, Oracle Developer