PROFESSIONAL SUMMARY:

• Over 9 years of IT experience.
• Over 8 years of Oracle Database implementation and administration experience.
• Implementation and maintenance of Grid Control.
• Implementation and maintenance of RAC.
• Build DR using Oracle Data Guard.
• Proficient in Oracle RDBMS - all areas of database Administration.
• Performed Data Cloning
• Performed backup, restore, recoveries using RMAN.
• Worked on Upgrade and Migration projects.
• Performed various database administrative to keep databases healthy.
• Worked with VLDB (Very large Databases)
• Worked on export/imports, data pump tasks.
• Worked on Database security, roles, grants, privileges, FGA, Data Vault etc.
• Worked on Virtual Databases
• Load balancing in RAC nodes using TAF
• Possess strong Linux skills; light administration skills.
• Possess excellent written and oral communication skills.
• Tablespace point in time recovery TSPITR.
• Transportable Table Space (TTS) migration AIX to Linux
• Manage Backup and Recovery Program for all Oracle Databases. Install, implement and configure RMAN.
• Pose strong skills in Shell Scripting.
• Managed team of DBAs
• Worked with Offshore team.
• Regular practice of Disaster Recovery Scenerios.
• Work independently and as well working extremely well with other teams and the customer on a daily basis
• Provided database technical consultation to other teams
• Effective communication skills with Project manager, account team, and customer on technical issues and resolutions
• Implementing ASM file system and its maintenance
• Adding node to RAC environment.
• Deleting node(s) from RAC environment
• Troubleshoot network issues to connect to database.
• Troubleshoot performance issues by generating statspack report.
• Provided 24/7 support whenever on call.
• Dealt with Oracle by opening an SR or calling their customer support whenever necessary.
• Written custom made scripts to send archivelogs to multiple locations (before Dataguard came in picture)
• Restored databases on different hosts

TECHNICAL SKILLS:

Languages: SQL, PL/SQL

Script and Markup Languages: Unix bash shell programming, Windows Batch files

Web/Application: Familiar with Weblogic and Websphere, Peoplesoft

OS & Administration: Linux, Solaris, Windows, AIX, HPUX

Database: 12c, 11g, 10g

PROFESSIONAL EXPERIENCE:

Sr. Oracle Database Admin

Confidential

Responsibilities:

• Build 2 node, 3 node 10g/11g RAC on RHEL and AIX.
• Provided day to day support for three application.
• Provided support in refreshing schemas
• Provided support in cloning databases
• Used data pump, RMAN duplicate database and export/import for data moment.
• Set up 12c OEM for alerts and thresholds.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Perform Backup and Recovery thru RMAN.
• Strong exposure in Installing / configuring / maintaining RAC, Data Guard, Physical / Logical Standby environments.
• Applied Quarterly CPU (CRITICAL PATCH UPDATES) on the entire database farm.
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, migrated, configured and tested Oracle 11g databases in various environments.
• Extremely dedicated, self - motivated, Pro-Active and willing to assume responsibility.
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Provided 24/7 DBA support
• Very familiar with Dynamic Views and Dictionary Tables.
• Preventive Maintenance & re-orgs.
• Installed, migrated and tested Oracle 11g databases in various environments.
• Worked on Active-Active Data Guard.
• Managed Standby with Data Broker.
• Good exposure of R11i and R12i
• Troubleshooted JDEdwards, and Peoplesoft
• Worked with workflow of JDEdwards and Peoplesoft
• Install and configure Oracle GoldenGate, uniderectional and bi-directional
• Configuration, troubleshooting GoldenGate issues
• Written and modified scripts to automate cronjobs.

Sr. Oracle Database Engineer

Confidential

Responsibilities:

