SUMMARY

• Over 8 + years in Oracle Database Administration, tuning, development, analysis, design, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, backup and recovery, cloning, troubleshooting and documentation.
• Excellent experience in Oracle database administration on Oracle 11g/10g/9i RAC and standalone databases in different environments LINUX, RHEL, OEL, WINDOWS.
• Strong Experience in Installation, configuration, Maintenance, Performance Tuning, Backup & Recovery Cloning of Oracle and SQL Server.
• Experience in Re - Organization of database using export/import and Data Pump.
• Experience in implementing and using Oracle Streams for Replication.
• Experience with Disaster Recovery, Data Guard, RMAN, Real Application Cluster (RAC), OLTP and Data warehousing environments.
• Enforcing Database security by creating and assigning Roles, Profiles and Privileges to various Users (Schemas) on different Objects.
• Implemented Oracle Enterprise Manager (OEM), Automatic Storage Management (ASM) & Automatic Database Diagnostic Monitor (ADDM).
• Proficient in using various database utilities like Export/Import, Expdp/Impdp (Data Pump), SQL * Loader.
• Excellent Knowledge on Golden Gate Installation and Migration.
• 3 years of experience in Goldengate Technology for Replication. Also, experienced in upgrading Goldengate software from 10.2.X version to 11.2.X.
• Extensive experience with RMAN backup, hot backup and cold backup. Performed full backups and incremental backups. Backup and Recovery strategy using hot backup, user managed and RMAN.
• Experience in developing Shell Scripts to manage Oracle databases daily backups and monitoring jobs.
• Migrating and upgrading the databases to higher versions.
• Excellent communication and interpersonal skills.
• Proficient in Verbal and Written Communication skills which enhances my ability to communicate with everyone working around me and the ability to prepare the Documentation with ease to understand.
• A quick learner and an excellent problem solver who can work independently or as part of a team. Skillful in learning new technologies quickly and incorporating them in the existing infrastructure.
• Expertise in maintaining Database Security using auditing.
• Expertise in loading data from flat files using external tables, SQL*Loader.
• Managed streams for data replication, data protection.
• Worked as a team member to provide 24x7 on-call production support
• Supporting a customer base & troubleshooting issues in production environment involving internet technologies
• Exporting & importing data into the databases using Oracle utilities such as exp/ imp and Data pump
• Interfacing with customers, analyzing their needs and providing recommendations on capacity planning, upgrades, migration of database, application architecture
• Accountable for database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, developer/integrator relations, script development, documentation and DBA training
• Creating table spaces, rollback segments, user maintenance, database security imposition by creation and granting of roles & privileges, performance tuning, backups, tuning of SQL statements and support for oracle toolsets and utilities
• Monitoring database System and optimal performance
• Preparing & maintaining servers, documentation & procedures, addressing performance bottlenecks
• Ensuring that goals of the process are achieved, restoring normal service as soon as possible based on customer perspective and within defined SLA

TECHNICAL SKILLS

Databases: Oracle 9i, 10g,11g, 12c, MS SQL Server 2000.

Middleware: Oracle Application Server 10g

Hardware & OS: Linux, UNIX, Solaris 9, 10, Windows 2000/2003.

Programming: Basic Shell Scripts.

NetWare: TCP/IP, FTP, Telnet, Netscape, and Internet

Tools: & Utilities: RMAN, Data Pump, Dataguard, OEM, Grid Control. Oracle Export/Import SQL Navigator

Oracle Tools: SQL*LOADER, Oracle SQL Navigator, TOAD

ERP Modules: Oracle Applications R12/11

Others: VMware, Net Backup, Toad

PROFESSIONAL EXPERIENCE

Confidential, Peoria, IL

Oracle DBA

Responsibilities:

• Administering 24x7 Real Application Cluster (RAC) databases running on Cluster File system. Worked with senior DBA’s for preparing cluster, configuring and Installation of Clusterware and Oracle RAC on Red Hat Linux. Startup and Shutdown of Individual instances on RAC database using Enterprise Manager.
• Installation, Cloning, Configuration and Administration of Oracle 11gR2 RAC.
• Migrated oracle 11gR2 databases to 12c from windows to Linux.
• Installed RAC on Oracle 11gR2 and worked on ASM feature of Oracle.
• Created and maintained immediate failover with up to the minute data to minimize the recovery time mission systems using oracle GOLDEN GATE (Testing Purpose).
• Setup RAC to RAC Data guard with real time applies for DR purposes and offloading reports onto read-only standby.
• Periodically cloned databases from production to the Dev environment using RMAN duplicate DB.
• Identify poorly performing SQL’s using Oracle 12c SQL monitoring feature and run SQL tuning advisor to analyze advisory suggestions.
• Used Oracle 11g SQL plan stability feature to stabilize execution plans of poorly performing SQL queries on OLTP systems.
• Work with application developers and business groups to partition large transactional table’s in-order to facilitate max availability, manageability and performance.
• Implemented and tuned RMAN backups using incremental backups (Oracle block change tracking) thus reducing the back-foot print on daily backups.
• Worked closely with the network team to migrate both public and private networks on the Production RAC clusters in a rolling fashion with minimal to no downtime.
• Applied standby first patch apply Oracle PSU patches on Oracle RAC clusters (GRID & DB) with 2 node RAC standby.
• Worked in 24 X 7 running databases and support environment
• Performed RAC all nodepatching and Rollingpatching.
• Migrated oracle 9.2.0.8 databases to 11.2.0.4 from windows to Linux
• Ggs Heterogeneous replication usingGoldenGate(Oracle 11.2.0.3 to SQL Server)
• GoldenGatetroubleshooting using Log miner
• Migrated Database between servers using Data Pump Export/Import
• Knowledge of the OracleGoldenGateinstallation, configuration, troubleshooting GG issues

Environment: Oracle 11gR2, Red hat Linux 6.X, Oracle 11gRAC, Toad, SQL-navigator, Goldengate, SQL*Loader, ASM, and Data guard

Confidential, San Jose, CA

Database Administrator

Responsibilities:

• Involved in Installation of Oracle 11g database in ASM (Linux).
• Created users & privileges with appropriate roles and levels of security
• Involved in migration of the database from Non ASM to ASM using Data pump utility
• Maintaining the Cold and Hot backups of the databases
• Performing Day to Day activities such as checking alert logs and scheduled tasks
• Created and managed table spaces monitored the data files space, resizing and adding new data files
• Exporting & importing data into the databases, using Oracle utilities such as exp/ imp, and Data pump
• Monitoring and performing daily incremental backups, weekly backups using RMAN utility.
• Involved in recovering of the data block using RMAN utility and complex backup and recovery issues
• Interaction with client/users on various issues
• Database Restore using RMAN, Cold Backup and Import
• GG Replication administration: GG installation, Configuration, Monitoring and Troubleshooting, Setup Golden Gate Database User with necessary privileges
• Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues.
• Refresh/Cloning of Database from production environment to test environment and application of patches, monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Applied bug patches according to the Oracle Critical Patch alerts.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Identified and trouble shot everyday issues like locking and scripts execution.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating Users and Database links, snap shots on production and development servers.
• Checking CRON jobs and restarting the failed jobs.
• Implemented automated backup strategy using the UNIX shell script and CRON Utility.
• Used SQL*Loader to load data from flat files to Oracle database.

Environment: Oracle 10g/11g, ASM, Red Hat Linux 4.x/5.x, Windows 2003, OEM, SQL*Loader, Grid Control, RMAN, ASM, Data guard, Data pump, Golden Gate 11g

Confidential, Oakbrook, IL

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle Databases.
• Performed 24/7 production support on rotational basis
• Installation, Configuration and Administration of Oracle 10g and structures.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Plan Golden Gate setup, Installation, configure to achieve Unidirectional replication
• Test initial Data Load option of GoldenGate during environment build
• Prepare GoldenGate parameter files for Extraction and Replication
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration·
• RAC Patching using Opatch tools - CPUs and PSUs patchingPro-active monitoring and performance tuning databases including partitioning and creating materialized views as well as working with Development teams to develop and tune SQL queries and stored procedures.
• Standby Database (Data Guard) setup and configuration.
• Working alongside programmers and contributing to the development process; Enabling and analyzing Trace files.
• Performing monitoring and performance tuning
• Defining and Setting backup and recovery procedures. Configuration of backup.
• Includes table/index/etc. maintenance in QA and production
• Support for test and/or development environments.
• Tuning the database using Statspack and custom scripts.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Tuning and balancing I/O by monitoring file system and tablespace i/o statistics.
• Modified tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to improve performance.
• Scheduled jobs using Cron Job.
• Tuning SGA, I/O Tuning, identifying contention, waits and tuning.
• Experienced in Tuning SQL statements using Explain Plan and using ADDM
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Optimal Space utilization in tablespace by avoiding fragmentation.
• Usage of Partitions to improve the query performance and manageability.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc).
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environment: RHEL 6, Oracle 11g, Golden-gate 11g.

