SUMMARY

• A dedicated Oracle Database Administrator with more than 15 years’ experience working with complex technology platforms and sophisticated data management applications.
• Self - motivated, responsible and organized with the ability to effectively work in a fast-paced environment.
• Detail-oriented and proven ability to multi-task under pressure.
• Enthusiastic with a positive attitude, motivating co-workers towards excellence.
• Over 15+ years of Oracle (8.x/9.x/10g/11g/12c) DBA experience on various complex platforms
• Extensively worked on Oracle Database (11g/10g/9i), installation, patching, upgrade, cloning.
• Experience in Building ESM, BEIS, BEP, App Navigator, XE, CAS and EIS .
• Experience Building Banner HR XE (extensible ecosystem) Application.
• Experience in Upgrading Banner Application 8.5 to 8.8.
• Experience in using Application tool Oracle Enterprise Manager (Grid Control), DBArtison and Toad.
• Experience in using System Application tool Tivoli Email System and Autosys jobs monitoring system.
• Configured and Maintained Oracle High Available Dataguard using latest Fast Start failover feature.
• Installed CRS and Created database with Oracle 10g /11g RAC using ASM
• Experience in upgrading SAP Oracle 10g Dataguard databases to Oracle 11GR2 versions
• Extensively worked on UNIX shell scripting to automatic database operation
• Provided on call production support of various applications and databases (in-house and external
• SAP 11g Oracle Database upgrades - High Availability Dataguard environment
• Autosys R11 job implementation and scheduling for RMAN backups.
• Strategic backup/restore guideline and scripting using RMAN for online/offline backup.
• Team player, excellent analytical and inter-personal skill.

TECHNICAL SKILLS

Operating Systems: WINDOWS 2003/XP/2000/98/95, HP-UX 10.x / 11.0, 11.x, Sun Solaris10, IBM AIX 4.3

Languages: Oracle SQL, Oracle PL/SQL, UNIX Shell (ksh), Fortran, Visual Basic, HTML, Mat lab

Tools: & Utilities: Oracle Enterprise Manager, TOAD 8.6.1/9, DBArtision, SQL Navigator 4.4, ClearQuestWRQ Reflection, SQL net configuration, Export/Import, Recovery Manager (RMAN), Server Manager, Sql*Loader, Data Pump, RAC related utilities

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database/Application Administrator

Responsibilities:

• Upgrading SAP Oracle 10g Dataguard Databases to Oracle 11GR2 versions.
• Configuring and setting up RMAN for 11g Oracle databases.
• Setting up and scheduling Autosys jobs ((R4. 5 and R11) for RMAN backups.
• Installing CRS and building new 11g Oracle databases using ASM
• Applying CPU and Bundle Patches on SAP and Oracle databases.
• Supporting UNIX team to perform OS upgrade TL12, Power7, LVM and LPM activities.
• Worked with centralized Remedy ticketing system to do change and incidents management
• Database refreshes from higher to lower environments using RMAN and export /import.
• Monitoring alerts and taking proactive measure for smooth functioning of databases.
• DBA Coordinator for major Frame and microcode upgrade.
• Operational Readiness Testing (ORT) done on High Availability Production and Data guard Databases.
• Restoring a backup set onto an ORT Test Server and confirming that the restored.
• Verification that we are able to successfully fail over between High Availability Production systems
• Verification that we are able to successfully fail over between systems in different physical data centers.
• Site-to-site Failover testing could include any combination of Hard or Graceful Failovers done in either an Automated or Manual fashion based on the capabilities of the Application

Confidential, NY

Oracle Database Administrator

Environment: Oracle 9i/10g/11g Running on Sun Solaries, AIX, HP UNIX and NT Platforms.

Responsibilities:

• Performed Site Switch to avoid failover on RAC and DATA GUARD Environment
• Monitoring of Tablespaces usage and add or resize the data file base on needs.
• Cloning production databases for testing purpose.
• Monitoring Archive mount point and run the script accordingly.
• Performed crash and recovery process on production database for refresh purpose
• Building new Instance base on request
• Review/revise policies, procedures, standards for Quality Assurance department.
• Write complicated SQL query for QA team base on request
• Provided support of customers will include investigating, managing, resolving and escalating issues.
• Creates and maintains system documents and records, e.g. flowcharts, procedures, templates.
• Create Database objects (Table, View, Procedure) by using DBArtision Tool.
• Proactively monitoring database performance through Grid Control
• Export/import and cold backup regular bases for certain databases.
• Installed Oracle CPU and PSU patches (quarterly and other)
• Installed Oracle Enterprise Manager Agent on Oracle 9i and 10g servers.
• Create/Upgrade Database using the Database configuration assistant (DBCA)
• Monitoring Alert and if any issue, recommend appropriate solution.
• Creating and configuring databases by using Oracle Universal Installer (OUI )

Confidential, St.Louis, MO

Oracle Database Administrator

Environment: Oracle 9i/10g Running on AIX Platform.

Responsibilities:

• Monitoring of Tablespace usage, archive log directories and automated error notification
• Create Raw Devices base for RAC database on DBA team needs
• Export/import backup regular bases for certain databases schema level.
• Monitoring the Tivoli Email System, if any critical alert comes and find the solution
• Creating database copy (Refresh) for Production Training System users.
• Monitoring and analyzing oracle database user’s activities.
• Installed Oracle binaries and OEM agent on Oracle 9i and 10g servers.
• Installing, Creating and configuring databases using OUI and OEM Grid Control
• Proactively monitoring database performance and hit ratios on different components of the SGA including the shared pool, buffer cache, redo log buffer.
• Managing the security of the database by creating users and assigning appropriate roles and privileges.
• Taking Backups of databases using Logical (Export & Import) and Physical .
• Cloning production databases for test purpose.
• Performed Database refreshes from both hot, cold backups and RMAN.
• Tuning the database for performance improvements
• Installed Oracle CPU patches quarterly with full cycle.
• Created Database using the Database configuration assistant (DBCA) and Oracle Net Configuration assistant

Confidential, St.Louis, MO

Oracle Database Administrator/Developer

Environment: Oracle 9i/10g Running on HP-UX Platform.

Responsibilities:

• Supporting Production and Development databases in 24x7 Environments
• Performed database change management to record the changes on oracle database object level.
• Run the Stat package accordingly to obtain stat info on a particular table.
• Create and Deleting user account in Oracle database base on Managers Request
• Creating table, index, view and synonyms and partition for implementation team.
• Granting privileges to users by assigning appropriate Roles.
• Set up password for new user and reset the password existing user.
• Analyzing oracle database user’s activities by using TOAD tool.
• Monitoring Tablespace quota usage in the databases
• Export/import and cold backup regular bases for certain databases and schema level.
• Monitored database health using shell scripts and also using Oracle OEM Grid Control

Confidential, Newark, DE

Oracle Database Administrator

Environment: Oracle 9i/10g Running on HP-UX Platform.

Responsibilities:

• Create/Delete user account in Oracle.
• Granting/Revoking privileges through assigning appropriate Role to the user.
• Creating new schema and granting/revoking object privileges to user.
• Set up password for new user and reset the password existing user.
• Cold and Export/import backup regular bases for certain production databases.
• Verify the weekend backup log file for all databases whether there is any error messages.
• Monitoring database activity (role violation, Space quota usage for tablespace).
• Verify audit output report every day bases whether any suspicious activity happen.
• Installed and configured Oracle Enterprise Manager (OEM) Grid Control
• Cloning production databases for testing team regular bases.
• Creating the Table, View and Partition
• Maintain UNIX file system group for various databases.
• Monitoring memory, disk I/O and CPU usage and Alert Log
• Installed Oracle CPU patches.

Confidential, Rochester, NY

Database Administrator/Developer /Data Analyst

Environment: Oracle 8i/9i/MS Access 7.0, Visual Basic, HP UNIX Platform, Window NT.

Responsibilities:

• Set up password for new user and reset the password existing user.
• Managing the security of the database by creating users and assigning appropriate roles and privilege.
• Maintaining Database System for Budget department
• Supporting Budget team (by providing proper projected/actual data) to do regular activity.
• Using SQL* loader for data loading from flat files.
• Monitoring Alert Log files and Tablespace usage in the Oracle Databases.
• Upgrading the Oracle Databases.
• Monitoring log files for evidence of any errors or any unusual activities.
• Cloning production databases for testing team monthly bases.
• Provide Technical Support for Employees to handle the routine jobs.
• Developed/Maintained Student Information system to monitor student activities.
• Interfaced with design managers, designers, and system users for ER logical Model and physical data model .
• Creating database objects ( Table, index, view and synonyms and partition )
• Managing Position Management FTE interface file and developing professional reports for the budget process