SUMMARY:

• 8 years of IT experience as Oracle Database Administration Ver. 12C/11G/10G/9i/8i on a variety of OS like LINUX, UNIX, and Windows. Vast experience in Installation, Configuration, Upgrades, Space Management, System maintenance, Cloning, patching, Sql*Plus, Performance Monitoring, Tuning, Backup and Recovery (RMAN) and also includes RAC, ASM, Data Guard
• Installed oracle database server on WINDOWS, LINUX and migration of oracle server from 8 to 8i, 8i to 9i and 9i to 10g, 10g to 11g, 11g to 12c and applied oracle patches
• Installed Oracle 11g RAC software with ASM File systems.
• Configured Oracle 11g database instance running across four oracle RAC nodes on Red Hat Linux AS 4 Server
• Installation, maintenance and tuning of RAC Applications.
• Used OEM for rapid installation and other Oracle Application maintenance utilities.
• 24*7 production database support to developers & end - users.
• Expertise in Real application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database
• Created two type of standby databases supported by DATAGUARD, logical standby and physical standby databases
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Implemented full, incremental and cumulative backup using RMAN and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
• Hands on experience in Performance tuning of the database - SQL Tuning, Used Tuning utilities like EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Performance Tuning like tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Installed and Configured of Oracle Grid Control.
• Logical backups using full export and DATAPUMP.
• Experience with cloning production database to refresh development and test environments (including RMAN Cloning, and Traditional Cloning).
• Good knowledge of configuration of 10g Grid Control, Data Guard on Disaster Recovery (DR) sites.

TECHNICAL SKILLS:

• Oracle 8i/9i/10g/11g/12c
• Real Application Clusters (RAC)
• Database up gradation 8i/9i/10g/11g
• Oracle Single Sign-On
• Disaster Recovery Solutions
• Recovery Manager (RMAN)
• Data Guard
• Security Administration
• Database Design
• Oracle Enterprise Manager (OEM)
• Performance Tuning (DB, RAC)
• Unix Shell Scripting
• Developing with PL/SQL
• Oracle Discoverer

PROFESSIONAL EXPERIENCE:

Confidential, Ann Arbor, MI

Sr. Oracle DBA

Responsibilities:

• Installation and creation of 10g, 11g, and 12c Databases for Development, Quality and Production environments and upgraded from 10g to 11g, 11g to 12c.
• Performance Monitoring and capacity planning, Security Compliance (FISMA), audit trail monitoring.
• Configured Oracle Advance Security, TDE
• Defined, design and configured a security policy to support FISMA compliance which get adopted by all the departments in the university.
• Configured RADIUS for two-factor Authentication in Windows and Linux environment
• Created 12.1.0.2 databases for Testing, and Production on Linux and Windows.
• Used to export and import of different databases using Oracle Exp / Imp and data pump utilities
• Performed all daily Maintenance tasks like monitoring job failures, scheduling backup jobs, and troubleshooting RMAN backup job failures and interacting with Oracle Team when required.
• Install and configured Oracle 12c database
• Design and implement database backup and recovery procedures using RMAN
• Having experience in Migrating data to other databases and Database storage management
• Monitoring database performance and database operation from OEM
• Support developer by tuning SQL query and PL/SQL codes
• Created table spaces and managed table spaces adding/deleting/ resizing data files
• Performed logical backup & recovery using export/import utilities and Datapump
• Performed SQL and PL/SQL tuning and Application tuning using various tools like AWR, SQL*TRACE, TKPROF and AUTOTRACE.
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
• Developed User Defined Functions and created Views in SQL Server
• Documenting Database management tasks

Environment: Oracle 10g/11g/12c, RMAN, DBCA, DBUA, Export/Import (EXP/IMP), Data Pump, AWR, SQL SERVER

Senior Oracle DBA

Responsibilities:

• Installation and creation of 10g, 11g, and 12cDatabases for Development, Quality and Production environments and upgraded from 10g to 11g, 11g to 12c.
• 24/7 Primary DBA support up to 2.5TB database.
• Created 10.2.0.1 and 11.2.0.2 databases for Testing, Development and Production on Linux.
• Used to export and import of different databases using Oracle Exp / Imp and data pump utilities
• Performed all daily Maintenance tasks like monitoring job failures, scheduling backup jobs, and troubleshooting RMAN backup job failures and interacting with Oracle Customer service when required.
• Install, upgrade, patches and configuration of Oracle Database (10g, 11g)
• Implemented Data Guard and managed Standby databases.
• Involved in implementing, managing, and configuring Oracle 10g R2, 11G RAC databases with ASM features. Supporting 10g and 11g RAC Oracle Database
• Performed conversion of Single Node Instance to multi node RAC with ASM, and adding instance to existing RAC
• Involved in installing, configuring and monitoring of Oracle Enterprise Manager (OEM): DB Control, Grid Control.
• Increased the database performance using ASSM and Tablespace Management.
• Developed Shell Scripts to automate database operation and database monitoring.
• Used Oracle backup/recovery RMAN utility and manual scripts to implement backup and performed complete and in-complete recovery.
• Doing user and session management.
• Prepared documentation on all the processes like problem specification, bugs fixing logs & change requests for future reference.

Environment: Oracle 11gR1, 11gR2, 12c, LINUX, RAC, ASM, RMAN, OEM Grid Control 12c, Data Guard

Senior Oracle DBA

