SUMMARY

• Around 8 years of Experience as Oracle 8i/9i/10g/11g DBA in Production, Test and Development Instance environment.
• Administered databases on Linux, Solaris, Windows-NT and Windows 2000.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Experience in Installation, Configuration and Re-Configuration of Oracle Database on Solaris OS, Red hat Linux AS/ES/4/5 and Windows advanced servers.
• Experience in Configuring, managing and monitoring both Physical standby and Logical standby databases using Data Guard.
• Involved with installation and maintenance of ORACLE 10g RAC 2 node cluster database for high availability.
• Experience in configuring, managing and monitoring ASM for standalone database and RAC database.
• Administrated database of various sizes from 40GB to 3TB.
• Experience in Design, Creating and Maintaining the Oracle Database.
• Experience in Capacity Planning and Space Management.
• Expertise in loading External tables into the Oracle database.
• Expertise in unloading tables from Oracle database using ODBC Connectivity.
• Experience in Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, UTLBSTAT, UTLESTAT, and STATSPACK.
• Monitoring and optimizing the performance of the database through Database Tuning – Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN and Scripts.
• Experience in using RMAN with Catalog database.
• Experience in Creating Duplicate databases using RMAN cloning as well as User managed cloning.
• Experience in Cumulative and differential incremental backup using RMAN.
• Experience in Point in time recovery.
• Expertise in applying Patch sets and Interim patches. Upgraded from 10.0.1.0 to 11.0.2.0.
• Experience in configuring, managing and monitoring Database Replication using Streams and Shareplex.
• Plan for contingency, disaster management that includes standby databases, data guard and cloning.
• Planning Backup/Restoration Strategy for 24x7 operation support.
• Planning and Scheduling Backups.
• Experience in Logical backups using Data Pump utility.
• Experience in Data modeling using Erwin tool.
• Experience in Migration from non oracle databases to oracle database.
• Experience in Oracle Enterprise Manager.
• Expertise in Database control as well as Grid control.
• Experience in Shell scripting.
• Experience in Flashback and Log miner.
• Expertise in Alert Monitoring and Ticketing.
• Provided support for implementing and upgrading various new and third party application in client site.
• Experience in working with a Team size of 2 to 5 DBAs.
• Expertise in PL/SQL programming.
• Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support

TECHNICAL SKILLS

Databases

Oracle 8/9i/10g/11g RAC

Platforms

Windows 98/2000/XP, Sun Solaris 10/9/8, RHEL ES/AS/4/5, IBM-AIX 6.x/5.x/4.3.3/3.2

Programming Languages

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

Tools/Utilities

TOAD, PL/SQL Developer, SQLPLUS, SQL Developer, Shareplex, Veritas, Erwin, TKProf, RMAN, Data Pump, data guard, Oracle Streams

Bachelor of Engineering, JNTU, India

Confidential,

Oracle DBA
First Data Corporationis an AmericanPaymentprocessing company headquartered inSandy Springs Georgia. First Data is a provider of electronic commerce and payment solutions. The company\'s portfolio includes merchant transaction processing services;Credit, Debit, Private-label, gift, payroll and other prepaidcard offerings; fraud protection and authentication solutions; electronic check acceptance services through TeleCheck; as well as Internet commerce and mobile payment solutions. The company\'s STAR Network offers PIN-secured debit acceptance atATMand retail locations.

Responsibilities

• Installation, configuration, and maintenance of Oracle 10g on RHEL 4 and 11g on RHEL 5.
• Responsible for setup and implementation of Two node RAC on Oracle 10g.
• Configured ASM with high redundancy for high availability.
• Implemented and managed Oracle Data Guard on Oracle 10g.
• Upgrading the Oracle 10g to the latest Oracle 11g Release 2 by applying patches. Used both patch sets and interim patches.
• Monitoring of Oracle Instances, Users, Tables, Table spaces, Memory Structures, Rollback Segments, Redo Logs, Archive Logs and Alerts.
• Creating and maintaining Databases manually as well as using DBCA.
• Replication of databases using Oracle streams.
• Encryption of tables and columns using Wallet manager.
• Creation of users and granting the users required privileges and roles.
• Involvement in space management, rectification of lock problems, managed quotas.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Managing backup strategy for all production databases (at least triple redundancy).
• Provide at least double redundancy for all development databases.
• Database backup & Recovery for non archive and archive database with RMAN commands.
• Used Data pump for exporting and importing tables, schemas and table spaces.
• Implemented Data Guard on production database.
• Archive weekly all production database exports to CD (in encrypted form), stored both onsite and offsite.
• Develop and enforce both database and OS-level security policies for data protection.
• Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Managed more than 4 databases using OEM Grid Control.
• Undo table space management.
• Rollback segment creation and assignment for transaction as per departmental requirement for process.
• Hands on experience working on High Availability Environments.
• Responsible for auditing tables using Triggers
• Active Alert monitoring.
• Post installation process, kernel upgrade, applying support packs and add-ons.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, AWR, ADDM, STATSPACK, SQL*Net, Data Pump, FLASHBACK and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Cloning databases with RMAN and also with user managed.
• Creation, managing and monitoring of database objects like Tables, Indexes, Views, Cursors, Triggers, Procedures, Functions, Materialized views etc.
• Loading of external tables into Oracle using SQL loader.
• Scheduling the databases backup using Cron tab and Veritas netbackup.
• Managing databases on multiple servers.
• Disk Space Monitoring.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.
• Managing and providing 24X7 supports for various versions of databases.

