SUMMARY:

• Over 10+ years of extensive experience as an Oracle DBA in IT with full System Analysis & Design, Software Development Implementation and Maintenance in Client/Server architecture, RMAN, TOAD, RAC, ASM, Data Guard, CRS, Active/Passive, Cloning, Statspack, AWR, Grid Control, OEM, Performance Tuning, Migration, OLAP/OLTP, Veritas, Informatica Power Center, Linux, UNIX, Sun Solaris, AIX, HP - UX, Oracle 6.x/7.x/8i/9i/10g/11g/12c.
• 10+ years of experience with Oracle 12c/11g/10g/9i/8i/7.3 Installation on Linux, Sun Solaris, IBM AIX, HP-UX and Windows NT/2000/2003, Administration, Monitoring, Performance Tuning, Database Backup and Recovery for Standalone, Active/Passive and RAC clusters.
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM).
• Laid hands on new tools and experienced features like Schema Management, Data guard and RMAN in Oracle 11g.
• Experienced in using 11g features Data Pump, AWR, ASM, ADDM, Grid Monitoring and Recycle Bin.
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, Cloning, Capacity Planning, script development and documentation.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery, Patching, upgrading and administering Terabyte of Oracle Databases on Oracle 11g/10g/9i/8i.
• Implementation of 10g/11g Standalone, Active/Passive and RAC followed by ASM
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Experienced in Tuning: Used Explain plan and TKPROF for SQL/PLSQL Tuning; Used STATSPACK Performance tuning i.e. tuning SGA, I/O distribution using STATSPACK, AWR and OEM 10g/11g/12c.
• Used Cron jobs to automate many DBA tasks
• Extensively used advanced queuing to process the on line jobs.
• Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.
• Schedule Meetings with Offshore DBA and guide them to work.
• Experience in utilities ADDM,, AWR
• Extensive experience on OEM,TOAD (Tools for Oracle Application Developers), SQL*Plus and SQL*Loader as well as traditional UNIX command that requires for Oracle DBA
• Configured and Maintained Physical Data Guard for High Availability and offline reporting.
• Participates in 7x24 on-call rotation, off-hour production problem resolution activities
• Designing and Building Relational Databases architecture in OLTP, OLAP, DW client/server.
• Experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM
• Engineering of the existing databases and provide both a Physical and Logical/Physical data model to maintain an existing Database.

TECHNICAL SKILLS:

Operating Systems: RHEL 3, RHEL 4, RHEL 5, RHEL 6, Sun Solaris 5.10, Sun Solaris 5.9, HP-UX 11i v1.5, AIX 4.3, AIX 5.3, Windows 2003, Windows 2000/NT, Windows XP

Databases: Oracle 12c, 11g, 10g, 9i, 8i, 7i

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch, TK Prof, Statspack, AWR.OS Watcher

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD 8.5, VNC Viewer, SQL Developer, Putty, SQL*PLUS, FTP, ERWIN 4.14, ERWIN, LogMiner and Flashback data Archive

Languages: SQL, PL/SQL for Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Sr. Oracle DBA

• Provide DBA support of 500+ databases Oracle versions 9i/10g/11g/12c hosted on Solaris, Linux and Windows operating systems, support for Standalone, Active/Passive, RAC (Real Application Clusters) on Linux, Solaris and support for Data Guard in a Logical standby configuration on Linux.
• Installed and configured Grid Control to monitor RAC and Non RAC instances, patched and upgraded the Grid Control to 11.2.0.4
• Involved in Database Administration Activities in a 24/7 Mission Critical Applications like of Transaction Processing, Batch Processing, and Clients Credits Reporting Details and Covers the Risk Management feature.
• Installation and creation of 11g and 10g Standalone, Active/Passive and RAC databases for Testing, Development and Production
• Creating and follow-up with oracle on Service Requests created regarding day to day issues.
• Lead Several Tuning Efforts, SQL Tuning, Instance Tuning and Monitoring Wait Events using (Statspack, TKPROF, AWR, ADDM, OEM 10G, EM11G, EM12C)
• Data Refresh from Production to Test and Development environments using RMAN Duplication, Datapump and regular export/import.
• Created (Dataguard) physical standby database as DR Solution for production database using RMAN, also setup Data Guard Broker to manage data guard environment.
• Recover/Cloned the database from ASM to ASM, ASM to File system,file System to ASM using RMAN duplicate command.
• Install and configure two node RAC 11gR2 (11.2.0.3) on Oracle Database Appliance (ODA) Release 2.2 for Linux x86-64.
• Migration/upgrade from Oracle 9i/10g to 11g and troubleshooting post upgrade issues and validations.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, OEM
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Performed SAN requirement analysis and configuration for the new RAC databases (Linux RHEL) to be built on IBM blade servers, Design and configure SAN, raw partition for OCR, Voting Disk, Oracle Home, ASM HOME and CRS HOME
• Taking periodic Backup of the Database and the software using RMAN and Grid Control.
• Migration of Database from Sun Solaris to RHEL 5 and applying patches whenever required.
• Experience in oracle features Flashback version query, Rollback Monitoring, Tablespace Management, Oracle Datapump, Flashback Table, RMAN and Auditing
• Good knowledge on ITIL processes - Change Management, Configuration Management, Incident & Problem Management using IBM ManageNow, HP service center etc.
• Scheduling jobs using Oracle Job Scheduler
• Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Installation and configuration of Oracle Client software and Tools
• Monitoring and Optimizing database performance
• Created scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration
• SQL scripts to monitor Tablespaces and extent growth

