SUMMARY

• Over 8 years of IT experience in E - Commerce, Web and Client/Server applications, ERP and data warehousing environment with good understanding of backend relational databases.
• Oracle Database Administration experience working with various Oracledatabase management systems in database design, testing, implementation, maintenance and administration in a multiple platform environment including RAC, DATAGUARD, ASM, UNIX, Linux, RMAN, STREAM
• ASM, storage management, Instance, Disk Group, Failure Group, Mirroring, Stripping
• Monitored and tuned databases to optimize the performance when volume of data impact performance utilizing STATSPACK, AWR, ASH, ADDM,OEM, SQL Analyze, SQL Trace, TKPROF, Explain Plan, and satisfy the availability requirements of multiple applications.
• Setup and configured Oracle RMAN and Catalog for database backup and recovery operation.
• Applied various strategies for complete and incomplete recoveries depending on the type of failure
• Experience in installation & configuration Oracle 8i, 9i, 10g and 11g including patches.
• RAC installation, configuration on 6 nodes. Used ASM and Oracle Cluster file system
• Installation and duplication of auxiliary database from primary database for Data Guard used RMAN
• Oracle 11g R2 architecture, software installation, configuration, new directory structure setup
• Oracle 10g R1 /R2, Oracle 9i, Oracle 8i, software installation, configuration and apply patches
• Created new database and configured new applications in Oracle 11g, 10g and 9i versions
• Wrote Shell scripts to automate the process of nightly backups, scheduled jobs, alerts and exports
• Data modeling, Normalization, logical and physical database design and Application architecture
• Security management and accessibility control by managing OS and Password file authentication, setup user account, profiles, roles, and privileges.
• Performed database and user sessions Auditing with Audit Trail
• Monitoring of multiple databases including disk storage, instances, users activities, quota allocation, tablespaces usage, memory utilization, alert logs and trace file.
• Experience in Configuring Listener and TNSname file, troubleshooting network connection issues.
• Setup database parameters, configuration of Oracle parameter file (PFILE) and Server File (SPFILE).
• Database upgrade and migration from Oracle 9i to 10g and 10g to 11g.
• Replication and synchronization data with other branches using Materialized View and Oracle Stream.
• Excellent interpersonal, customer relational and proven communication skills.
• Experience in SQL, PL/SQL, Stored Procedure, Function, Triggers and Packages.
• Manages and maintains multiple production and non-production Oracle databases of significant and/or strategic impact across the enterprise.

TECHNICAL SKILLS

Databases: Oracle RDBMS Database System Version 11g, 10g, 9i, 8i, 8, 7.3

Operating Systems: UNIX, Linux Red Hat, DOS, Windows NT/XP, 2003 Server, IBM AIX 5.3, Mainframe

VAX/VMS, Sun SOLORIS 10:

Tools: Oracle Enterprise Manager (EM), Real Application Cluster (RAC), ASM, Data GuardRecovery Manager (RMAN), Oracle STREAMS, Log Miner, Oracle Flashback, TKPROF, Data PumpExport/Import, Crystal Report, SQL Plus, SQL Loader, Erwin, Microsoft Visual Source Safe, TOADOracle Data Warehouse Builder, Oracle Gateway, Oracle Portal

Languages: SQL, PL/SQL, iSQL, HTML, XML

Others Software: MS-Office MS-Word, MS-Excel, MS-PowerPoint, Microsoft Outlook, TOAD 10.1

Front Ends: Oracle Forms 6i, 9i, 10g. Oracle Reports 6i, 9i, 10g.Oracle Developer Suite 10g., SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, PA

Oracle DBA

Responsibilities:

• Control and managed various version of software development for multiple clients
• Provided 24x7 full technical support for production and non-production databases
• Monitored RMAN backups archivelog and exports of all databases
• Load data from third party’s flat files to production database tables used tool SQL Loader
• Used multiple Oracle tools like ADDM, AWR, ASH, OEM to tune to improve database performance
• Involved in installation of Oracle software 11g R2 and 10g R1 in AIX 5.3 environment
• Implementation of new releases and Hotfix to QA and production databases
• Maintained production and non-production databases in-host environment
• Performed Flashback feature on/off and configure retention on the request of QA team
• Performed logical backups for cloning databases used data pump utility
• Setup new Windows VM servers for development, Installation of Oracle software 11g R2, 10g R1
• Used orapatch utility to apply quarterly Oracle patch sets to production and non production databases
• Setup off-site Disaster Recovery databases for replication used 3rd party tool Quest Shareplex
• Wrote various DBA scripts and UNIX shell scripts to achieve certain goal and perform tasks
• Monitored and tuned databases and SQL to optimize the performance used tools OPTIMIZER,AWR reports, ASH reports, ADDM report, OEM, TKPROF, Explain Plan

