SUMMARY

• Around 7+ years of experience in Oracle Database Administration, tuning, development, analysis, design, Installation, patches, upgrades, migrations, configuration, space management, data modeling, cloning, backup and recovery, auditing, database security, SQL, PL/SQL, troubleshooting and documentation.
• Experience in Installation, Configuration and Maintenance of Oracle 12c/11g/10g RAC database with ASM, EXADATA and single instance database.
• Experience in designing and implementing Disaster Recovery(DR) plan using Data Guard and Golden Gate
• Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
• Experience in Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Experience in system Monitoring & Database Performance Tuning using Explain plan, SQL Trace.
• Performed fine tuning by creating indexes, TKPROF, EXPLAIN PLAN and TRACE events.
• Experience in Supporting EDW with OLTP and OLAP Data ware House applications.
• Upgraded database from 9i, 10g to 11g and Migrated databases across different servers & platforms.
• Experience in database full Backup (hot and cold), DataPump Export/Import, SQL Backtrack and Restore and Recovery procedures using RMAN.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Proficient in performance tuning in large OLTP (40 TB) and data warehouse environments.
• Expertise in Installation, Upgrade Configuration, Migration, Patching, RMAN, Performance Tuning, Backup & Recovery, and Data Guard on different Oracle versions, played different roles like Production/Development database administrator and Data Warehouse DBA.
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM).
• Job scheduling using cron utility and Shell Scripting for automating DBA tasks.
• Back - end programming, database Triggers, stored Procedures and Functions using PL/SQL.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, packages, performance Tuning, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Oracle Enterprise Manager Grid (10g, 11g, 12c) - upgraded 10g (10.2.0.4) to 11g (11.2.0.3) to 12.2.0.1 (including agents upgrades, etc.)
• Experience in maintaining Oracle Data Guard
• Setting up the complete Database Security Implementation and troubleshooting Oracle Technologies as an Oracle DBA on OLTP and OLAP environment.
• Experience in Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Experience in Database Creation, Partitions, and Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage, resolving ORA-errors and network management.
• Experience of Auditing, Oracle Security, OEM, SQL Navigator, TOAD and Opatch Utility.
• Expertise knowledge of Oracle Architecture, SGA and PGA
• Proficient in SQL, SQL*Plus, SQL*Loader, TOAD Quest and Tuning of SQL Queries.
• Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and Virtual IP Configuration Assistant (VIPCA) and a very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

Operating System: Red Hat Linux, HP UNIX, Solaris, AIXWindows 2000/2003/2008/2012

Database: Oracle 12c/11g/10g/9i/8i, RAC11g/10g, SQL Server

Storage Technologies: Oracle ASM, SAN, Net AppVirtualization Technologies VMware, Oracle Virtual Machine

DR Technologies: Oracle Data Guard, Data Guard Broker

Backup recovery Tools: RMAN, flash recovery

Programming Languages: SQL, PL/SQL, UNIX Shell Programming, Java, CC++, HTML.

Tools: / Utilities Oracle10g/11g Data Guard, Oracle Enterprise

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle DBA

Responsibilities:

• Responsible for upgrading system from Oracle 10.2.0.1 (10gR2) to Oracle 11.2.0.2 (11gR2).
• Performed the migration and upgradation of Oracle databases by using import/export, oracle datapump.
• Experience in HP-UNIX environments.
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database, Data Guard, Materialized views, Bi Directional Streams Replication, Golden Gate
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience in working with EXADATA with for OLTP and OLAP Databases.
• Created database objects like tables, views, indexes and partitions.
• Used Oracle backup utility RMAN to implement Oracle backup.
• Scheduling meeting with the Application Team in different location to gather the information for migration.
• Applying patches whenever required in Exadata, RAC and standalone servers.
• Performed SQL Tuning and database tuning based on reports generated by Run time SQL execution plans, AWR, ASH Reports, Explain Plan and monitor the database performance
• Estimating the space requirements for database growth for next 12 months and availability of Hardware to support the processes.
• Carried out Performance optimization and Query tuning using Statspack, Tkprof and OEM.
• Installed and Configured Oracle Enterprise Manager Grid Control for monitoring several databases.
• Creating Users and Grant/Revoke roles, privileges on database objects and creating database links (dB link).
• Monitoring the Users, Tablespaces, Memory Structures, Rollback Segments, Redologs, Tables, Archived Redologs and Alerts.
• Performed various database migrations, refreshes as per requirements.
• Applied CPU patches each quarter to keep the databases up to date.
• Worked with developers to tune, optimize code.
• Worked with Oracle support to resolve various issues with the database by opening SR’s.
• As a team member, involved in interacting with business users, gathering business requirement.

Environment: SQL, Oracle 10g, Oracle11g, RMAN, Import/Export, OEM, IBM AIX 5.3

Confidential, VA

Oracle DBA

Responsibilities:

• Performed the migration and up gradation of Oracle databases on Oracle Super cluster half rack.
• Installation of Oracle database and ASM (11.2.0.4) on Zones/Domains.
• Involved in configuration of Super cluster half rack (11.2.0.3.19 BP) with 2 compute nodes.
• Involved in implementing replication using Golden Gate
• Involved in installation of database on Exadata half rack 4 compute nodes and 8 ZFS storage cell.
• Developed and implementing Disaster Recovery (DR) plan using DataGuard.
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Installed Oracle GoldenGate and configured heterogeneous replication.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Hand on experiences in creating Index optimization jobs to increase database performances.
• Maintaining Production, Development & Test databases and applications which are in Exadata, RAC, single instance servers
• Responsible for upgrading system from Oracle 11.2.0.3 to Oracle 11.2.0.4.
• Hands on experiences on installing and maintaining of RAC databases.
• Performed restoring of database via RMAN utility.
• Experience in Knowledge Transfer of Golden Gate Product and Installed Golden Gate(10.4/11.1)
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Hands on experiences on 12c Oracle Enterprise Manager Grid Control for monitoring several databases.
• Used Oracle backup utility RMAN to implement Oracle backup.
• Performed the migration and up gradation of Oracle databases by using import/export, oracle datapump.
• Production & Non-Production support for several mission critical/entity essential OLTP systems, which utilize multiple Oracle databases (TB Sizes).
• Installed and Configured Oracle 11g.
• Created database objects like tables, views, indexes and partitions.
• Scheduling meeting with the Application Team in different location to gather the information for migration.
• Performed SQL Tuning and database tuning based on reports generated by Run time SQL execution plans, AWR, ASH Reports, Explain Plan and monitor the database performance
• Estimating the space requirements for database growth for next 12 months and availability of Hardware to support the processes.
• Creating Users and Grant/Revoke roles, privileges on database objects and creating database links (dblink).
• Monitoring the Users, Tablespaces, Memory Structures, Rollback Segments, Redologs, Tables, Archived Redologs and Alerts.
• Performed various database migrations, refreshes as per requirements on EXADATA environment.
• Applied CPU patches each quarter to keep the databases up to date.
• Worked with developers to tune, optimize code.
• Worked with Oracle support to resolve various issues with the database by opening SR’s.
• As a team member, involved in interacting with business users, gathering business requirement.
• Applied CPU patches each quarter to keep the databases up to date.

Environment: Oracle Super cluster half rack (11.2.0.3.19 BP), Exadata Half Rack, Oracle 10g/11g, Oracle Enterprise Manager (11g, 12c), SunOS SPARC 5.10

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle 9i and creation of database.
• Performed regular Backups and Recovery as per Organization Strategy to support the database and also maintain 24 hours uptime for the database while carrying out the activities.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Experienced with CDC/Golden Gate 11g skills in large production environment
• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN.
• Backup/Restoration, Scheduling Backups, taking Logical Backups.
• Involved in Design and implementation of oracle 10g DataGuard both physical/logical standby databases.
• Performed Partial, Complete and Metadata Exports & Imports.
• Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Responsible for Oracle 9i logical and physical databases design, implementation and maintenance.
• Created Tables with appropriate Tablespace and Index.
• Created Users, Roles and Schemas with suitable Permissions.
• Responsible for Partitions on tables and Indexes for managing large tables.
• Maintained Logs/Backups using Imp/Exp Utilities.
• Coordinated with Unix Administrators for Space Management on various servers &help in Oracle.
• Automating processes, Scheduling Jobs per user requirements using DBMS JOB.
• Database monitoring for Deadlocked process.
• Installation and configuration of Statspack and analysis of Statspack.
• Performed SQL tuning by using Explain Plan and TKPROF and Oracle Enterprise Manager.
• Responsible for Data Integrity and Concurrent Data, Locks, Latches and Deadlocks.
• Created Users and Roles with appropriate Privileges.
• Created Materialized views and database links. Wrote shell scripts for monitoring the database.
• Designed logical and physical Data Models using ERWIN.

Environment: SQL, Oracle 10g, Oracle Enterprise Manager, PL/SQL, TOAD and SQL *Plus.

Confidential

Oracle Developer

Responsibilities:

• Involved with Maintenance and Support processes.
• Analyzed the software requirements of the project by studying the Software Requirement Specification document.
• Created various database objects like table, indexes, sequence and views
• Involved in creating, debugging and modifying stored procedures, functions and packages using SQL Developer and TOAD.
• Used various forms of control structures including IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Creating SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Maintaining a Test Database for testing and research.
• Documented business rules, technical designs, test cases, and user guides.
• Testing the system in and fixing the errors.
• Involved in unit testing, integration testing, system testing

Environment: SQL, PL/SQL, SQL*Loader, Oracle 10g, Oracle9i, UNIX (Sun Solaris 2.8)