SUMMARY

• Oracle Database Administrator with 71/2 years of hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management and database security.
• Experience in administration of Oracle 12c/11g/10g/9i and RAC databases.
• Worked as a team member to provide an effective on - call production database support (24x7).
• Experience in working as an Oracle database admin in various environments like Linux and Windows.
• Created development, testing, staging, production, RAC and standby databases.
• Experience in Data guard Configuration, Implementing and maintaining Standby Databases i.e. Active Data guard and Snapshot Standby.
• Having detailed knowledge about the architecture (physical and logical structure) of a database.
• Hands on experience in Grid Control 10g & 11g & installed 12C for Database monitoring / Performance / Diagnostics.
• Experience in implementing and maintaining database security.
• Data modeling experience using tools like Erwin.
• Experience in Working with Oracle Virtual Box, Oracle VM server & Oracle VM Manager.
• Solid experience in database backup concepts and recovery scenarios. Created and monitored database objects like Tables, Indexes, Views, Users and DB links.
• Extensively experienced in Oracle Database monitoring and Tuning using Grid control/Oracle Enterprise Manager (OEM) monitoring.
• Experienced in OracleGoldenGate installation, configuration, troubleshooting GoldenGate EXTRACT and REPLICAT.
• Expertise in replication technologies including GoldenGate, Streams, and Materialized Views.
• Used Data masking to protect private and confidential data by replacing sensitive information with dummy data.
• Experience in Performance Tuning and Database Tuning and Monitoring.
• Performed Flashback features to handle efficient database recovery and implementing restore points for testing.
• Experience in backup and cloning using RMAN procedures.
• Designed and implemented Database recovery strategies using RMAN, OEM.
• Experienced in fixing the Performance issues in Data guard/RAC.
• Experience in Data Migrations using oracle Export/Import, Data Pump, RMAN, SQL*Loader.
• Experienced in utilizing UNIX Shell scripts for backups, export and import of database.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Worked on many day to day activities like creating table spaces, adding data files, resizing, creating users, granting privileges, resetting password etc.
• Resolved shared memory allocations, long transactions, locking issues and deadlocks.
• Good at monitoring server performance, database transaction log growth and error logs.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*Loader.
• Expertise in Performing Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Explain Plan, Statspack, SQL*Trace, Tkprof.
• Experienced with hardware sizing and capacity planning.
• Performance tuning of the database - SQL Tuning, Used tuning utilities like AWR, and ADDM.
• Expertise at Tuning Database Server at Hardware level, OS Level and Oracle Database Level. Experience in executing Korn shell scripts using crontab for scheduled backup of database.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Involved in doing extensive administrative tasks on UNIX & Red Hat Linux server databases.

TECHNICAL SKILLS

Database: Oracle 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i

Oracle Products: Real Application Cluster, Golden Gate, Data guard, Import and Export, Data pump, Recovery Manager, Oracle10g/11g, Oracle Real Application Cluster, RMAN, Transparent Data Encryption, ASM

Operating System: Oracle Linux Red Hat Enterprise Linux (RHEL), Sun Solaris, Windows XP/2003/2008/7, HP-UX, IBM-AIX

Languages: SQL, PL/SQL, Unix shell scripting, HTML, Java

Tools: & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, BMC Remedy, TKPROF, AWR, ASH, TOAD, Putty, ERWIN, ETL tool (Informatica), VERITAS

PROFESSIONAL EXPERIENCE

Senior Oracle Database Administrator

Confidential, Malvern, PA

Responsibilities:

• Administering and supporting Oracle database environment over 110 databases, up to 15TB, utilizing advanced concepts such as Data Guard & Oracle RAC combined on all the production, development and testing environments. Installed, configured and maintained Oracle 2/3 Node 12c RAC.
• Performed various operations like re-linking protocol library, implemented 12c Transaction Guard while configuring services, and deployed instance caging.
• Created container and pluggable databases in 12c RAC and created services configured with PDB
• Worked on ASMCA and used SYSASM for created disks, drop and add disks to disk groups and tuning ASM parameters according to requirement.
• Configured disaster recovery databases using data guard and performed DR Testing.
• Performed switchover and monitor using DGMGRL.
• Involved in Installation and Configuration of Management agents in 12C (Cloud Control).
• Used 12C/11G grid control Maintenance, tuning and monitoring databases.
• Worked on Active data guard and performed Troubleshooting data guard environment
• Involved in OracleGolden gate installation, configuration, troubleshooting Golden Gate Extract and Replicate files.
• Involved in up-gradation of databases from 10g to 11g and applied patch set and interim patches whenever required.
• Upgraded development and production databases from 10g to11g on Linux.
• Used 11G grid control Maintenance, tuning and monitoring databases.
• Providing Application Support for performance and database related issues.
• Worked with teams and Involved in building Databases for BI (Business Intelligence) Applications.
• Worked on storage Indexes and tested their behavior with different query predicate conditions.
• Performed cross platform migration of databases on Solaris 10g to Linux 11g using GoldenGate.
• Documented and logged errors in GoldenGate environment and worked on OLTP Compression.
• Extensively used Log dump utility and define utility for resolving issues in GoldenGate.
• Extensively used data pump for migrating data between platforms.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Implementation of Flashback Technology and cloned databases for development and test environments using Recovery Manager.
• Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN.
• Worked in Data Warehouse environment, involved in activities like partitioning tables, creating materialized views and reorganizing indexes.
• Database Sizing, Table space Management and Rollback Table Space Management, Transaction Management and Security Administration.
• Implemented database security using Transparent Data Encryption.
• Strong understanding of business processes with good experience in development.
• Good experience of coordinating with various teams like Deployment, Testing Team to speed up Development process.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.
• A logical, analytical thinker with exceptional database skills having rich experience as an Oracle PL/SQL developer.
• Encrypted sensitive information like Tables, table spaces, Encrypted columns within the database and implemented Encryption keys on relational database management systems by using TDE.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Performed Database and SQL tuning by using various Tools like AWR, ADDR, TKPROF, Explain Plan, SQL Advisor and optimizer hints.
• Involved in managing end-end lifecycle of user identities across the enterprise resources using Oracle IDM (Identity Management).
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: Oracle 12c/11gR2, Solaris/Linux, SQL, OEM, RAC, ASM, Data guard 10g/11g, Putty, RMAN, Explain Plan, AWR, ADDM, ASH, TTS, Flashback, Data Pump, Performance Tuning/ Monitoring, GoldenGate

Senior Oracle Database Administrator

Confidential, Chicago, IL

Responsibilities:

• Worked as Operation DBA and having good experience working in build-stage planned and implemented high availability using RAC and Data guard.
• Worked in build stage, Installed and configured oracle software, databases from scratch.
• Installed and configured RAC (2node) & created Databases using DBCA.
• Created custom services for RAC database for distribution of load across the nodes.
• Created ASM disk groups and managed grid infrastructure network resources.
• Installed standalone servers on ASM, created disk groups on ASM.
• Worked on ASM and performed SAN migration.
• Configured disaster recovery databases using dataguard & worked on 11g new feature active data guard.
• Converted physical standby databases to snapshot standby, performed manual switch over to DR servers.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers.
• Applied patches on standalone servers using OPatch utility and upgraded OPatch utility from lower version to higher version.
• Involved in migration of databases from standalone (ASM) to cluster Environment.
• Maintained catalog server and registered databases in catalog server.
• Using SQL Tuning Advisor and SQL Access Advisor to fix bad SQL.
• Having good experience in monitoring databases through grid control.
• Installed and configured Oracle Enterprise Manager 11 g Grid Control.
• Implemented data transfer using Data Pumps and Export/Import utilities.
• Involved in scheduling incremental, cumulative and full backups and configured retention policy.
• Developed a bunch of Index monitoring scripts in order to sort out the unused space occupied in table spaces.
• Implemented advanced features AWR, ADDM reports for monitoring database performance, Modified and updated the Performance tuning scripts.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.
• Mentoring Level-II DBA’s and involved in 24x7 Production-on calls supports for all the production databases with Oracle.
• Performed various operations like bringing down oracle cluster-ware resources, created ASM disk groups and managed grid infrastructure network resources.
• Involved in configuring thresholds for cell metrics using CELLCLI.
• Migrated databases into EXADATA RAC- databases successfully using Data pump.
• Installed standalone servers on ASM, created disk groups on ASM
• Worked on ASM and performed SAN migration.
• Performed migration of databases from HP UNIX to Oracle 11.2.0.x on RHEL.
• Implemented load balancing using 11.2.1.0.6 OracleGolden Gate.
• Installed and configured, troubleshooting Golden Gate Extract, pump and replicate processes on AIX 7.x servers.
• Worked on Performance Tuning (11g &10g) on Solaris 10, AIX 7.1.

Environment: Oracle 11g/10g, Red Hat Linux 4.x, 5.x, RMAN, SQL server, RAC 10g/11g, Data Guard, OEM, Grid Control 10g/11g, STATSPACK, AWR, Explain Plan, Performance Tuning/ Monitoring

Oracle Database Administrator

Confidential, Chicago, IL

Responsibilities:

• Worked on Oracle Database 10g 2 node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Installed & Configured Oracle 11g RAC on Solaris and VMware server.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data Pumps Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Created indexes to facilitate easy user interface implementation and tuning.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Implement single sign-on in databases using Kerberos (Active directory) authentication to meet SOX requirement.
• Enabled database level auditing to find out which users are not using single sign on to login to databases.
• Worked on implementing windows authentication for SQL Server databases. Provided end user support for troubleshooting issues with single sign on.
• Supported databases on RAC environment.
• Manage Oracle RAC database configurations utilizing Veritas Cluster Server (VCS), GoldenGate & Data Guard to ensure maximum availability and data protection.
• Analysis and recommendation for best access path for the application programs.
• Monitoring growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Diagnose and troubleshoot database problems and failures.
• Creating and refreshing materialized views.
• Created scripts for hot backup on a daily basis scheduled with cron jobs.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, Windows 2003/XP/7, OEM, Oracle RAC, Data-Guard, TOAD, STATSPACK, EXPLAIN PLAN, GoldenGate, RMAN, Performance Tuning/Monitoring

Oracle Database Administrator

Confidential, Libertyville, IL

Responsibilities:

• Provide backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade support for approximately 30 Oracle databases.
• Installed & Configured Oracle 11g1 R1 & R2 RAC on Linux.
• Installed and configured Oracle Grid Control.
• Worked on different versions of VMware servers & workstations.
• Worked on troubleshooting and solved many issues that were encountered while installing & configuring Databases & Apps.
• Administration and support of Oracle Application Server 9i and 10g.
• Installation and maintenance of Oracle 10g Data Guard.
• Involved in backup and recovery using Recovery Manager
• Standby database setup via Data guard for Database Disaster Recovery.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Createddatabase objects such as tables, indexesand views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces and Responsible in configuring and backing up database using hot backups, Cold backups and Logical backups.
• UNIX shell scripting as and when required based on the requirement.
• Migration and Up-gradations of Databases and Patched Oracle Database Server 10g using OPatch.
• Performance tuning on production databases supporting the application using STATSPACK.
• Develop, document, and implement security configuration for Oracle software and database instances to comply with existing standards. Refresh development/test databases from copies of production.
• Develop, document, and implement security configuration for Oracle software and database instances to comply with existing standards.
• Refresh development/test databases from copies of production.
• UNIX shell scripting as and when required based on the requirement.
• Database cloning from Production to Test and Development environments.
• Installation of Oracle cluster ware, Configuring public and private network and VIP.
• Worked on creating, monitoring and management of database users, granting/revoking of system/object privileges, management of roles & resources and setting of init.ora parameters.
• Prepared the MOP’s (Method of Procedure) for renaming the Database, Creating and upgrading the DB, RE-IP, Partitioning the Tables etc.