Environment: Oracle 11g, 10g, Unix, IBM AIX 5.3, Windows 2003 Servers, Quest Shareplex

Confidential - Des Moines, IA

Oracle DBA

Responsibilities:

• Installation, Upgrading and configuration of Oracle 10g, 9i, on UNIX and Windows
• Managed and provided 24x7 technical support for Oracle databases
• Performed logical backups and cloning used data pump utility
• Setup RMAN and created recovery catalog database for database backup and recovery
• Applied various recovery scenarios for complete and incomplete recovery in case of failure
• Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota
• Monitored data files, logical data storage and data growth activities
• Performed auditing on user sessions with Audit Trail
• Migration of Oracle Database from 9i to 10g R2 in Unix and Windows server environment
• Wrote Shell scripts to automate operating system and schedule database tasks
• Replication and synchronization data with other branches using Materialized View
• Setting up Block and Segment storage parameters for Tables, Indexes and Clusters for optimal space utilization and concurrent transactions
• Worked as a team member in RAC project for high scalability and availability. Involved installation of Oracle software on six nodes and creation of RAC databases
• Performed Security Administration, Creation of Users, Managing their roles and privileges and quota
• Worked as a team member in Data warehousing project, involved in data mart, Dimensions and ETL

Environment: Oracle 10g, 9i, Unix Sun Solaris 9.0, AIX, Linux, Windows 2003 Server

Confidential, Reston, VA

Oracle DBA

Responsibilities:

• Installed Oracle software, patches. Upgrade old servers included installation of Oracle 10g R2
• Work closely with development and designing team to support and improve the production system
• Database planning and designing included Logical /Physical data models used tool Erwin/Data Modeler
• Migrated and upgraded databases from Oracle 9i to 10g R2 in UNIX and Linux environment
• Day to day DBA activities, users account setup, role and privileges, assigned storage quota
• Monitored and tuned databases to optimize the performance and satisfy the availability requirements of multiple applications used EXPLAIN PLAN, STATSPACK, OEM, AWR, ADDM and SQL Tuning Advisor
• Refreshed Development and QA databases from Production used Data Pump import utility
• Utilized Oracle Support MetaLink to troubleshoot the problems and issues
• Managed logical and physical storage including Disk, Data files, Tablespaces and database objects

Environment: Oracle 10g, 9i, UNIX, Linux, Sun Solaris 9.0, Windows Server

Confidential, Charlotte, NC

Oracle Developer / DBA

Responsibilities:

• Performed conversion of business requirements into conceptual, logical /Physical data models used Erwin
• Installed Oracle 10g R1, patch for R2 on new servers, new databases are created and configured with DBCA
• Performed DBA tasks like Creation of new database objects including, tablespace, tables, indexes, sequences, triggers, procedures, functions and packages.
• Performed Oracle Database upgrade from 9i to 10g in Unix and Windows environment
• Created and maintained Materialized views for best performance and replication
• Validate database & system configuration and health from Performance aspect - Optimize jobs/processes to run efficiently
• Run and Analyzed STATSPACK report to tune SQL statements for optimal performance
• Planned and performed full, incremental, differential and archivelog backups with RMAN
• Managed logical backups with export and import utilities
• Performed day to day DBA tasks including user account setup, reset password, space management,storage monitoring and troubleshooting database issues

Environment: Oracle 9i, UNIX Sun Solaris 8.0, Windows Server, Linux

Confidential, Scottsdale AZ

Oracle Programmer/Developer

Responsibilities:

• Worked as a member in Business Application development team, performed relational data modeling, including logical and physical design, SQL and PL/SQL coding
• Wrote numerous stored procedures, functions and database triggers for business application functionality
• Designed several pharmaceutical client-server and web-based business applications with Oracle Form Designer
• Debugged and complied application coding issues
• Performed modification of application level packages and form level triggers
• Designed, developed several matrix, master-detail reports with Report Designer
• Wrote backend SQL, PL/SQL code for application database objects
• Used tool like Explain Plan to optimize the code for better performance
• Expertise in conceptual, logical and physical data modeling design, reverse and forward engineering and comparison of the data models
• Involved in Data warehousing project, performed data modeling, Dimensions, ETL, used Oracle Database Builder
• Performed Extraction, Transformation of OLTP data to load into data warehouse tables

Environment: Oracle 8i, 9i, SQL, PL/SQL, Oracle Developer 2000