SUMMARY

• Accomplished, results driven, analytical and Consultant with over 7+ years of IT experience and Software Development, Oracle D Confidential base Administrator, Infrastructure design and system implementation specialist in a large enterprise setting, supporting disaster recovery and high availability
• Demonstrated track record in assisting and leading solution delivery in resolving clients and customers issues on multiple projects across multiple industries
• Experience in installations, planning, configuration, deployment, d Confidential base security and supporting production and non - production environment
• Experience implementing and managing Oracle RAC/ASM/standby D Confidential Guard on 10g, and 11gExperience maintaining d Confidential base including d Confidential base security, capacity planning, monitoring, and performance tuning I/O, Memory & SQL Tuning etc.) Using Stats pack, Explain plan, ADDM, TKPROF and analyzing AWR report
• Experience in upgrade, regular security patching, interim patching for various bug fixes on d Confidential base products and upgrading all Oracle software
• Experience implementing backup and recovery and disaster recovery strategy, VMware Administration
• Experience in troubleshooting Oracle d Confidential base issues, and modifying Store Procedures (SQL scripts, DBMS packages), Job scheduling
• Knowledge of ETL and experience writing import SQL scripts providing efficient IT service support, improving business IT operation through IT service delivery, Program/Project Management

TECHNICAL SKILLS:

RDBMS: Oracle 10g/11g,, MS Access, MS SQL server 2008

Languages: SQL, PL/SQL, HTML, UNIX Shell Scripting, Ksh, bash

Operating Systems: Linux (Redhat Linux, SUSE), Windows 9X/XP/NT

Utilities: SQL*PLUS, Putty, UNIX Shell Scripting, MS Office Suite, OEM, SQL*Loader, ETL, Oracle Business intelligence (BI), Oracle JDeveloper, SQL TRACE, Remedy ticketing system, Explain Plan, RMAN, OEM, TKPROF, STATSPACK, AWR, and ADDM

Environment: ASM, UNIX, Sun Solaris 10, HP-UX 11 (64 bit), Confidential AIX 5.0, Enterprise Linux 5.0

PROFESSIONAL EXPERIENCE:

Confidential

AscensionOracle DBA

Responsibilities:

• Provided support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/D Confidential Protector, trace analysis, service creation, cluster and system management
• Maintained and supported Client’s d Confidential bases including daily monitoring, resolved performance related issues via table partitioning, indexing, instance tuning and performance analysis using ADDM, analyzed AWR report
• Provide support for Oracle Enterprise Manager Grid Control and Agents
• Implemented and supported highly available RAC clusters for companywide single sign on application,
• Experience in capacity planning/management, monitoring of d Confidential base space and estimating growth requirements
• Implemented D Confidential base backup and recovery and logical (Hot/Cold) backups Oracle backup utility such as RMAN
• Managed high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.
• .Experience performing Backup and recovery using RMAN complete recovery, tablespace recovery and controlfile recovery

Confidential

Oracle DBA

Responsibilities:

• Provided KT (Knowledge Transfer)/ workshop sessions to Clients technical and customer management team
• Designed and implemented d Confidential base security schemas (grant/revoke/users access) installed routine security related patches
• Performed installation, configuration, created d Confidential base objects, users with appropriate roles and maintained d Confidential base instances

Confidential

Oracle DBA

Responsibilities:

• Implemented Security administration by creating of roles, views and granting the necessary object/system privileges for users
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on d Confidential bases. This include checking if the Listener is running, optimal running of all d Confidential bases, Unix error messages, disk space availability, document problem resolutions
• Upgrade Family Single Multipricing application from Oracle 10g, JDK 1.5, Weblogic 9.2 to Oracle 11g, JDK 1.6 and Weblogic 10.3 respectively
• Edited the property files for Development, Testing, Acceptance and Production to run upgrade the Single Multifamily Pricing application for 20 million clients for the Mortgage and loan processes for Confidential
• Deployed the Development and Testing environment of the MultiPricing Single Family application on local machine, checkout code into CVS and migrated to Weblogic Servers for Testing
• Assisted in the starting and re-starting of Servers for the deployed Development and Testing environment to Linux machines before moving to Acceptance and Production environments

Confidential

Oracle DBA

Responsibilities:

• Efficient in sending daily operational report to the top management regarding the whole operation of the day, including any hitches and making recommendations
• Performed d Confidential base monitoring and space management, reviewing and implementing schema design
• Experience in maintaining referential integrity in application SQL, stored procedures, and triggers.

Confidential

Oracle DBA

Responsibilities:

• Monitor and support Backup and Recovery (point in time recovery)using RMAN, D Confidential pump (Import and Export) utility
• Monitored Oracle trends for hardware usage and user load (OEM, AWR report)
• Wrote and modified Stored procedures, complex SQL queries for d Confidential extraction from SQL Server
• Technical SupportAug 2006