Responsibilities:

• On call support for Dev/Test and production environments and applications on all business days and 24 x 7 during holidays and weekends
• Installation and patching the database for Dev/Test and production hosts (latest & bug).
• Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
• Performed Cloning of a Database using RMAN for a test database environment
• Developed recovery Strategy using Oracle RMAN in daily and weekly maintenance
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
• Monitoring database performance and database operation to prevent downtime and slowness of the services.
• Installed and configured of release 11g R2 RAC with ASM
• Managed multi node (3 nodes) RAC with ASM, and adding instance to existing RAC.
• Created and monitored all database objects, including tables, clusters, indexes, sequences, packages and procedures
• Created table spaces and managed table spaces adding/deleting/ resizing data files
• Managed Undo Segment in order to avoid "Snapshot too old" error
• Extensively involved in Instance creations and maintenance
• Performed logical backup & recovery using export/import utilities and Datapump. Involved in Configuration.
• Design and implement database backup and recovery procedures using RMAN
• Having experience in Migrating data to other databases and Database storage management
• Upgraded database from 10g to 11g on Linux
• Expert in monitoring database using Oracle Enterprise Manager (OEM).
• Automating database daily operations. Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Support developer by tuning SQL query and PL/SQL codes

Environment: Oracle 10g/11g, PL/SQL, Oracle Standby databases, RMAN, Hot backups, RAC.

Oracle DBA

Responsibilities:

• Provided 24*7 on-call production database supports.
• Hands-on experience in database tuning using AWR, ADDM, Enterprise Manager.
• Having involved in database performance tuning for memory (SGA), disk I/O contentions, rollback segment contention and application tuning
• Check daily backup reports and re-run backups manually on failed database Using RMAN
• CLONING of production databases for test and development purpose
• Refreshed schemas on development/testing from production using export/import
• Implemented Data guard environments on both production and development and successfully implemented Fail-Over/Switch-Over scenarios in Test database
• Involved in Creating Oracle Databases on 9i and 10g and configured RMAN for taking fresh backup
• Implemented table-spaces, extents and indexes on Oracle 10g R2 Database.
• Installed, upgraded, configured, and apply patches to Oracle Database (9i, 10g)
• Database Backups, Space Management and Customer External Data File Loads and Scheduled backups using RMAN.

Environment: Oracle 9i/10g on UNIX, Cloning, Linux, OEM, RMAN

Oracle DBA

Responsibilities:

• Engaged in up gradation and Migration of production and development Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Performed daily database administration tasks including user management, space monitoring, performance monitoring and tuning.
• Plan and perform point-in-time recovery of databases as part of disaster recovery implementation
• Expertise in managing backup and recovery strategies for production environment using RMAN.
• Having Experience in Database administration support for Oracle 11G and Oracle 8i/9i /10g database.
• Installed, upgraded, configured Oracle database (10G, 11G)
• Monitored performance & tuning the databases using trace file, alert log files, AWR, ADDM and OEM.
• Experience in oracle flashback technology for high availability and different recovery procedures for complete and incomplete recoveries depending on the type of failure using RMAN.
• Worked with IT managers and application developers to ensure the database integrity high availability and security
• Have Implemented and managed Oracle 10g R2 RAC databases with ASM features with 3 nodes.
• Vast experience in Export, Import, Datapump and SQL*Plus Utilities

Environment: Linux, Oracle 9i/10g, RMAN, CLONING, DataGuard, SQL*Plus, Windows, Export/Import, Performance Tuning.

Oracle DBA

Responsibilities:

• Managed the production databases and also have an experience in installation, validation, up gradation of databases.
• Installed Oracle Database in Linux Environment using DBCA.
• Installed and Configured RAC Environment on ASM with 3 nodes.
• Install, Create & maintain Oracle databases across multiple platforms and setup backups.
• Performance tuning of the production databases as per the requirement.
• Preparing the documentation as part of the validation process.
• Keep in touch with multiple stakeholders of the project for requirements gathering. Applying patches and patch sets to the existing environments (10G R2, 11G R1)

Environment: Oracle Database 9i/10g/11g, Oracle RAC, ASM, Linux, UNIX.

Oracle DBA

Responsibilities:

• Configured Oracle database, performance tuning, and Applied patches to two node RAC with ASM and Grid Control environment.
• Expertise in Installation of 11g RAC with oracle clustered ware, ASM and OEM
• Responsible for creating and managing Data guard instances, and involved in database installation, maintenance and administration for disaster recovery.
• Administered and monitored 10g grid control.
• Database tuning methodologies and monitoring techniques.
• Implemented backup, recovery scripts for Oracle Database using RMAN.
• Implemented incremental RMAN backup scripts (Level 0, Level 1, archive log) created Cumulative backup and optimally scheduled RMAN backups.
• Hands-on experience in administering database including job scheduling (DBMS JOB), backup/restore (RMAN), data import/export (IMP/EXP), Datapump etc.
• Involved in Managing of table spaces such as dropping, creation and updating of storage parameters.
• Setting up physical and logical standby database / data guard for operational recovery.
• Administer and create all the object of database including tables, table spaces, setting privileges, indexes, user logins, and passwords (security).
• Communicating with Oracle support on different Technical Assistant Requests TARs.

Environment: Oracle 11g/10g, RAC 11g/10g, RMAN, OEM 11g/ 10g, Data Pump, RHEL, ASM, Data Guard.