SUMMARY

• Oracle IT professional with over 9+ years of experience as an Oracle database administration for Oracle 12c/11g/10g/9i within very large scale database environment(OLAP) and mission critical large OLTP systems.
• Configured, managed/maintained and tested Development, Testing, Staging, and Production Environments on RHEL, IBM - AIX, SUN SOLARIS, HP-UX and Windows platforms. Configured, Standby databases/ Data guard for OLTP, Decision Support Systems (DSS) Data Warehouse environments in oracle 11g/10g/9i/8i. Installed, configured and maintained ASM enabled 10g/11g RAC and single instance databases.
• Expertise installing, configuring and maintaining Oracle high availability solutions like Real Application Cluster (RAC) on Oracle 10g & 11g both on Windows and Linux platforms.
• Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Experienced performing manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
• Experienced in Data conversion and Migration and Upgrade of Oracle 8i to 9i, and Oracle 10g to 11g.
• Experienced setting up Data guard for Disaster recovery on Oracle 10g & 11g Production databases.
• Experience in Upgrading databases. (10gR2 to 11g, 10gR1 to 10gR2, 9i to 10gR1).
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control.
• Experince in Installing and Configuring database alerts in 12c OEM.
• Strong knowledge and experience of managing Oracle 10g and 11g RAC environments using the OEM Grid Control tools
• Experienced in Database Performance Troubleshoot using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Proficient Installing, Configuring, Tuning and Maintaining Oracle 8i/9i/10g under Windows 32/64 bit, Sun Solaris, HP, Unix, IBM AIX and Red Hat Linux platforms.
• Experience with the latest Oracle technologies like 9i/10g RAC, CRS, AWR, ADDM, Temporary Table space groups, and Flashback technologies, Data Pump, SQL Tuning Advisor, SQL Access Advisor, Undo Advisor and Segment Advisor.
• Experience in installation and configuration of GoldenGate11g to support data replication in Oracle Database environment.
• Experience in Managing/working/converting oracle GoldenGate databases.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems
• Experienced in utilizing Goldengate replication technology for ORACLE Upgrades
• Expertise in using GoldenGate to support data replication in the Oracle database environment
• Proficient with Tuning, SGA, Buffer Cache, Rollback Segments, and Redo Mechanisms.
• Monitored and Detected Alert Log Files, Listener Log, Redo Log status, trace files and Locks for the database.
• Experience working with SQL Server, T-SQL procedures and queries, SSIS, ETL, CLR C# procedures and functions, etc.
• Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering Terabyte of Oracle Databases on Oracle 11g/10g/9i.
• Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools
• Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Expertise in Replication of Oracle Database using Logical Standby, Streams and Shareplex
• Expertise in database and Application performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK, SQL Tuning and SQL writing.
• Automated database periodic maintenance and activities using Korn, Perl Shell Scripts.
• Used Repository manager to build Repository, User groups, Users and managed users by setting up their privileges and profiles and Experienced managing Very Large Scale Databases (VLSD)
• Experienced in loading data from flat files into database tables using SQL*Loader and ETL Tools like Informatica, Dataflux, Data Stage
• Experience with the latest Oracle technologies like 9i/10g RAC, CRS, AWR, ADDM, Temporary Table space groups, and Flashback technologies, Data Pump, SQL Tuning Advisor, SQL Access Advisor, Undo Advisor and Segment Advisor.
• Extensive Experience writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Configured Oracle 10g&11g on different Operating Systems for OLTP & Data Warehousing environments.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g on various platforms as Windows Servers 2008/2003 and UNIX (HP-UX, Sun Solaris, IBM AIX) and Linux(RHEL,SUSE) Environments.

TECHNICAL SUMMARY

RDBMS: Oracle 11g/10g/9i/8i RAC, SQL Server 2008/2005

OS Platform: : Linux, UNIX (HP-UX 10.x, 11.x, Sun Solaris, IM AIX 5.x),Linux(RHEL 4.x,5.x and Windows NT/2000/2003/2008/2012

languages: SQL, PL/SQL, C,UNIX Shell Scripting.

Database Utilities/Tools: Putty,STSTSPACK,EXPLAIN,PLAN,TKPROF,ERWIN,Informatica,Dataflux,cognos,Microstratategy,Veritasbackup,Datastage,RMAN,Export/Import,OEM,SQL*Loader,AWR,ADDM,RAT,TOAD

High Availability: Oracle RAC (11g/10g),Dataguard ( Physical Standby),Clustering,ASM,SAN

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Sr. Oracle Database Administrator

Environment: AIX, RHEL RedHat Linux, Oracle 10G/11g RAC, ASM, Dataguard, Streams, RMAN Duplication, SQL, PL/SQL, UNIX Scripting, OEM Grid Control, Ignite, DBartisan, Toad, Sql Developer, Datapump, Putty.

Responsibilities:

• Installed, configured, upgraded, and applied patches and bug fixes for Prod, Test and Dev Servers.
• upgrade/migration of the oracle databases from Oracle 10g to Oracle 11g (10.2.0.1 to 11.2.0.3) on a different platform from AIX to RHEL (Oracle Enterprise Linux).
• Creation of new databases on QA/INT/REG servers.
• Installation of Oracle 11gR2 RAC with 2, 3 nodes on Linux and AIX
• Experience in installing Oracle patches and upgrading databases. (10g R2 to 11gR2, 10g R1 to 10gR2, 9i to 10gR1).
• Responsible for configuration of 10gRAC and 11gRAC on Linux and AIX using ASM and RAW devices and Oracle CRS
• Export/Import Datapump and Transportable tablespaces to migrate databases from one database to another.
• Performed pre and post installation tasks in migration starting from research on initialization Parameters for Datamart Database and Database Links, Synonyms, Views and Roles for Different Databases, which will be preferable to current environment.
• Data refresh/cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Statspack, ADDM, ASH reports, OEM Grid Control, Fine tuning of SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and table spaces to improve the performance.
• Administration and troubleshooting of RAC instance startups and instance evictions
• Implement and setup physical Standby database using Dataguard in oracle for disaster recovery.
• Administering ORACLE Databases 10g (10.2.0.4), 11g (11.2.0.3) with over 10 TB in size
• Experience in upgrading Dev and Test instances to 11g (11.2.0.3)
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Automated various tasks thru Crontab
• Develop centralized monitor database activities scripts such as space management, alert log, cleanup, RMAN Backup Jobs, Gather stats for Schemas, Tablespace monitoring, Disk monitoring, etc.
• Implemented partitioning on large tables, expertise in using in composite partitioning, local indexes, global indexes and indexes of hash partitions.
• Worked very closely with development team providing solutions on sql tuning and application design
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, and archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Redesigned table and index partitioning strategies HINTS to improve the query performance.
• Successfully implemented Backup and Recovery using RMAN, which includes hot backups and Cold backups to tape, drives, and disks.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Monitoring production and non-production database using Oracle Grid Control (OEM) 10g and 11g
• Monitor and analyze performance issues using Ignite 8 Config
• Monitor database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization.

Confidential, Salt Lake city, UT

Sr.Oracle Database Administrator

Environment: RHEL RedHat Linux, Sun Solaris, Oracle 12c/11g/10g, RAC, ASM, Dataguard, Streams, Golden gate, RMAN Duplication, SQL, PL/SQL, UNIX Scripting, OEM Grid Control, Ignite, TOAD, Sql Developer, Datapump, Putty.

Responsibilities:

• Experince in installation and configuration of GoldenGate11g to support data replication in Oracle Database environment
• Used GoldenGate to move large volumes of data between oracle servers with minimal impact to online systems and performing GoldenGate on process of extract and replication of single instance as well as RAC Databases
• Responsible for installing and configuring Golden Gate 9.5 on Oracle Servers
• Responsible for upgrading Golden Gate 9.5 to Golden Gate 10.0
• Performed Initial load, extract, replica, trial files and exporting data onto Repository Database using Golden Gate tool.
• Migration of Oracle 9i/10g databases from Linux 2.6 to Oracle 11g on Solaris 5.10
• Responsible for configuration of 10gRAC and 11gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS
• Administration and troubleshooting of RAC instance startups and instance evictions
• Implement and setup physical Standby database using Dataguard in oracle for disaster recovery.
• Experience in upgrading Dev and Test instances to 11g (11.2.0.3)
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Export/Import Datapump and Transportable tablespaces to migrate databases from one database to another.
• Applied patches, patch sets and Critical Patch Update (CPU) using OPatch utility and OUI.
• Documentation of Oracle 10g and 11g databases, hardware and Golden gate.
• Automated various tasks thru Crontab
• Develop centralized monitor database activities scripts such as space management, alert log, cleanup, RMAN Backup Jobs, verify Golden gate processes, Gather stats for Schemas, Tablespace monitoring, Disk monitoring, etc.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Statspack, ADDM, ASH reports, OEM Grid Control, Fine tuning of SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and table spaces to improve the performance.
• Implemented partitioning on large tables, expertise in using in composite partitioning, local indexes, global indexes and indexes of hash partitions.
• Performed pre and post installation tasks in migration starting from research on initialization Parameters for Datamart Database and Database Links, Synonyms, Views and Roles for Different Databases, which will be preferable to current environment.
• Worked very closely with development team providing solutions on sql tuning and application design
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, and archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Monitoring production and non-production database using Oracle Grid Control (OEM) 10g and 11g
• Monitor and analyze performance issues using Ignite 8 Config
• Monitor database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization.

Confidential, Monroe, LA

Sr.Oracle Database Administrator

Environment: Oracle 10g RAC,11g, UNIX, Solaris 10, Informatica, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN, Business Objects XI, DataGuard

Responsibilities:

• Develop/customize UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.
• Performed administrative maintenance, monitoring Oracle Server database systems in a global 24x7 operational environment.
• Responsible for configuration of 11gRAC, 10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS
• Database upgrades and Datacenter Migrations of Oracle databases from 9i and 10g.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance
• Administering ORACLE Databases 10g (10.2.0.2), 11g (11.1.0.7) with over 5 TB in size
• Experience in Upgrading Dev and Test instances to 11g (11.1.0.7)
• Analyzed the impact of upgrading from 10.2 to 11.1 at the SQL statement level by using the other component of 11g Real Application Testing which is called SQL Performance Analyzer or SPA.
• Oracle Clusterware installed to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication
• Installed and Configured Golden gate (11.2.1.0) replication in Bidirectional between Schemas.
• Implemented partitioning on large tables, expertise in using in composite partitioning, local indexes, global indexes and indexes of hash partitions.
• Creation & Maintenance of 20 Single Instances and 5 RAC Databases in Development, Test and Production servers. Coordinated with System Admin’s for Server Support, NAS and SAN storage.
• Performed Pre & Post installation tasks in Migration starting from Research on Initialization Parameters for Datamart Database and Database Links, Synonyms, Views & Roles for Different Databases which will be preferable to current environment.
• Experience in Upgrading Dev and Test instances to 11g (11.1.0.7)
• Experience in Replication of Data bases using Oracle Streams and Logical Standby.
• Worked with Data Architect on dimensional modeling to optimize the already existing data-warehouse database using STAR Schema, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Re-designed table and index partitioning strategies HINTS to improve the query performance.
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Experienced in configuration of 10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS and Veritas Netbackup as a media management layer.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Worked on configuring Oracle Data Guard and EMC Symmetric Remote Data Facility on production server.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink)

