SUMMARY

• 8 years of experience in Oracle12c/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/11gRAC 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, failoverof 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 noledge 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 the 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 NonASM 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 the database up to date by applying the latest CPU and PSU using the 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 PerformanceViews.
• 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 wif 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,Sybase, 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 Datastage.

PROFESSIONAL EXPERIENCE

Confidential, Austin Texas

Oracle DBA

Responsibilities:

• Installed Grid Infrastructure Software on new Linux Servers for 2node and 3nodeRAC and Failover environments.
• Install, configure and support Uni-directional and Bi-directional Oracle-to-Oracle replicated environments utilizing Oracle GlodenGate.
• Resolving the issues in conflicts between the target and source database in Glodengate.
• 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.
• Created Oracle 11g databases and replicate Sybase schema objects to Oracle
• Troubleshooted PL/SQL procedures and functions to support corresponding Sybase functionalities
• Performed Sybase performance tuning
• Configured Dataguard broker between the primary and standby databases, perform Switchover/Failover and monitor the 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 datapump tool for exporting and importing the 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 the Query.
• Monitoring heavily loaded databases regularly and did performance tuning
• Resolving issue regarding sql and pl/sql coding as per the user requirements
• Troubleshooting PL/SQL and SQL code and to suggest developers about any improvements
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools ExplainPlan, SQLTrace, and AWRreports, ADDM, TKPROF, TOAD and Oracle Enterprise Manager.
• Understood the 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 the Database Level for table space and Regular file system cleanup at UNIX level.
• UNIX shell scripting as and when required based on the requirement.
• Experience wif remedy ticketing tools for resolving the 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

Oracle DBA

Responsibilities:

• Responsibilities ntract in Defense Information System Agency. Support DoD DISA/NDSS (Network Design Support Systems)multiple Oracle/Sybase production and test database on UNIX and Windows platforms. Provide database architecture, design, database patches, and all its associated products to include applications tools.
• Database management, monitoring, clustering, ETL operations, query performance tuning and optimization. RAC, SharePlex v7 Replication, TOAD for Oracle 12.6, OEM 12c, PL/SQL, PowerPoint, package, function, loading and analyze weekly data, maintain production database, logicaland physical data modeling, data migration, Global traffic engineering, performance assessment module (PAM), Network usage and GOS analysis and review, circuit sizing calculation, VoLP performance, partition table/index, weekly/monthly backups, export/import and refresh database, Perl data loading scripts.
• Strong Oracle APEX (Application Express) 3.2/4.1 DBA/Dev for administration, design, development, deployment, workspace, application wizard, data loading, create page, and application, LOVs, validations for SQL, PL/SQL, forms/reports, and PLPDF report using functions.
• Support customer facing web applications. Manage Oracle Communications Operation Monitor 3.3, and monitor communication process at Palladion/JITC labs. Use OBIEE 11g on repository, dashboards, ad-hoc analysis/query, published reporting from data source/models for Call data.
• ETL processes, data modeling, DataStage v7/8, ERWin, ETL code for data migration, it includes database, package, functions, and procedures.Performance tuning and troubleshooting are on database and application. Weblogic servers are on forms and reports.

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 I/O and Memory Usage.
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Oracle Grid Control Management Server Installation.
• Used transportable tablespaces (TTS) to move the data Oracle on a different platform and also much faster than performing either an export/import or unload/load of the same data.
• Implementation of 10g Data Guard.
• Made performance improvements to the 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 the 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 the 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-SQLSTATSPACK, TKPROF, EXPLAIN PLAN

Confidential, Indianapolis, Indiana

PLSQL 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 wif DBCA.
• Backing up databasesusing catalog database wif the halp of RMAN.
• Monitoring Oracle instances wif Oracle Enterprise Manager.
• Loading and Unloading of tables to and from Oracle respectively.
• Monitoring and managing Alert notifications.
• Configured databases wif file systems and ASM.
• Used performance views to tune the performance of the databases.
• Table level replication using Oracle Streams.
• Efficient in using the 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

PLSQL 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 the Oracle server.
• Creating databases, objects, roles andGranting privileges.
• Partitioned large tables to increase the Performance.
• Configured scripts to monitor activity wif database.
• Responsible for optimizing the 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 the need.
• Involved in Designing backup and recovery procedures for OLTP systems.
• Use TOAD tool to access the database. Used PL/SQL developer to create PL/SQL Procedures.
• Testing PL/SQL procedures against the 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.