Environment: Oracle11g/10g/9i,Grid Control 10g/11g/12c,RedHat Linux, Solaris, DataGuard, RAC, ASM, CRS, TKPROF

Confidential, Bloomfield, CT

Sr. Oracle DBA

• Provide DBA support of 500+ databases Oracle versions 9i/10g/11g/12c hosted on Solaris, Linux and Windows operating systems, support for Standalone, Active/Passive, RAC (Real Application Clusters) on Linux, Solaris and support for Data Guard in a Logical standby configuration on Linux.
• Installed and configured Grid Control to monitor RAC and Non RAC instances, patched and upgraded the Grid Control to 11.2.0.4
• Involved in Database Administration Activities in a 24/7 Mission Critical Applications like of Transaction Processing, Batch Processing, and Clients Credits Reporting Details and Covers the Risk Management feature.
• Installation and creation of 11g and 10g Standalone, Active/Passive and RAC databases for Testing, Development and Production
• Creating and follow-up with oracle on Service Requests created regarding day to day issues.
• Lead Several Tuning Efforts, SQL Tuning, Instance Tuning and Monitoring Wait Events using (Statspack, TKPROF, AWR, ADDM, OEM 10G, EM11G, EM12C)
• Data Refresh from Production to Test and Development environments using RMAN Duplication, Datapump and regular export/import.
• Created (Dataguard) physical standby database as DR Solution for production database using RMAN, also setup Data Guard Broker to manage data guard environment.
• Recover/Cloned the database from ASM to ASM, ASM to File system,file System to ASM using RMAN duplicate command.
• Install and configure two node RAC 11gR2 (11.2.0.3) on Oracle Database Appliance (ODA) Release 2.2 for Linux x86-64.
• Migration/upgrade from Oracle 9i/10g to 11g and troubleshooting post upgrade issues and validations.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, OEM
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Performed SAN requirement analysis and configuration for the new RAC databases (Linux RHEL) to be built on IBM blade servers, Design and configure SAN, raw partition for OCR, Voting Disk, Oracle Home, ASM HOME and CRS HOME
• Taking periodic Backup of the Database and the software using RMAN and Grid Control.
• Migration of Database from Sun Solaris to RHEL 5 and applying patches whenever required.
• Experience in oracle features Flashback version query, Rollback Monitoring, Tablespace Management, Oracle Datapump, Flashback Table, RMAN and Auditing
• Good knowledge on ITIL processes - Change Management, Configuration Management, Incident & Problem Management using IBM ManageNow, HP service center etc.
• Scheduling jobs using Oracle Job Scheduler
• Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Installation and configuration of Oracle Client software and Tools
• Monitoring and Optimizing database performance
• Created scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration
• SQL scripts to monitor Tablespaces and extent growth

Environment: Oracle11g/10g/9i,Grid Control 10g/11g/12c,RedHat Linux, Solaris, DataGuard, RAC, ASM, CRS, TKPROF

Confidential, Pittsburgh, PA

Sr. ORACLE DBA