Environment: Oracle 10.1.0.4/10.2.0.4/11g R1 and R2, RHEL 4 and 5, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Shell Scripting, Stored Procedures, TOAD, Oracle Streams and all Oracle Tools.

Confidential,
Portland, OR Jan ’09 - Mar ‘10
Oracle DBA

The Regence Group is a nonprofit Blue Cross Blue Shield licensed health insurance company headquartered in Portland, Oregon. It is licensed to sell health insurance plans under the Blue Cross Blue Shield name in Idaho, western Washington, Utah, and Oregon.

Responsibilities

• Configuration and maintenance of a Two node RAC on Oracle 10g.
• Configuration of ASM with normal and external redundancy.
• Restoration of databases from Critical failures.
• Responsible for scheduling backups.
• Taking Incremental backup using RMAN.
• Creation and maintenance of databases.
• Creation of tables, table spaces, users, views and related objects.
• Performing analysis and diagnosis of database performance statistics.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Performing Online and Offline backups with RMAN as well as User managed.
• Schema and Table level replication using Oracle Streams.
• Tuning SQL queries when the performance is poor.
• Upgrading databases from 10.0.1.0 to 10.0.4.0 using Patch sets.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Alert monitoring and Ticketing.
• Implemented downstream capture at the destination database using Oracle Streams.
• Implementing backup procedures using Cron Tab.
• Performed activities such as Query Optimization, Database Consistency Monitoring.
• Installation of Oracle 10g on RHEL 4.
• Used Shell Scripting to backup database.
• Physical and logical data modeling using Erwin tool.
• Responsible for granting required privileges and roles to users.
• Duplicating production databases.
• Renaming and resizing databases.
• Restoration of purged tables using Flashback.
• Implementation of logical backups using Log Miner.
• Upgrading databases from 10.0.1.0 to 10.0.4.0 using Patch sets.
• Scheduling Oracle Jobs in the database.
• Implemented Point in time recovery using RMAN.
• Configuration of Multiple Listeners in the server and Net Service Names for the target databases using NETCA and NETMGR.
• Responsible for Space management and resolving dead lock issues.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER, AWR, ADDM, STATSPACK, SQL*Net, Data Pump, Flashback, Data Guard, ASM and RMAN.
• Managing table spaces, user profiles, indexes, storage parameters.
• Involved in developing and implementing PL/SQL stored procedures and triggers.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Oracle 10.2.0.3/11.1.0.6/.7, Linux, Solaris 10,Window 2003, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Shell Scripting, Stored Procedures, ASM, Data guard.

Confidential,
Utica, NY Mar ’08- Nov ‘08
Oracle DBA
The Utica National Insurance Group is among the top 100 insurance organizations in the nation,* and our products include a wide range of commercial and personal coverage. I have worked for Utica National on this project as a Database Administrator installed oracle, created, monitored, upgraded databases from Oracle 9i to Oracle 10g

Responsibilities:
.

