SUMMARY:

• Over 7 years of experience in the Information Technology field, with comprehensive hands - on expertise in development, production database administration, database application development and performed different tasks like installation, configuration, upgrades, patches, database refresh, performance tuning, backup and recovery, cloning, space management, database security.
• Repeatedly demonstrates the ability to apply technical skills for the achievement of tactical and strategic business solutions, and also leverages managerial and interpersonal skills to motivate, direct and inspire project teams. With experience in both Finance and Healthcare across a wide variety of systems and companies from large to small, I is seeking a new challenge to call upon my technical skill set.
• Excellent experience in Installation and Configuration of Oracle 9i, 10g, 11g on a variety of operating systems including UNIX/LINUX, Solaris and Windows environment.
• Experience in Oracle Real Application Clusters (RAC) Installation, administration, troubleshooting and Performance tuning in 10g and 11g.
• Extensive experience in installing, upgrading and applying patches to various versions of oracle (11g/10g/9i). Duties included raising Oracle SR support to deal with bugs and issues associated.
• Expertise in Upgrade and Migration of oracle database to higher version and other platforms using Oracle Data Migration Assistant.
• Comprehensive noledge in Database Architecture & Implementation, Data Models, Database design, Normalization & System study.
• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Experience in performing Hot and cold backups with and without RMAN. Automated RMAN scripts using cronjob to perform daily backups.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
• Experienced in troubleshooting traditional export/import and datapump export/import.
• Experience in refreshing the Databases from Production to Development Environment.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Expertise in managing database by creating new users, roles, profiles and providing required user privileges in development, test, training and production environments
• Expert experience in Monitoring Oracle Databases using Oracle Enterprise Manager, Grid Control, and TOAD.
• Good experience in SQL, PL/SQL, Shell Scripting.
• Experience in registering Databases to Oracle 10g Grid Control and registering Databases to RMAN Catalog.
• Experience in Capacity planning.
• Co-ordinate with UNIX administrators for space managements on various servers
• Experience working with the client side, doing requirements gathering, providing innovative solutions, client interfacing and support for application and queries.
• Creating high level and detail design for applications. Creating and execution of test cases/test plans. Executing test cases and test scripts for data validations.
• Highly motivated individual and good team player.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Operating System: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP

Database: ORACLE 9i/10g/11g, MS Access 2013, MYSQL

High-Availability: RAC (9i/10g/11g), Data Guard (Physical and logical standby setup)

Tools & Utilities: OEM (Oracle Enterprise Manager), RMAN (Recovery Manager), Export/Import, SQL*Loader, SQL *Plus, TOAD, Data Guard, Putty, Opatch, Winscp3, Virtual Network Computing with PC Anywhere and VNC.

Languages: SQL, PL/SQL, Shell Scripting.

Middleware Applications: Oracle application server 10.1.2, Oracle Fusion 11g (Discoverer)

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDR

PROFESSIONAL EXPERIENCE:

Confidential - Prussia, PA

Core Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL and WINDOWS server.
• Creating and maintaining the Oracle databases.
• Installed Oracle 10g, 11g RAC databases.
• Installation and maintenance of Oracle 10g Data Guard.
• Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Createdand managing the database objects such as tables, indexesand views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Worked on import/export and SQL- loader.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Performed Explain Plan analysis for Query Optimization.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAIN PLAN.
• Creating and presenting weekly status report to the client

Confidential - Irving, TX

Oracle DBA

Responsibilities:

• Performed upgrade/migrations of databases 10g to 11g.
• Installed and implemented Backup and Recovery procedures, Implemented Hot, Cold, Logical backup.
• Extensive Performance Tuning, Memory (SGA) tuning, Net backup, EMC (Time finder and SRDF), Raw Devices.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Used SQL server for ecommerce apps.
• Worked in Automatic Storage Management (ASM) with EMC storage for managing data in SAN.
• Used shell scripting for automation of job scripts, for Startup and Shutdown, Health Check of Databases, analyzing of Tables and Rebuilding of Indexes.
• Load balancing, Database/Schema/Table Re-Organization for faster performance using export/import and Move procedures. Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Data modelling, Database Design and creation usingER-Win, Visio.
• Daily Health Checkup of the database using STATSPACK, AWR, ADDM, TKPOROF.
• Installation, maintenance and tuning of Oracle 10g RAC databases including ASM and CRS.
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Creating and dropping of users, granting and revoking rights as when required.

Confidential

Core Oracle DBA

Responsibilities:

• Worked as an Oracle DBA (Database Administrator) for the client Confidential .
• Six months of rigorous training on Relational Database Management System (SQL, PL/SQL) and Oracle Database Architecture.
• Knowledge of Database Build, Database Migration, Cluster Upgrade, Database Upgrade, CPU Oracle patching.
• Supporting 1200 SQL and Oracle Databases 24X7 including Production.
• Installation of the Oracle and SQL Server to meet client requirements.
• Promoted to the role of Senior Systems Engineer for my outstanding performance and contribution to the Organization.
• Creating and presenting weekly status report to the client.
• Knowledge in Oracle Backup & Recovery, Export/Import, Datapump.
• Conducted Knowledge Transfer sessions for Oracle 12C and enabled a team of 10.