SUMMARY

• Over Right (8+) years of referable experience in Oracle 12c/11g/10g/9i DBA and have been involved in Installation, Configuration, Upgrades, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Reporting, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control.
• Experience in installing, configuring, administering, managing oracle databases, implementing solutions like High Availability (HA), Disaster & Recovery, Cloning, and Database Security.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster - ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup, adding a node to this cluster database for High Availability and Recovery.
• Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• Configured and maintained replication using Oracle Gloden Gate.
• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
• Experience in Cumulative and Differential Incremental backups using RMAN.
• Having good knowledge on EXADATA and Involved in moving databases in EXADATA RAC environment.
• Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and ASH (Active Session History) for analyzing teh database performance and tuning.
• Experience in Database Upgrades in 10g and 11g.
• Experience in Data Migration using Data pump utility, Non RAC to RAC and Non ASM to ASM.
• Database Refresh from Production to Development and from Development to Test environments.
• Replication of tables to cross platform and Creating Materialized Views.
• Experience in maintain of production and Non - production batch servers using AutoSys scheduler.
• Managing Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Planning and scheduling Physical Backups (offline/online) and Logical Backups.
• Experience in implementing Flash Back Pointing Time Recovery.
• Experience in maintaining ETL tools for Reporting Solutions.
• Experience in User Management by Granting, Revoking Privileges according to requirement.
• Experience in Space Management by Monitoring and Managing Tablespaces.
• Keeping teh database up to date by applying teh latest CPU and PSU using teh OPATCH utility.
• Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured Listener for external procedure calls.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
• Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables.
• Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, and PL/SQL Developer.
• Monitoring Alert log for any errors and issues.
• Communicated and interfaced with Oracle support via Metal-link to troubleshoot day-to-day database issues.
• Experience in UNIX shell programming.
• Hands on experience working on High Availability Environments. 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

Database: Oracle 12C, 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i, MS-SQL

Oracle Products: Oracle Real Application Cluster 10g/11g, Gloden Gate, Data guard, Import and Export, Data pumps, Data Masking, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle 10g/11g/12c (Grid Control), Oracle Exadata, RMAN, Transparent Data Encryption

Operating System: Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008, AIX 5.x

Languages: SQL, PL/SQL, Visual Studio 2012, C#, UNIX shells scripting

Tools: & Utilities: SQL Trace and SQL tuning Advisory, SQL*plus, VMWARE, ADDM, DBCA, SQL*Loader, Log Miner, TKPROF, AWR, ASH, Toad, Putty, ERWIN, HP OpenView service, ETL tool

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. Oracle DBA

Responsibilities:

• Installed Grid Infrastructure Software on new Linux Servers for 2node and 3node RAC and Failover environments.
• Install, configure and support Uni-directional and Bi-directional Oracle-to-Oracle replicated environments utilizing Oracle GlodenGate.
• Resolving teh issues in conflicts between teh target and source database in Gloden gate.
• Worked in troubleshooting RAC and implemented 11g New ASM features.
• Applied necessary Patches during installation and also in up-gradation of databases on Oracle database versions 10g and 11g.
• Extensively worked in setting up physical standby database using Data guard on Oracle 11gR2.
• Configured Dataguard broker between teh primary and standby databases, perform Switchover/Failover and monitor teh Dataguard status via DGMGRL and GUI.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Handy in utilizing data pump tool for exporting and importing teh data between databases.
• Involved and Upgraded Analytical Databases from 11g to 12c.
• Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to teh Query.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, and AWR reports, ADDM, TKPROF, TOAD and Oracle Enterprise Manager.
• Understood teh concepts of AMS (Archival Management System) and implemented successfully in production environment to archive historical data.
• Well Experienced in taking Backup for a very Huge Databases using AVAMAR.
• Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN.
• Data loading using SQL*Loader into Oracle Database from different sources (OLTP).
• Migration of databases from 11g to 12c using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Weekly Data Refresh from Production to Development and Test environments using Data Pump export/import.
• Having good exposure in user management, table space management, session management, undo management issues.
• Involved in managing space issues in teh Database Level for table space and Regular file system cleanup at UNIX level.
• UNIX shell scripting as and when required based on teh requirement.
• Experience with remedy ticketing tools for resolving teh tickets.
• Provided 24x7 support and On-Call rotation when needed for very large databases.

Environment: RHEL 4.2, HP-Unix 7, OEM, Oracle 10g/11g/12c, RAC, Gloden Gate, SQL* Loader, Shell scripting XMing, Putty, HP OpenView service, RMAN, ASM, Data Guard, TSM, AVAMAR

Confidential, Groton, CT

Sr. Oracle DBA

Responsibilities:

