Sr. Oracle Dba Resume
2.00/5 (Submit Your Rating)
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.