OBJECTIVE

• An accomplished Database Administrator with demonstrated success designing and implementing database solution dat improve business functionality.
• Possess diversified technical background with Enterprise System Solution.
• Proven ability to implement technologies dat decrease costs, increase performance and positively affect teh bottom line.

SUMMARY

• 7+ years of IT experience as Oracle Database Administrator Ver. 8.0/8i/9i/10g/11g (RAC and NON - RAC) on a variety of UNIX (SOLARIS, HP - UX, AIX), Windows NT 4.0/2000/2003 with Oracle (8.0/8i/9i/10g/11g), stored procedures, DB triggers, Developer 6i/9i, Forms 4.5 & 6i/9i and Reports 2.5& 6i/9i, SQL *Plus etc.
• Installation and Configuration of Oracle 10g and 11g Real Application Clusters (RAC) with 4 nodes with Automatic Storage Management (ASM).
• Worked on third party replication tool called shareplex (Quest). Has done configuration, installation and upgrades..
• Proficient in Oracle DBA activities such as Upgrades, Patches, Cloning, Backup and Recovery, Performance Tuning, Capacity Planning, Script development and documentation.
• Planned and implemented DR & high availability solutions using Oracle 10g and 11g standby Database using Oracle Data Guard
• Experience in Glodengate, Multi-Master Replication setup, configuration and maintenance of replication process.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development team. Extensive familiarity with tuning tools like Oracle Enterprise Manager’s (OEM), SQL Analyzer, performance manager etc., Stats pack, TOAD. For SQL tuning using “Explain plan”, “TKPROF”, “SQL TRACE”, Optimizer modes, using optimizer hints gathering statistics etc.
• Delivering Oracle Database performance tuning for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, ADDM, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring
• Experienced in using 10g features Data Pump, Flash-Backup Recovery, AWR, ASM, ADDM, 10g and 11g Grid Monitoring, Recycle Bin
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN.
• Planning, Scheduling and taking Oracle Backups.
• Proficiency in SQL and PL/SQL programming. Includes creating database objects like creating tables, views, indexes, constraints, sequences, functions, procedures, packages, triggers, PL/SQL blocks, partitioned tables etc.
• Highly organized and dedicated with a positive attitude.
• Excellent communication and interpersonal skills.
• Willing to relocate and able to work independently and in a team.
• Having an Attitude of willing to learn, accept teh challenging environments.
• Confident in delivering teh results at teh said duration by constantly motivating teh concerned teams to provide teh best solutions to teh clients

TECHNICAL SKILLS

RDBMS: Oracle 8.0,8i, 9i, 10g, 11g(RAC and NON-RAC)

Database Experience: Database Server Tuning and Sizing, Application SQL Tuning, User- Space Management, Backup/Recovery Techniques, SQL *Net Configuration

Tools: RMAN, OEM, ASM, SQL *Loader, EXP, IMP, Expdp, Impdp, TOAD, Aqua data, DB Artisan

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

Languages: C#, VB.NET, VB, C, C++, COBOL

Web Technologies: Web Services, ASP.NET, JavaScript, VBScript, HTML, DHTML, CSS, and XML.

Scripting: ASP, VB Script, Java Script

Web Servers: IIS 3.0/4.0/5.0, Java Web Server 2.0

.Net Technologies: C#. NET, ASP.NET, VB.NET, ADO.NET

Application Servers: Microsoft Commerce Server

Protocols: SOAP, HTTP, TCP/IP, and SMTP

Operating Systems: HP-UX, MS-DOS, Windows 9x/XP/NT/2000/2003 Servers, UNIX, LINUX

Version Controls: Visual Source Safe Dimensions

Methodologies and Tools: Crystal Reports

Documentation Tools: MS Visio, MS Office

Third Party Software: Shareplex 6.x, 7.x

Replication: Multi Master replication, Glodengate

PROFESSIONAL EXPERIENCE

Confidential, Ashburn, VA

ORACLE DBA

Responsibilities:

• Installing and upgrading Oracle databases from 10g to 11g and also applying latest patches.
• Working with DEV team to rectify teh sql’s for better performance.
• Using dataguard for disaster recovery and replication techniques such as glodengate for replicating data into different sites.
• Building RAC and creating multiples instances according to various specifications and requirements.
• Work with oracle support on severity 1 issue at an expedited speed in 24x7 mission critical production environment.
• Scheduled shell scripts to generate AWR reports and send across teh Dev and Production team to check teh database performance timely.
• Doing weekly releases to fix code issues
• Doing regular database refreshes in staging and test environments using RMAN and datapump techniques.
• Implementing and troubleshooting dataguard and replication (glodengate) issues.
• On-Call support as part of regular production support work.
• Exclusively worked on backup and recovery techniques.

Confidential, Dallas, TX

ORACLE DBA

Responsibilities:

• Installation, configuration Oracle software, created databases and upgraded databases from different version to 10g/11g. Created databases on RAC and NON-RAC environments including different platforms like Windows, UNIX (SOLARIS, HP-UX, and AIX), and LINUX.
• Worked on Informix databases from converting teh data to Oracle.
• Building new databases by giving teh hardware and software specs.
• Migrating standalone database to RAC environments across different OS platforms.
• Performing data extracts and data mapping across different RDBMS.
• Installing and upgrading shareplex third party software for replication.
• Applying CPU patches using OPatch utility every quarter.
• Managing teh database's storage structures including configuring ASM and its associated components.
• Managing users and security includes audit vault and database vault.
• Managing schema objects, such as tables, indexes, and views according to teh application requirements.
• Supported Development teams by writing PL/SQL programming and in creating Functions, Procedures, Packages and Triggers.
• Proactively monitoring teh database's health and taking preventive or corrective action as required.
• Monitoring and tuning performance.
• Making database backups and performing recovery using regular EXPORT ULTILITY, SQL-BACKTRACK and RMAN.
• Setting up physical and logical standby database for primary database on RAC and NON-RAC environments.
• Setting up administrative scripts for analyzing, gathering stats etc.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 24x7 production support when required.
• Refreshing databases for development and test teams using RMAN, SQL-BACKTRACK, EXPORT and IMPORT utilities.
• Restricting unauthorized database access using logon triggers.
• Support for application teams in promoting database changes for every release.
• Installing and configuring OEM (Oracle Enterprise Manager) and Grid Control. Performing administrative tasks using OEM. Used Oracle Enterprise Manager (OEM) for database monitoring, job scheduling etc .Installing and configuring required for deploying agents and different OS platforms.
• Recovered database objects using Flashback query and knowledge in Transportable table space, Data Guard, Real Application Clusters (RAC).
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for monitoring database performance.
• Installing, configuring and troubleshooting oracle Multi-Master replication. Efficient handling for Multi-master Replication with 4 master sites.
• Build RAC from teh scratch. dis including configuring OS for RAC install, raw or blocked devices used for storage, Installing CRS, ASM, Creating ASM Disk Groups, Installing RDBMS binaries and upgrade all teh components as needed. Configuring RAC services according to application requirements. Configure ONS for RAC clusters.
• Work with oracle support on severity 1 issue at an expedited speed in 24x7 mission critical production environment.

Confidential, Ashburn, VA

ORACLE DBA

Responsibilities:

• Installation, configuration Oracle software, created databases and upgraded databases from different version to 10g/11g. Created databases on RAC and NON-RAC environments including different platforms like Windows, UNIX (SOLARIS, HP-UX, and AIX), and LINUX.
• Applying CPU patches using OPatch utility every quarter.
• Managing teh database's storage structures including configuring ASM and its associated components.
• Managing users and security includes audit vault and database vault.
• Managing schema objects, such as tables, indexes, and views according to teh application requirements.
• Supported Development teams by writing PL/SQL programming and in creating Functions, Procedures, Packages and Triggers.
• Proactively monitoring teh database's health and taking preventive or corrective action as required.
• Monitoring and tuning performance.
• Making database backups and performing recovery using regular EXPORT ULTILITY, SQL-BACKTRACK and RMAN.
• Setting up physical and logical standby database for primary database on RAC and NON-RAC environments.
• Setting up administrative scripts for analyzing, gathering stats e.t.c
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 24x7 production support when required.
• Refreshing databases for development and test teams using RMAN, SQL-BACKTRACK, EXPORT and IMPORT utilities.
• Restricting unauthorized database access using logon triggers.
• Support for application teams in promoting database changes for every release.
• Installing and configuring OEM (Oracle Enterprise Manager) and Grid Control. Performing administrative tasks using OEM. Used Oracle Enterprise Manager (OEM) for database monitoring, job scheduling etc .Installing and configuring required for deploying agents and different OS platforms.
• Recovered database objects using Flashback query and knowledge in Transportable table space, Data Guard, Real Application Clusters (RAC).
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for monitoring database performance.
• Installing, configuring and troubleshooting oracle Multi-Master replication. Efficient handling for Multi-master Replication with 4 master sites.
• Build RAC from teh scratch. dis including configuring OS for RAC install, raw or blocked devices used for storage, Installing CRS, ASM, Creating ASM Disk Groups, Installing RDBMS binaries and upgrade all teh components as needed. Configuring RAC services according to application requirements. Configure ONS for RAC clusters.
• Work with oracle support on severity 1 issue at an expedited speed in 24x7 mission critical production environment.

Confidential, CA

Oracle DBA

Responsibilities:

• Creating teh database, tables, tablespaces, data objects, setting privileges, indexes, user logins, password (security).
• Implemented teh Controls for User Access, Password Management Segregation of Duties.
• Implemented Password Administration, User Schema Account Naming by using standard Oracle profiles, enable password encryption, data encryption in accordance to teh SOX policies of teh company.
• Security User Management, Privileges, Roles, Auditing, Profiling, Autantication. Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Checking teh backups and doing regular staging database refresh.