SUMMARY

• Experience in installation, configuration and maintenance of Oracle 12c, 11g/10g RAC
• Worked with ASM and not ASM builds.
• Worked on Linux, HP - UX, IBM-AIX, Sun Solaris, and RHEL.
• Build 2-node and 4-node clusters
• Build Data Guard for DR project
• Managed database using e-business and SAP.
• Tune databases using ASH, AWR, ADDM, SQL Performance Analyzer, Hang Analyzer etc.
• Good Experience in written shell scripts.
• Oracle Database administration with SAP and Unix Scripting
• Experience with Toad Data Modeler using Erwin
• Build complex entity relationship models - both logical and physical database design.
• Experience in resolving complex restore and recovery issues using RMAN.
• Worked with the following 11g/12c new features.
• SQL Access Advisor
• SQL Performance Analyzer
• SQL Plan Manager
• Table compression enhancement
• Active Data Guard
• Upgraded from 10 to 11g R2.
• Query Result Caching
• Invisible Indexes.
• Database Replay.
• AWR Baseline Enhancements
• Automatic Memory Management.
• Automatic SQL Tuning.
• Data Recovery Advisor.
• Read-Only Tables
• Flashback Enhancements
• RMAN Enhancements
• Table Compression Enhancements.
• Silent Installation of RAC
• Worked with Oracle Engineers in troubleshooting issues.
• Worked on CPU, PSU and one off patches.
• Worked on Exadata.
• Worked on Migration project.
• Pose expert knowledge in cloning databases
• Worked extensively on refreshes using Data Pump and Export Import.
• Extensive work building queries using dictionary tables and dynamic views.
• Experience in security implementations using FRA
• Installed 12c Grid agent
• Recovered database from block corruption.
• Worked on database triggers, stored procedures and functions using PL/SQL.
• Worked on GoldenGate project for migration.
• Provided 24/7 production support
• Worked on 12 cloud control.
• Worked with offshore teams
• Lead Upgrade and Migration projects.

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, Arizona

Sr. Oracle DBA

Responsibilities:

• Build and managed RAC Clusters
• Build and supported Data Guard Environments
• Managed Security / Audit compliance of more than 30 account’s (Consisting of platforms: Oracle, SQL, DB2)
• Managed Oracle EBS Financial Sector and dealt directly with Clients
• Worked with storage teams for ASM needs.
• Worked on much performance related issues.
• Managed and met SLA’s timing’s
• Evaluated Team performance’s and helped by mentoring team if needed
• Managed Change Management process of CRQ’S (Consisting of platforms: SQL, DB2)
• Managed in-house Oracle Databases running on various operating systems like Windows
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Implementation of high availability of solutions with Oracle10g RAC, Physical and Logical standby databases(Data Guard), Materialized View, VCS and Golden Gate
• Installed Golden Gate
• Experience in replication using Golden Gate and Materialized Views
• Replication and Extracting data and applying on production database’s using Golden Gate
• Using Enterprise Backup utilities for backup.
• Writing scripts for backup and recovery.
• Database creation, Installation, patching and database upgrades.
• System tuning for better performance.
• Written Shell scripts.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Applied CPU and quarterly patches in the development and production environments using Opatch utility.
• Used 12C OEM to run AWR reports, 12C MA agents registration
• Installed 12C MA Agents on Linux, AIX, Solaris Platform.
• Creating packages and database triggers.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL procedures, tuning queries and
• Writing UNIX shell scripts for backup and recovery.
• Database/Schema Refresh as per client requirement.
• Worked on capacity planning
• Worked on weekends for deployments with offshore teams.
• Used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Installed and implemented 10g RAC with 4 nodes with ASM.
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions
• Responsible for installing and configuring Golden Gate on Oracle Servers.
• Database migration from 9i to 10g to 11g.
• Designed, configured and maintained backup and recovery policies using RMAN.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Discoverer Administration including the design and administration of Business areas.
• Setting up privileges to create local and remote objects
• Create materialized views to refresh data at regular intervals.
• Using materialized view logs to reduce the replication time costs for fast refreshes.
• Upgrading/Migration from Oracle 8i databases to 9i and to 10g.
• Installing of quarterly security patches on all non-production and production servers.
• Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
• Worked on SQL Server 2005 and 2008 instances
• Administered, managed, Backup / Restore / Recover SQL Server Databases.
• Actively participated in Oracle and SQL Server Load Tests.

Environment: Linux, CentOS, 12c Cloud Control, 11g Grid control, OEL, ASM, VMWare, TOAD, ERWIN, Oracle 9i, 10g, 11g and 12c Databases

Confidential - Summit, NJ

DBA (consultant)

Responsibilities:

• Involved in 24x7 Production Database Administration and support.
• Data Refresh from Production to SIT/UAT/LT and Development environments using RMAN Duplicate Database.
• Setup, Configured and supported Physical Standby (Data Guard) databases for high availability and disaster recovery.
• Took Hot and Cold backups, Performed Full and Point in Time Recoveries using RMAN, investigated causes for failures and resolved them.
• Used Shareplex for the replication environment.
• Intensively used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Created users, roles and granted privileges according to the business requirements.
• Migration of code from development to production instances, database space and file system space monitoring, purging of unwanted data and files.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Applied CPU and quarterly patches in the development and production environments using Opatch utility.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Creating and refreshing materialized views, views, synonyms, and indexes.
• Developed UNIX Shell scripts for daily database logical backups, data retention, purging and other scheduled database procedures.
• Installed foglight and OSWatcher on various database servers.
• Evaluate and adjust Oracle database initialized parameters in init.ora file. Monitor and optimize database performance.
• Worked with Oracle support to resolve database critical issues
• Installed and configured Oracle 10g and 11g Real Application Cluster (RAC) Instances with stand by database (data-guard) using CRS and ASM.
• Added nodes to the RAC cluster for the increased load and removed it when not necessary.
• Successfully installed oracle 10g on RHEL 4 on VMWare Environment.
• Implemented oracle database connectivity to SQL Server database using Oracle Transparent Gateway.
• Installation and configuration of Oracle 8i, 9i, 10g RAC in UNIX/LINUX and Windows environment. User authentication.
• Knowledge of Erwin for Data Modeling and Dimensional Data Modeling.
• Design and implementation of backup and recovery strategy using tools Veritas Netbackup and RMAN for disk and tape backup.
• Installing 9i and 10g databases on LINUX and SOLARIS 10.
• Database sizing & tuning.
• Created SQL Server stored procedures and triggers utilizing T-SQL.

Environment: HP-UX, Linux, Oracle 10g with RAC, Java, Oracle 9i, Oracle 8i, TOAD, RMAN, OEM and Windows.