SUMMARY:

• Over 5 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g and 11g.
• Expert working knowledge of 12c, 11g, 10g, 9i and 8i databases with the UNIX and Windows operating system.
• Performing complete and incomplete recovery during disasters, failures and user errors.
• Data Guard administration and maintenance.
• Monitoring Day - to-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, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Perform Logical backup using full/partial export/import and data pump.
• Creating Logical and Physical database structure, Creating and altering Tablespaces. Managing Users and Resources, Granting and revoking privileges through Roles.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Deployed Standby databases using Data Guard 11G (Maximum Performance).
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch as well as database upgrades
• Installed and maintained Real Application Clusters (RAC)
• Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment. Monitored physical I/O and Proper sizing of rollback segments.
• Cloning of production databases as needed for testing, development using RMAN or scripts
• Performed SQL tuning based on report generated by ASH, ADDM, AWR
• Identified and resolved performance issues caused by table fragmentation using segment Advisors
• Troubleshoot and resolved locking and concurrency issues, Excessive parsing, resource bottleneck (including memory and CPU bottlenecks) and recommending a solution
• 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.
• Experience in configuration and administration of Data Guard (Physical/Logical standby Databases)
• 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.
• Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard)
• Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.
• Responsible for the installation, configuration and overall up from 10g/11gr1 to 11gr2 (10.2.0.2 to 11.2.0.2)
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, managed quotas. Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
• Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.

TECHNICAL SKILLS:

Databases: Oracle 11G/10G

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer, Nessus, Excel, Words, MS Project and PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Database Administrator

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, TOAD 11.0.

Responsibilities:

• Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.
• Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in handling large databases upto 4TB in size and largest table of size 60GB with 145 million records.
• Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases
• Installation, Configuration of ASM, RAC databases, Adding Services and maintaining GRID control.
• Migrated databases from 9i and 10g to 11g R2 using utilities like export/import, datapump and transportable tablespace.
• Implemented replication on databases using and Golden gate between homogeneous and heterogeneous databases.
• Performed replication between databases using Materialized Views and DB links from a remote database.
• Successfully performed installation, setup and creation of Primary & Standby database using dataguard to deliver no data loss with maximum availability mode.
• Worked closely with application teams for rolling application.
• Performance tuning of Oracle instances
• Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
• Monitoring Day-Day Backups, Log's & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Experience in Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
• Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
• Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.
• Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
• Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
• Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
• Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.
• Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

Database Administrator

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, Data Pump.

Responsibilities:

• Installation of oracle 11g databases in production, development and test environments depending on project requirements.
• Configuration of Listener and Tnsnames.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
• Designed Logical and physical database for business transaction functionality.
• Provide production support for the deployed project till it is stabilized.
• Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database
• Refreshing development/test database from production using Export/Import & RMAN backups.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Managing database security.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Defragmentation of tables and indexes for improved performance and effective space management.
• Managed Database Maintenance Activities to achieve optimum database uptime.
• Written SQL scripts to create database objects like tables, views and sequences.
• Created procedures and functions using PL/SQL.