SUMMARY:

Oracle Database professional with over 7 years of experience. Worked in different environments (development, test and production) on different platforms (LINUX, Windows and Solaris). Highly motivated individual with strong leadership and interpersonal skills. Self - starter and fast learner who usually exceeds business expectations. Possesses excellent written and verbal communication skills. Can articulate business concepts to technical audiences and technical concepts to business audiences.

TECHNICAL SKILLS:

• Database Security
• Oracle Database Performance Tuning
• Transparent Data Encryption
• AWR report analysis
• Patch Set Update & Management
• STACKPACK
• RMAN - Backup & Recovery
• ADDM, ASH, ADRCI
• Oracle Database Upgrades
• SQL TRACE (4 years)
• Data Pump and expdp/impdp
• TKPROF, EXPLAIN PLAN
• SQL/SQL * Plus
• Oracle Database User Management
• ASM Automatic Storage Management
• Oracle Enterprise Manager & SQL Developer
• Oracle Data Guard
• Oracle Database Refresh
• Real Application Clusters (RAC)
• EXPLAIN PLAN
• Linux/UNIX
• Oracle VM Virtual Box
• TOAD
• Access & Excel

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Oracle 11g and 12c RAC Database monitoring, backup and recovery and maintenance.
• Created Physical Standby databases, configured log shipping. Worked on switching over these physical standbys to primary and original primary as physical standbys.
• Performed batch jobs using Crontab utility.
• Monitored and Troubleshot database performance using OEM, AWR, ADDM, Explain Plan, SQL Trace, TKPROF, ASH, ADRCI and Cluster Interconnect Tuning (RAC).
• Performed backup and recovery procedures using RMAN and Data Pump utility for Oracle databases
• Cloned schemas, objects and databases on new server using exports from 10g database and imported in 11g using data pump.
• Implemented Flashback technology of Oracle 11g and 10g along with Recyclebin for faster recovery of databases and database objects.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data
• Member of Production DBA Team and participated in ON-CALL rotation.
• Maintained and administered data warehouses.
• Resolved PL/SQL performance issues.

Confidential

Oracle DBA

Responsibilities:

• Upgraded databases from 10g to 11g and 11g to 12c. Applied PSU and bug fix patch.
• Applied various patch sets released through Critical Patch Updates (CPU).
• Used TOAD for database management.
• Performed ETL using SQL*Loader and External Tables.
• Developed Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity reports.
• Refreshed database from Production to IST, UAT and Development databases.
• Implemented Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.
• Performed other Security related tasks including Transparent Data Encryption (TDE).
• Installed OEM 11g, 12c and configured all RAC nodes, primary and standby databases and setup various monitoring alerts.
• Wrote Linux scripts for weekly/daily backups using RMAN for production databases.
• Worked with development team to work out complete database design and capacity planning for new database projects and enhancements.
• Worked with Agile/Scrum and participated in all Agile/Scrum ceremonies.
• Assisted developers and Application Analyst on SQL queries and tuning.
• Monitored and maintained database disk space, alert logs, tablespaces and instance health status.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle 10g and 11g on Linux environment
• Created Users and Assigned Roles/Privileges, Expiring User Password, Creating User Profiles.
• Refreshed test and development databases from production database.
• Installed Oracle Grid Control Management Server.
• Created Testing and Development databases following OFA compliance rules.
• Identified and removed fragmentation, row migration/chaining of database objects.
• Performed space management, capacity planning, disaster recovery and overall maintenance of databases.
• Performed incremental backups using RMAN.
• Identified and recovered corrupted db blocks using Block recover option in RMAN utility
• Troubleshoot and resolved various Oracle connectivity problems.
• Perform bulk load into the database using SQL Loader.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle 10g and 11g on Linux environment
• Created Users and Assigned Roles/Privileges, Expiring User Password, Creating User Profiles.
• Refreshed test and development databases from production database.
• Installed Oracle Grid Control Management Server.
• Created Testing and Development databases following OFA compliance rules.
• Identified and removed fragmentation, row migration/chaining of database objects.
• Performed space management, capacity planning, disaster recovery & overall DB maintenance.
• Performed incremental backups using RMAN.
• Identified and recovered corrupted db blocks using Block recover option in RMAN utility
• Troubleshoot and resolved various Oracle connectivity problems.
• Perform bulk load into the database using SQL Loader.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities