PROFESSIONAL SUMMARY:

• Having 8+ years of vast experience and sound knowledge in Oracle Database Administration, worked on large scale production environments across multiple platforms. Ability to provide comprehensive solutions in all areas of DBA. Well versed with all aspects of DBA including Installation, Configuration, Migration, Capacity planning, Performance Tuning and Backup & Recovery. Hands - on experience with Oracle Cluster ware and Real Application Clusters (RAC) 10g/11g, Data Guard and Golden Gate.Accept challenging assignments and keen perseverance in solving them, complex problem solving and strong analytical skills.
• Experience as   On-Call   24x7   production   DBA support for maintenance activities.
• Experience as an Oracle DBA with databases versions Oracle 10g,11g,12c on various operating systems like Linux, Solaris, aix, and windows
• Experienced in database management for oracle on virtual machines, physical machines and also amazon AWS cloud.
• Excellent experience in installation, configuration, upgrades, migrations, patches, production support, performance tuning, backup and recovery, cloning, space management, database security, auditing.
• Experience in implementing and using Oracle Database High Availability Features and Products to improve overall Performance, Scalability and Manageability
• Good knowledge and experience in Linux and Windows Server Administration.
• Well experienced in installation,configuration and administration of Oracle 10g, 11g, 12c databases in Oracle Solaris, Linux, IBM AIX and HP-UX platforms.
• Proven experience in coordinating with globally spread teams for successful implementation of Projects.
• Experienced in implementing Oracle RAC environment with ASM and Data Guard.
• Engineering, implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Golden Gate, Oracle Advanced Replication and specific Network Storage and Clustering solutions
• Possess in-depth knowledge in Oracle Partitioning and Compression technologies
• Good experience in migrating and managing oracle 11g and 12c database on Exadata X2-2, half RAC and full RAC machines.
• Experienced in providing DBA support for various applications like SAP, SIEBEL CRM, PEOPLE SOFT etc.
• Experience in Installation, Configuration and Maintenance of Golden Gate for real-time transactional change data capture, transformation and delivery, offering log-based bidirectional data replication
• Implemented Golden Gate replication for Oracle databases, and troubleshooting any failures related to replication.
• Experienced in using Data Pump for migration activities.
• Experienced in handling high priority issues and ensure timely restoration of database services.
• Performed database Upgrades, Patching & cross-platform Migrations.
• Strong knowledge in Oracle Advanced Security, Database Vault, Audit Vault and EPV.
• Implemented RMAN backup and recovery strategy; Used RMAN for all type of Critical Recovery scenarios.
• In-depth experience with RMAN for Cloning, database refreshes, and DR creations.
• Extensive client facing experience, Lead/participate in meetings with stakeholders, Application teams and suggesting appropriate solutions.
• Experience working in large database environments and mission critical projects
• Experienced in Performance Tuning using TKPROF and STATSPACK/ AWR,ASH reports.
• Experienced in capacity planning for databases
• Experienced in managing databases using Oracle Enterprise Manager 10g, 11g, 12c (Grid/Cloud Control).
• Good experience with TOAD , SQL*Loader , SQL*Plus and PL/SQL Developer .
• Excellent SQL, PL/SQL programming skills; Proficient in Shell scripting
• Tuned the database at every level namely design, application, shared pool, SGA, I/O, Sort, Undo, locks, SQL, Operating System
• Experienced in providing DBA support for MS SQL Server, My SQL and DB2 database along with oracle
• Experienced in using Oracle Support (Metalink) to raise service requests and download oracle products.
• Strong Interpersonal skills and documentation skills, Ability to work as a strong team leader/member.

TECHNICAL SKILLS

Databases: Oracle 12c RAC, Oracle 11g RAC, Oracle 10g RAC, oracle 9i, oracle 8i, Oracle 7.3, SQL Server, MySQL

Oracle Products: Oracle RAC, Oracle Apps 11i/R12, Data Guard, Golden Gate, SQL*Plus, PL/SQL Developer, SQL*Loader, OEM 10g/11g/12c, Oracle Reports

Features: Oracle ASM, RMAN, OPatch, Export/Import, Oracle Data Pump

Tools: TOAD, XShell, Putty, WinSCP, EPV, Serena PVCS, Veritas Net Backup, BMC Remedy, Log Miner, VMware, AWR, ADDM, STATSPACK, Autosys

Operating System: Red Hat Enterprise Linux, Oracle Enterprise Linux, Oracle Solaris, IBM AIX, HP-UX, Windows Server

Languages: SQL, PL/SQL, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Belden, Richmond, IN

Sr. Oracle DBA

Responsibilities:

• Responsible for support and administration of entire Oracle database environment (9i, 10g, 11g, 12c, RAC, ASM, Data Guard)
• Successfully optimized the performance of SQL queries and batch jobs in Oracle Database 11g R2 RAC database environments. 
• Implemented replication for oracle databases using GoldenGate; Prepare GoldenGate parameter files for Extraction and Replication; investigate failures with replication
• Performed migration of database from one platform to another with zero database downtime using Oracle Golden Gate.
• Setting and Monitoring Exadata using EM12c.
• Successfully migrated databases from Solaris to Linux servers using Data Pump or Exp/Imp.
• Performed database upgrade from 11g to 12c
• Implemented Enterprise Manager Grid Control OEM (11g and 12c) to provide monitoring and management of the Oracle database estate.
• Planning and Implementation of upgrades for standalone as well as RAC databases.
• Performed day-to-day DBA activities
• Troubleshooting Oracle errors, fine-tune database parameters, and analyze AWR reports.
• Automating the RMAN backup scripts, listener log purge, alert log clearance, export backups, using shell scripts.
• Upgrade/Patch/Clone/Migrate Oracle EBS Application Tier
• Performed admin tasks using AD utilities such as adadmin, adpatch, adctrl, admgrpch, adrelink and rapidwiz.
• Oracle Client Installations, deploying OEM agents (10g/11g/12c) on servers and monitoring databases using OEM
• Configuration of RMAN backups for databases using TSM.   Design and optimize backup & recovery strategy, refresh stage databases
• Performance tuning of long running batches/queries; Troubleshooting RAC, DATAGUARD, and ASM issues
• Planning, designing, testing and building new databases and database objects.
• Applying quarterly PSU Patches to RAC/Non-RAC databases; Applying GI patches/PSU to CRS on RAC clusters.
• Setup Data guard environment for 2/3 Node 11g RAC databases, Performed DR drills like Switchover/Switchback using DG Broker, Upgraded RAC-Data guard systems
• Extensively involved in Capacity Planning (ASM, file system disk space, Tablespace Management)
• Extensively involved in database maintenance tasks (Database health checks and housekeeping activities).
• Database Security (User administration; Managing Roles, Profiles and Privileges)
• Table Partitioning, creating Index Organized tables, creating locally managed tablespaces.
• Expert at database tuning, application tuning and performance monitoring. Fine tuning Initialization parameters, I/O, memory and operating system kernel parameters.
• Write Shell scripts to monitor tablespace and extent growth.
• Database instance tuning, maximizing performance by setting utilization, storage parameter and allocating system resources (Shared pool, Buffer cache, Redo logs, Rollback segments)

Environment: RHEL 6.1, Oracle Solaris, AIX 5.3, Windows Server, VERITAS, Oracle (12c,11g,10g,9i), RAC, Data Guard, ASM, OEM 10g/11g/12c, TOAD, RMAN, BMC Remedy, BMC Control-M, SAN, VMware VSphere, PL/SQL, UNIX Shell Scripting, Subversion

Confidential, New Jersey

Sr. Oracle DBA

Responsibilities:

• Installed and configured Oracle 11.2.0.x and 12.1.0.x RAC-One system to simplify the database management
• Re-platform and upgraded Oracle 10g databases to oracle 11g
• Upgraded various Oracle 10g databases to 11gR2
• Configured Streams to replicate from a OLTP to Data Warehouse on oracle 11gR1 database and upgrade the database to 11gR2
• Installed and configured Golden Gate for replication OLTP data to the DR site to implement high availability
• Installed, configured and upgraded an Oracle 11g RAC databases to a new host to allow the high rate of expansion of an Enterprise people repository
• Installed and configured Oracle 12c RAC-One environment to bring back a vendor managed application to the home data center
• Installed, configured and managed Oracle 12c standalone using ASM for a people repository of the patients
• Installed, configured and managed a 2 node Oracle 12c database for CRM
• Migrated Databases to Oracle Exadata Database Machine.
• Upgraded 11.2.0.3 to 11.2.0.4/12.1.0.2 GRID/RDBMS on Exadata
• Implemented Exadata compression for Datawarehouse database.
• Done migration of non-ASM database to ASM.
• Installed, Configured and Maintained Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases.
• Configured Standby databases using Data Guard 11g (Maximum Performance)
• Patched PSU patches and required one-off patches to database servers on quarterly
• Database cloning from Production to Test and Development environments
• Work with the application developers to review and deploy database changes
• Created Users, Roles and Security administration
• Administer multiple 11 Oracle Databases on Linux Red Hat platform using Banner ERP front end.
• Installed and implemented Oracle Data Warehouse and Banner's Operational Data Store.
• Installed and implemented Banner's Degree Works product for the Registrar's office.
• Work with Banner 9 upgrades, Luminis 5 upgrades, and ODS 8.4 upgrades.
• Backup configuration and Recovery testing on new builds and existing environments
• Troubleshot various performance issues to bring the application and database performance to a stable level
• Built Oracle 11g database servers (Sun Cluster and 2 node RAC) for Offline DR location to enable high availability at a home datacenter located other side of the states

Environment: Oracle Applications 11.5.10.2 and R12.1.3, Oracle 11g, 12c, Sun Solaris, IBM AIX, RHEL, Oracle 11g ASM, Oracle Discoverer 11g, SQL*plus, Oracle Exadata, Oracle Golden Gate, Oracle streams, ZFS/ ZBA backups, OEM, ASR

