Professional Summary:

• Oracle DBA having 7 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g 11g, 12c with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 9i, 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux environment.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• Experience in upgrading Exadata database from 11.2.0.1 to 11.2.0.3
• 24 7 production database support with Support to developers end-users.
• Installed Oracle 11g ASM 10g RAC software with ASM OCFS2 File systems.
• Experienced in Installation of high availability RAC environment 2, 3 and 4 node clusters and upgraded standalone databases to 10g RAC environment.
• Expert in implementing ORACLE STREAMS unidirectional, bi-directional and downstream capture and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Managed very large database VLDB of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Logical and physical modeling using Erwin. And Expertise using tools like Erwin, ER/Studio and Toad.
• Implemented RMAN backup Full, incremental and cumulative and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY and AUTOSYS JOBS.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Data loading using SQL LOADER, Logical backups using full export and DATAPUMP.
• Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL LOADER.
• Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experienced in using Oracle's Transportable Table space TTS feature allows users to quickly move a user Table space across Oracle databases.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience in applying security patches to the databases.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNS Names, V and DBA views.
• Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network SAN .
• Knowledge on Oracle Support Process for Technical requests using Metalink My Oracle support MOS and other support procedures.
• Excellent interpersonal and strong analytical skills, Documentation Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

Technical Skills:

Confidential

Position: Sr. Oracle DBA

Responsibilities:

• Responsible for 24x7 Oracle Database Administration of Production, Development, Testing databases.
• Responsible for maintaining very large critical OLTP, OLAP databases of various sizes up to 18 TB.
• Responsible for installing Grid Infrastructure software on new AIX 6.1 servers for 2 node RAC and performing the failover testing for the necessary Failover Servers.
• Responsible for installation and configuration of SQL server 2005 database on Dell servers.
• Responsible for installing Oracle 11g 10g software and created both Stand Alone and RAC databases.
• Responsible for patching the grid Infrastructure and the databases with the latest applicable CPU and database patch set using both rolling methodology and individual nodes.
• Excellent knowledge of migration of a huge database from AIX 5.3 Stand Alone to more robust AIX 6.1 RAC servers with minimal down time. The migration was done using the DBMS FILE TRANSFER package which is a feature of 10g.
• Responsible for performing up gradation of databases from 10.2.0.3 to 11.2.0.2 and 10.2.0.4 to 11.2.0.2 using the Transportable Table spaces upgrade method as it was required by the Business.
• Responsible for setting up Automatic Storage Management to reduce I/O contention and support RAC databases.
• Well versed with setting up the Physical Standby both in Cascaded and Active mode using RMAN Duplicate in preparation of disaster recovery of production databases for both Stand Alone and RAC databases.
• Configured Oracle Data Integrator ODI , mapped and translated the source data with Oracle Data integrator.
• Configured the DATAGUARD broker for the standby database in the Maximum Performance mode.
• Initiated the plan for the disaster recovery testing, documented and performed the switchovers manually and also using the DATAGUARD for 10g and 11g production databases for both on Stand Alone and RAC databases.
• Successfully setup and managed Oracle data guard on Exadata utilizing multiple networks for redo transport.
• Developed and implemented Exadata software patches across all components of Exadata database machine.
• Responsible for installing and configuring Oracle Gateway DG4ODBC, DG4DRDA... , in order to interact with other databases like the DB2 and pull the data to load it onto the oracle database.
• Involved in Capacity and Resource planning. Estimated the size of Data files and Redo log files based on current transactions rate, time for recoveries etc.
• Responsible for estimating the SAN requirements for the new RAC servers based on the current size of the database.
• Involved in the design of various Backups/Recovery strategies for Oracle databases as per SLA requirements and was part of a cost saving initiative where the database was backed up to disk instead of tapes using the Rolling Incremental Backups.
• Tested RMAN backups on T2 and T4 SAN using a customized script and documented the time for the both.
• Responsible for installing the agent on both RAC Stand Alone databases and registered them with the OEM GC so that the monitoring is enabled.
• Responsible for monitoring database's Performance using ORACLE Enterprise Manager OEM and Grid Control and other tuning tools like AWR repository, ASH report, AAS report, Stats pack report and Session Trace 10046 to find/fix root causes for performance degradation in the databases.
• Responsible for troubleshooting the failed backup jobs scheduled on the database using the Grid Control and closely worked with TSM and Netback up support.
• Responsible for scheduling blackouts on the databases using Grid Control for different application requirements.
• Monitored and maintained Security by managing Roles/Privileges for users of the databases.
• Used ORACLE Wait Interface, to identify the top most wait events and their causes.
• Used advisor, tasks like ADDM, Access Tune and Undo Advisors for performance tuning.
• Worked extensively with tools like Data pump, Exp/Imp, for loading data into database and monitoring and querying databases using DB artisan, Toad.
• Created Indexes-Bitmap/Join Indexes, Function-Based Indexes etc as per the given structures, operations, data in the tables for increased performance.
• Responsible for creating materialized Views/Snapshots for replications and increase query performance.
• Partitioned Tables, Index for increased query performance and easier maintenance.
• Analyzed query plan using Plan Table, Explain Plan, Dynamic Sampling, optimizer Hints and for estimating CPU Query costs.
• Refreshed databases and schemas from the Production and UAT to the new Dev., UAT databases using Data pump, RMAN, and Transportable Table spaces etc.
• Responsible for schema rebuilt from prod to other environments and check for invalid objects and fix them after the schema is rebuilt.
• Developed Shell Scripts to carry out routine checks on databases and perform various tasks on the database.
• Thorough knowledge of Peregrine ticketing system and ITSM-change management tool.

