SUMMARY

• 6+ years of experience as database admin on Oracle 10g/11g/12c.
• ROUTINE - design, install, create& testing databases. Solving tickets, Refresh data by exp/imp. Debugging scripts. Troubleshooting issue on databases and applications. User, space, objects and memory management.
• RAC - Implementation & admin of 10g/11g RAC on Linux & SOLARIS. ASM, OCFS, RAW devices, load balancing, inter instance parallelism, add/remove node. Troubleshooting & Admin ASM. Apply patches. RCA of resource failure issues.
• UPGRADE - 10g /11g. Apply security/PSU patches. Validate database structure. Troubleshoot failed component in upgrade process. Upgrade ASM and RAC from 10g to 11g.
• MIGRATION - 8i to 10g to 11g databases plus applications, cross-platform using Data guard, data conversation. Maintain performance across all phase. Consolidate SQL SERVER & DB2 to oracle by migration workbench
• BACKUP - script, test and troubleshoot backup. RMAN, user managed, exp/imp, NetBackup. Optimize backup time frame & space. Restore database, datafile. Point in time recovery. Used Flashback technology. Clone database.
• TUNNING - Instance, database & SQL performance optimization. Using Explain plan, TKPROF, ADDM, AWR, v$ and dba views & HIST tables. Modify parameters, forcing index, hints, optimizing joins, sub queries, I/O & cpu utilization. Top sql/session, bottle-neck issues. Tune init parameter. Used RAT (Real application Testing) to simulate Load and SPA for performance analyze it. Full table scan and Index usage. Create performance baseline, comparing performance, Investigate Top activities, generate trend report of tablespace usage & estimate future growth.
• MONITOR - Errors, space, audit users, threshold and alerts by shell scripts, OEM, sql queries, logs and spool files. Setup & Admin grid control
• COMMUNICATION - developers, business analyst, users, release coordinator for development and performance issue. Review codes, scripts. Adopt business flow of application without KT.
• OTHER SKILLS - work 24 x7, weekends, late hours. Work in Team or as stand-alone person. Multi-tasking. Worked Confidential client site.

TECHNICAL SKILLS

DBA: RAC, ASM, RMAN, DATAGUARD, DATAPUMP, EXP, IMP, TKPROFPT, SQL Tuning & Optimization, Backup & Recovery.

O/S: SUN SPARC Solaris 5.9/5.10, Red Hat Enterprise Linux 4Windows NT, 2000

RDBMS: Oracle 8i, 9i, 10g, 11g, 12c

Tools: & Utilities OEM/OEM GRID, SQLPLUS, PUTTY, TOAD, X-manager.

PROFESSIONAL EXPERIENCE

Confidential, OH

Oracle Database Administrator

Responsibilities:

• Responsible for administrating and support of various Oracle Database version on Sun Solaris and Red Hat platform for GE Aviation.
• Analyze the current data management procedures in practice and suggest ways for automating the process or improving the existing system.
• Configuring and using the Oracle Enterprise Manager for Performance, Maintenance and Administration tasks. Suggest improvement on utilizing Enterprise Manager effectively for day to day tasks and alerts.
• Monitor and troubleshoot database backups, disk space, and database availability.
• Monitor and resolve database performance issue using OEM, Precise and under guidance of Performance DBA.
• Migrate database to different OS version and older database versions to higher version.
• Export and Import of Schema, objects and database using exp/imp and Data Pump utility.
• Implement and monitor user access and security.
• Respond to trouble tickets and change requests.

Confidential

Oracle Database Administrator

Responsibilities:

• Maintained and supported over 500+ databases on several Unix flavors and windows environment
• Installed and supported on Oracle 9i/10g/11g/12c databases having size in range 1TB-180TB along with Standby servers, Data Guard Setup, Configured Oracle Data Guard using physical standby database, active data guard Implemented RMAN Backups, Creation of catalog database in development and production environment
• Involved in implementation, installation of Oracle Infrastructure and Oracle RAC setup and troubleshooting the problems that are encountered in day-to-day activities.
• Installed the 11g/12c Grid Infrastructures
• Support for standby databases, failover, switchover etc.
• Experienced in upgrading databases from lower to higher version of oracle such as 10g to 11g, 9i to 11g, 11g to 12c.
• Experienced on database cross platform migration using data pumps, RMAN transportable table space.
• Cloned an Oracle database using RMAN /manual Cold and Hot cloning
• Regular Security patching on oracle products and interim patching for various bug fixes on databases
• Provided support using Oracle Enterprise Manager Grid Control and Agents
• Creation and managing Standalone and RAC databases, tables, views, indexes and other database objects
• Worked with several team members such as application, platform, middleware team to sort out the critical issues
• Provided On-call standby database support on rotational basis
• Performing database export/import using data pump.

Confidential

Oracle Database Administrator

Responsibilities:

• Perform Oracle DBMS software installation, (Oracle 10g Software on Solaris/Linux/HP-X/Windows/Linux/AIX), RDA reports, maintenance, upgrades, and patches.
• Performing oracle database upgrades from 9i,10g,11g to upper version
• Data guard Configuration and Managing Physical Standby configuration for Production and test environment.
• Performed failover, Switchover on standby environment.
• Monitor the Oracle DBMS growth and disk space utilization.
• Manage availability of the Oracle database instance and listeners.
• Administrating System DBA tasks of around 500 databases on various platforms (Solaris, Linux, HP-UX, and AIX).
• Successfully applied Oracle’s critical Security Patches (CPU) on various versions of Oracle databases.
• Taking Backup of Database using Export/ Import utility.
• Configured archiving and maintaining archived data.
• Performed online as well as offline backups.
• Controlling and monitoring user access to the database.

Environment: IBM P, Oracle 10g, 9x, 8.x, LINUX, UNIX, Sun Solaris