Confidential, Dallas

Oracle DBA

Responsibilities:

• Production support DBA responsible for several duties/projects as assigned.
• Provided 24*7*365 on-call support and weekend support for maintenance activities.
• Implemented replication for oracle databases using Golden Gate; Prepare Golden Gate parameter files for Extraction and Replication; investigate failures with replication
• Upgradation of RAC databases from 10.2.0.4 to 10.2.0.5 & 11.1.0.6 to 11.2.0.3, 10.2.0.5 to 11.2.0.3 etc., Upgradation of 10.2.0.4 CRS/ASM to 11.2.0.1 GRID Infrastructure
• Work closely with database vendors, Infrastructure groups, other DBAs, and application teamsto proactively develop database solutions.
• Extensively working on new builds of 11gR2 RAC, RAC One-Node, Data Guard environments withASM on Linux/AIX platforms.
• RMAN Catalog maintenance, purging sufficiently old backups from tapes etc.
• 10G/11G RAC Installation/Maintenance and troubleshooting CRS/Grid Infrastructure and ASM issues
• Performed upgrades from Oracle 10g to 11g on Linux and Solaris machines.
• Working effectively with business users, Oracle Apps functional and technical teams to resolve issues.
• Setup and configuration of OEM 10g/11g/12c; Agent installations & configuring   target hosts/databases for monitoring by setting up thresholds and then responding to alerts and notifications.
• Implemented Backup and Recovery strategy (RMAN).
• Creation of new disk groups in ASM environments, performing disk additions/deletions as and when required.
• Installed and configured 2/3 Node 10gR2/11gR2 RAC databases with ASM on Linux
• Export and import of tables, schemas and full database as per development/Application team requests using Data pump or Export/Import
• Upgrades and Patch management, Database Migration activities using Data Pump; Database Reorgs
• Implemented Disaster Recovery and Replication using Oracle Data Guard; Oracle RAC administration

Environment: RHEL 5.4, Oracle Solaris, Windows, Sun E5000, SAN, VERITAS, Oracle (11g,10g,9i), RAC, Data Guard, Erwin 7.1, OWB, DataStage 7.5 EE, PL/SQL, UNIX Shell Scripting, DBArtisan, TOAD

Confidential

Oracle DBA

Responsibilities:

• Developed backup and recovery strategies for Oracle Server databases.
• Handled database migration from Solaris to Linux
• Worked on monitoring and optimizing the database by performance tuning.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Developed UNIX (KORN) shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Experience in Backup & Recovery techniques using RMAN and conducted disaster recovery drills.
• Responsible for partitions on tables and indexes for managing large tables.
• Used STATSPACK for Database Monitoring and Database Performance.
• Tuning the SGA, Buffer Cache, Rollback Segments, Redo Mechanisms, Monitoring and Detecting Locks.
• Extensive use of Scheduler in Windows and Crontab in UNIX environment for scheduling routine tasks.
• Creating Stored Program Units in the Form of Packages, Functions, Triggers and Procedures for implementing the database intensive business rules.
• Optimization and enhancement of existing procedures and SQL statements for better performance.
• Providing backend support to junior developers for stored procedures and functions, reporting, SQL query tuning and optimization, performance monitoring, resource usage and profiles.
• Coding stored procedures, Packages and functions and well tuning the SQL in the application.
• Writing SQL*Loader scripts to load the external files into the Oracle Database.
• Using SQL Loader for populating static tables and fact tables.
• Using EXPORT/IMPORT for table level and full database de-fragmentation.
• Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).

Environment:Oracle Solaris, HP-UX 11, Windows, Oracle 9i/10g/11g, Oracle RAC, Data Guard, ASM, TOAD, O EM (10g, 12c), VERITAS, SAN, RMAN, SQL*Plus, PL/SQL, SQL*Loader, Serena PVCS, EPV, Control-M.

Confidential

Oracle DBA

Responsibilities:

• Installation, Upgrade and Configuration of Oracle 9i, 10g databases on Linux/Solaris platforms.
• Installation, Configure, setup of 10g RAC; Add new nodes to RAC 10g Cluster to distribute the load
• Performed upgrades from 9i to 10g and applied quarterly patches.
• Managing Veritas Clusters for HA, I2 Implementation.
• Configuration of Oracle Enterprise Manager - OEM 10g tools for monitoring, performance enhancement and debugging.
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager), Stat spack, and V$ dynamic views.
• Setting up RMAN, Hot and Cold Backups, Exports.
• Involved in Database Design & Data Modeling (ERWIN).
• Development of solutions for enhancements based on a technical specification
• Analyze, design, develop, test and deploy stored procedures, packages, functions, triggers, cursors and Schema objects in the database and support post deployment.
• Involved in Streams Configuration for Sharing Information Between Databases.

Environment: Oracle Solaris, AIX 5.x, Windows Server, VERITAS, Oracle (10g,9i), RAC, OEM 10g, TOAD, RMAN, SAN, PL/SQL, UNIX Shell Scripting, PVCS, BMC, Oracle Streams