SUMMARY

• Over 7 plus years of diversified experience as Oracle Database Administrator (DBA) on Oracle 11g/10g/9i/8i in development and production environments.
• Proficient in Oracle Database Administration activities such as Oracle Architecture, Database Installation, Upgrades, Migration, Patching, Cloning, Backup & Recovery, Performance Tuning, Automatic Storage Management (ASM), Capacity planning, Shell scripting, and documentation.
• Responsible for Production/Stage/QA/UAT/Development database maintenance and 24x7 support of production Data Warehouse Environment and OLTP databases.
• Implemented and administration of Oracle 9iR2 /10gR2 Real Application Clusters (RAC) on UNIX, Solaris, Linux (RHEL) platform.
• Experience in installing, configuring and administration of Oracle 11g/10g (RAC), 9i, 8i databases.
• Experience in adding nodes and deleting nodes to existing Oracle 11g, 10g RAC databases.
• Implemented Data Recovery (DR) and High Availability solutions using Oracle 11g/10g Standby Database.
• Experienced in upgrading database versions from Oracle 8i to 9i, 9i (9.2.0.x) to 10g (10.2.0.x) and 10g to 11g.
• Experienced in setting up Physical Standby Database by using DATA GUARD for Production Database.
• Proficient in Database Backups and Recovery using Logical Backups (Export/Import), Physical Backups (Cold/Hot) and Recovery Manager (RMAN).
• Hands on experience in implementing Recovery Manager (RMAN) for creating catalog Database and Backups.
• Experience in Performance Tuning by using tools/utilities such as Automatic Workload Repository (AWR).
• Worked in Development and Administration tools on Grid Control, TOAD, and Cluster Ready Services (CRS).
• Extensively worked on Advance Replication of data by using Oracle Streams.
• Experience in Monitoring and Application Tuning of Oracle Databases using various diagnostic utilities like ADDM, TKPROF, SQL TRACE and EXPLAIN PLAN.
• Performed Database Tuning - Tuning involved I/O, Memory SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Data Dictionary Views etc.
• Hands on experience in SQL query, PL/SQL Function, Packages, Stored Procedure, and Triggers to implement business logics of oracle database.
• Expertise includes management of schemas, objects & partitioning the tables & indexes.
• Experience in UNIX Shell scripting and CRON Jobs to monitor database status and analysis.
• Monitoring system performance using vmstat, iostat, SAR, Top etc.
• Experience in Logical and Physical Database Modeling and Design tools like Erwin etc.
• Good team spirit, strong oral and written communications skills, analytical and interpersonal skills and organized working habits with a willingness to learn new concepts.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3 RHEL 2.1, 3.x, 4.x, 5 .x, SuSE Linux Enterprise Server 9, 10 and Windows 95/98/ME/NT/2000/XP, VMware.

RDBMS: Oracle8i/9i/10g&11g RAC,SQL Server 2000/2005/2008

Application: Oracle Applications 11i and R12

Languages: SQL, PL/SQL, Java, C, C++, .Net, UNIX Shell Scripting, PERL.

Tools: & Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, data pump, Erwin, Power designer, TOAD, Oracle SQL Developer, Golden Gate.Banner, Forms, Reports.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Others: Informatica Power Center 7/8.1/8.6, ODI, BI,BO, ERwin® Data Modeler r7.3, PLSQL DEVELOPER, Quest Software Toad V8/9/10, DBArtisan 8.1/8.7

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Managing, troubleshooting and resolving Oracle Databases, RAC and applications issues.
• Installation of Oracle 10g/9i/cluster ware, Configuring public and private network and VIP.
• Configured the Public Network/Private Interconnect for Oracle 10g RAC.
• Involved in DATAGUARD (Standby) setup for high availability and disaster recovery purpose.
• Managed disks and disk groups using ASM.
• Performance tuning and Monitoring using Grid Control database & managing instances using OEM.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Import and Export of database objects to copy from one database to another database
• Creating Database links.
• Developed UNIX Shell Scripts (KORN Shell) for automating the loading procedures.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL programs, tune queries and database sizing.
• Co-coordinated, and delivered Oracle courses such as Database Administration, database security, enterprise backup and recovery solutions, PL/SQL concepts.
• Writing SQL Loader control files for data loading.
• Creating PL/SQL packages, procedures and database triggers.
• Database tuning, backup and recovery and general day to day running of the system.

Environment: Oracle 11g/10g/9i RAC, Sun Solaris 10/9, Putty (Unix),OEM, RMAN, Data Guard, AWR, PL/SQL, ERwind Data model.

Confidential, Atlanta, GA

Sr.Oracle Application DBA

Responsibilities:

• Provided Oracle database administrative support for all production and development databases.
• Installation, maintenance and configuration of Oracle Enterprise Edition 10g/9i database.
• Responsible for Oracle10g/9i/8i logical and physical databases design, implementation and maintenance on UNIX and NT.
• Extensively used the advanced features of PL/SQL like collections, nested table, varray and dynamic SQL. Oracle Developer Suite 6i
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration.
• Upgraded various databases from Oracle 9i (9.2.0.1) to Oracle 10g (10.2.0.1).
• Involved in installation, configuring and administration of Oracle 10g/9i RAC.
• Performing Oracle Database backups and recovery by using Oracle Backup utility Recovery Manager (RMAN).
• Participated in Planning, Analysis, Design, Implementation and Maintenance of Database Systems.
• Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.
• Set up Standby Database by using Data Guard for High Availability and DR.
• Performed database tuning using Explain Plan, TKPROF, SQL Trace and Enterprise Manager.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, AWR, Diagnostics Pack.
• Involved in activities like allocating systems storage and develop plans for future storage requirements like Capacity planning.
• Moved database Schema changes to stage or production.
• Data loading using SQL*Loader into Oracle Database from different sources (OLTP).
• Sizing database objects for effective space management and optimal performance.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Having very good experience in SQL, PL/SQL and UNIX Shell Scripting writing stored procedures, functions and database triggers.

Environment: Oracle 10g/9i RAC, PL/SQL, Red Hat Linux (RHEL 3), AIX, RMAN, Export/Import, Data Guard, OEM, PL/SQL, ERwind Data model, SQL*Plus.

Confidential, McLean, VA

Sr. Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administrations.
• Installing and Configuring of Oracle 9i/10g RAC
• Managing, troubleshooting and resolving Oracle Databases, RAC and applications issues.
• Installation and Creation/Conning Oracle Databases.
• Setup and configure Standby database (Physical & Logical) for high availability.
• Migrating Oracle 9i database to Oracle 10g. Installing Oracle Patch. Migrating production database to new server.
• Logical and Physical data modeling.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Performing Backups and Recoveries using RMAN/ conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN incremental backups.
• Used Export and Import ofdatabases for Logical backups and restores.
• Responsible for managing development and test databases.
• Designed the logical and physical database.
• Used Export and Import ofdatabases for Logical backups and restores.
• Creating and dropping of users, granting and revoking rights as and when required.
• Cloning databases for development and testing.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Coordinated with the developers and customizing the modules.
• Created and maintaining materialized views.
• Tuned of the Database for improved performance in a scenario of Full table scans on large tables, Design discrepancies in physical database layout,
• Finding and resolving I/O bottlenecks, Heavy data loading jobs.

Environment: Oracle 10g/9i RAC, HP-UX 11, Sun Solaris 2.9, RMAN, Data Guard, OEM, PL/SQL, SQL*Plus.

Confidential, Hartford, CT

Sr. Oracle Developer/DBA

Responsibilities:

• Participated meetings to gather functional and non-functional requirements with tax experts, tax officers and end-users.
• Involved in system analysis and developed requirement catalog.
• Participated in developing Entity-Entity Matrix, Logical Data Model and Data Flow Diagrams.
• Extraction of data from source systems through Excel and Flat files, loading in to the data mart tables for report needs.
• Extensively used Korn Shell Scripts for doing manipulations of the flat files, given by the share brokers.
• Created Tables & Views and referential integrity constraints using SQL and wrote Database Triggers, Procedure & Functions using PL/SQL.
• Created index on all key fields and analyzing tables is done to reduce query return times. Materialized views are created in many cases for frequent refreshes of data and also to improve performance.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• Developed Menu Model Diagrams and Input/output structures for the data entry screens.
• Involved in developing the Process Model Diagrams to represent the Income Tax business processes
• Used DBMS PROFILER package to understand where the code is spending the most time, detect it and then optimize it.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, used these tools with EXPLAIN PLAN.
• Developed program specifications and test plans based on the logical program specifications.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Orecle8i as back-end.
• Intensively involved providing end-user trainings to tax officers and data-entry operators.
• Designed and developed Web-enabled Oracle Forms & Reports including Forms based on stored procedures.
• Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.

