SUMMARY:

• A DBA with total of Nine years of experience in Oracle (8i to 12c) and 3years of experience in Oracle Applications (11i, R12) installation, migration, backup, recovery, scripting, performance tuning, administration, monitoring on Solaris & Windows platforms.

TECHNICAL SKILLS:

Database: Oracle 8i, 9i, 10g, 11g & 12c, Oracle Apps 11.5.9, 11.5.10, R12, MySQL 4.1 & 5.0, MSSQL 2000 & 2005, Progress 9.1E & 10.1C, Cassandra

Languages: SQL, Shell Scripting

Tools: /GUI: SQL*Plus, SQL Developer, Grid Control, TOAD, Data pump

Tuning tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Grid Control

Operating System: Linux, Sun OS 5.8 & 5.10, Windows NT, Windows 2000/2005, HP - UX 11i

PROFESSIONAL EXPERIENCE:

Confidential

Senior Support Engineer

Responsibilities:

• Install Oracle 12c on Windows server. Database creation as per the requirements and setup of physical standby database.
• Conducted online on the provided Oracle database administration documents. Setting up of the environment to enable full to take place.
• Worked extensively on improving query performance/optimization using AWR reports, Explain plan, trace and TKPROF, gathering statistics and analyzing them.
• Created a new database in the existing RAC cluster using RMAN duplicate.
• Configured RMAN backup scripts for the regular database backups.
• Configured, tested and deployed Oracle Data Guard setup successfully.
• Created Streams environment in unidirectional and table level for replication of data.
• Operational Knowledge in Cassandra database physical layout design, monitoring solutions, backup and high availability strategy for Cassandra.

Confidential

Senior Oracle DBAx

Responsibilities:

• Responsible for supporting various Oracle’s customer on Oracle 12cR1, Oracle 11g & 10g on various OS platforms namely Linux, Hp-UX, Solaris, Windows, AIX. The support nature is in category of Severity 1/2/3 with high-end customers of Oracle Inc.
• Provide DBA support with a high degree of customer service, technical expertise and timeliness. Provide accurate solutions and best practices to user problems to ensure productivity. Perform root cause analysis on failures.
• Worked with customer for different RAC related issue: RAC recovery, backup and recovery related issues, issues with block change tracking & also flash recovery area.
• Strong Knowledge of Oracle Recovery Manager (RMAN). Providing suggestions/solutions to customer’s backup procedures, optimize performance of RMAN backups, plan for backup and recovery of the database and resolving any RMAN related issues.
• Sound knowledge of Dataguard and handling database corruption issues. Experience of managing DR environments (Standby, ADG, Snapshot database)
• Hands on with Enterprise manager cloud control.
• Assisted customers with cross platform migration using RMAN and Data Guard technologies.
• Familiarity with database upgrades and patching activities.
• Exposure to Oracle Golden Gate 10g/11g replication to remote sites for disaster recovery. Knowledge of the Oracle GoldenGate installation, configuration, troubleshooting GG issues.
• Effectively collaborate with other Development, Operations and Support team to resolve performance and design issues.

Confidential

Oracle Apps DBA/Database Administrator

Responsibilities:

• 24x7 production support for several mission critical systems, which utilize multiple Oracle 9i, 10g & Oracle Apps 11i databases.
• Installed oracle database server on Solaris 8/10, upgrade of oracle server 9i to 10g and applied oracle patches.
• Installation of MSSQL & MySQL RDBMS software on various platforms.
• Installation, Configuration and deployment of Oracle Real Application Clusters (RAC) with 3 nodes using Automatic Storage Management (ASM).
• Manage RAC environment for Day to Day Database administrator. Add or Remove Node from RAC. Troubleshoot performance issues for the RAC instances.
• Implemented and maintained Oracle Data Guard/standby databases for fail-over purposes.
• Regular database administration for all versions 9i/10g including develop user profile, monitor user access to database, space management, alert monitoring, wait events, locks, latches and other bottlenecks.
• Installed ASM environment and migrated database from NON-ASM to ASM.
• Knowledge of Flashback technology.
• Performance-tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, Grid Control.
• Create Shell scripts for monitoring of active session, session wait, session locks, table space monitoring, file system monitoring.
• Database creations, Oracle RAC database cloning on request from application owners.
• Creating standby database and setting up database broker. Handle Switchover and Failover of database.
• Analysis of application Patches and their pre requisites. Manage/Execute application patches using adpatch utility.
• Running maintenance tasks using adadmin, like compiling invalid objects in apps schema, regenerating and compiling forms. Register and setup concurrent programs and forms.
• Creating front end users and setup responsibilities. Setting up profile values, manage printers.
• Responsible for Oracle apps cloning activities and Oracle Apps SYSADMIN functions.
• Maintain & troubleshoot problems with concurrent managers, Apache, forms server, report server, concurrent requests & discoverer.
• Setup printers in OS, which was later configured in Oracle Applications to be used when a concurrent program is submitted.
• RMAN backup & recovery. Hot backup & manual recovery. Add, manage backup scripts; monitoring backup jobs. Maintain Recovery procedures for each application database.
• Performing regular database preventative maintenance activities (Index rebuilding, Analyzing the database, tune buffer cache, chain rows)
• Worked on import/export, export data pump/import data pump.
• Applying CPU and PSU to Oracle Database and RAC database.
• Installation and Upgrade of Oracle Enterprise Manager Agents.
• Monitor and administration of databases using Grid Control.
• Production support activities and resolve issues for the application/functional team through tickets or page in a timely manner.

Confidential

Oracle Database Administrator

Responsibilities:

• Database Cloning and Refresh.
• Creating the development and test environment for Database/application testing.
• Migration of data/application from one database to other using export-import.
• Performing regular preventative maintenance activities (Tablespace Re-organization, Index rebuilding)
• Perform disaster recovery testing.
• User creation/deletion & database access.
• Add, manage backup scripts; monitoring daily hot backups.
• Checking status of scheduled jobs. Checking status of tablespaces and invalid objects in database. Monitoring space usage in the database, reporting possible problems and monitoring database alert logs.
• Data extractions as requested by users. Troubleshooting user’s issues. Support production maintenance activities.
• Automating alerts when database system crosses threshold limits. Maintaining central repository for centralized monitoring for all databases.
• Troubleshooting issues related database links.
• Monitor advanced replication between master and snapshot instance with use of materialized views & refresh groups.
• Partitioning tables by determining the suitable methodology to improve performance and manageability. Implemented range partitioning in Data warehouse environment.
• Setup Oracle Enterprise Manager Grid control for data monitoring/performance/diagnostics.
• Plan, install, configure and performed upgrade of existing oracle 8i, 9i to 10g version on various platforms through POC, development, QA and go-live stages. Provided support to functional/application team through all stages of the project.
• Advised team members in all phases of the assignments and assist in the coordination of team activities.
• Provide monthly reports on service level. Work towards the agreed service levels (i.e., Availability, response time, resource utilization etc.)
• Working with Oracle Product Support (TAR) for resolving any critical issues.