ENVIRONMENT: Oracle 10g/11g, AIX 6.1, 5.3, 5.2 , Solaris 10, Red Hat Enterprise Linux, HP-UX 11.2, RAC, OEMGC11g, SQL PLUS, TOAD, DBARTISAN, SQL DEVELOPER, Reflection X, Exadata, Putty, Putty Connection Manager, Shell Scripting, ASM, Oracle Gateways DG4ODBC, DG4DRDA , Peregrine Ticketing System, ITSM, TSM, VERITAS.

Confidential

Position: Sr. Oracle DBA

Responsibilities:

• Responsible for installation of Oracle 10g/9i version on IBM-AIX 5L, Windows2000/2003 Server
• Installed and created Oracle 9i and 10g databases in development, Production and QA environment including configuration, backup performance tuning.
• Implemented Oracle RAC Real Application Cluster with four nodes on a single database for Scalability and high availability.
• Supported Production Database Oracle 9i RAC 4 Node with High Level Evaluation, performance tuning, instance recovery, load balance.
• Configuration of RAC instances, including four 4 Exadata instances ranging from V2 to X3.
• Created storage spaces and connected to master and work repository in ODI.
• Parsing data from any format into a normalized Oracle database. Coding and preparation of Test plans.
• Extensively worked on deployment/migration process, data flow control between production, development and reporting.
• Created and monitored the Standby database configuration for the Disaster recovery scenarios.
• Worked with Oracle Data Pump expdp and impdp which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Implemented database and Schema Replication using Oracle streams in order to share and propagate data, events, and messages.
• Design and implemented backup strategies, like, incremental, complete and cumulative Backup of the database using Recovery manager RMAN , used utilities like Export/Import and Data Pump.
• Developed customized UNIX shell scripts Korn Shell, C-Shell , SQL, PL/SQL to automate routine DBA tasks such as backups, Exports/Imports, space usage monitoring, extent growth.
• Utilized performance tools like V SQLSTATS and SQL monitoring views to resolve Exadata performance related waits.
• Design and developed scripts to monitor instance locks, long running queries, free space, and extent growth.
• Involved in installing of SQL server 2000 on Dell servers. Applied patches and service packs to keep the database up to date.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
• Used Automatic Storage Management ASM as a vertically integrated file system and volume manager, purpose-built for Oracle database files.
• Optimization and tuning SQL queries and execution plan using TRACEFILE, TKPROF, and EXPLAINPLAN.
• Worked on tuning T-SQL queries so as to improve the performance.
• Monitoring database performance during peak and non-peak loads using TOAD, OEM, and STATSPACK.
• Daily Health Check Up of the Database using AWR, ADDM.
• Performance tuning which includes creating indexes, analyze tables and optimizer hints.

