SUMMARY:

• I have over 7 years of active experience in installation and configuration, system implementation and problem trouble shooting. Experience with Oracle 11G and 12c Installation, Administration, Data Guard, RMAN, ASM, and RAC Involved in different scenarios of OLTP and data warehouse farms.
• Experience in creating development, test, stage, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
• Expertise in installation and configuration of oracle 11g, 12c on various platforms like IBM - AIX, SUN SOLARIS, Confidential -UX, Red Hat Linux and Windows.
• Having a sound knowledge of new features of Oracle 11g R2.
• Managed Oracle Databases on Amazon Web Services.
• Experience in implementing DR using Data Guard.
• Build, installed 12c on AWS RDS.
• Exposure in install/configure/upgrade the High-Availability Hadoop Clusters.
• Proactive monitoring in identifying bottlenecks in the application and database using Statspack, AWR, ADDM and 12c OEM Cloud Control Monitoring.
• Expertise in database backup/recovery strategy (BCV mirroring, RMAN, Export/Import & Data Pump), Performance Tuning, Capacity Planning, Standby database (Logical, Physical), Oracle configuration management, database cloning, refresh, and patch management.
• Worked with latest 11g/12c features Data pump, Flash-Back Recovery, AWR, ASM, ADDM and 12c cloud control
• Migrated databases to Exadata.
• Patched Exadata servers.
• Creating and Customizing SQL Azure Dynamic Data Masking.
• Experience working with Azure SQL Database Import and Export Service. 
• Experience in performance-tuning services like EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g/11g/12c OEM Grid Monitoring, custom scripts troubleshooting Oracle databases using sqltrace.
• Involved in oracle technical support process through Metalink and other procedures.
• Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Build and managed Oracle Goldengate replication.
• Experience in Configuring Unidirectional and bi-directional replication
• Experience in using OEM, TOAD, Data migrations using export/import, Data pump, RMAN.
• Maintaining Database Security using security compliance auditing, capacity planning.
• Experience in using SQL *Loader and External Tables for Export/Import of data.
• Experience in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
• Extensive use of TOAD for extracting scripts from the dictionary.
• Strong experience in working with multiple projects in high-pressure environment.
• Installation, configuration & administration of Oracle Grid control.
• Worked on the BMC remedy ticketing system.
• Capacity Planning and bench marking the data growth year over year.
• Experience as On-Call 24x7 production DBA support, Application/Development DBA.
• Very familiar in creating TAR/SR with Oracle Support and Metalink to resolve the production database issues.
• Excellent verbal and written Communication, Presentation and Analytical skills.

TECHNICAL PROFICIENCY:

Operating Systems: RHEL, CentOS, Windows, HPUX, AIX, Solaris

RDBMS: Oracle Server 9i/10g/11g/12c

Storage: ASM, Tivoli Storage Manager

Tools: Upgrade, Migration, RAC, Data Guard, ASM, GoldenGate, SQL*Plus, PL/SQL, SQL*Loader, TOAD, 12c Cloud Control, Export/Import, Data Pump, RMAN, Shell Scripts, RMAN Duplicate Database.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager.
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Maintain and Administer SQL Server Databases on Windows Server VM.
• Upgraded oracle from 11g to 12c.
• Creating and Customizing SQL Azure Dynamic Data Masking 
• Managed Oracle Databases on Amazon Web Services.
• Migrated Oracle Database to AWS.
• Worked on AWS EC2.
• Build Data Guard Broker & Data guard on AWS.
• Worked on databases on VMWare.
• Moved Oracle Databases between two Confidential -UX Servers using the Cold Backup.
• Created and configured Oracle Enterprise Manager Grid Control Repository Database.
• Monitoring Oracle Databases and SQL Server Databases using Oracle Enterprise Manager and SQL
• Experienced with SRVCTL, OCR and Voting Disk of 11g RAC.
• Strong physical and logical Data Guard skills.
• Handled RAC Node hangs and node eviction issues.
• Build, install 12c on AWS RDS
• Maintaining schemas and partitioning tables.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Configure and manage tablespaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Worked on Space Management and Security.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.
• Back up of Archive Log files and monitoring space in that mount point.
• Responsible for taking full hot/cold and Differential database backup.
• Cloning and Refresh of Database using RMAN.
• Database health check using Statspack report, Tkprof, AWR
• Managing and Resolving end user request via HPSC ticketing tool
• Work on OEM issues, setup alerts thresholds.
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Implemented the Security using Oracle Database Vault.
• Worked on the RAC environment for the high availability managed by ASM.

Confidential, San Francisco, CA

Oracle Database Administrator

Responsibilities:

• Managing and creating Oracle database.
• Build and managed database on RAC and ASM
• Managed standby databases and resolved gaps.
• Worked on performance tuning of the queries, instance and databases.
• Installed and configured Oracle 12c, 11g on Linux for Production, Development and Testing.
• Installed, configured and tested oracle 11g and 11g RAC environment and trouble shooting.
• Implemented Migration of Databases from 11g to 11g and applying patches whenever required.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy-included development of daily, weekly and monthly strategy incorporating incremental backups.
• Monitoring & Managing the Tablespaces and datafiles growth
• Database designing, Database administration.
• Defining backup & recovery plan, Database tuning.
• Refresh and Cloning of Database.
• Experience in Database migration from 9i to 11g,11g on Production/Development databases
• Enabling SSO services, Wallet manager, Oracle text installation
• Expertise on database backup/recovery solutions.
• Removing table fragmentation.
• Dataguard implementation and maintenance for Disaster Recovery.
• Alert Log Checking (Monitoring) and User Trace File and Archive log maintenance.
• Creating users, granting roles, Creating and Maintaining snapshot.
• Database Export and Import Utilities.
• Monitoring locks and various sessions.
• Managing OEM.
• Performing Day-to-Day DBA tasks - performance tuning, database design, system security, database installation configuration, patching, technical database support in 24X7 environment.
• Responsible for quarterly patches, /maintaining/Monitoring/Upgrading the Production/Dev/Test and training databases for products.
• Setup/configured oracle RMAN for database backup and recovery. Application of different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & OS scripts like shell & cron job schedule.
• Installation of oracle database and clients on UNIX and windows (Silent installation, GUI installation.
• Restore and Recover of database from offline, online and RMAN backup.
• Maintaining 1300+ Database instances running on Linux in VERITAS cluster environments.
• Retrieval of backup from TSM (Tivoli Storage Management).
• OEM Monitoring (health, status, alerts, agents etc., Configuration of databases in different groups, Instances, agents, Listener, Setting/Removing Blackout)
• Managing Agent using OEM and manually (upload Matrix, Resynchronization etc.)
• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 9i, 11g and 11g clients/databases on Solaris and Linux.
• Complete Build of 2-node 11g RAC Cluster on RHEL 4 from scratch.
• Migrated 11g database to 11g R2.
• Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
• Used Performance tuning tools such as tkprof, explain plans, oradebug and trace files to tune SQL Queries.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Migration of Databases and applying patches whenever required.
• Developed 10 PL/SQL Packages from the scratch for monitoring purpose.
• Experienced with SRVCTL, OCR and Voting Disk of 11g RAC
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Implemented the Security using Oracle Database Vault
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Space Management and Security.