Confidential, New Castle, DE

Oracle Database Administrator

Environment: Red Hat Enterprise Linux 4.x, AIX 5.2, OEM, Oracle 9i/10g RAC, Cognos 7.2, TOAD, Erwin, STATSPACK, EXPLAINPLAN, IBM DataStage,C++, Weblogic, SQL Server 2005

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installing & Configuring Oracle 10g Grid Control, 10g RAC on Linux & AIX.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Installed and setup 10g Oracle Enterprise Manager Grid Control (10.2.0.3) and Mass Agent Deployment on several hosts.
• Installed Oracle Dataguard for Oracle Disaster recovery, High Availability and data protection.
• Implemented Oracle RAC with Data Guard implementation for disaster recovery
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Logminer, Segment Advisor, Database Monitor, Server Stat’s, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance
• Implemented Oracle database backup & recovery solutions using RMAN and Exports/Imports.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created user accounts, roles and granting access permissions to the database.
• Monitored data transfer between the Database servers using DataStage, Oracle Streams/CDC, SQL*Loader, MS SQL Log shipping and DTS packages.
• Extensive Responsible in configuring and backing up database using RMAN for hot backups, cold backups and logical backups
• Upgraded Oracle databases from 9i to 10g.
• Migrated data from MS SQL Servers to Oracle, and vice versa.
• Involved in designing logical & and physical data models using power designer.
• Implemented Oracle Database 10g two node Real Application Cluster (RAC) on a Linux system
• Installed and configured Oracle Enterprise Manager 10g Grid ControlData guard set up for higher availability of Instances.