ENVIRONMENT: Oracle Server 10g/9i,Dell servers, T-SQL, PL/SQL, UNIX Shell Scripting, IBM-AIX 5L, Windows 00/03 Server.

Confidential

Position: Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 9i and 10g databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Successfully migrated databases from windows2000/2003 running oracle 9i over to Linux boxes 10g.
• Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Used cross platform transportable table space TTS to transport table spaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager RMAN and Flash Recovery in RAC Environment.
• Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Table space point in time recovery TSPITR using RMAN.
• Implemented Streams replication between RAC and non RAC database environments.
• Installed Oracle 10g Enterprise Manager Grid Control for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Assisted a team of DBA's in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
• Worked on Automatic Storage Management ASM with SAN Storage for managing data in EMC Symmetric.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer CBO , SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Stats pack.
• Performed conversion single instance to Real Application Cluster RAC database instances.
• Performed Heavy T-SQL coding and optimization.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Experienced on Database Security by monitoring User Management, Privileges, and Roles, Auditing, Profiling, Authentication and Risk management.
• Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Environment: HP-UX 11, Red Hat Linux4, Windows 2000/2003, Oracle 9.2.0.8/10.2.0.3/11i, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL Plus, PL/SQL, T-SQL,ASM, J2EE, ToadV9.7 SQL, Navigator V6.1.

Confidential

Position: Oracle DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments
• Responsible for administering, supporting production and development of Oracle 9i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Loaded data from flat file to Oracle database using SQL Loader.
• Created indexes on tables for performance tuning.
• Performance monitoring, tuning and space management in database with Grid control.
• Performed Troubleshooting and system maintenance.
• Involved in user creation and user access control.
• Involved in Schema creation and management. And Developed stored procedures, standalone functions and PL/SQL packages to comply with the requirements.
• In depth knowledge of setting up RMAN backups and maintaining catalog schema.
• Proficient in creating auxiliary and duplicate database using RMAN.
• Develop, implement and test Backup and recovery strategies for development databases.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule the code.
• Maintained the RMAN repository and customized recovery catalog and also involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.

Environment: Oracle 9i, SQL, PL/SQL, RHEL 2.1, Windows 2000 Server.

Confidential

Position: Jr. Oracle DBA

Responsibilities:

• Installed and created Oracle 9i and 10g databases for Testing, Development on HP-UX. Responsible for CLONING /REFRESH of Database for development, testing using RMAN, Export/Import, Data pump
• Created and Managed Physical Stand by database for failover and switch over operations.
• Responsible for sizing capacity planning of Oracle databases.
• Responsible for setting and managing user accounts, granting privileges to users.
• Designing the security policies and database access strategies, Logical and Physical database structure.
• Database design/architecture experience using both logical and physical modeling using Erwin Tool.
• Tools Implemented backup and recovery strategies, taking Backups on scheduled time and monitoring those.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN Recovery Manager .
• Partitioning Strategies for very large tables.
• Implemented Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Wrote monitoring/health check scripts, to send alerts like, database uptime/downtime status, sizing issues.
• Responsible for performing block/recovery using RMAN.
• Performed backup validations using RMAN.
• Identifying the expensive SQL statements and assist the developers during modification.
• Responsible for writing Stored Procedures according to specs and control files for input to SQL Loader for loading data from external files into the Oracle database.
• Responsible for Management of schemas, objects partitioning the tables indexes.
• Responsible for Automation of data load using shell scripting with SQL Loader.
• Responsible for Monitoring of database performance during peak and non-peak loads using AWR, ADDM, STATSPACK.