SUMMARY

• IT experience of 7+ years managing oracle databases on Linux, Solaris and Windows
• Hands on experience in Oracle 10g, 11g, 12c, RAC, OEM, 12c cloud control, Data Guard, Exadata, partitioning, RMAN Skilled in setting up/Installation
• Strong physical and logical Data Guard skills.
• Expertise in Oracle Managed Filesystems (OMF)
• Oracle Grid and RDBMS Patches
• Worked on Windows, Linux, Solaris and AIX platform.
• Upgrade databases from 11g to 12c.
• Experience with new features of 11g R2 which includes SQL Access Advisor, SQL Performance Analyzer, SQL Plan Manager, Table compression enhancement, Active Data Guard, Query Result Caching, and Invisible Indexesetc.
• Managed database on Exadata
• Migrated databases to half rack Exadata machine.
• Worked on SQL Server 2008 and SQL Server 2012.
• Administered and worked on 11g grid control and 12c cloud control
• Installed Data Guard from scratch
• Implemented hot backups and recovery procedures using RMAN.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Created and managed role - based security to restrict or permit users according to their database usage
• Applied one off, CPU and PSU patches.
• Installed RAC from scratch on Linux.
• Build and maintained on Data Guard and ASM
• Experienced in maintaining large databases
• Experience in installing, configuring and maintaining Standalone and RAC databases
• Supported 24/7 mission critical huge databases.
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux
• Skilled in using tools such as SQL Developer and TOAD.
• Dealing with database security and auditing.
• A self-motivated, responsible and team player with a set of strong technical skills.
• Creating and reviewing documentation for change management, implementation plan and proof of concept (POC).
• Worked extensively on Oracle Upgrades, Migrations and Patching.
• Experience in migrating from SQL to Oracle, Replications, and Clustering.
• Experience with installing and maintaining Oracle Grid Control.
• Installed and configured 11g RAC on LINUX platform with ASM disks for storage.
• Experienced in RAID, storage technologies and backup solutions
• Experience on Oracle Support processes for technical requests through Metalink.
• Supported the system 24x7. Ability to work beyond regular hours.
• Implementation and using of Oracle 11g new features like Data Pump, ASM, Flash Back Technology, Transportable Table spaces and Automatic Workload Repository.
• Implementation ADM disk, Data Guard, and RAC.
• Worked on 12c Database Migration.
• Cloned databases using RMAN Duplicate
• Refreshes database objects using export/import and Data Pump.

Areas of Expertise

• Oracle 9i, 10g, 11g 12c
• Oracle Automatic Storage Management
• Oracle GoldenGate
• Performance Tuning
• Security Administration
• Replication
• Distributed Databases
• Disaster Recovery Solutions
• Database Design
• SQL Server
• Recovery Manager (RMAN)
• Standby Database Solutions
• Oracle 10g, 11g, 12c Data warehousing
• Oracle Enterprise Manager (OEM)
• Data Pump, TKPROF, RMAN, Shell Scripting
• SQL, PL/SQL
• UNIX, Solaris, HPUX, Tru64, AIX
• Windows Server 2008, 2012
• Active Data Guard
• Real Application Clusters - RAC

PROFESSIONAL EXPERIENCE

Confidential - Ohio

Oracle DBA

Responsibilities:

• 24x7x365 administrative support staff.
• Refreshes Database / schemas using Data Pump.
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 9i, 11g and 11g clients/databases on Solaris and Linux.
• Complete Build of 4-node 11g RAC Cluster on RHEL 4 from scratch.
• Migrated 11g database to 11g R2.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Experienced with Space Management and Security.
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Maintain and Administer SQL Server Databases on Windows Server VM
• Applied Patch’s to Oracle 11g, 11g tested.
• Upgraded Oracle 10g Release 2 to 11g Release 1 and on to Release 2.
• Moved Oracle Databases between two HP-UX Servers using the Cold Backup.
• Installed Oracle Enterprise Manager Grid Control 10.2.0.5 on Windows Server and configured the same with the other Oracle Databases.
• Created and configured Oracle Enterprise Manager Grid Control Repository Database.
• Monitoring Oracle Databases and SQL Server Databases using Oracle Enterprise Manager and SQL
• Experienced with SRVCTL, OCR and Voting Disk of 11g RAC
• Strong physical and logical Data Guard skills.
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Configure and manage tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Worked on Space Management and Security.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.

Confidential - Greenville, SC

Oracle DBA

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager
• Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
• Used Performance tuning tools such as tkprof, explain plans, oradebug and trace files to tune SQL Queries.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Migration of Databases and applying patches whenever required.
• Experienced with SRVCTL, OCR and Voting Disk of 11g RAC
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Implemented and planned out Server Security and authentication.
• Worked on GoldenGate replication
• Change Capture and Delivery (with and without a Data Pump)
• Performed various Initial Data Load in Oracle GoldenGate configuration.
• Contrasting Batch and Online Operation
• Database migration from 10g to 11g.
• Responsible for installing and configuring Golden Gate on Oracle Servers.
• Database migration from 11g to 12c.
• Designed, configured and maintained backup/recovery policies including RMAN backups.
• Written shell scripts to monitor databases.
• Involved in 24x7 support for production RAC databases with on-call pager
• Implemented the Security using Oracle Database Vault
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Index management for better performance, maintenance of Oracle Database
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Installed, Migrated, configured and tested Oracle 11g databases in various environments.
• Worked on Active-Active Data Guard.
• Managed Standby with Data Broker.
• Install and configure Oracle GoldenGate
• Configuration, troubleshooting GoldenGate issues

Confidential - Minneapolis, MN

Oracle DBA

Responsibilities:

• Schedule backup in 11g using db console.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor
• Resolved performance issues.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Planning, Implementing and validating various versions of Oracle Databases to 11g Release 2 & 11g Release 1upgrades on all the environments.
• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Worked as part of a team and provided 24/7 support when required.
• DevelopPerlscripts for different risk related reports
• Performance tuning for existingperlscripts and database objects and sql
• Perlscripts as per requirement
• Executed scripts as perl shell
• Maintenance of installed Oracle database and supporting multiple production, development and test instances of varied complexity including Multiple Tier and RAC environments.
• Worked on the RAC environment for the high availability managed by ASM.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
• Handled database migration from Solaris to Linux.
• Installed, configured and performed the maintenance of SQL Server.
• Implemented Replication using Streams and Proficient in using TOAD and Oracle Enterprise Manager (OEM).
• Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN, recover and test the backups regularly.
• Created Unix Shell scripts to automate database operation.