Confidential

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle Databases.
• Performed 24/7 production support on rotational basis
• Installation, Configuration and Administration of Oracle 10g and structures.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration·
• RAC Patching using Opatch tools - CPUs and PSUs patchingPro-active monitoring and performance tuning databases including partitioning and creating materialized views as well as working with Development teams to develop and tune SQL queries and stored procedures.
• Standby Database (Data Guard) setup and configuration.
• Working alongside programmers and contributing to the development process; Enabling and analyzing Trace files.
• Performing monitoring and performance tuning
• Defining and Setting backup and recovery procedures. Configuration of backup.
• Includes table/index/etc. maintenance in QA and production
• Support for test and/or development environments.
• Tuning the database using Statspack and custom scripts.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Tuning and balancing I/O by monitoring file system and tablespace i/o statistics.
• Modified tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to improve performance.
• Scheduled jobs using Cron Job.
• Tuning SGA, I/O Tuning, identifying contention, waits and tuning.
• Experienced in Tuning SQL statements using Explain Plan and using ADDM
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Optimal Space utilization in tablespace by avoiding fragmentation.
• Usage of Partitions to improve the query performance and manageability.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc).
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Analyzed the user requirements and Designed partitioned tables for improving performance of Data marts.
• Performed partition maintenance and automated the process of creating new partitions as and when required. Automated the process of analyzing tables every night.

Environment: Oracle 10g (RAC), OEM, RMAN, Exp/Imp, ASM, SQL*Loader, Data Guard

Confidential

Oracle Database Administrator

Responsibilities:

• Installation and Maintaining of Oracle (10g and 11g).
• Involved in designing of disaster recovery using Data Guard, High Availability using RAC
• Responsible for administration and supporting Oracle 9i, 10g databases.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins.
• Taking Backups on scheduled time and monitoring scheduled Backups through RMAN.
• Cloning databases using scripts as well as RMAN.
• Responsible for creating the training databases used for training the users over the entire state.
• Periodically refreshing the SIT/UAT databases from Production database.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Performed database tuning using Explain Plan, TOAD, and Enterprise Manager.
• Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets
• Good knowledge in UNIX Shell scripting
• Involved in Data Migration / Conversion Process.
• Experienced with Data Guard Implementation.
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Importing data from flat files into database using SQL loader and External Tables.
• Experienced in Volume management, Disk Management using volume manager.
• Written shell scripts to automate the tasks.
• Physical and Logical database design.
• Mapping of old data fields to new model data fields for data migration.
• Worked very closely with development team.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team. Daily Health Check Up of the Database using STATSPACK, AWR, ADDM.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Environment: RHEL 5, Oracle 10g, 10gRAC, TOAD 9.6.

Confidential, Pittsburgh, PA

Oracle Database Administrator

Responsibilities:

• Design, installation, configuration and maintenance of Oracle 10g RAC & non-RAC databases with ASM
• Implemented database security by managing users with roles and assigning privileges.
• Developed shell scripts for generating alerts on ORA errors by monitoring the alert.log file.
• Developed shell scripts to automate data refresh from production to lower environments using expdp/impdp.
• Involved in operating system tuning, optimizing database performance, query tuning using Explain Plan, TKPROF and Oracle Enterprise Manager (OEM)
• Developed shell scripts for automatic logical and physical backups of the databases and sending email notifications.
• Assisted and provided business users with queries and data in the form of spreadsheets and flat files.
• Created and documented database maintenance plans on updating statistics, reorganizing indexes, disk optimization by managing data files and tablespaces.
• Created dbms scheduler jobs for gathering statistics after the batch processing window.
• Used the table partitioning and compression features for large tables.
• Developed procedures to purge obsolete data and reclaim space, analyzed long-running queries to avoid full tablescans and created indexes as required.
• Made tuning recommendations to developers related to PL/SQL, assisting them on expensive queries.
• Allocation of system storage and planning for future database storage requirements.
• Built proactive monitoring scripts to monitor outage conditions and notify the team.
• Performed database tuning using Oracle Enterprise Manager.
• Created and maintained various database-related documents such as manuals and data dictionary spreadsheets.
• Upgraded the databases to the latest patch sets on server side and client side.
• Work on user requests for various tasks like contention issues such as deadlocks.
• Developed triggers to monitor the databases for unusual activities over the database links
• Used Low Archive Log Space event triggered RMAN backup job that would clean out the directory
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Created SQL tuning sets for long running batch jobs via Enterprise Manager, Created database maintenance plans, including updating statistics, re-indexing, structure modifications, capacity plans, and index analysis.
• Design and creation of data models using ERWin data modeler.
• Writing scripts for Import and export procedure, setting up new environments, backup and recovery, Import and export procedure.

Environment: Oracle 8, 9i, 10g, HP-UX 10 (IA64), Red Hat Enterprise Linux 4, TOAD 9.2, SQL developer, SQL*Plus, SQL*Loader, ERWin, Import/Export, Visual Source Safe (VSS), Win SCP, Grid Control, OEM