SUMMARY

• Over 7+ years of experience as an IT professional as an Oracle DBA Had experience leading various projects in 11g/10g/9i/ using RAC for HA and 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 Oracle 12c(12.1.0.1), 11g(11.2.0.3,11.2.0.4), 10g(10.2.0.3,10.2.0.4,10.2.0.5), 9i(9.2.0.8), on Operating Systems UNIX, Linux and Windows platforms.
• RAC with proficiency in setting up and administering 10g RAC and 11g RAC with Automatic Storage Management (ASM).
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g / 11g.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Experienced in using 10g and 11g features Data pump, Flash - Back Recovery, AWR, ASM, ADDM, Grid Control Monitoring and Recycle Bin.
• 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).
• Extensive experience Real application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database.
• Data guard Broker configuration and Managing Physical Standby databases using Oracle Data guard Broker.
• GoldenGate replication implementation
• GoldenGate Unidirectional and Bidirectional replication
• 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 like ER/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.
• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.

TECHNICAL SKILLS

Operating Systems: HP-UX 11.x, Sun Solaris 9, 10, AIX 5.1, 5.2Red Hat Linux RHEL 5.x,6.x and Oracle Enterprise Linux 5,6

RDBMS: Oracle 12c/11g/10g/10gRAC/9i.

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

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

Tools: /Utilities: RMAN, OEM, Sql Navigator,, SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Data pump, Data guard, VERITAS Net Backup.

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

Hardware Platforms: IBM Power Servers, CISCO Smart UCS Blade servers, HP UX 11.31 Itanium Servers

PROFESSIONAL EXPERIENCE

Confidential, Ohio

Sr. Oracle Database Administrator

Responsibilities:

• Involved in Installation and configuration of Oracle 11gR2 RAC (2node) using oracle Clusterware and ASM.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC,Standby Database (Active Data Guard),Replication. Install, upgrade and maintain Oracle 11g R2 on Windows 2008R2, Redhat5.
• Install, upgrade and maintain Oracle 12c on Redhat5.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• HP-UX Platform migration to Oracle Linux 6.3 Using RMAN Transportable table space
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• 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.
• Implemented Initial Data Load, Batch/Online replication, Security in Golden Gate
• DML and DDL Replication: Difference and configuration
• Golden gate Heterogeneous replication using Log miner utility
• Configured and Administered STREAMS and GOLDEN GATE.
• Standby Database (Data Guard) setup and configuration.
• Logical backup using Data pump and Import/export.
• Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
• Statistics and Reporting: various Golden Gate commands like STATS/LAG,RANGE to check the performance of various processes
• Configured Streams to capture propagate, apply changes in multiple databases.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• 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.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Data Modeling, Database Design and Creation using ER-Win, Visio.
• Monitoring and Troubleshooting of Database Replication issues using golden gate, dealt with conflict resolution and performance issues.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures. Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Installed Oracle 12C 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.
• SQL trace using Event 10046, SQL TRACE,Dbms session,Dbms support,Dbms monitor
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Environment: Oracle 11gR2, Red hat Linux 5.X,, Oracle 11gRAC, Toad, SQL-navigator, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, 11g Grid Control, Oracle RAC Grid Control, and Data guard.

Confidential, NYC,NY

Sr. Oracle Database Administrator

Responsibilities:

• Review of Database logical and Physical design.
• Migrated the oracle Database from 9i to 11g version.
• Install, upgrade and maintain Oracle 11g R2 on Windows 2008R2, Redhat5.
• 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 SQL server 2008/2005, backup and recovery.
• Database Restore using RMAN, Cold Backup and Export.
• Applying PSU / CPU Patches applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like Table space 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.
• Implemented Initial DataLoad, Batch/Online replication, Security in Golden Gate
• Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
• Creating database objects in operational datastore and maintaining them in Golden Gate
• Trouble shooting and performance tuning Golden Gate replications
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL, Data Guard, ASM and OEM
• 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.
• On-Call 24x7 DBA support for very large databases.

Environment: Oracle 11g/10g/9i, HP UX 11.31/ RHEL 5.4, Windows 2008, Data guard Grid control RMAN, Export/Import, ASM Packages. Tivoli backup, SQL*Loader, ASM, Data guard, Datapump

Confidential, NYC, NY

Oracle Database Administrator

Responsibilities:

• Installation of Oracle 11.1.0.7. on Oracle Linux .
• Install, Upgrade and configure Oracle database for various 32-bit and 64- bit platforms like HP-UX, Solaris - SUN SPARC & Oracle Linux Intel
• 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 to 10g/11g on Oracle database.
• Used shell scripting to automate all RMAN jobs.
• Migrating data using RMAN transportable tablespace
• Creating and maintaining Materialized Views for replication.
• RMAN Duplicate database and RMAN duplicate Standby database
• Run 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: Oracle 11g/10g, Cisco Blade server Oracle Enterprise linux, RMAN/10g Enterprise manager, Cisco Load balancer

Confidential, NYC, NY

Oracle Database Administrator

Responsibilities:

• Installed, Created and maintained 2 Node 10g RAC with ASM and created database for production, development and test environment on HP-UX platform.
• 24 x 7 production support group member supported by our team.
• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external backup using NETBACKUP.
• Migration of Database from 9.2.0.6 to 10.2.0.2 (RAC)
• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS), Export/Import and Datapump (expdp/impdp).
• Manage and maintain database and user security using OEM Grid Control
• Supported development by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools like Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager (OEM).
• Worked with IT managers and application developers to ensure the database integrity, high availability and security.
• Writing backend procedures, functions, packages and triggers using PL/SQL and also kshell scripts for automatic recovery
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Data Loading using SQL*Loader and DBVERIFY for corruption checking.
• Developed PL/SQL packages, procedures, functions and triggers to support application.
• Installed Oracle 11g database in the test environment and tested the upgrade from Oracle 10g to 11g.
• Monitoring and Tuning the CPU, memory usage, I/O contention, paging, network statistics on UNIX servers using IOSTAT, NETSTAT, VMSTAT, TOPAS and PRSTAT.
• Applying upgrade patches, maintenance and interim patches on all the databases
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures
• Designed physical and logical database structures and created, managed Tablespaces.
• Applied High priority patches downloaded from Metalink.
• Monitored production database using AWR and ADDM for Daily or weekly tuning needs.
• Gathering schema stats and monitoring the index usage.
• Documented backup and recovery plans and tuning procedures.

Environment: Oracle 10g/9i, Oracle 10g RAC, ASM, Red Hat Linux 4.x, HP-UX 11,Windows 2003, AIX, Data Warehouse, ERWin, Netbackup, OEM, SQL*Loader, Grid Control, RMAN, ASM, Dataguard, TOAD, Datapump

Confidential

Oracle 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 (9i, 10gR1).
• Also provided support to customers to manage their operational dataranging 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 undo 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, 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: Red Hat, Oracle 9i/10gR2, Oracle Enterprise Manager, SQL*Plus, PL/SQL, SQL*Loader, Toad 9

Confidential

Oracle Database Administrator

Responsibilities:

• Responsible for managing production, development & test databases and applications.
• Oracle database upgrade from 9i to oracle10g
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Database migration from Windows to Linux using exp/imp and Datapump
• Configured scripts to monitor activity with database. .
• Implement Hot, Cold and RMAN Logical backup plans.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Oracle Configuration. Oracle Tuning. Oracle Patch Administration.
• Creation of Table space, Data files, Indexes and monitoring them.
• Creation of Users and Granting them privileges and roles.
• Performed Database Tuning. Performed Database Security and Integrity. .
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 9i/10g, SQL Server 2005, IBM AIX UNIX, TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.

Confidential

Oracle Database Administrator

Responsibilities:

• Installing Oracle 9i/10g RAC on AIX and RHEL creating database for production, development and test environments.
• Assisting developers and 24*7 production database supports.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN, Complete and incomplete recovery of database
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Migration of database from 9i to 10g in the production and development.
• Performed SQL query optimization by gathering statistics and by using explain plan, STATSPACK, TKPROF and SQL Trace.
• Applied patches for the upgrades, bugs recovery, troubleshooting.
• Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Worked on 10g New Features: Data Pump, Automatic performance and diagnostics, Flash Back Technology, 10g RMAN’s New Features and Data guard(stand by database)
• Responsible for creating tables and indexes, performance monitoring of queries, table space allocations, and data striping.
• Used RMAN for Cloning of the creating database in test and development environment.
• Performed migration of database with Export, Import, Datapump and SQL*Loader jobs.
• Periodically uploading data from flat files using SQL*Loader
• Monitoring production systems to establish status and conduct proactive maintenance
• Ensuring proper online and offline backup and Periodical reading and checking of backups taken.
• Online index rebuilds. Controlling and monitoring user access to the database. Monitoring Rollback Segments.
• Estimation and creation of Control file, Log file (including multiplexing), Data files, Tablespaces and rollback segments.

Environment: Oracle 10gR2, Red hat Enterprise Linux 4.x,, SQL*PLUS, Explain Plan, UNIX Shell Scripting