We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

FL

SUMMARY:

  • Oracle Database Administrator with 2 years of experience in Oracle Administration in planning, installation, configuration and upgrades of Oracle 11gR2 databases, Experience includes managing Oracle 11gR1, 11gR2 RAC environments using the OEM Grid Control tools.
  • Experience includes Oracle Utilities Data Guard, Data Pump, Flashback and RMAN. SQL.
  • Good experience of setup & configuration, implementation of (Oracle 11gR2 RAC two - node on Linux with ASM).
  • Extensive knowledge on database administration for Oracle 11g,12c and with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
  • Engineering, implemented, documented and support builds of new clusters to use Oracle 11g/12c RAC on HP-UX, Solaris, IBX-AIX and Unix/Linux. Including installing cluster ware, ASM (and shared disks) and creating new databases.
  • Expertise in upgrading the databases from Oracle 10g, Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
  • 24*7 production database support with Support to developers & end-users.
  • Experienced in Installation of high availability RAC environment and upgraded standalone databases to 11g RAC environment.
  • Expertise in Configuring, maintenance of Data guard in RAC environment and standalone environments.
  • Managed very large database (VLDB) of maximum size 32TB.
  • Managed and provided support for 67 production databases.
  • Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing Environments.
  • Implemented RMAN backup (Full, incremental and cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
  • Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
  • Involved in Monitoring, Optimizing Oracle database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, CBO, TKPROF, EXPLAIN PLAN and SQLT.
  • Good with concepts of Database Links, Materialized views, Flashback Technology, Partitioning Tables to improve Performance and Manageability.
  • Hands on experience in Data Archiving
  • Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
  • Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user table space across Oracle databases.
  • Good experience in applying Patches (Patching), Critical Patch Update(CPU)/Patch Set Update(PSU) and One-off Patches using OPatch and run installer, also involved in Upgrading and Migration of a Oracle server to higher version available.
  • Effective troubleshooting of database and Performance problems.
  • Good experience in Data Migration using export/import.
  • Prepared DBA work plans, Documented Client site’s “Site specific work procedures”, Change Management and control, Best Practices and did Capacity planning for clients.
  • Management of Objects, Schemas, Partitioning the tables and Indexes.
  • Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
  • Expertise in using OEM, SQL Developer and third-party tools like TOAD.
  • Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.

TECHNICAL SKILLS:

Operating System: UNIX, LINUX, Solaris, AIX, HP - UX and WINDOWS NT/2000, XP.

RDBMS: ORACLE 12c/10g

Oracle Tools/Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * LoaderAWR, ADDM, OEM, Sql Server.

Languages: SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE:

Confidential, FL

Sr. Oracle DBA

Responsibilities:

  • Worked on refreshing production databases on sandbox for application testing using export/imports and RMAN active duplicate.
  • Performing Backup/Restore of all the Oracle databases using RMAN.
  • Provided on call support for every 3 weeks and provided support on weekends.
  • Worked on Real application testing to have access the work load before migrating and upgrading production databases.
  • Supported mission critical databases and extensively involved in resolving the performance issues.
  • Worked on implementing standard RMAN backup policies and successfully was able to restore huge database when required.
  • Provided support for 3 Oracle Exadata machines - Prod, DR, QA - to be used for mission critical applications.
  • Managed and resolved RAC (10g, 11g), ASM and cluster ware issues.
  • Management of schemas, objects partitioning the tables & indexes.
  • Worked on refreshing the QA databases with PRODUCTION backups.
  • Developed scripts for monitoring Tablespace sizes, alert log files, Tablespace growth and implemented Crontab job to alert if the tablespace size exceeds above 80%.
  • Responsible for taking backup of schemas, tables and table spaces using Oracle 11g Data pump.
  • Experienced in developing shell scripts for deleting old file.
  • Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
  • Worked on database upgrade from 11.2.0.3 to 11.2.0.4.
  • Experienced in performance tuning on long running query’s in database.
  • Very good experience in using performance tuning tolls like SQLT,SQLHC.
  • Experienced in backups, restores, indexes, key structures and data loading.
  • Worked on data blocks corruption issue, index & table rebuild.
  • Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
  • Providing Solutions to the Problems Faced by end Users or Programmers.
  • Strong knowledge of Oracle internals, tools including DBMS jobs, RMAN, SQLPlus, export/import, Toad, Oracle Enterprise Manager (OEM).
  • Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.

Environment: Oracle 11.2.0.3/11.2.0.4 , Exadata X4/X5 Quarter/Half/Full RACK, OEM 12c, LINUX, IBM AIX, TOAD,SQL Developer.

Confidential, NJ

Oracle DBA

Responsibilities:

  • Provided 24*7 Support for Production environment for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment.
  • Design Evaluation and Analysis of physical and logical model.
  • Involved in Installation and customization of Databases (10g&9i) in Windows, Linux and Solaris environments.
  • Involved in Schema management, Tablespace Management, User Creation.
  • Monitoring the Extraction and loading processes of Data.
  • Upgraded and applied patches as and when required on 8i, 9i, 10g.
  • Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.
  • Responsible for Oracle implemented backups like LOGICAL&PHYSICAL i.e. Export & import and having experience with EXPDP&IMPDP.
  • Implemented Consistent exports using SCN.
  • Good experience with recovery managed backups i.e. RMAN.
  • Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
  • Documented the complete project including all pre-installation, post installation and database configuration steps.
  • Manage users, privileges, profiles, schemas, involved in writing UNIX shell scripting for automating the jobs.
  • Experience in using automatic monitoring and management processes like batch processing using CRONTAB for processes like import, export databases.
  • Used analyze table, analyze indexes to tune queries and increase performance.
  • Experience with SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
  • Tuning Oracle 10g database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Confidential

Oracle DBA

Responsibilities:

  • Involved in 24x7 Oracle Production Database Administration.
  • Performing all the Database Administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup & recovery, space management in database, user and roles administration, schema management.
  • Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
  • Monitored Production Databases, performed performance tuning, added data files, resized segments, and tablespaces.
  • Installed and configured Oracle 11g.
  • Migrated Oracle 10g database to Oracle 11g.
  • Storage and space management including table spaces and data files.
  • Monitoring Database for fragmentation and correcting them.
  • Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan.
  • Monitoring and Management of table space growth, extent growth.
  • Planning and implementation of Backup and recovery procedures and Maintenance of Database.
  • Performed Backup/Recovery using RMAN.
  • Wrote scripts for Startup, Shutdown and automation of backups.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
  • Prepare the documents of the process and knowledge transferring about the project to the new team members.
  • Involved in the process of tuning and refining queries of various applications.
  • Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
  • Interfacing with Oracle Corporation for technical support.

Environment: Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting.

Hire Now