PROFESSIONAL SUMMARY

• Over 8 years of professional experience as Oracle Database Administrator having good experience in database administration, database installation, up - gradation, migration, installing patches, performance tuning, RAC installation and maintenance, setting up and configuring Dataguard, performing all kinds of backups and recoveries, cloning databases, replications using golden gate, auditing and product support
• Hands on experience on Oracle (9i/10g/11gR1/11gR2), installed and configured on different platforms like Windows, UNIX, RHEL 4, RHEL 5, OEL 5, OEL 6, Solaris 10, HP-UX.
• Experience in 24*7 on-call production database support
• Configured disk layout, mount points and capacity requirements for servers.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES 10/11g OEM Grid Monitoring.
• Have good noledge on 12C OEM GRID control on OEL 6.1.
• Expertise in configuring Oracle 10g/11g RAC software with ASM File systems.
• Skilled in cross platform migrations from AIX to Linux, UNIX to Linux.
• Experience in using OEM, TOAD, and Data Migrations using export/import.
• Expertise in Upgrading databases and applying Oracle PSU and CPU patches
• Applied patches using OPATCH utility and have done tuning.
• Upgraded databases from 9i to 10g/11g and 10.2.0.x to 11.2.0.x.
• Experience on working with Data Guard physical & standby databases.
• Implemented 11g new features in Dataguard environment and have hands on experience on Active Dataguard.
• Experience in deploying Golden Gate for ensuring high availability.
• Worked on ASM and Installed standalone servers on ASM.
• Having experience in migrating databases from non-asm to ASM environment.
• Have excellent noledge in troubleshooting ASM environment.
• Excellent noledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN like recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption.
• Performed scheduling the jobs using the CRONTAB utility.
• Performance Tuning me.e. tuning applications, shared pool, me/O distribution, rollback segments, buffer cache, redo mechanisms
• Have monitored databases for compliance with internal standards.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Implemented Oracle Advanced Security Options such as Data Encryption to ensure data privacy.
• Proficient in index rebuilding and index tuning.
• Experience working with Database Resource Management.
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• Experience using Erwin as a Data Modeling tool.
• Experience designing the DW model and the physical structure.
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.
• Expertise in creating Oracle Tables, Table Partitions and Materialized Views.
• Excellent Written and verbal Communication skills with a customer service oriented attitude. Knowledge on Oracle Support processes for technical requests with Metalink.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Operating systems: RHEL 4.X,5.X, OEL 6.X, SOLARIS 10.X,11.X, MS-DOS, NT, Windows 2000/2008

Databases: Oracle 11gR2, 10gR2 RAC, 9i, 8i

Oracle Database Tools: Toad, OEM, SQL Developer, Grid Control, MS SQL

Tools &Utilities: Export/Import, RMAN, Data Pump, CRONTAB

Languages: C, Unix shell scripts, PL/SQL

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

SR. Oracle Database Administrator

Responsibilities:

• Installed and Maintained of Oracle Grid infrastructure 11gr2 on RHEL.
• Implemented 11g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Used (OEM grid) 10g /11g monitoring and managing of Oracle instances using Enterprise Manager Grid Control.
• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance and daily monitoring OEM, Managing and maintaining the host and its targets, clearing outstanding alerts, creating blackouts’ and turnover tickets to front line support (FLS).
• Installed 12C OEM grid control on OEL 6.1.
• Worked on database design in RAC environment, creation and configuration, space management and other database maintenance procedures in multiple oracle production and development environments.
• Installed and configured 5 NODE RAC on RHEL 5.5.
• Migrated databases from single instance to RAC environment.
• Performed Database refresh from Production RAC to RAC TEST environment.
• Installed databases using DBCA on ASM in RAC environments.
• Extensively used CRSCTL and SRVCTL commands in RAC.
• Have good noledge in using R-Config utility.
• Migrated databases from NON ASM TO ASM.
• Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.
• Involved in configuring Data-guard for production databases on 11gR2.
• Worked on physical standby databases and troubleshooting issues in Data Guard environment.
• Converted physical standby to snapshot standby and also to active Dataguard.
• Involved in creating listeners and TNS manually in Dataguard Environment.
• Upgrading development and production databases to Oracle11g.
• Migrating databases from 10.2.0.4 AIX databases to Oracle 11.2.0.3 on RHEL 5.5.
• Extensively used data-pump at schema level and Database level for moving data from Unix to Linux during migration
• Applied patches on standalone servers using Opatch utility.
• Performed up-gradation of databases from 10g to 11gR2 on RHEL.
• Scheduled various job using UNIX Crontab utility, like doing incremental backups.
• Evaluated mix of backup and recovery methods based on organizational needs.
• Performed schema level refresh using Data Pump for export and import for data transfer
• Wrote scripts for Backup of databases, maintenance of archive logs for databases.
• Configured database retention policy using RMAN and implemented RMAN for backup and disaster recovery.
• Involved in Registering of databases to catalog database.
• Performed block recovery, datafile recovery using RMAN.
• Performed HOT backup and COLD backup using scripts and RMAN and also developed backup strategies using incremental and cumulative backup methods.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Have performed data load from non-oracle to oracle database using SQL Loader and provided maintenance of user accounts, privileges, profiles and roles.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Have done performance tuning using jobs using dbms schedule, TKPROF, STATSPACK, AWR, ADDM utilities.

