EXPERIENCE 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.

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

TECHNICAL SKILLS:

Technical: Database Oracle 11g, 12c, 13c OEMTools Toad, Data Modeler, MySQL Workbench5.0, Erwin, Toad for Oracle and Oracle Sql Developer

Database: Migration Tools SQL Ways 3.5/5.6, MySQL Migration toolkit, Spectral Core.

Languages: PL/SQL, SQL, UNIX Shell Scripting, HTML.

EXPERIENCE DETAILS:

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