• Handling & Administrating Oracle Production, Development and Staging Databases ranging from 50 Gigs to 8 TB in size for various OS Platforms including Linux, Solaris and AIX for standalone and clustered databases.
• Ensuring continuous 24x7 Availability, Reliability and Optimal Performance of Production Databases using DataGuard, RAC, RMAN etc.
• Developing Backup Strategy Includes Documentations of Backup and Recovery Processes, Ensuring Successful Periodical Database Backups, Restoration and Testing Backups
• Proactively identify, diagnose and resolve database issues in Production, Development environments related to SQL, server, performance, locking, bugs, storage, networking, backups and communicate with other teams, clients or agencies in the resolution of these issues.
• Expertise on OEM10g, OEM11g, OEM12c installation, configuration and monitoring.
• Experience in Installation and Involved in Implementing RAC Database with 2 and 4 nodes.
• Write documentation for the DBA group detailing procedures, architecture diagrams and solutions to problems.
• Applying Oracle Patches Updates (CPU, PSU) and one-off patches on PROD, QA and DEV Databases, Upgradation and Migration of Database from 9i to 10g, 10g to 11g and applying patches when required.
• Experiences in Wait Interface, Materialized Views, ASM, ADDM and SQL Tuning
• ASM Management using RAC utilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTL
• Partitioned large tables to increase the performance
• Implementing Range, List Partitions, Hash Sub Partitions
• Creating and refreshing materialized views
• Performed SQL tuning and assisted developers with coding PL/SQL
• Performance tuning of Oracle Database Objects by fixing row chaining
• Implement change and test plans prior to commencing changes, installs or upgrades and verify in a test environment prior to implementing in production.
• Implemented Backup & Recovery procedures using RMAN, Hot/Cold Backups
• Continuous monitoring of the Database through Grid Control and troubleshooting the issues, if any
• Responsible for setting and managing user accounts, Granting required privileges to users
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE and OEM.
• Performing the daily Maintenance tasks and interacting with Oracle Customer service when required

Environment: Oracle11g/10g/9i, RedHat Linux, OLTP/DW, RMAN, SQL Tuning, Oracle and OS Patching

Confidential, MIDDLETOWN, NJ

Sr. Oracle DBA

• Experience with configuration, installation, and administration of Oracle 10g, RAC, Enterprise Manager, Diagnostic Pack and Tuning pack.
• Plan, Implemented and documented the RMAN backup strategy for new and Existing RAC and Non RAC databases by configuring channels, allocating space for Backupsets, Implementing retention policy for backupsets, clean the archive log after backup and write the shell script to automate the backup process by scheduling in crontab.
• Experience in Set up Test environments using snapshots standbys
• Experienced in Read only Tables, Invisible Indexes, Online Indexes Rebuilds and Real Time SQL Monitoring
• Configured ASM disk groups to store Datafiles, redolog files, and control files.
• Worked on SQL Performance Analyzer, SQL Plan management and SQL Access Advisor
• Working experience with Oracle Advanced Security (ASO/TDE) Option and database encryption.
• Experience installing Oracle database components and tools.
• Experience with RMAN backup and recovery setup, tuning, and execution.
• Experience in Enterprise Manager 10g, Virtual Private Database, Transportable tablespaces and scheduler.
• Database streams and data guard (physical and logical)
• Database Creation, DB Refresh, create control file, etc
• Fully utilizes CASE tools to develop, or modify, physical database designs from logical designs, using the logical design, discussion with the Data Analyst, application development reviews.
• Managed Database security and Auditing.
• Performed the Oracle DDL, DML operation.
• Implemented Real Application Clusters (RAC) setup, configuration and cluster interconnection of 5 instances with server side load balancing using Automatic Storage Management (ASM) .

Environment: Oracle10g/9i, Red Hat Linux 4.x, IBM AIX, RAC, DATGUARD

Confidential, Chicago, IL

Sr. Oracle DBA

• Analyzing slow-running SQL queries and generating statistics using the Execution Plan and recommending solutions for faster execution.
• Maintenance of Advanced Queues enque and dequeue operations.
• Responsible for administering and supporting production and development Oracle 9i Databases.
• Responsible for setting and managinguser accounts, Granting required privileges to users.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Installed HACMP on AIX 5.3 box with more than 8 nodes to share data among multiple computers.
• Applied patches, keeping applications software bug free and improving data integrity.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Using DBArtisan, TOAD, and Rapid-SQL for database administration tasks.
• Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• Applied High priority, security patches downloaded from Metalink.
• Configured scripts to monitor activity with database.
• Cloned Environments to create Patch Test, Development and QA Environments
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Environment: ORACLE 9i, 10g, LINUX, SUN SOLARIS 9, IBM AIX, TOAD

Confidential

Database Administrator

• Scripts for Cold Backups, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Experience in managing systems, Operations, and Technical Support to develop and improve databases and Master files. .
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Knowledge of Data transfer between SQL Server and Oracle.
• Hands on experience in Hot/Cold Backups, and Cloning of Databases
• Monitoring the Database storage and Day to Day activities.
• Database Creation, DB Refresh, create control file, etc.
• Proactive database monitoring using automated scripts based on v$views.
• Developer Environments setup using database cloning and refresh procedures.

Environment: Oracle 9i/8i, Red Hat Linux 4.x, IBM AIX, MIGRATION, SQL, PL/SQL