Environment: Oracle 9i, PL/SQL, PERL, HTML, Discoverer, SQL*PlusReports, Sql*Loader, WindowsXP, UNIX, TKPROF, MS Outlook 2000, TOAD, Mind Map, MS Office, Oracle Reports9i/6i, Oracle Forms9i/6i .

Confidential, SD, CA

Sr. Oracle Developer/DBA

Responsibilities:

• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Import and Export of database objects to copy from one database to another database
• Creating Database links.
• Developed UNIX Shell Scripts (KORN Shell) for automating the loading procedures.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL programs, tune queries and database sizing.
• Co-coordinated, and delivered Oracle courses such as Database Administration, database security, enterprise backup and recovery solutions, PL/SQL concepts.
• Writing SQL Loader control files for data loading.
• Creating PL/SQL packages, procedures and database triggers.
• Database tuning, backup and recovery and general day to day running of the system.

Environment: Oracle9i,SQL,PL/SQL,OracleDesigner2000,Toad5.0,JAVA,HTML,UNIX,MSOutlook98/2000,MSWord,Micrsoft SQL Server 2005

Confidential

Jr. Oracle Developer

Responsibilities:

• Wrote shell scripts to process PL/SQL procedures and wrote PL/SQL program units for data extracting, transforming and loading
• VMware in a test environment
• Developed BI publisher reports to query the Service contract data from Oracle EBS
• Fine-tuned, the SQL queries in order to improve the overall system performance
• Taking logical backups using export at object and schema level to save space and reduce fragmentation in your database.
• Wrote UNIX shell scripts to encrypt flat files that are created by Oracle Job’s and to upload FTP the flat files to the designated server.
• Tuning application using tools like Explain plan, SQL*Trace and TKPROF for high efficiency.
• Design and Development of middleware solution for EDI 820 Payment Order /Remittance Advice, an Inbound Interface into Oracle EBS
• Wrote new procedures, which are triggered by UNIX shell script to process the staging data and do the required process.
• Developed BPEL process to interface Beeline Invoices to Oracle EBS
• Performed exception handling for data that did not conform to the required format.
• Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
• Testing and Implementing enhancements and solutions.
• Assisted in setting up the Forms and Reports Services on standard 6i server.
• Support for the development, pre-production and the production databases.

Environment: Oracle9i,SQL,PL/SQL,OracleDesigner2000,Toad5.0,JAVA,HTML,UNIX,MSOutlook98/2000,MSWord,Micrsoft SQL Server 2005, Windows XP, Erwin, Mind Map, Oracle Forms 9i, Reports 9i,Teradata.

Confidential

Jr. Oracle DBA/Developer

Responsibilities:

• Database administration for Oracle databases including installation, configuration, backup and recovery, performance tuning.
• Performed daily Database Backup using Export/Import, Cold, and Hot.
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Modification of oracle parameters and also involved in the database startup/shutdown activities in a maintenance window.
• Performance tuning of the SQL queries using Explain plan.
• Attended the performance issues and database trouble shooting.
• Troubleshooting Database performance by checking Alert Log file.
• Database performance tuning using relational database concepts and tools like STATSPACK etc.
• Data sourcing, transformation and loading using Export, Import, SQL*Loader.
• Performed Tablespace Management such as create tablespaces, add data files, monitoring extents, rebuilding indexes.
• Attended the daily database change requests for creating database objects (Tables, Indexes, synonyms, users, roles, views, sequences, database links, procedures, functions and packages).
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Reading Alert Log and User trace Files and Diagnosing the Problem.

Environment: Oracle 8i, HP-UX, Windows NT/2000, TOAD6.3, SQL, PL/SQL, Statspack, Cold, Hot.