PROFESSIONAL SUMMARY:

• Over 8+ years of experience as an Oracle DBA in various domains to deliver new products, upgrades with Oracle 10g, 11g and 12c on Sun Solaris, Red Hat Linux and Windows platforms.
• Extensive knowledge on database administration for Oracle 12c, 11g, 10g, 9i with experience within a very large scale database environment and mission critical large OLTP systems in a variety of environments like Linux, HP - UX, IBM-AIX, Sun Solaris, RHEL and Windows.
• Expert in planning, creation, administration and troubleshooting of Oracle 11g/10g/9i, OLTP (multiple instances)/OLAP databases.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Cloud Control, Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Have Hands on experience in Oracle 10g, 11g 3-Node RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery).
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
• Have implemented replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for DR high availability.
• Excellent experience in various migration techniques like export/import, Data pump, backup, restore, cloning, and data guard.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Writing scripts in the UNIX based environments for managing the users roles and privileges, scheduled backups (using data-pump /cold backups), manage statistics, Disk space management.
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in writing PL/SQL Stored Procedures, Functions, Packages and Triggers, various UNIX Shell Scripting.
• Experience using Erwin as a Data Modeling tool.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
• Provided 24*7 on-call production database support and maintenance including remote database support. Worked on Automatic Storage Management with SAN storage for managing data in EMC symmetric.
• Knowledge of Data Normalization and its normal forms.
• Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.

TECHNICAL SKILLS:

Operating Systems: RHEL, HP-UX, Windows, Sun Solaris

RDBMS: Oracle 10g R2, 11g R1/R2

High Availability: RAC, Data GuardLanguages: SQL, Java, C, PERL, UNIX Shell, T-SQL

Tools: RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, ERWIN, TOAD, etc

Tuning Tools: TKPROF, EXPLAIN PLAN, S TATSPACK, SQL Advisor, DBMS, Stats

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Responsibilities:

• Build 2 node RAC cluster
• Setup Maximum Availability Physical standby Data Guard
• Refreshed databases using RMAN duplicate database.
• Refreshed schemas using data pump.
• Worked with storage admins for disk space for ASM
• Migrated databases from UNIX file system to ASM.
• Applied CPU / PSU / one-off patches.
• Used 12c cloud control to monitor databases.
• Setup jobs/alerts using OEM.
• Utilized a combination of Bash and Korn shell scripting to integrate two sets of scripts
• Created and modified shell scripts
• Worked with shadow copy software to back up large databases and quantities of data
• Migrated data from one server to another
• Worked with CLI and GUI
• Worked with vi Text editor
• Modified existing RMAN scripts.
• Worked on Confidential Shadow image.
• Generated Oracle Audit Remediation reports

Confidential, Nashville, TN

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Proactive database monitoring using 11g grid monitoring tool.
• Installation, Configuration and Maintenance of RAC, Stand by database. Installed and Configured Oracle 11g RAC, CRS using ASM.
• Implemented the Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintain primary and standby databases.
• Database migrations from HP-UX11 to AIX 6.1 platforms.
• SQL tuning using statspack and explain plan, tkprof.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Responsible for upgrade & migrating databases from 10g to 11g &11g to 12c.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 11g, 12c & OEM
• Install, configured and maintained Oracle 10g on Linux Red Hat 5
• Clone database from Production to Development, QA testing environments
• Create materialized view (snapshot)
• Installed, patched, and configured Oracle 10g and monitoring Oracle database.
• Upgrade OPatch
• Rolling install oracle patch in Oracle RAC 11g
• Upgrade database from 10g to 11g
• Managed table space
• Monitoring database in GRID CONTROL, OEM and OS level
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans
• Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment: Sun Solaris 5.10, Aix 6.1, HP-UX 11.31 Oracle 9i, 10G, 11G, & 12C, OEM, UNIX, SQL, Oracle Auditing, Oracle Partitioning, Oracle Replication, Hot Standby, Data Guard.

Confidential, Boston, MA

Responsibilities:

• Installed, configured and managed Oracle 10g RAC
• Configured Oracle networking for RAC
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• REFRESH/CLONING of Database and applications for development, testing
• Installation and Maintenance of STANDBY database using DATAGUARD.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Experience in troubleshooting the ORACLE streams.
• Configured RMAN backup for 10g RAC database
• Monitoring 10g RAC performance
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation (including index design)
• Migration of system and applications from Oracle 9i to 10g, 10g to 11g using Database
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.
• 24*7 production support and on call rotation.
• Worked in environments of small 20 GBs size databases up to 4 TB Size Databases/DW.
• Extensive experience of setting up Oracle Enterprise Manager & Grid Control and database control for monitoring, tuning and managing Oracle RAC and non-RAC Environments
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (SQL Backtrack and RMAN)
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Worked with RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Worked with system administrators, business analysts in designing and implementing backup and recovery procedures using RMAN, SAN based backups using EMC BCVS
• Raised SR and TAR with Oracle Support.
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN. Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Provided System support for both development and 24*7 production environments.
• 24x7 Production Database Administration support

Environment: Oracle 10g RAC/9i, SQL, RHEL 4, AIX 5.2, Shell scripting, SQL Server 2000/2005