• Installed Oracle 11g on Linux and Worked on RAC 10g and worked on ASM feature.
• Installation and configuration of Oracle 11g RAC 2 node on Linux.
• Applied CPU security patches in both RAC and standalone systems in ASM environment.
• Responsible for maintaining Oracle 11g/10g standby databases in Solaris and Linux
• Done up-gradation from 10g to 11g and applied patches when required.
• Configured 11g new feature Active Data guard on 11g and maintained standby databases.
• DBCA for database creation.
• Executed Switchover operation during planned maintenance.
• Involved in Database and Transaction log Backups and Restoration, backup strategies, scheduling teh backups.
• Database backup & Recovery with export and import for non-archive and archive database with RMAN commands.
• Also configured database cloning using RMAN.
• Backing up system & user databases and restoring them as required and Create Database users and roles and implement appropriate user security.
• Space management on file system and ASM.
• Experienced with Oracle 10g/11g ASM feature.
• Created disk groups with required redundancy levels.
• Migrated Non-ASM databases to ASM environment for high availability on 11g.
• Implemented Oracle Replication through materialized view.
• Designed Logical and Physical Data Modelling using Erwin.
• Daily Health Check Up of teh Database and SQL Queries using Statspack, AWR, ADDM and TKPROF.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for teh same.
• Experience with database partitioning and responsible for daily loads.
• Worked on setting up auditing in databases.
• Migration of databases from SQL Server 2008 and Sybase to Oracle 11gr2
• Experience with DDL and DML operations and having sound knowledge.
• Good experience with Oracle performance issues in both application tuning & memory tuning.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables and indexes.
• Writing UNIX shell scripts to manage Oracle environment and application processes.

Environment: RHEL 5, Sun-Solaris -9, Oracle 9i/10g/11g, 10g/11g RAC, Toad, 10g Grid, OEM, RMAN,ASM, Dataguard, Oracle Streams, ERWIN, MS-SQL, Sybase, Oracle Gateway, SQL*Plus, Shell Scripting

Confidential, Bloomington, Illinois

Oracle DBA

Responsibilities:

• Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem.
• Recognition and resolution of database issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical me/O and Memory Usage.
• Performance tuning me.e. Tuning RAC, tuning applications, shared pool, me/O distribution, rollback segments, buffer cache, redo mechanisms.
• Oracle Grid Control Management Server Installation.
• Used transportable tablespaces (TTS) to move teh data Oracle on a different platform and also much faster than performing either an export/import or unload/load of teh same data.
• Implementation of 10g Data Guard.
• Made performance improvements to teh database by building Partitioned tables, Index Organized Tables Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan,
• SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing
• And use of Hints, Stored outlines, Statistics for teh same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted
• Privileges and permissions to appropriate groups.
• Implemented and followed data security standards and Security User Management, Privileges,
• Roles, Auditing, Profiling, Authentication and Risk management.
• Performed application migrations to non-cluster databases to cluster databases.
• Devised & Implemented backup strategies using hot, cold, and exports based on teh business requirements.
• Implemented VERITAS Net Backup-using RMAN as a media management layer.
• Applying security patches both Server side and Client side and Performed testing.

Environment: Oracle 10g/9i, Windows 98/NT/2000, Oracle Enterprise Manager, SQL* Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN

Confidential, Indianapolis, Indiana

PL/SQL Developer & Oracle DBA

Responsibilities:

• Configuration and Maintenance of Physical Standby databases.
• Supported different Databases like Production, Testing, Staging and Training.
• Online and Offline Database backup and Recovery.
• Upgrading databases from 9i to 10g.
• Creating databases manually or with DBCA.
• Backing up databases using catalog database with teh help of RMAN.
• Monitoring Oracle instances with Oracle Enterprise Manager.
• Loading and Unloading of tables to and from Oracle respectively.
• Monitoring and managing Alert notifications.
• Configured databases with file systems and ASM.
• Used performance views to tune teh performance of teh databases.
• Table level replication using Oracle Streams.
• Efficient in using teh Oracle Tools like SQL* Plus, SQL* Loader, and IMPORT/EXPORT.
• Month end job monitoring and checklist preparation and co-ordination.
• Adding and resizing table spaces based on threshold metrics.
• Granting and revoking required privileges and roles to users.
• Implementation of table level snapshots on target databases.
• Hands on experience working on High Availability Environments.
• Implementation of almost all Oracle tools.
• Responsible to provide 24 x 7 database administrative activities over different
• Database servers, representing various RDBMS on Linux OS.

Environment: Linux 4, Window 2003, OEM, RDBMS, Oracle 10g/9i, SQLDBA, PL/SQL, TOAD7.5

Confidential

PL/SQL Developer & Oracle DBA

Responsibilities:

• Installed and configured oracle 8i/9i databases.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring teh Oracle server.
• Creating databases, objects, roles and Granting privileges.
• Partitioned large tables to increase teh Performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing teh queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Involved in Performance Tuning of SQL Queries.
• Creating tables, indexes, views and synonyms depending upon teh need.
• Involved in Designing backup and recovery procedures for OLTP systems.
• Use TOAD tool to access teh database. Used PL/SQL developer to create PL/SQL Procedures.
• Testing PL/SQL procedures against teh test cases. Involved in creating use cases and test cases.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory and operating system.

Environment: Windows 98/NT / 2000, HP-UX, LINUX, AIX, Oracle 8i/9i, TOAD, Database Tools/Utilities, Oracle Enterprise Manager