SUMMARY

• Hands on experience on various platforms like OEL4/5/6, RHEL Linux 4/5/6/7, AIX, Solaris, Ubuntu and Windows environments.
• Experience on different variants of Oracle databases such as 9i, 10g, 11g, and 12c.
• Excellent experience in trouble shooting and fixing performance issues at session and system level using various reports like Explain plan, TKPROF, AWR and ADDM reports.
• Excellent experience in improving database performance by SQL tunings, SQL profiles and Baselines.
• Experienced in configuring and Installation of multiple node 11g and 12c Real Application Clusters (RAC).
• Migrated NON - ASM databases to ASM using RMAN
• Expertise in installation, configuration, and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager Cloud Control (OEM 12c and 13c), Toad, Oracle SQL Developer.
• Experience in implementing cross platform Migration such as IBM AIX, Solaris and Windows to Linux.
• Good experience on Upgrades and Patches in various stand alone and RAC environments.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using Recovery Manager (RMAN).
• Configured 11gRAC on ODA Oracle Database Appliance
• Excellent experience in installing and supporting oracle 12C multitenant databases and converted several regular 12c databases to Multitenant.
• Good working knowledge in implementing EXADATA features like HCC, Flash cache and SMART SCAN features.
• Provided and implemented performance tuning recommendations of all components in the Exadata machines.
• Performed Oracle upgrades with custom build Ansible playbooks and conf deployments by using Ansible in multi-site cluster environment.
• Performed the automation using CHEF configuration management and managing the Infrastructure environment with Puppet.
• Defined the automation strategy of Database releases and maintenances on Oracle/Cassandra/Sybase which reduced the overall release time and man power.
• Supported in analysis and designing of Oracle Exadata Server for infrastructure and related projects, Integration of Exadata monitoring into our existing IT monitoring framework.
• Implemented Standby Databases with the help of Data Guard for High Availability, Data Protection, and Disaster Recovery for enterprise data.
• Experience on Fast Start Failover (FSFO) implementation of Data Guard as per the end user requirement.
• Configured Data Guard for more then 50+ databases with Data Guard Broker and FSFO
• Pioneer in Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Experience in replication of schemas using Golden Gate schema replication which includes online change synchronization and DDL synchronization.
• Golden Gate 11g and 12c installations and maintenance of unidirectional replication.
• Experience in using PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance.
• Good experience with Oracle enterprise manager (OEM), and utilities like AWR, ADDM, Flashback Technology, SQL tuning advisor.
• Expertise in configuration and maintenance of table partitions in oracle 11g and 12c.
• Performance Tuning experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE.
• Experience in proprietary change management processes to prevent Production Disruptions and Outages.
• Cloning and Refreshing databases from Production to Test and Development and from Development to Production.
• Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good communication and coordination with different departments for efficient problem escalation and deciding on optimal solution.
• Experience on performance optimization in private cloud models (IaaS/PaaS) with enterprise standards, workflows and industry best practices using VMware products.
• Rendered performance tuning to VMware servers, Virtual sessions and management of server resources between virtual machines.
• Strong MySQL skills with significant general system administration skills on UNIX/IBM AIX, Linux and Windows environment, Knowledge in general System Administration tasks.
• 24*7 production database support to developers & end-users.

TECHNICAL SKILLS

Operating Systems: RedHat Enterprise Linux, Sun Solaris, IBM AIX, Microsoft Windows Server, Oracle Enterprise Linux.

RDBMS: Oracle 12c, 11g, 10g, 9i and 8i, MySQL 5.1, 5.6, 5.7

Database Management tools: Oracle Enterprise Manager Cloud Control (OEM), Oracle Enterprise Manager Grid Control (OEM), TOAD, TIVOLI and ERWIN.

Tools: and Utilities: RMAN, SQL Navigator, SQL*Loader, SQL Developer, ASMCMD, DataGuard Manager Utility(DGMGRL), Server Control Utility (SRVCTL), Traditional Data pump, EXPDP/IMPDP DataPump, Data Guard, VERITAS Net Backup, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Splunk, Putty, Oracle Data Integrator(ODI), and Oracle SQL Developer, Ansible and puppet.

Languages: SQL, PL/SQL, Perl, Bash, Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Advisor

Responsibilities:

• Involved in 24x7 on-call support for enterprise production databases .
• Installation and Configuration of 4 node RAC using oracle clusterware and ASM storage, Configured A CFS file system and administer ed ASM Instances and Disk Groups in RAC .
• Resolved several RAC related outages caused due to node evictions and resolved many performance issues in Oracle 12c RAC databases.
• Provided support and recommendations for components in Exadata X6 machines and Implement performance tuning for all components in the Exadata machines.
• Actively participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Monitored IT framework on machines integrated with Exadata.
• Experience in cloning of databases using RMAN.
• Migrated over 200+ databases across data centers using various methodologies like DATAPUMP, Log shipping and RMAN XTTS.
• Configured RMAN backups (Full, incremental and cumulative) and performed recovery, incomplete recovery and disaster recovery.
• Oracle Instances deployments by using Ansible in multi-tenant installations
• Install and Configured Disk and file system management using LVM Partitions and ASM Diskgroups.
• Worked on configuring Oracle 11g two node RAC database on ODA Oracle Database Appliance.
• Install, configure and upgrade databases to Oracle 12c, consolidate multiple databases into multi-tenant database containers, evaluate and implement latest database technology and new Oracle12c features.
• Installed Oracle 12c (cloud) and migrated all the databases from Oracle 11g to Oracle 12c.
• Performed RAC all node patching and Rolling patching.
• Implemented Backup, Recovery procedures and Hot, Cold and Logical backup plans.
• Installed and upgraded Golden Gate to version 12c.
• Successfully implemented Unidirectional Golden Gate replication for Oracle 12c databases on 2 node RAC Clusters.
• Identified and fixed Golden Gate Replication issues using GGSEVT and log dump utilities.
• Performed database migrations from AIX Solaris to Linux using Oracle Golden gate and data guard
• Installation and configuration of Golden gate for replication and resolved issues to sync Databases.
• Implemented Golden Gate replication during database migration from AIX to Linux server.
• Installed, configured and supported Golden gate (11g) replication solutions to facilitate data flow between environments.
• Developed custom utilities to automate manually intensive tasks including mass schema changes, recovering Golden Gate corruptions.
• Implemented, configured and maintained data guard for oracle 11g (primary and standby databases) to ensure disaster recovery, high availability and data protection
• Extensively worked in various areas of data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Installed OEM 13C and configured agents on all our monitored database servers.
• Configured and setup of monitoring alerts and BI publisher reports in OEM 12c and 13C.
• Implemented the resizing of online redo logs in production and standby databases
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Expertise in the creation of databases, tablespaces, tables, indexes and other database objects.
• Installed and configured relevant network components to ensure database access as well as database consistency and integrity.
• Experience in troubleshooting and resolving various Oracle connectivity problems.
• Extensively used DATAPUMP and Export / Import utilities for logical backups.
• Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
• Performed various performance goal oriented database tuning using Explain plan , AWR , ADDM and various Oracle Advisors to tune the database.
• Tuned various slow running queries to improve performance and decrease data fragmentation.
• Performed instance tuning, memory tuning query tuning and complete database tuning.
• Created and implemented various table partitions for large tables.
• Applied quarterly PSU patches to different versions of databases.
• Upgraded Oracle 10g database to 11g and 11g to 12c, Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set.

Environment: Oracle 12.2.0.1, 11.2.0.4, Oracle Exadata, IBM AIX 6.3,7.1, Red Hat Linux 6.0, PL/SQL, SQL*PLUS, ORACLE ENTERPRISE MANAGER 12c/13c Cloud Control, Oracle 11g Grid Control, Oracle RAC, Data Guard, Toad 12/12.5, Server control utility(SRVCTL), ASM Command line (ASMCMD), DataGuard Manager Utility(DGMGRL), MySQL 5.5, 5.6.

Confidential

Sr. Oracle Database Admin

Responsibilities:

• Installed, maintained new Oracle 9i and 8i instances. Upgraded several Oracle 10g instances from Oracle 9i , Connectivity with different client programs using ODBC .
• Maintained backups for recovery using RMAN in tapes and disks.
• Planning and implementing Backup strategy for the databases using RMAN , Scripting backups, once in two weeks on the application database.
• Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.
• Migration from SQL Backtrack to RMAN as backup utility.
• Periodically fine-tuned and optimized the database performance for data integrity and maintained the databases for the day-to-day DBA activities.
• Redesigned the database backup/recovery scripts to log errors, and to be consistent/ robust.
• Modified and maintained database structures and views for the core system.
• Performed work related to importing and exporting data using IMP and EXP tools in Oracle, file structures.
• Setting up client/server Architecture and distributed processing.
• Reduced DBA off-hours support needs by 60% through planning and proactive monitoring.
• Implemented automated backup strategy using the UNIX shell script and CRON Utility.
• Wrote Shell scripts to automate DBA tasks such as monitoring tablespaces , health on daily basis.
• Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i .
• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Creating users and database links, snapshots on production and development servers.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.

Environment: Oracle 11.2.0.1/11.2.0.3 , Red Hat Linux 4/5, PL/SQL, SQL*PLUS, SQL* loader, Data Guard, Server control utility (SRVCTL), DataGuard Manager Utility (DGMGRL), Toad, AWR, ADDM, Recovery Manager (RMAN).

Confidential

Sr. Oracle Database Engineer

Responsibilities:

• Worked as Support Database Administrator Responsibilities include Creation & Maintenance of Table Spaces, Data Files.
• Upgraded database from Oracle 9.2.0.8 to 10.2.0.1 using database upgrade utility (DBUA).
• Loading data from flat files into database tables using SQL* loader.
• Creating and maintaining triggers, packages, functions and procedures.
• Created users and established the application security by creating roles.
• Used Indexes and Hints to enhance the performance with the help of Explain plan.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader.
• Used TOAD for faster application design and developments.
• Implemented Hot, Cold and Logical backup plans using RMAN and Data pump tool.
• Creating tables, indexes, views and synonyms depending upon the need.
• Involved in Designing backup and recovery strategy for OLTP systems.
• Strong and extensive use of DDL and DML tools/ Maintained database schemas and dictionaries.
• Modified spfile parameters like DB block size, block buffers, shared pool.
• Used NETMGR and NETCA for the creation of Listeners.
• Involved in Query tuning of SQL Queries.

Environment: Oracle 9.2.0.8, 10.2.0.1, 10.2.0.5, Red Hat Linux 5/5.5, PL/SQL, SQL*PLUS, SQL* loader, ORACLE ENTERPRISE MANAGER 10g Grid Control, Data Guard, Toad, AWR, ADDM, Recovery Manager (RMAN).