SUMMARY:

• Over 6 years of professional experience as Oracle Database Administrator having good experience in Database administration, Database Installation in different platforms include Linux, Windows, Unix up - gradation, Migration, installing patches, Performance Tuning, RAC Installation and Maintenance, setting up and configuring Dataguard, performing all kinds of Backups and Recoveries, Cloning Databases, replications using Golden Gate and Auditing in Development and Production Environment.
• Having good experience in 12C Database administration and Installed 12C database on RHEL on Test Servers and configured 12C Grid Control on OEL 6.3.
• Having experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g.
• Experience in Working with Oracle on Exadata related Issues/Investigations & Troubleshooting Exadata.
• Knowledge in handling Distributed database and replication environment issues with Mviews, Streams, Goldengate and Advanced Replication.
• Experiences in Installation /Configuration /Performance Tuning /Troubleshooting Oracle GoldenGate (OGG) in Oracle to Oracle Homogeneous environments and Heterogeneous environments (MS SQL Server to Oracle & DB2 to Oracle).
• Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates..
• Team player with excellent interpersonal, analytical and communications skills
• Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
• Strong knowledge in Oracle database definition, structure, documentation, long range requirements, operational guidelines and protection strategies.
• Installed, Configured and Replicated databases using Oracle Goldengate.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports
• Configured Targets and used OEM to do the daily tasks regarding the performance, maintenance.
• Experience in Goldengate software security alert compliance standards and maintaining up to the standards.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE, 11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Expertise in using oracle Export/import, Datapump utility to migrate data across schemas.
• Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases.
• Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.
• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 11g features Data pump, AWR, ASM, ADDM, Grid Monitoring, and Oracle
• Enterprise Manager. Installation, administration and maintenance of Oracle 11g
• Installed patches using Opatch utility and upgraded databases from 9i/10g to 11gr2 and expertise in applying Oracle PSU and CPU patches.
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.
• Experience in provisioning with different scripting languages like Python, Bash, Shell
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
• Strong experience in configuration of RMAN, Planning and scheduling Backups using CRONTAB.
• Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.
• Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby database (Data Guard), Materialized views, VCS, Streams Replication, Golden Gate.
• Experienced in Oracle Support processes for technical requests through Oracle and other Support.
• Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service Extensive experience in 7*24 production database support.
• Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.
• Design, development, and testing of backup and recovery to ensure complete recoverability.
• Solid experience in disaster recovery, routine maintenance for Oracle databases.
• Security management for database, network, and operating systems.
• SQL Net installation/configuration/troubleshooting (Server and Client side

TECHNICAL SKILLS:

OPERATING SYSTEM: Red Hat Linux RHEL 5.x and Windows XP

RDBMS: Oracle 12c/11g/10g

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, SQL Navigator, TOAD, Data Pump (expdp, impdp),SRVCTL,SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Providence, RI

Oracle DBA

Responsibilities:

• Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
• Install setup and configured Oracle Enterprise Manager Cloud Control 12c as a tool of administration, performance tuning, monitoring, alerts and also OEM Grid Control 11g/12c. expdp/impdp errors in a RAC environment, configuring storage accordingly.
• Troubleshooting errors using Clusterware logs and patching 11g and 12c RAC environments
• Involved in upgradation of databases from 11.2.0.4 to 12C in QA and DEV environments.
• Implemented ASM on RAC and standalone databases and managing disks and disk groups.
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Creating physical databases with multiple table spaces from logical and physical data model
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Experience in handling Multi-Terabyte Database migrations/Consolidations with minimum/no downtime.
• Proven Experience in implementing high Availability using Oracle RAC & Veritas Cluster server (VCS).
• Proven experience in troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).
• Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
• Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
• Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. Responsible for maintaining the Database environments under SOX compliance and attend the SOX audit once in a year with all the evidences
• Apply the oracle security patches (CPU patch / PSU patch) on standalone database, Oracle RAC and clusterware (oracle 11g - Grid Infrastructure)
• Providing Level 3 operational support for the database tower
• Keeping the databases up to date with respect to Latest PSU's and comfortable in applying patches.
• Setting up ACFS mount for GG replication for multi node RAC clusters
• Automating tasks using cron for Goldengate restart.
• Implemented data transfer using Data Pumps and Export/Import utilities
• Responsible to monitor database performance using AWR, ASH and ADDM using Oracle Enterprise Manager Database and Grid Control 11g/12c, generated reports as needed.
• Performance tuning via AWR and Statspack. Fine tune Transaction intensive servers i.e. OLTP situations (I/O bottlenecks, SGA, pinning objects, Sort space, Redo logs) using explain plan, tkprof and identifying the execution plan and tune queries, using Indexes, hints etc. Exporting dictionary statistics from production to stage for tuning.
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
• Monitoring and troubleshooting database issues with OEM grid control.
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
• Resolving RAC specific issues such as node evictions
• Performed proactive and reactive tuning/managing database space utilization and growth
• Implementing Oracle ASM and resolving ASM related issues
• Detailed analysis of the business and users requirements by doing various information gathering techniques.
• Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)
• Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc…
• Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.
• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Supporting Multi node 11g RAC / 12C RAC and Data Guard environment for HA.

Environment: Oracle 10g, 11g, 12C, Unix shell script, Grid Control, Data Guard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR and Statspack Reports, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN, Crontab, Tivoli Storage Management for DB tape backups, BMC Patrol for DB monitoring.

Oracle DBA

Responsibilities:

• Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.
• Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on multiple platforms.
• Performed up-gradation of 10g to 11g.
• Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
• Automated routine DBA tasks like backup's and stats by using Grid control job's
• Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.
• Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
• Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration
• Adding and removing nodes to existing Oracle database RAC configurations
• Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
• Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
• Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
• Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.
• Performed activities like monitoring the database and provide maximum uptime.
• Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.,.

Environment: RHEL 4.4, HP-UX, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2, Autosys, Golden Gate, SQL*Plus, PL/SQL, SQL*Loader