PROFESSIONAL SUMMARY:

• Oracle Database Administrator with over 9 years of experience in Oracle Administration including RAC 11g/10g/9i on platforms including Unix/Linux, HP - UX and windows, Sun Solaris environments up to 15 TBs
• Extensive experience in database administration including installation, de-installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database vault, cloning, migration, as well as full documentation.
• Strong in developing Recovery Manager scripts for database backup and disaster Recovery including
• HOT and COLD backup options for both RAC and standalone Instances.
• Proficient in the installation, configuration and technical support for Oracle 10/11g databases as well as non-RAC databases.
• Experience in installing and maintaining Oracle Data Guard to implement physical Standby Database for
• Disaster Recovery in 9i, 10g, 11g and Providing Critical Solutions with strategic Disaster Recovery Plans.
• Experience in taking Logical Backups by using Oracle Utility EXPDP and IMPDP and experience in loading data from flat files to database using Oracle utility SQL*Loader.
• Solid experience with routine maintenance of Oracle databases including gathering stats and monitoring the databases using OEM12c
• Excellent experience of data migration, data archiving and data access techniques
• Hands on experience in Hot/Cold Backup, Recovery & Cloning of databases using RMAN Skilled in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by Data Guard.
• Experience in working on ASM Instance, space management, Exadata and VMWare .
• Experience in performance tuning of Different components and identifying bottlenecks in performance of databases on OS, Storage, and SGA levels.
• Hands on Experience in SQL tuning and optimization using DBMS STATS, AWR , ADDM and tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF .
• Creating and Managing Users, Roles and Privileges with required security implementations
• Install, configure and support unidirectional and bidirectional oracle to oracle replication using Goldengate
• Strong in writing shell scripts to setup CRON jobs for checking Adaptive server's availability, backup of databases and crucial system tables, nightly batch jobs for data transfer between servers.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i (EE/SE), SQL Server 200/2005, MS Access

OS: Red Hat Linux, HP-UX, Sun Solaris AIX 5.1, 5.2, 5.3, WINDOWS NT/2000/2003/XP Technologies Data Guard, Grid Control, Data Streams, Goldengate, Flashback

Tools: OEM, TOAD, SQL Developer, Hummingbird, FTP, Putty, Spot Light,

Utilities: Datapump, RMAN, DBCA, ASM, Dataguard, Tkprof, SQL * Loader

Languages: SQL, PL/SQL, C.

Shell scripting: Shell Script (Bourne shell & Korn Shell)

PROFESSIONAL EXPERIENCE:

Oracle DBA IV

Confidential, Auburndale, MA

Responsibilities:

• Administering all the databases (Production, Staging, Engineering)
• Managing RAC 3 node Production database
• Monitor and Manage database server health through OEM and TOAD
• Configure and manage ASM using sql, ASMCA and ASMCMD
• Deployed and Installed OEM12.1.0.4 and agents for production and
• Deployed and Installed OEM 12.1.0.5 and agents for non-production databases
• Monitor Active Data guard standby database using DGMGRL and OEM
• Providing Snapshot standby database as on request
• Part of the team to migrate production Database to Exadata Quarter Rack
• Manage exadata using CLoud control and CellCLI
• Performance analysis of production database
• Created scripts for automated purging of trace files and alert log file.
• Installed oracle binary and cloned binary using OUI in silent mode
• Configured Hugepage, kernel parameters for oracle
• Used VMware to take snapshot backup of database
• Perform SQL Tuning, AWR, ADDM report, Tuning Advisor
• Installation of 11g SE/EE Databases
• Configure Dataguard with Active dataguard setup and Dataguard Broker
• Installed July 2015 PSU Patch on standalone databases, RAC and in Data guard
• Using Jira as ticketing tool

Core Oracle DBA

Confidential, Quincy, MA

Responsibilities:

• Administering all the databases (Production, Development and Quality) taking ownership of databases, problem analysis, resolution.
• Monitored database and server health through NAGIOS and TOAD
• Applied changes to database on customer requests on daily basis
• Supported portal releases in coordination with developers
• Troubleshoot the issues which are escalated by other teams.
• Administered and maintained Production instances, 24/7 Production Database Support and maintenance.
• Responsible for data migration on weekly basis from UAT to PROD environment
• Performed database backup using RMAN, EXPDP and TTS
• Installation of databases to Oracle 11g.
• Refresh of the database using DATAPUMP and RMAN duplicate.
• Managed and Monitored active-passive goldengate replication
• Performing development, quality and test cloning from Production databases.
• Monitored alert logs for errors and fixing them
• Monitored automated several routine tasks - Automating hot backup, Monitoring scripts - file system at OS level, archive issues, daily and weekly export, tablespace issues, and issues related to Database down, validating backup and taking action when there is backup failure. Tracking them through email.
• Applied database bug patches using OPATCH utility.
• Ran long scripts and providing the log to the requested user and monitoring Sid’s.
• Performed Refresh from production to development and quality databases as per the user request.
• Free space monitoring - adding and resizing data files.
• Managed the archived redo log files when archive destination is full.
• Gathered Statistics for tables & schemas using DBMS STATS.
• Exported and imported for the schema, table, transportable tablespace and database refresh using Datapump.
• Troubleshoot issues facing by development and testing team and resolving and providing the root cause.

