SUMMARY:

• I have over 5 years’ of hands - on experience as an Oracle Database Administrator. I have worked in complete system development life cycle (SDLC). I have also configured and supported Oracle High Availability Solutions like Dataguard, RAC and Oracle Golden Gate. I am a proactive DBA who pay great attention to details. I am a good team player with excellent documentation skills. I have supported Oracle Databases of versions 10g, 11g and 12c running on Solaris, UNIX, LINUX and Windows platforms.­
• Experienced with all facets of Oracle DBA day-to-day activities in both production and development environments. Some duties include Database Monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
• Experienced 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), Patch sets as per the Oracle recommendations.
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues. Setup the unidirectional replication on oracle 11g databases using Goldengate.
• Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.
• Successfully upgraded the databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
• Experience as 24x7 productions DBA as well the application (development) database administrator.
• Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure 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.
• Tuning of RAC environment. Managing fail-over of instances. Configure table for parallel load.
• Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 11g features like RMAN, Data pump Flash-Back Recovery and ASM.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Datapump Export/Import (Oracle 11g, 12c).
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance monitoring/tuning/troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, SQL TRACE. Applying patches under LUNIX platform.
• Experience in database patching, cloning, upgrade, migration & maintaining standby db server (DR).
• Experience with database backup, recovery, and setting up disaster recovery Database servers.
• Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems.

PROFESSIONAL EXPERIENCE:

­­­

Confidential - New York, NY

Oracle Database Administrator

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Installation of 12c OEM and customize it to our needs.
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Migrate Database across different servers and platforms using Transportable Tablespaces (TTS) and Data Pump Export/Import and perform database Refresh and RMAN Cloning.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database / Data Guard and performed data Replication using Golden Gate Technology.
• Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace and TKPROF for best performance.
• Manage alerts, notification, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support.
• Installed OEM 10g grid agent on servers and configured to OEM 10g Grid Control.
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Alert management, Created and setup alerts to send notification to Users from application wherever necessary.
• Perform day to day activities like backup-restore, space management, monitoring database alerts, performance tuning.
• Proficient in troubleshooting Node Eviction in Oracle RAC Environment
• Applied PSU and CPU patches and other database related patches.
• Have a good experience in administering Oracle Clusterware components.
• Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as TKprof, Explain plan and SQL*Trace. Efficiently performed installation, setup and creation of two node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Confidential - Cincinnati, OH

Oracle DBA

• Installed, configured, and maintained Oracle 11g on Linux also Upgraded from Oracle 11g to 12c.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Responsible for all database activities such as User management, space management, database security management.
• Implemented the resizing the online redo logs in production and in standby database.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Implemented data guard for the critical production databases and tested switchover and failover. Logical standby databases for the real time DML apply in the remote databases. Disaster recovery plan for the production to standby database to check the data consistency.
• Maintain databases build database backup and recovery routines (RMAN), monitor database activities and conducting performance monitoring. Clone Development, test and UAT databases using RMAN.
• Handling multi-terabyte databases and the capacity planning for the data and application growth and recommend partitioning strategies for very large tables.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Collecting performance statistics using AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers
• Experienced of managing and administering 24 X 7 running databases and support
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like
• EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
• Performance tuning of Queries by maintaining partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
• Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.