• Oracle Database software installation, Instance creations, schema creations.
• Supported different Databases like Production, Development, Testing, and Data warehouse.
• Upgraded Databases from Oracle 9i to Oracle 10g on Solaris.
• Migration of Oracle Databases from Solaris to AIX.
• Experience in Data conversion using RMAN in the migration process of Oracle databases in Cross platforms.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Well conversed using the CRSCTL and SRVCTL tools for maintaining database , ASM and node applications
• Created physical standby database and worked with data guard to provide Disaster Recovery.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed troubleshooting of database using AWR and ADDM reports.
• Experience in Replication of oracle databases from prod to test/dev databases.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDMP and OS methods.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Extensively compressed large tables in Data warehouse Environment to reduce space usage.
• Responsible for network configuration and involved in a Client –Server environment using TNSNames, LISTNER, Net Configuration Assistant and other configuration files.
• Extensively used SQL LOADER as a tool for loading data.
• Performed replications using Oracle Streams.
• Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEM Database Control to monitor database.
• Created and Managed users, user profiles, table spaces, data files, archive log.
• Created database links that are required for databases.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, Solaris 7, RMAN, Sql*Loader, Import & Export, Data pump, Data guard, RMAN, AWR, ADDM, Stats pack, ASM, TOAD 7.4, Shell scripting, Data warehouse, AIX 4.3 etc.

Confidential,
Indiana Nov ‘06 – Jan’ 08
Oracle DBA/Developer

Lilly was founded by Eli Lilly in 1876, and are now the 10th largest pharmaceutical company in the world. Across the globe, Lilly has developed productive alliances and partnerships that develop innovative medicines at lower costs. Lilly is consistently ranked as one of the best companies in the world to work for, and generations of Lilly employees have sustained a culture that values excellence, integrity, and respect for people.

Responsibilities

• Configuration and Maintenance of Physical Standby databases.
• Supported different Databases like Production, Testing, Staging and Training.
• Online and Offline Database backup and Recovery.
• Upgrading databases from 9i to 10g.
• Creating databases manually or with DBCA.
• Backing up databases using catalog database with the help of RMAN.
• Monitoring Oracle instances with Oracle Enterprise Manager.
• Loading and Unloading of tables to and from Oracle respectively.
• Monitoring and managing Alert notifications.
• Configured databases with OMF and ASM.
• Used performance views to tune the performance of the databases.
• Table level replication using Oracle Streams.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, and IMPORT/EXPORT.
• Month end job monitoring and checklist preparation and co-ordination.
• Adding and resizing table spaces based on threshold metrics.
• Granting and revoking required privileges and roles to users.
• Implementation of table level snapshots on target databases.
• Hands on experience working on High Availability Environments.
• Implementation of almost all Oracle tools.
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 10g and Oracle 9i on Linux OS.

Environment: Oracle 9.2.0, Linux 4, Window 2003, Oracle Enterprise Manager, RDBMS, Oracle 10g ,SQLDBA, PL/SQL, TOAD7.5

Confidential,
Fishers, IN Dec’05 –Oct’06 Oracle Developer/DBA

Sallie Mae (NYSE: SLM), commonly known as Sallie Mae, is the nation’s leading saving, planning and paying for education company. Since its founding almost four decades ago, the company’s saving programs, planning resources and financing options have helped more than 31 million people make the investment in higher education. Sallie Mae is listed on the Fortune 500 and is one of the Top Innovators in IT according to InformationWeek. The company also has been recognized as one of the 100 Best Corporate Citizens according to Business Ethics magazine.

Responsibilities:

• Installation and maintenance of Oracle 9i on Linux OS.
• Installed, upgraded and patched Oracle installations.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Loading of tables into oracle.
• Created Users for the Applications, giving them different level of permissions.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.

Environment: Oracle 9.2.0.7, Window NT/2000/2003, Oracle Enterprise Manager, MS SQL Server 7/2000,RDBMS, VERITAS Netback up, SQLDBA, PL/SQL, TOAD7.5, Shell Scripting, HTML, Stored Procedures, Triggers.

Confidential,
Hyderabad, India. Jul ’04 - Sep ‘05
Oracle DBA
Apollo Hospitals is the largest healthcare provider in Asia. Apollo Hospitals Group is an integrated healthcare organization with owned and managed hospitals, diagnostic clinics, dispensing pharmacies and consultancy services. My role as a DBA was administration, maintenance, security and performance tuning of databases.
Responsibilities:

• Production Support for Oracle 8i/9i databases.
• Created and configured database manually using Oracle Database Configuration Assistant.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) and OS methods.
• Used Log miner to extract individual transactions from archive log files.
• Performed Schema Refresh by using Export/Import.
• Worked on SQL*loader to load data into database.
• Responsible for network configuration and involved in a Client –Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Managing database objects like Table spaces, Tables, Indexes, Views, and Synonyms etc.
• Monitored the databases using tools like Oracle Enterprise Manager (OEM).

Environment: Oracle 8i/9i, RHEL 3.0, Log miner, Explain Plan, Stats pack, RMAN, SQL, Schema Refresh, Snapshots and Materialized Views etc.