Environment: Oracle 10g/11g RAC, SQL Loader, putty, OEM, RHEL 5.X, AIX 5L, UNIX, Programming Language/Tools: TOAD, PL/SQL, and MS SQL.

Confidential, Portland, OR

SR.Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 10g and 11g on RHEL.
• Installed and configured RAC (2 node) on 11gr2 on ASM.
• Involved in migrating production databases single instance on standalone to RAC environment and single instance RAC to RAC databases using r-config.
• Monitoring Health checks of OCR, voting disks and Interconnect for better performance and troubleshooting issues in RAC environment.
• Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.1 to 11.2.0.x
• Performed upgrade of database from 10g to 11g with Oracle Database Upgrade Assistant (DBUA) and manually in development, testing and in production environment.
• Done migration of non ASM database to ASM database.
• Implemented Dataguard for 10g and 11g production databases running on RAC.
• Configured logical and physical standby databases and converted physical standby to snapshot for testing purposes.
• Have hands on experience in active Dataguard and troubleshooting Disaster Recovery Environment.
• Involved in cross platform migration from HP-UNIX to RHEL.
• Installed and configured Golden gate for replication
• Configured parameters for replication, DDL support.
• Configured parameters for the Bi-directional replication.
• Performed RMAN backup and also developed backup strategies using Incremental and Cumulative backup methods.
• Performed HOT/COLD backups and Logical backups.
• Worked on creation of users, granting roles and privileges to users, tablespace management.
• Performance tuning of database by generating reports AWR, ADDM, ASH, TKPROF, STATSPACK, SQL TRACE and EXPLAIN PLAN.
• Defragmentation of tables and indexes for improved performance and efficiency.
• Created and scheduled Oracle backend process jobs in crontab.
• Performed daily monitoring of Oracle instances using Oracle Enterprise Manager (OEM) and Grid control to monitor users, tablespaces, memory structures, log and alerts.
• Weekly data refreshes from Production to Development and Test environments using Transportable Table spaces (TTS), Data pumps and Exports/Imports.
• Involved in optimizing SQL statements using Indexes and Hints.
• Made use of the Ref cursors in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.

Environment: Oracle 10g and 11g, RHEL 4.X, 5.X, OEM, Toad, ASM, GRID, AWR, OEM, Data Guard, RMAN, Shell Scripting (for monitoring the database).

Confidential . Hartford, CT

SR. Oracle Database Administrator

Responsibilities:

• Installation and Maintenance of Oracle 11gR2 on IBM-AIX and Red Hat LINUX.
• Installed 13 STANDALONE ASM servers on 11gr2 RHEL.
• Worked on physical and snapshot standby databases in Dataguard environment.
• Involved in construction of Disaster Recovery (DR) for all the production databases using DATAGUARD on ASM.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configured pfile, Listener and Net service names manually for production and physical standby databases in Dataguard.
• Minimized downtime during disaster recovery and data corruption using data guard.
• Upgraded databases from 9i to 10g & applied patches on 10.2.0.1 to 10.2.0.x.
• Involved in cross-platform migration from AIX to RHEL using RMAN convert.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for standalone instances.
• Cloning databases using RMAN on remote server for Testing.
• Configured retention policy of backups for databases using RMAN.
• Involved in regular activities like creating tablespace, monitoring tablespace sizes and clearing OEM alerts.
• Generating reports AWR, ADDM, ASH, TKPROF, STATSPACK, SQL TRACE and EXPLAIN PLAN.
• Worked closely with ETL applications team.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Management of table space growth, monitoring data files additions, extent growth.
• Worked on several shell scripts to maintain the database activities & implemented automated backup strategy using the Unix shell scripts.
• Managing crontab file, rescheduling the failed jobs (due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts).
• Reading Alert Log and User trace Files and Diagnosing the Problem.

Environment: Oracle 10g and 11g, AIX 5.X, RHEL 4.X, 5.X, OEM, Toad, ASM, GRID, AWR, OEM, Data Guard, RMAN, Shell Scripting.

Confidential

Oracle Developer / Database Administrator

Responsibilities:

• Performed Database Installation on 10g UNIX and up gradation of databases from 9i to 10g.
• Upgraded databases from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Performed database tuning for daily loads and slow response issues by refining queries and used STATSPACK, TKPROF utilities for Tuning and analysis.
• Recovery of database from media failures, dropped accidentally and data block.
• Developed and modified PL/SQL packages, stored procedures, functions, cursors, triggers as per the customer requirements
• Partitioned large tables to increase the performance
• Installation and creation of databases using DBCA and manually.
• Experience in working with cold and hot backups.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Created materialized views, Rebuilding Indexes and partitioned tables and Index organized tables.
• Setting up new development and QA environments and involved in deployments and migration and configured scripts to monitor activity with database
• Responsible for optimizing the queries and application tuning
• Designed backup and recovery procedures for OLTP system
• Designed database tables as per technical specifications
• Used TOAD tool to access the databases
• Used PL/SQL procedures against the test cases

Environment: Oracle 9i/10g, Windows NT/2000, HP-UX, PL/SQL, SQL Server 2000, TOAD, Database Tools/Utilities, Shell Scripting