OBJECTIVE:

Oracle database administrator in a challenging environment

SUMMARY:

• Fifteen plus years of Oracle DBA experience in production support environments
• Expertise in RAC, system and database performance tuning, backup and recovery, physical and logical design
• Solid knowledge of SQL, PL/SQL, stored procedures, packages, and triggers
• Ability to diagnose problems and resolve issues across various tiers (application, network, database, server or storage tiers)
• Strong verbal and written communication skills with team player mentality

COMPUTER PROFICIENCY:

Database feature: RAC, client - server, AMS, data Guard, data warehouse

Performance Tuning: database tuning, SQL tuning

Disaster recovery: data guard, SRDF

Backup and restore: RMAN via netbackup , Tivoli, SQL Backtrack

Scripting: SQL, PL/SQL, KSH and DOS

Database lifecycle: modeling, architecture, installation, upgrade, migration, deployment, refresh

Security: PSU patching, TDE, auditing

Database product and utilities: Oracle Grid, OEM, Solar Wind, SQL loader

Platform: Linux, AIX, HP-UNIX , Sun Solaris, Window MSSQL Server 6.5, 2000, 2005, 2012 ERWin , DBVisit , Documentum, Weblogic, Teamsite, Crystal Reports, Siebel , EMeta, BMC patrol , BCV, SRDF, Peoplesoft and Shareplex Oracle scheduler, cron, at, autosys, maestro, remedy ticket

EXPERIENCE:

Confidential, Roseland, NJ

Oracle Database Administrator

Responsibilities:

• Configured, built and maintain 12.1.0.2 RAC databases on ASM.
• Tuned performance bottlenecks by analyzing SQL statements, creating indexes, using hint, tuning database parameters and using SQL profiles and so on.
• Led an effort to plan, design, and implement Oracle upgrade from 11.2.0.4 to 12.1.0.2.
• Created and managed data guard. Perform business contingency test by snapshot standby and switchover using data guard broker.
• Tightened Oracle security by PSU patches, TDE and auditing.
• Used ERWin for data modeling. Worked on logical design, database normalization, physical database design and implementation.
• Worked on remedy system for ticketing/work-flows.
• Exceptional team attitude and ability to work independently with strong initiative.
• Excellent communication skills in both verbal and written to liaise with various teams in the organization.
• Collaborated with offshore team on routine database support related activities.

Confidential, Piscataway, NJ

Oracle Database Administrator

Responsibilities:

• Installed, configured and maintained RACs on ASM.
• Analyzed and created solutions for challenging performance-tuning situations at system, database, and SQL statement levels. Refreshed non-production environments using different methods such as RMAN, data pump and transportable tablespace. Optimized backup strategies.
• Developed complex database objects like stored procedure, functions, packages and triggers using SQL and PL/SQL.
• Performed complete recovery and incomplete recovery.
• Maintained transparent data encryption (TDE). Used TDE with Encrypted columns and Data Pump.
• Implemented shell and DOS scripts to automate database monitoring and reporting.
• Created/cloned MSSQL databases. Daily monitored on SQL Server activity, error logs, and NT event logs. Backed up and restored SQL database. Monitored and optimized SQL Server performance. Scheduled and managed jobs on MS SQL Server.
• Orchestrate meeting with leads/upper managers and guide staffs.

Confidential, Somerset, NJ

Oracle Database Administrator

Responsibilities:

• Built and supported both logical and physical standby databases. Maintained large data warehouse up to 2.5TB with partition and compression.
• Worked on database RMAN backup to tape through BCV split.
• Monitored long running queries and provided performance tuning.
• Refreshed data through stream, shareplex, BCV split, and data pump.
• NACLC/SF-86 security clearance to be able to work on government project.

Confidential, Bridgewater , NJ

Oracle Database Administrator

Responsibilities:

• Managed client-server, RAC, data guard, and data warehouse databases.
• Installed and configured two nodes RAC with ASM in 11.2.0.2 Version on Linux.
• Supported SOX-compliance databases. Familiar with release management, incident management and change management.
• Developed and implemented database backup with RMAN through Netbackup to tape.
• Managed offshore team on database patching, upgrade, and storage migration.

Confidential, Warren, NJ

Oracle Database Administrator and SQL Server Database Administrator

Responsibilities:

• Created and maintained Oracle RAC databases in Solaris.
• Backed up database with RMAN or SQL BackTrack. Refreshed non-production databases via various techniques, such as data pump, RMAN clone, SQL BackTrack cross-node restore, and BCV split.
• Upgraded database from 9i to 10g to 11g.
• Performance tuning at database and statement level. Provided SQL tuning advice to application team.
• Managed data warehouse database. Supported large database with size of 2TB.
• Utilized partition and compression. Exposed to ETL tools.
• Migrated data from MSSQL Server to Oracle with transparent gateway. Shared the documentation with team member.
• Involved with SQL server installation, configuration, backup, recovery, monitoring and performance tuning.

Confidential, New York, NY

Oracle Database Administrator

Responsibilities:

• Expert knowledge of hands-on database administration.
• Experience in logical design, database normalization and physical database design and implementation using ERWin.