Oracle Database Administrator

Confidential, Michigan

Responsibilities:

• Responsible for administration and supporting Oracle RAC 10g/11g databases.
• Coordinated system support and performance
• Coordinated system changes with Customers and other system areas
• Performance tuning of applications and the databases Oracle 10g/11g
• Proactive database monitoring using 10g grid monitoring tool.
• Implemented and configured Goldengate on two-node rac system
• Installed ASM environment and migrating database from NON-ASM to ASM.
• Provides and supports the implementation of business solutions
• Upgrade/Migration databases from Oracle 9i to Oracle 10g
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance.
• Real Application Clusters monitoring, tuning, load balanced using Oracle Enterprise Manager
• Involved in the configuration and installation of a 4 node RAC for high availability and load balancing
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Intensively used 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Database dot release upgrades using oracle universal installer and catpatch.sql.
• 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
• 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.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.
• Experience with pre-production and production of Oracle 10gR2 with multi node RAC with ASM
• Database links (db links) were created to access the data from remote databases.
• Monitored Cold and Hot backup scripts of the databases supporting different applications.
• Performed the logical backup at different levels like table, schema and database level.
• Used Shell Scripting extensively to set up various jobs like backups, Housekeeping, and user deletion

Oracle DBA

Confidential, Westlake Village, CA

Responsibilities:

• Supported 24x7 Oracle Production Databases of RDBMS 9i/10g on SAN with different RAID levels.
• Installed and configured OEM Grid Control and centralized the monitoring for all databases. Performing monitoring and performance tuning
• Performed Oracle Streams replication monitoring and tuning.
• Managing, troubleshooting and resolving oracle database issues.
• Refresh/Cloning of Database for development and testing purpose.
• Setup and configure SQL Server 2005 for other business functions.
• Performed Oracle Database upgrades from 10g R1 to 10gR2.
• Involved in Upgrade/Migration of the oracle databases.
• Standby Database (Data Guard) setup and configuration.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Defining and Setting backup and recovery procedures.
• Enabling and analyzing trace files for any errors occurred while database runtime.
• Performing monitoring and performance tuning using different tools like AWR, SQL trace, TKPROF, Explain plan.
• Tuning and balancing I/O by monitoring file system and table space I/O statistics.
• Made use of the REF CURSORS in stored procedures for report generation.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Optimal Space utilization in table space by avoiding fragmentation
• Usage of Partitions to improve the query performance and manageability.
• Installation of Oracle RDBMS server software and version upgrades.

Oracle DBA

Confidential, Detroit, MI

Responsibilities:

• Configure, implement 10gR2 RAC with ASM on Sun v890 servers
• Providing support to the SA team for Oracle RAC compatible hardware configuration
• Installed and configured Oracle 11g on HP-UX and Linux
• Tune the database using SQL Performance Analyzer
• Demonstrate Database Repair Advisor - a wizard/expert system that guides DBAs through the fault diagnosis and resolution process
• Create physical standby database from hot backup of primary database
• Create logical standby database from hot backup of primary database
• Resolving gaps between primary and standby databases (Gap Resolution mechanism FAL )
• Performance tuning of existing 9i RAC database using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK,
• Extensive Performance Tuning, Memory (SGA) Tuning, etc on 10g RAC
• Setting and Installing Oracle Enterprise Manager (OEM) and Enterprise Backup Utility
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager), Statspack, and V$ dynamic views

Environment: Oracle 9i / 10g with RAC 11g, Oracle Dataguard, Sun Solaris 9, HP-UX 11, OEM, TOAD

Oracle DBA

Confidential

Responsibilities:

• Installation of Oracle on Linux and Windows.
• Performed installations of Oracle 8i and SQL server databases.
• Created tables, indexes, tablespaces, users, integrity constraints and supported all phases of a development cycle.
• Analyzed and suggest improvements to SQL queries and statements written by others.
• Developed stored procedures to pull the data from the distributed systems.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Maintaining daily batch cycle and providing 24/7 support.
• Developed and implemented complex data models and logical database designs.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Defined database requirements and designed data model.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Provided production support to the clients on Oracle 9i database administration aspects such as database backup using Oracle Export Utility and database crash recovery from the backup dumps and redo logs.
• Installation of Solaris, Linux and Windows on the servers.
• Monitored tablespace related issues like increasing the storage parameter values, resizing the data files, adding new data files etc.
• Involved in creating the new user management and security enforcement.
• Database links (db links) were created to access the data from remote databases.
• Solved different database related issues like taking care of different processes resources, listener and connect string.
• Monitored Cold and Hot backup scripts of the databases supporting different applications.