SUMMARY:

• Certified Senior Oracle Database Administrator with over fifteen years of extensive experience in logical/physical design of Oracle database, database maintenance, backup/recovery strategy, disaster recovery and performance tuning.
• Forward - thinking professional with strong skills in researching and implementing Oracle 10g, 11g RAC/ASM and dataguard solutions on various platforms such as Solaris, AIX and Linux to provide high availability and scalability of applications.
• Support Company with all new technology changes that improved productivity.

SKILL:

Platform: Solaris 2.6, 2.8, 10, IBM AIX 5.3/6.2, Linux 6/7, Windows 2000

Languages: SQL, SQL*Plus, PL/SQL, Unix Shell Programming

Databases: Oracle7, Oracle8i, Oracle9i, Oracle10g, Oracle 11g, Oracle 11gR2 with RAC/ASM and DATAGUARD

Tools: Oracle Enterprise Manager 10g/11g, Grid Control, AWR, ADDM, ASH, TKPROF, EXPLAIN PLAN, SQL*Loader, Import/Export, SQL*Net, DB verify, RMAN, RAID technology (mirroring and striping), SQL-Backtrack, Netbackup, FDR Upstream, TOAD for Oracle. GoldenGate and SHAREPLEX

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Senior Oracle Database Administrator

Responsibilities:

• Supported critical bank applications. Designed database infrastructure and provided 24x7 support, including production, testing and development database systems running Oracle RDBMS versions from 9i to 11g R2 with RAC/ASM and dataguard. Worked with business and system administrator group on database capacity planning and storage design. Assisted application developers on performance tuning and optimization. Maintained database security.
• Installed, configured and built Oracle 10g/11gR2 2 to 3 nodes RAC databases with ASM on Unix/Linux operating systems to improve application scalability.
• Upgraded/migrated RAC database from 10g to 11gR2 and platform from AIX to Linux.
• Installed, configured and built oracle 10g/11gR1/11gR2 active/passive OS cluster databases which provided high availability of application.
• Designed and implemented RMAN, SQL Backtrack backup/recovery strategy to prevent data loss.
• Performed flashback database to point in time per business requirement
• Set up physical standby database with dataguard broker for data protection and disaster recovery on both single and RAC database.
• Tested disaster recovery strategy with dataguard switchover or flashback
• Controlled and monitored user access to the databases which maintained system security
• Restored Oracle 10g/11g databases from Solaris to AIX with RMAN restoration which minimized downtime during the server migration.
• Migrated Oracle 10g/11g RAC databases from file system to ASM with RMAN restoration.
• Used OEM grid, SQLTrace, AWR report, ADDM, ASH, EXPLAIN PLAN and various SQL scripts to monitor database performance and identify problematic SQL statements
• Wrote shell scripts that proactively monitored database and server space usage, alert log for Oracle errors, database activity and server load
• Provided daily support to application development team which kept team more productive
• Worked with system administrators in the planning and configuring of new hardware ensuring requirements were met.
• Documented system problems, database errors, and their solutions for future reference
• Upgraded databases from 9i, 10g to 11g R1, 11g R2.
• Installed, configured and maintained GoldenGate on oracle 10g database.

Confidential, Newark, NJ

Responsibilities:

• Managed, supported 24 X 7 production database for Oracle 9i/8i on Sun Solaris 2.6/2.9 and Window 2000 and provide full DBA support for production database as well as standby database, replication Database.
• Designed and implemented the company reporting system using SHAREDPLEX.
• Installed, configured and upgraded oracle database 9i/8i/8x supported company reporting database (OLAP) (over 1000GB), online- transaction database (OLTP) (over 600GB), and the other databases such as Carrier Server database, foglight database, Brix database, Remedy database and so on.
• Analyzed and implemented database backup/refreshing/disaster recovery strategy with SQLBacktrack/SHAREPLEX and scripts (Unix, and Window 2000)
• Setup, maintained, and failed over Standby database (Physical)
• Built and implemented the general monitoring scripts for database space checking (DB level, and
• OS level), database connection checking, Archive log files removed, etc.
• Lead performance monitoring and fine-tuning of the system for optimal performance,database Tuning, Application Tuning (SQL tuning), and database reorganization.
• Installed/configured/Used application tools (Quest Software, BMC, and OEM): SPORTLIGHT, FOGLIGHT and OEM used as an aid for monitoring production database to check all kinds of alarms, alerts and messages. SHAREPLEX used as for replication of on-line transaction database and partial reporting database. SQLBACKtrack used for database backup and recovery.
• Third-Party Application software install and upgrade: BRIO application for reporting group (Hyperion )BRIX WORX application for Voice line group.

Confidential, NY, NY

Responsibilities:

• Data modeling, logical and physical database design.
• Oracle installation/configuration.
• Database creation, storage management, security management, and database tuning/ query optimization.
• Designed and implemented backup/ recovery procedure: hot backup, cold backup, and export/import
• Setup database monitoring scripts for checking trace file, free tablespace, extents, locks etc.
• Heavy development supported for reviewing trigger, store procedure, package etc.
• Used Oracle’s Enterprise Manager for SQL tuning, schema and storage analysis.
• Provided on-call support for multiple Oracle databases.

Confidential, Wayne, NJ

Responsibilities:

• Maintaining and modifying current manufacture database system-using Oracle 7.3.4, SQL*PLUS 3.1/3.3, PL/SQL 2.0/3.3, Developer/2000 tools: Oracle 4.5/5.0, Oracle Report 2.5 on Unix Sun Solaris 2.6 environment.
• Designed and developed system and application monitor programs using shell script, SQL and PL/SQL to check oracle alert log file, Oracle Export log file, free tablespace, locks, connection and etc,.
• Installed, migrated Oracle RDBM 7.3.4, to 8.05, 8.1.5 and other oracle application tools.
• Participated in data modeling, logical and physical database design for oracle projects.
• Designed and implemented database backup and recovery procedure such as hot backup, cold backup, archive backup and Import/Export.
• Developing web application using HTML, CGI Perl script, and SQL script.
• Developed oracle forms for company inspection and calibration system, involved in Oracle Form module coding and testing.
• Using SQL*Plus to write on SQLPLUS reports for company incoming inspection systems.
• Using Perl to develop reports for company’s vendor on-time delivery system.
• Using CGI, Perl and HTML to develop the company web page for Q.A and Purchasing Department.
• Using Oracle utility SQLLOADER to populate data from Mainframe to Oracle database
• On-line technical support for end users and application software problems.