Objective

• Oracle RAC DBA seeking opportunities to apply expertise toward solving large, complex IT challenges.
• Ability to utilize over 4 years of experience in Information Technology and System Analysis to design, develop and implement IT solutions.

SUMMARY

• 4 years experience as ORACLE RAC DBA administrating Oracle 11g, 10g, 9i.
• Extensive hands - on experience in performance tuning, backup/recovery using RMAN and space management for large databases in Production, Testing and Development environments.
• Skilled in high-volume workflow with creative problem resolution skills.
• Experience includes design, development, implementation and production support for ERP PeopleSoft (HRMS and FINANACE).
• Experienced in troubleshooting, inter-departmental coordination and time management.
• Consistently promoted to positions of greater responsibility.
• Production maintenance and 24x7 support for High availability (RAC) systems.
• Worked to secure database for SOX by implementing roles, profiles and Oracle’s best security practices.
• Worked in project organizational, architecture design and technical management background from development to production.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, Java, Visual Basic, UNIX Shell Scripting.

RDBMS: Oracle 11g/10g/9i, SQL Server 2000, MS Access.

Operating System: UNIX, Solaris, HP-Unix, AIX5L, Linux, Windows, MS-DOS.

Web Development: XML, HTML, ASP, JSP.

Tools: SQL*PLUS, TOAD, PUTTY, OEM Grid Control, RMAN, External Tables, Imp/Exp and Data pump, SRVCTL, ASM.

PROFESSIONAL EXPERIENCE

Confidential

ORACLE Core DBA

Responsibilities:

• Working with clients (fortune 500 companies) to resolve their Oracle Database issues
• Responsible for administering day to day operations of all Oracle databases.
• Primarily responsible for creating, maintaining, and managing highly visible production databases.
• Responsibilities also included installing, upgrading, patching, tuning, monitoring and troubleshooting.
• Databases with large amounts of data and high transaction rates.
• Resolved performance issues via AWR, ADDM, and ASH.
• Tuned Databases by resizing SGA, PGA, redo logs, Temp and undo tablespace.
• Identified Blocks, locks, waits and maintained statistics of the database and tuned them.
• Applied both patches (CPUs and RDBMS) when appropriate.
• Participated DBA Team in all change management meetings to provide DBA input.
• Implemented any ad hoc changes to database data.
• Configured Dblink to get data from the remote databases.
• Monitored disk spaces (track and trend space utilization). And Raid level recommendations.
• Created new RAC Databases whenever needed.
• Configured RMAN as backup method for Oracle.
• Refresh dev/test databases via RMAN Duplicate /EXP/EXPDB .
• Utilized UNIX shell scripting and cron/scheduler to perform Automation of system related daily tasks.
• Manage standby databases.

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Provided production DBA support to clients and created new databases.
• Worked with Platforms: Solaris 5.9, Sun V-490 (4 X UltraSPARC-1V 1.35 GHz), Linux.
• Used Database: Oracle (9.2.0.8) / (10.2.0.2).
• Supported Java developers for ongoing physical and logical modifications to existing systems, issues/errors and bugs.
• Participated on the DBA Team in all change management meetings to provide DBA input.
• Administered day to day operations of all Oracle databases such as tablespace space, index and table fragmentation
• RAC Database creation, review and research of appropriate database configuration parameters.
• Tuned Databases by resizing SGA, PGA, redo logs, Temp and undo tablespace.
• Ensured the high availability by proactively monitor and optimize oracle database infrastructure through Grid control, ADDM, AWR, ASH and other tools or sqls.
• Applied both patches (CPUs and RDBMS) when appropriate.
• Implemented parallel execution for performance and created views for performance and security.
• Handled the Backup, Recovery and Refresh planning for a RAC database and implemented using RMAN.
• Wrote UNIX shell & SQL scripts for ease in DBA tasks and to automate the batch processes.
• Used SQL*Loader and new features of 9i to load data such as External tables.
• Troubleshot processes from start to finish by setting events 10046 and using TKPROF.
• Monitored CPU usage, I/O contention, memory paging on UNIX server.
• Implemented table partition for manageability and performance.
• Identified locks, waits and maintained statistics of the database and tuned them.

Confidential, Mequon, WI

(Internship) DBA

Responsibilities:

• Installed and created Oracle 9i, 10g Databases on Windows / Linux servers.
• Performed regular maintenance and performance tuning on Oracle 9i, 10g database.
• Providing maintenance of user accounts, privileges, profiles and roles.
• Managing undo segments, processes, memory, online redo log files, data files.
• Creating logical and physical design; installing and upgrading databases.
• Performed monthly maintenance and performance tuning on database.
• Setting off initialization parameters, and configuring online redo logs.
• Created primary database objects such as tables, views, and indexes.
• Knowledge of the database security by granting of roles and privileges to the users.
• Setting up logical / physical backups for these databases.
• Depending upon the nature of the database, setup of either full export, partial export or export of just structure of schema objects and cold or hot backups.
• Managed the disk space, data blocks, extents, data segments, index segments, temporary segments.
• Monitored the alert logs and trace files and mirrored the control files and multiplexing the redo log files.
• Killed long running queries that may have caused database to slowdown.
• Research options of better performance tuning, backup, validation, and restores.
• Assisted windows admin to create and run scheduled tasks do daily maintenance, and backups.
• Research RMAN to do backups on multiple databases.