• Manage Blackboard, PeopleSoft (HR), Pinnacle (Phone Service) Application
• Manage Oracle on Windows 10g.
• Create Physical Data Guard on RAC 11G
• Manage Data Guard 11g
• Administrate 6 node cluster 10G and 11G
• High Availability Features for RAC
• Patch standalone database and RAC databases
• Used SRVCTL utility for managing multiple instances and nodes
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility
• Refresh databases using RMAN
• Perform Backup and Recovery thru RMAN.
• Written RMAN scripts for purging out applied logs at standby databases.
• Refresh schemas and databases using Datapump and traditional exp/imp
• Installed, created and configured 10g and 11g databases and Clients.
• Database sizing, Capacity Planning
• Analyze database objects
• Work closely with application developers and system administrators Automated various tasks thru Crontab.
• Used TOAD for various database Administration tasks
• Provided full DBA support for Oracle Applications in Production, Test and Development environments
• Meet SLA’s
• Performance Tuning of SQL and Databases parameters
• Use OEM 12c to automate backup task and Administration
• Manage security and grants for database users

Environment: Oracle 10g and 11g on RAC, Oracle Grid Control, Windows and Toad.

Sr. Oracle DBA

Confidential, IL

Responsibilities:

• Install and configure Oracle software.
• Refresh schema level and full level production to non-production databases.
• Created 2 production physical standby databases and 5 non-production physical standby databases.
• Successfully configured multiple standby databases for a production database. (standby from standby)
• Written RMAN scripts for purging out applied logs at standby databases
• Database sizing, Capacity Planning.
• Installed, created and configured 8i, 9i and 10g databases and Clients.
• Install and configure Oracle software.
• Refresh schema level and full level production to non-production databases.
• Designed the database schema and create any necessary database objects.
• Formulate optimal application SQL using Grid Control.
• Ensured database security is implemented to safeguard the data.
• Work closely with application developers and system administrators to ensure all database needs are being met.
• Apply patches or upgrades to the database as needed.
• Created 2 production physical standby databases and 5 non-production physical standby databases.
• Successfully configured multiple standby databases for a production database. (standby from standby)
• Worked with Real Application Cluster (RAC) databases.
• Used SRVCTL utility for managing multiple instances and nodes.
• Responsible for having multiple OCFS locations in RAC environment.
• Managed and multiplex Voting Disk and OCR file for maximum RAC availability.
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Perform Backup and Recovery thru RMAN.
• Written RMAN scripts for purging out applied logs at standby databases.
• Performance Tuning of database, SQL tuning for Application
• Performance Tuning of DBs using SQL trace, TKPROF, Explain Plan
• Physical and Logical database design.
• Database sizing, Capacity Planning.
• Analyze database objects.
• Applied various patches which includes quarterly critical patch using OPatch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Configured Listener from multiple homes in one server.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments
• Worked very closely with ORACLE for Data Guard implementation and other major issues.

Environment: Oracle 8i/9i,10g and 11g on RAC, Oracle Grid control, HP Unix, Toad.

Oracle Jr. DBA

Confidential

Responsibilities:

• Installed databases
• Silent install Oracle Home
• Worked with offshore team on deployments
• Troubleshoot Networking issues
• Troubleshoot database issues posted in alert log
• Failover the nodes
• Changed parameter values
• Installed ASM disks
• Monitor, administrator ASM, RAC.
• Performed Database Administration using TOAD, Oracle Enterprise Manager, SQL scripts and DB Artisan
• Performance Tuning of database, SQL tuning for Application
• Database sizing, Capacity Planning.
• Analyze database objects.
• Backup databases.
• Refreshing tables/schemas on a regular basis.
• Refreshed database from production to non-production.
• Export / Import using Data Pump.
• Troubleshoot OEM repository
• Update sysman passwords to troubleshoot OEM connection issues.
• Manage security and grants for database users.
• Created Materialize Views on a remote host to refresh multiples times in a day.
• Reconfiguring Services via srvctl utility
• Working with Oracle to solve multiple RAC issues.
• Troubleshoot connectivity issues and solved listener configuration.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Worked as secondary on-call DBA

Environment: SQL, SQL*Plus, 10g, 11g; Linux, HP UX, Toad, OEM, Grid, DB Artisan