We provide IT Staff Augmentation Services!

Oracle Sql Tuning Resume

Pasadena, CA

SUMMARY:

  • About 9 years of experience as Oracle DBA/Exadata having hands on 12c, 11g, 10g on AIX, Linux, and Windows servers experience with RMAN, and standard backup and recovery procedures; practicality of Data Guard, upgrades and patches.
  • Worked as a Core DBA/Exadata DBA as migration specialist on Oracle 11gR2, Exadata X4 & X7, OEM 13c, RAC, Data Guard, Linux.
  • Excellent experience in production support, installation, configuration, upgrades.
  • Expertise in development, testing and implementation of Backup and Recovery Strategy Using RMAN, Data pump and Export/Import utilities.
  • Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups.
  • Provide network troubleshooting and administrative support for the development staff.
  • Implemented Data guard (Physical Standby) for RAC databases.
  • Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.
  • Proficient in scheduling jobs, patches, alerting for databases and also database administration through OEM12c and 13c cloud control.
  • Oracle Exadata (X4 & X7) administration supporting multiple database RAC environments.
  • Configured and administered many installations of Data Guard and Active Data Guard.
  • Documented database structure, changes, problems, issues for future reference.
  • Identify and make recommendations per database performance issues.
  • Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC.
  • Extensive knowledge on database administration of Oracle 10g, 11g, 12c with experience on very large - scale database environment and mission critical large OLTP and OLAP systems.
  • Extensive knowledge of Oracle OEM 12c Architecture, Framework, and Infrastructure.
  • Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
  • Experienced in troubleshooting traditional export/import and data pump export/import.
  • Performed DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
  • Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
  • Created Unix Shell scripts to automate database operation.
  • Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, STATSPACK, OEM Grid Control and manual scripts.

TECHNICAL SKILLS:

Database: 12c,11g,10g & 9i Backup & Recovery (RMAN)

Database Troubleshooting: Database Upgrade Database Migration

Performance Optimization: Managing High Availability

Data Guard, ASM & RAC: Exadata

SQL: Training and Mentoring

Documentation: 13c Cloud Control

PROFESSIONAL EXPERIENCE:

Confidential, Pasadena, CA

Oracle SQL Tuning

  • Involved in Teradata to Exadata migration project (TD2EX) by performing SQL Query Tuning.
  • Extensive use of OEM tools in analyzing slow SQL.
  • Used Oracle Exadata Feature (Offloading, Smart Scan) to improve query performance.
  • Involved in analysis and tuning of SQL queries by using SQL Monitor report and Explain Plan for faster and better performance of the SQL queries.
  • In order to overcome performance bottlenecks, implemented alternate approaches like

    Global Temporary Tables, Common Table Expression (CTE) and Early row reduction etc.

  • Experience in optimization of code and tuning SQL queries for optimal performance.
  • Used Explain Plan, Oracle hints and Expression stats to improve the performance of SQL statements.
  • Co-ordinated with Real World Performance Team (RWPT) to resolve complex SQL performance problem.
  • Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
  • Performed application Query tuning using utilities ADDM, AWR.
  • Generate and interpret ASH, explain Plan.
  • Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance.

Environment: Oracle Database 12c, SQL*Plus, OEL6, UNIX, SQL Developer, OEM, Putty.

Confidential

Computer System Analyst

Responsibilities:

  • Worked as a Core DBA/Exadata DBA as migration specialist on Oracle 11gR2, Exadata X4 & X7, OEM 13c, RAC, Data Guard, Linux.
  • Support multiple mission critical RAC databases running on Exadata machine.
  • Maintained database backup and recovery procedures that support business continuity.
  • Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
  • Performed Database Refresh using RMAN duplicate and Schema level refresh from Production to UAT and DEV Environments for testing Purposes.
  • Performed 60 TB Database Migration from X4-2 to X7-2 Exadata machine.
  • Performed monthly partition maintenance like truncating partitions and adding new partitions.
  • Perform data validation post database migration using row count and object count.
  • Applied quarterly patches and one-off patches on regular basis.
  • SQL Tuning, End-user tuning and troubleshooting using various tools like EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, AWR, ADDM, ASH, v$ performance views.
  • Respond to database alerts and perform Root Cause Analysis (RCA).
  • Added, deleted database instance/services for RAC configuration.
  • Work on different versions of Databases with OEM Grid control to maintain the database effectively.
  • DBA activities such as configuring Grid events, Regular Backup's, Replication, Tuning, and troubleshooting performance issues.
  • Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
  • Documented database structure, changes, problems, issues for future reference.

Environment: Oracle Database 11gR2, OEL6, Exadata, RMAN, SQL*Plus, PL/SQL, Shell scripting, RHEL6.1/7.1, SQL*LOADER, Oracle OEM, Putty, Data guard, Toad.

Confidential

Database Administrator

Responsibilities:

  • Responsible for Oracle Database Administrator, providing 24x7 support for production and development 11g/10g databases on different platforms like Linux/Unix and windows.
  • Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux,Unix(i.e AIX) and Windows OS.
  • Responsible for Installation of RAC and Managing RAC Environment efficiently.
  • Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing
  • Extensively using DATAPUMP and Export /Import utilities for logical backups.
  • Analyzing the Tables and Indexes on performance base regularly.
  • Documented database structure, changes, problems, issues for future reference.
  • Provide network troubleshooting and administrative support for the development staff.
  • Troubleshoot and resolve various Oracle connectivity problems.
  • Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
  • Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
  • Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
  • Knowledge of writing Automated Scripts in the CRON for backups and restoration.
  • Used EXPORT/IMPORT to do table level and full database defragmentation.
  • Managed RAC Linux servers, running Oracle in cluster environments.
  • Work with the production support team and maintain operational consistency and efficiency.
  • On quarterly basis perform DR-Drill activity to test application functionality.

Environment: Oracle Database(10g,11g and 12c), IBM-AIX, RMAN, SQL*Plus, PL/SQL, Shell scripting, RHEL6.1/7.1, UNIX, SQL*LOADER, Oracle OEM, Putty, Data guard.

Confidential

Technical Associate

Responsibilities:

  • Managing users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backup.
  • Performs general DBA duties (install software, create databases, table spaces, add redo log files, managing storage & work closely with Sr. DBA on capacity planning and performance tuning)
  • Used various data movement utilities like export, import and Load, Planning.
  • Identify and make recommendations per database performance issues.
  • Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in weeks on the application database.
  • Oracle Database and SQL tuning using EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
  • Loading the data using SQL Loader.
  • Carrying out DR-DRILL activity (Snapshot standby, Switchover-Failover) .
  • Sound knowledge in oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Troubleshooting and Recovery of Database from Data file losses. Backup and Recovery involving archiving, redo logs, data files using RMAN.
  • Performs DB patching, DB Cloning, Install DB, troubleshoot issues/errors, DB/Application Maintenance using manual approach, Collaborate with Oracle support for bugs & issues resolutions and personal research.
  • Developed strategies for data extraction from various source systems, transformation and loading into data warehouse target systems.

Environment: Oracle Database (10g,11g), Shell Script, PL/SQL, TOAD, SQL Developer, SQL loader, TKPROF, Windows 2003.

Hire Now