SUMMARY

• Over 8(+) years of experience as an IT professional along with extensive experience as an Oracle DBA with Data Modeling and PL/SQL development in Production, Development and Test environments. I have lead various projects in 11g/10g/9i using RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, upgrade, Capacity planning, cloning, patching, Performance Tuning.
• Excellent experience in Installation and configuration of Oracle11g, 10g, 9i, on Operating Systems UNIX, Linux and Windows platforms.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g / 11g.
• Data Modeling, Database Design and Creation using ER - Win, Visio.
• Expertise in administration, production support, configuration, upgrades, patches, space management, database security, performance tuning, troubleshooting database design, UNIX shell scripting and documentation.
• Extensive knowledge on database administration for Oracle9i, 10g and 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Installing and configuring OEM 12c.
• Experienced in using 10g and 11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Oracle Fusion Integration: BPEL & ESB & EBS design & implementation
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMANwith VERITAS Net Backup, &IBM TSM Storage Manager.
• Experience with implementing the Streams Replication and Golden Gate.
• Experience in Middleware Migration.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Expert in SQL* Loader, export/import and data pump to load data in to tables.
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).
• Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.
• Excellent knowledge in SQL, PL/SQL, Partitioning, Data modeling with utilities likeER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database Triggers.
• Implemented development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise
• Expert in implementing development, testing, staging, production and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Implementing standby database and database replication to provide high availability of database.
• Expert in implementing oracle streams, and two types of standby databases supported by dataguard, logical standby and physical standby databases.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$ views, DBA views and Data modeling, Logical and Physical databases design using tools like Erwin and Visio.
• Experience in working with ETL tools like ODI (ORACLE DATA INTEGRATOR) and other data ware housings transactions.
• Worked with the application design team in developing a custom ETL application using built-in Oracle technology (Oracle Replication, Materialized Views, Snapshot's, and PL/SQL) as well as designing the Star Schema used to support the company's Enterprise Business Intelligence system.
• Experience as On-Call 24x7 production DBA and application/development DBA and Oracle Support processes for technical requests through Meta link and other Support Procedures.
• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
• A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2Red Hat Linux RHEL 2.1, 3.x, 4.x,5.x and NT/2005/

RDBMS: Oracle /11g/10g/10gRAC/9i

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

DB Management: TOAD 9.5, Enterprise Manager grid,OEM, Grid control (RAC)

Tools: /Utilities: RMAN, OEM, Sql Navigator, Oracle Management Service(OMS), SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Data pump, Data guard, VERITAS Net Backup, MS Access.

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

Database Modeling: Erwin 4.1.2, Visio.

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 0, HP XP256 / XP512, IBM C server p5 model 590, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

Oracle Database Administrator

Responsibilities:

• 24x7 production support for several environments including production Oracle 11gR2databases.
• Data Modeling, Database Design and Creation using ER-Win, Visio.
• Work and implement PL/SQLstored procedures.
• Implement the different security strategies to restrict the access of database.
• Worked on data Conversion from one data model to another data model .
• Create and maintain Logical Data Model(LDM) and Physical Data Model (PDM).
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Implemented the Streams Replication and Golden Gate.
• Involved in Database migration from Oracle 11g to 12c.
• Installed Oracle 11g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases.
• Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Knowledge in TIBCO Business Works(BW).
• Experienced in Data Conversion from DB2 database to Oracle database.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.

Environment: Oracle 11g, Red hat Linux 5.8, Oracle 11gRAC, Toad, SQL-navigator, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM, Erwin 4.1.2, MS Access, Oracle database platform includes installation, configuration, maintenance, and performance tuning of Oracle instances on Oracle 11g, Golden gate,Oracle RAC, Grid Control, Streams, and Data guard.

Confidential, Columbia, MD

Oracle Database Administrator

Responsibilities:

• 24x7 production support for several environments including production Oracle 11gR2 databases.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts.
• Managing and supporting more than 60 production database as a team player.
• Trouble shooting PL/SQL procedures when necessary and provide the solution.
• Support for application deployment and rollback changes if necessary.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Gather the requirements and Design application schema structure.
• Created logical structure of a schema using ER-WIN.
• Enabling user level trace and monitoring the session for trouble shooting application errors.
• Worked on creating tables, indexes, triggers, types, procedures, packages and functions.
• Installing OEM 12c and agents across the production environment.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installed Oracle 11g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Scheduled the daily RMAN and Export used to backup the database.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.
• Data Modeling, Database Design and Creation using ER-Win, Visio.
• Work and implement PL/SQL stored procedures.
• Implement the different security strategies to restrict the access of database.

Environment: Oracle 11g, Red hat Linux 5.8, Oracle 11gRAC, Toad, SQL-navigator, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM, Erwin 4.1.2, MS Access, Oracle database platform includes installation, configuration, maintenance, and performance tuning of Oracle instances on Oracle 11g, Oracle RAC, Grid Control, Streams, and Data guard.

Confidential, Columbia, MD

Oracle Database Administrator

Responsibilities:

• 24x7 production support for several environments including productionOracle 11gR2databases.
• Performed upgrade/migration of singe instance database to RAC environment with dataguard.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Installing OEM 12c and agents across the production environment.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Install and configure Weblogic, OIM servers in Oracle Fusion Middleware11g.
• Installed, configured and tuned various SOA Suite Domains and Clusters contains Admin Servers.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Installed Oracle 11g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Scheduled the daily RMAN and Exportused to backup the database.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.
• Data Modeling, Database Design and Creationusing ER-Win, Visio.
• Work and implement PL/SQLstored procedures.
• Implement the different security strategies to restrict the access of database.

Environment: Oracle 11g, Red hat Linux 5.8, Oracle 11gRAC, Toad, SQL-navigator, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM, Erwin 4.1.2, MS Access, Oracle database platform includes installation, configuration, maintenance, and performance tuning of Oracle instances on Oracle 11g, Oracle RAC, Grid Control, Streams, and Data guard.

Confidential, Newyork,NY

Oracle Database Administrator

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle 9i, 10g 11g databases.
• Performed upgrade/migrations of databases 9i to 10g and 10g to 11g.
• Worked onOracle Fusion Middleware 10G to 11G upgrade.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN. configure Oracle ASCP to optimize specific business criteria
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAW Devices.UNIX shell scripting in csh,ksh to be controlled from Crontab.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.
• Used SQL server for ecommerce apps.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Installation, maintenance and tuning of Oracle 10g RAC databases including ASM and CRS.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Data Migration as part of enterprise data warehouse project.
• Monitoring and Troubleshooting of Database Replication issues using Shareplex and golden gate, dealt with conflict resolution and performance issues.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures. DataRefresh in Test and Integration Databases using Transportable Table spaces.
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases.
• Designing the security and database access strategies using tools like ESM.

Environment: Oracle 10g, Red hat Linux 5.X, Solaris 10, Oracle 10gRAC/9i, Toad, SQL-navigator, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM, Erwin 4.1.2, MS Access, Oracle database platform includes installation, configuration, maintenance, and performance tuning of Oracle instances on Oracle 10g, Oracle RAC, Grid Control, Streams, and Data guard.

Confidential, Alabama

Oracle Database Administrator

Responsibilities:

• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 9i on, Sun Solaris and Windows 2003, Redhat4.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Have created database on SQLsqrver2005, backup and recovery.
• Database Restore using RMAN, Cold Backup and Export.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Worked on Advanced Replication including synchronous and asynchronous scenarios.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• Performed Data Migration as a part of enterprise data warehouse project.
• Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Performed and maintained replication.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Developed tools to migrate the data from legacy systems to oracle database.

Environment: Oracle 10g/9i, Java, SQL, PL/SQL, Toad, Pl/SQL Developer, Erwin, O/S: RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, ASM Packages.

Confidential, Illinois

Oracle Database Administrator

Responsibilities:

• Installation of Oracle 10.1.0.2 on Sun Solaris as well as Windows Servers.
• Install, Upgrade and configure Oracle database for various 32-bit and 64- bit platforms like HP-UX, Solaris - SUN SPARC & Intel, MS Windows 2000.
• Involved in Design and implementation of oracle 10g Dataguard both physical/logical standby databases in high availability mode.
• Use of Data Guard Manager, 9i and 10g Data Encryption.
• Carry general administration tasks using tools like OEM and Toad.
• Implemented and maintained streams for synchronization of data at various sites.
• Used RMAN for backup and recovery jobs.
• Create & Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges. Created multiple Raid levels using volume manager.
• Applying Patches 9.2.0.6 on Oracle database.
• Used shell scripting to automate all RMAN jobs.
• Ran the Oracle STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
• Enabling the Trace files for the sessions which experience a very bad performance and generate the Trace output using TKPROF utility for further analysis.
• Trace the SQL that have poor performance and identify the ways of improving the performance by adding necessary indexes or removing the unwanted indexes.
• Trace the frequently called procedures/packages and pinning them to improve the performance.
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.

Environment: Sun Solaris, SUN SPARC, HP-UX, Windows 98/NT/2000, IBM X Series Server, Oracle 9i, Oracle Enterprise Manager, STATSPACK, TKPROF, EXPLAIN PLAN

Confidential

Database administrator

Responsibilities:

• Provided technical support for Oracle Server to customers for Production Database.
• Supported customers including international customer to install the developed application on different operating system e.g. windows, UNIX of all flavors on Oracle Database (8i, 9i, 10gR1).
• Also provided support to customers to manage their operational data ranging from GB to TB in Oracle database, solving of space problem, data loading problem Experience with building, installation, upgrade, and patching of Oracle.
• Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database, prepared Oracle database environment for the application analyst.
• Analyzed SQL queries causing performance problems.
• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins.
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.
• Provided OS (RAM, I/O, CPU) tuning for Oracle Database.
• Worked on Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.
• Applied patches both Server side and Client side.
• Supported the Upgradation from Oracle Server 8i and then to 9i/10g.
• Implemented OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM), Oracle Sales Analyzer (OLAP front-end) in Oracle 8i / 9i environment, Data Migration as part of enterprise data warehouse project. Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID And RAW Devices.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.

Environment: Solaris 8.0/9.0/10.0, HP-UX, AIX, Linux Red Hat, Windows 2000/2003 Oracle 8i (8.1.6/8.1.7 ), Oracle 9i/10gR1, Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad 8, ERWIN 3.6