PROFESSIONAL SUMMARY:

• Strategic, results oriented Oracle Database Admin with over 8 years of IT experience, strong experience in installation, configuration, maintain cloning, upgrading, design of physical data storage, access and security administration, backup and recovery, troubleshooting, performance tuning of Oracle RDBMS both RAC and NON RAC in Linux/Unix, Solaris and Window environments, experience in building client relationships, establishing project strategy and deliverables; developing and delivering solutions. Results driven IT personnel with skills in team building and problem solving with an establish reputation for effectively working with diverse groups of people and adaptability to changing environment.

TECHNICAL SKILLS:

Application: Clusters (RAC), NAS and SAN.

Tools: SQL Developer, TOAD, Putty, SSH Secure Shell, Aqua Data Studio 6.0 Query Analyzer.

Data Modeling Tools: Erwin Data Modeler 7.5/8.2, Microsoft Visio & Access, Program with Visual Basic

Operating Systems: RHEL 4/5, OEL4/5, AIX, Windows Servers, Solaris 2.9, 10Programming: SQL, PL/SQL, Shell Scripting, HTML, DHTML, XML, JavaScript's, C++, (C#.NET, ASP.Net)

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 11g databases on Linux platform.
• Perform Daily Monitoring of Oracle Instances, users, table spaces, Logs and Alerts.
• Daily Health Check of the Databases using Oracle Enterprise Manager.
• Keeping an eye on any visible issue like long running queries and blocking or wait events.
• Taking corrective steps and escalating to data center if and when needed.
• Demonstrate knowledge and hands on experience working on Confidential Cloud (AWS)
• Implementation experience tuning and maintaining Oracle database on AWS
• Checking storage and space usage, disk space, table space and adding data files.
• Account and user management, created Users, resetting passwords, unlocking accounts.
• Granting roles, privileges and profiles to the user with limited rights as per requirement.
• Configured network components like TNSNAMES and Configured listener services.
• Maintenance troubleshooting and tuning activity for high performance.
• Working on performance tuning activities, creating SQL plan and AWR, ADDM reports.
• Analyzing long running/expensive queries, generating explain plan for Full Table Scan.
• Creating new Indices to avoid FTS for performance improvement.
• Taking DDL (structural changes) and DML (data) requests from the development team.
• Managing Reference Data/Standard data and day0 data scripts in SVN and database.
• Implemented multiplexing control files and redo log files
• Configured and setup Oracle 11g Data Guard
• Performed physical backups using RMAN utility
• Performed bulk data load into the database using SQL Loader
• Verifying naming convention and standard for database design changes.
• Managing scripts in SVN for higher migration and production releases including version control and tracking in the SVN as well as databases.
• Deploying database changes from Development to higher testing environments during the build and deployment window.
• Performing database backups and recovery using oracle export/import utility.
• Refreshing and restoring databases in lower environments for the preparation of new releases.
• Performing production tasks as approved by change control team.
• On Call Production/ non - production support as per the shift

Environment: Oracle 11g, RHEL, OEL, Windows, Oracle E M, Grid Control 12c, ERwin, AWS

RDBMS, SQLPLUS, TOAD, SQL Developer, PL/SQL, Stored Procedures, Data Guard, ASM, RAC.

Confidential, Huntsville TX

ORACLE DBA

• Installed, configured, and maintained Oracle 10g/11g databases on Linux platform.
• Performed day to day administrative tasks by analyzing the database and validating disk space.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g.
• Configured and Implemented Cold and Hot Backups using RMAN with and without recovery catalog.
• Implemented and managed Primary and Stand by databases using Data Guard on Oracle 10g and 11g.
• Upgrading the Oracle 10g to 11g and applied patches as required.
• Exposure to database replication concepts like streams and Golden Gate.
• Perform Daily Monitoring of Oracle Instances, users, table spaces, Logs and Alerts.
• Daily Health Check Up of the Database using AWR, ADDM and generating reports.
• Configured Flash Recovery Area databases using Automatic Storage Management.
• Created Users with limited rights as per specific module under specific client.
• Granting roles, privileges and profiles to the user as per requirement.
• Replication of tables to cross platform and Creating Materialized Views.
• Performed daily maintenance tasks space management and rectified locking problems.
• Configured network components like TNSNAMES and Configured listener services.
• Database backup and Recovery for non-archive and archive database with RMAN.
• Configured database cloning using RMAN with and without recovery catalog.
• Configuration, migration and upgrade of catalog database using RMAN.
• Implementation of Data Guard on production database as a DR solution.
• Develop and enforce both database and OS-level security policies for data protection.
• Maintenance troubleshooting and tuning activity for high performance.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Efficiently using the Oracle Tools like OEM, SQL* Loader, TKPROF, LOGMINER.

Environment: Oracle 10g/11g, RHEL, OEL, Solaris, Windows, Oracle EM Grid ControlRDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures, Data Guard, ASM, RMAN, RAC, Grid Control for management of an Oracle maximum availability architecture environment

Confidential, Laurel Baltimore, MD

ORACLE DBA

• Database monitoring and performance tuning using OEM and STATSPACK.
• Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
• Implemented Data guard and administered the primary as well as standby database.
• Installed Oracle 10g RAC database on RHEL and applied all current patches
• Responsible for maintaining Oracle 10.1.0.2 using SRVCTL, Oracle Enterprise Manager.
• Involved in maintaining Oracle Cluster - ware using CRSCTL.
• Configured the VERITAS clustering for Oracle on the production and staging databases.
• Involved in RAID configuration and disk striping for optimized database I/O performance.
• Upgraded databases from 10R1 to 10gR2 using Data Pump and RMAN.
• Responsible to schedule daily incremental and weekly full backups through RMAN.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Used Flashback table feature to restore tables using new feature of Oracle 10g.
• Involved in Performance Tuning particularly, shared pool and buffer cache.
• Extensive application tuning through STATSPACK, explain plan, SQL*Trace.
• Implemented scripts to capture high resource utilization queries.
• Involved in daily monitoring tasks like db status, no of extents, free space using scripts.
• Implemented Oracle Advanced Security Options and encryption algorithms.
• Cloned the production database periodically to the testing databases through RMAN.
• Identified the long running transaction through and also for Rollback monitoring.
• Used EM on Oracle 10g for diagnostic summary, host CPU utilization, wait events, alert Log errors.
• On-Call 24x7 DBA support for production databases.
• Extensively used SQL Queries to handle data mapping.
• Tuned the SGA. Monitored share Pool, Database buffer cache and Redo log buffers.
• Monitored Table-spaces and Segment fragmentation.
• Performed trouble shooting activities, created new users and assigned privileges and roles to users.

Environment: RHEL, Oracle 9i/10gR1/R2, PL/SQL, SQL*PLUS, Exceed 6.2, Oracle EM

9.2.0/10g, VERITAS Cluster 5.0, RMAN, Data Pump, Data Guard, ASM, RAC, Import/Export, and Stats-pack.

Confidential, Baltimore, MD

Jr. DBA

• Managed and maintained oracle databases running on Window and Linux Operating System
• Installed Red Hat Enterprise Linux (ISO) 5.5 Operating System on Servers
• Configured Oracle network used NETCA and NETMGR utilities
• Worked independently and collaboratively with DEV. teams to resolve complex Oracle issues
• Managed system issues, performance tuning, backup/recovery and replication issues