SUMMARY:

Have over 8 years of focused experience in IT industry in various fields like banking, insurance, financial, retail, healthcare and manufacturing. 8years Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as Oracle DBA; proficient in Oracle 10g/11g/12g Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 12g/11g/10g on Unix and Windows NT platform. Involved with architect group in designing the logical and physical model of the databases. Thorough understanding of the Oracle data dictionary. Have good experience in UNIX administration, Shell scripting. Have impeccable communication and interpersonal skills and an exceptional team player. Managing the team of Oracle DBAs and actively coordinated with the end user community. I can work perfectly and effectively under stressful conditions where speed and accuracy are necessary for mission critical databases. My attention to detail and the ability to maximize system resources can be beneficial to your company.

TECHNICAL SKILLS:

Operating Systems: RED HATLINUX CENTOS ENVIROMENT, UNIX, Windows XP 

Database Systems: Oracle10g/ 11g, 12c MS Access 2000 RMAN data guard

Oracle Utilities: Oracle Data Grid control, ADDM, AWR, OEM, RMAN, DATA PUMP, SQL Loader, SQL PLUS.

Designing/ Analysis: Oracle Microsoft Office

PROFESSIONAL EXPERIENCE:

Confidential, Silver Spring, MD

Oracle Database Administrator

Responsibilities:

• Maintain Oracle Applications 11g DBA skills for complex 24×7 environments
• Developed Recovery Manager (RMAN) scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances
• Provides logical backups of data using oracle data pump utilities EXPDP and IMPDP, to move
• Oracle data from a database or schema to another.
• Experience with various tools such as Data Pump, SQL*Loader, Oracle SQL Developer and Oracle Enterprise Manager (OEM).
• Maintaining Oracle Data Guard & Standby Database and providing critical solutions with Strategic disaster recovery plans with different recovery procedures and methods. 
• Proactive monitoring the disk usage and the memory usage of the server and monitoring tablespaces. 
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database. 
• Communicate with Oracle support via the Metalink for other important troubleshooting issues. 
• Upgrading databases using best practices.
• Hands on experience in oracle RAC ( real application clusters) with ASM
• Good knowledge of of database administration10g, 11g, and 12c
• Expertise in oracle EBS sysadmin setup task for oracle application like responsibility, forms, menu, users.
• Comprehensive experience as Oracle DBA, especially in  Exadata  and Oracle  Goldengate  proficient in Oracle 9i/10g/11g/12c software installations, migrations, 
• Assist the Technical Support Unit in developing. and implementing RDBMS subsystem 

  backup and recovery procedures

• Full Understanding of the E - Business Suite with its architecture 11i & R12.
• Hands on experience in Installation and maintenance of E-business 11i & R12 environment.
• Trouble shooting, Monitoring, Performance tuning of  E-business Application Servers

Confidential, Silver Spring, MD

Oracle DBA

• Install, configure, and implement backup/recovery strategies using Oracle RMAN.
• Installing and upgrading from Oracle 11gR1-R2
• Oracle database management and monitoring using 11g Grid Control.
• Creating user accounts and appropriate privileges as well as maintaining database security
• Using Enterprise Manager to schedule backups
• Ensure daily RMAN backups are completed and valid for restore and recovery
• Hands on experiences in oracle RAC with ASM
• Create different tablespaces, tables, schemas, and users accounts
• Provide performance tuning, maintaining, and troubleshoot database problems
• Installs the Oracle server and client software applications.
• Install, implement, and configure Oracle Enterprise Manager on Windows and Linux environment to administer databases in production environment.
• Advanced troubleshooting using trace files, alert log, and external links (MataLink or Oracle Support)
• Expert in oracle EBS sysadmin.
• Generating Reports and preparing memo to communicate progress and providing early alerts for major updates.
• Performance tuning of Database, SQL queries using the AWR, ADDM.
• Monitoring and resizing Tablespace, relocating data files for better disk I/O
• Documented the problems and solution in the failures of production databases. 
• Full Understanding of the E-Business Suite with its architecture 11i & R12.
• Hands on experience in Installation and maintenance of E-business 11i & R12 environment.
• Trouble shooting, Monitoring, Performance tuning of E-business Application Servers.

Confidential 

Oracle DBA 

• Establish a backup and recovery strategy using daily hot backups, RMAN and weekly full backup.
• Performing database design and development for instances used in test, development and production environments.
• Installation of Oracle 10g and 11g on Linux Red Hat V 5.5, and Windows platform.
• Create and configure Oracle databases using DBCA or manually by using scripts.
• Inline Deduplication Implementation .
• Utilize Automatic Workload Repository (AWR) to generate snapshots of key performance data.
• Implement and maintain Oracle Dataguard Physical and Logical standby databases for disaster recovery.  
• Managing database security by creating and assigning appropriate roles and privileges to users depending on the user activity.
• Perform database migration from Oracle version 9i to 10g & 11g respectively.
• File convertions to ASM
• Cloning of production databases as needed for testing, development using RMAN.