Environment: Oracle 11g/10g/9i, SQL * PLUS, TOAD, Import/Export Oracle Enterprise Manager, Windows NT/2000, Red Hat Linux, UNIX scripting, PL/SQL, Sun Solaris, Oracle RAC, RMAN, HP-UX, IBM-AIX, OEM Grid Control

Oracle Database Administrator

Confidential

Responsibilities:

• Database Installation and embedding oracle base software into the product on multiple platforms.
• Supported Oracle 11g, 10g and Oracle 9i Databases of Production, Testing, Staging, Dev and Training environments.
• Administer, maintain, develop and implement policies and procedures for managing DB security and alert log entries.
• Resolve database performance issues, database capacity issues, and distributed data issues.
• Developed RMAN scripts for backup and recovery of databases.
• Database Design, Schema Design, Performance Monitoring, Tuning.
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability.
• Involved in disaster recovery procedures and performed Backup/recovery.
• Recovery of Database from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption.
• Safe Guarding Customer Data by ensuring that tables with sensitive and critical data can be accessed by only selected group of users as per client requirement.
• Using EXPLAIN plan utility to analyze the cost involved in query processing and tune it for faster retrieval.
• Created Indexes-Bitmap/Join Indexes, Function-Based Indexes etc as per the given structures, operations, data in the tables for increased performance.
• Support of database with features like partitioning with PL/SQL calls to collect stats, index maintenance.
• Implemented database security by setting up auditing, roles and privileges.
• Worked on performance tuning of SQL and Procedures and packages.
• Created Cron jobs in production to automate production tasks.
• Performing Database design and modeling using ERWIN.
• Used PL/SQL Tables and Array’s to process huge volume of data and used bulk collect and bulk bind for mass updates as performance improvement process.
• Creating databases using Optimal Flexible Architecture (OFA).
• Automating daily routine activities using Korn shell scripts.

Environment: Oracle 11g/10g/9i, Red Hat Linux, SQL*PLUS, Oracle Windows, HP-UX, UNIX Scripting, PL/SQL, ERWIN, RMAN, DataGuard, Performance Tuning, EXPLAIN PLAN

Oracle Database Administrator

Confidential

Responsibilities:

• Installation, Maintenance and administration of Oracle 10g on Red hat Linux and HP-UX systems.
• Administered Oracle 10g and 9i databases in Production, Stage and Dev environments.
• Implemented Data guard and administered the production database.
• Responsible to schedule backups through RMAN.
• Worked on oracle patches using OPatch utility.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Create & Manage Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges. Created multiple Raid levels using volume manager.
• Used extensive Sub Queries, PL/SQL procedure, DDL functions, database triggers and packages.
• Monitored the data loading jobs. Performed scheduled Oracle monitoring and maintenance tasks.
• Responsible for writing database programming to Store/Retrieve the information using SQL.
• Extensive application tuning through STATSPACK, EXPLAIN PLAN, SQL*Trace.
• Implemented scripts to capture high resource utilization queries, implemented scripts for daily monitoring like db status, free space etc.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.
• Tuned the SGA, Monitored the shared Pool, Database buffer cache and Redo log buffers.
• Monitored Table spaces and Segment fragmentation. Performed trouble-shooting activities, created new users and assigned privileges and roles to users.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Running Korn shell scripts to create database from a template, to perform free space management and writing scripts to report space situations to the DBA.

Environment: Oracle 10g/9i, Red Hat Linux, SQL*PLUS, Oracle Windows, HP-UX, RMAN, Oracle Enterprise Manager 10g, DataGuard, STATSPACK