SUMMARY

• Up to 7 years of experience in Information technology as an Oracle DBA on Linux, Unix and Windows operating system environments.
• Experienced in handling high availability systems like Real Application Clusters (RAC) and Dataguard.
• Experienced in Designing, Administration, Implementation, Troubleshooting and quality management for several production/Development/Test Environments on Oracle (10g, and 11g) Databases.
• Extensive working experience in using tools like RMAN, Data pump, exp/imp, flash - Back Recovery, AWR, ADDM, OEM, Gloden gate, 12C Cloud Control monitoring and Flashback Technologies-Flashback Databases, Flashback Tables etc.
• Experienced in Implementing High Availability database environment using Oracle Datagurad with physical standby database.
• Experienced in managing Automatic Storage Management (ASM) in RAC and Single Instance Environment.
• Experienced in Performance Tuning and optimizing large Data Migration using core utilities like SQL loader, data pump, Table partitioning.
• Experience in performing SQL Tuning to improve database performance.
• Experienced in writing SQL and PL/SQL codes such as PLSQL blocks, Stored procedures, Packages, Triggers and Functions.
• Experienced in Designing a database as per functional requirement.
• Experienced in writing and Configuring various Shell Scripts for automation and monitoring of databases.
• Experience in working on Agile Methodology for development work.

TECHNICAL SKILLS

RDBMS skills: Oracle 9i, 10g and 11gR1/R2,MYSQL5.1,5.5

Project acquired Skills: Oracle RDBMS, Red hat Linux4.0/5.0 and Oracle Linux v4,v5, SQL server2005/2008.

Operating Systems: Red Hat Enterprise Linux 4.0,5.0, Sun SolarisWindows 2000/2003.

Programming skills: C, C++ Programming, SQL, PL/SQL, Shell scripting/Perl Scripting.

Tools: and utilities DBCA, OEM, SQL Plus, SQL*Loader, SQL Tuning DBCA,DBUA, OEM, 12C Cloud Control/Grid control, SQL Developer, NETCA, RMAN, DATA PUMP Export/Import, Data guard, SRVCTL,ASMCMD, ASMCA.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Oracle DBA

Responsibilities:

• Providing 24/7 support for Production Databases of mission critical applications.
• Supporting large size database in 3-node RAC cluster running on Linux Server 5.3 in DEV/QA/Test/Production with ASM configured for storage.
• Supported 2-node RAC cluster of Data Warehouse Databases across all DEV/QA/Test/Production and developed reports based on DW data.
• Creating and Monitoring ASM disk groups for any storage related issued and troubleshooting storage issue by working closely with storage team and OS team.
• Proactively monitoring databases using OEM 12c Oracle Cloud control (grid control) to identify possible issues in super sensitive OLTP and OLAP Production environment.
• Automatic Oracle jobs/patching/code deployment using Oracle 12c Grid control/ Grid control.
• Analyzing Database performance using time-to-time snapshot and by running AWR/ASH report to provide complete report.
• Configured and Monitored Physical standby database using active Data guard on Oracle RAC setup to support Disaster Recovery(DR) process and Replication process with Primary database.
• Working with developers to support development work and business team to provide suggestions on Database related changes.
• Configured Cronjob setup for backup using RMAN in Production and performed back/restore using EXPDP/IMPDP for backups and restore.
• Experienced in Performance Tuning of complex SQL queries and using Oracle performance tuning utilities like SQL Plan Baseline, Sql performance Analyzer, Explain Plan, TKPROF, STATSPACK, Sql Trace and Sql Tuning Advisor.
• Worked on Partitioned tables, partitioned index and partitioned materialized view.
• Experienced in Working on in-house built ETL process and changing ETL structure based on business development.
• Working closely with development team on Agile Methodology to support mission critical application.
• Experienced in writing SQL,PL/SQL, triggers, stored procedure and functions.

Environment: Oracle 11gR2RAC, 12C Cloud control, Data Guard, ASM, RMAN, ASM, SQL * PLUS, OEM, SQL developer, Shell Scripting, TOAD, Linux 4.0/5.0 (RHEL),MYSQL 5.5.

Confidential, San Francisco, CA

Oracle DBA

Responsibilities:

• Provided 24/7 production support and worked on on-call rotation.
• Responsible for maintaining Oracle 11g/10g/9i databases on different Operating system environments.
• Translating technical and Business requirements into efficient Logical and Physical data models.
• Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces for source and target Data Mapping and Packages.
• Worked on Oracle database migration project from 10g to 11g.
• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Datapump.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs.
• Implemented backup and recovery procedures using RMAN, Import/Export & Data Pump (impdp/expdp).
• Configured DataGuard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Extraction/Replication of production environment using Gloden Gate.
• Supported installation and setup of 2-Node Oracle RAC database.
• Monitoring and Administrating Oracle RAC databases on Oracle 11g Clusters.
• Created and maintained databases by creating tablespaces, tables, indexes, and views and materialized views.
• Worked on collecting data for reporting using Materialized Views and Configuring refresh jobs for Data Replication.
• Worked on in-house built reports based on Stored Procedures and Tuning code for better results.
• Tuning code written by developers for better performance using explain plan/ADDM/TKProf/stats pack/auto trace and real time data also by providing necessary solution to improve.
• Monitored tablespace size, resizing tablespace, relocating data files for better disk me/O.
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs. working with reports team to develop reports by understanding business logic using SQL/PLSQL code.
• Worked on SQL/Triggers/stored procedure/PLSQL packages.
• Working with development team on Agile methodology to support application development.
• Developed shell scripts and automated nightly jobs using Cron to schedule teh backups, exports, refresh test DB from production site and build development, testing staging DBs.

Environment: Oracle 10g/9i, OEM 10g Grid Control, OEM, AWR, ADDR, Gloden Gate, SQL Developer, Erwin, RMAN, RAC, ASM, Data Guard, Linux 4.0/5.0 (RHEL), Sun Solaris.

Confidential, Albany, NY

Oracle DBA

Responsibilities:

• 24x7 Oracle Database Administration of Production, Development, Testing databases.
• Setup and configured Standby Databases for disaster recovery and reports generation in maximum performance mode using Dataguard.
• Setup and Configured Physical Standby and Logical Standby Databases for various production systems.
• Working with development team for database Design and Implementation as per business requirement.
• Involved in Data Modeling, Design, Implementation and Creation of Databases.
• Involved in setting up of ORACLE 10g RAC Databases for test prototype environment with three nodes-cluster on Red hat Enterprise Linux 4.
• Setup Automatic Storage Management to reduce me/O contention and support RAC databases.
• Patched/Upgraded Oracle 9i Databases to Oracle 10g databases using DBUA/Manually.
• Involved in Capacity and Resource planning. Estimated teh size of Data files and Redo log files based current transactions rate, time for recoveries etc.
• Designed various Backups/Recovery strategies for Oracle databases as per SLA requirements.
• Monitored databases Performance using Oracle Enterprise Manager (OEM) and Grid Control.
• Monitored and maintained Security by managing Roles/Privileges for users of teh databases.
• Responsible for Instance Tuning, me/O Tuning, Identifying and fixed contention waits.
• Used advisor, tasks like ADDM, SQL Tuning, Access Tune and Undo Advisors for performance tuning.
• Developed Shell Scripts and SQL scripts to carry out routine checks on databases and perform various tasks on teh database.

Environment: Oracle 8i/9i/10g, MYSQL 5.1, Solaris 9, Red Hat Enterprise Linux 4, RAC, Windows 2003, TOAD, and SQL developer.

Confidential

Jr. Oracle DBA/Developer

Responsibilities:

• Provided Testing Database support, Network Technical issues and client related technical issues.
• New user accounts creation and Implementing Security features with roles and privileges.
• Involved in designing new Database objects for application development as per business logic.
• Responsible for creating and maintaining user Tablespaces and resolving database storage issues.
• Worked on database backup strategy, design and implementation using cold/hot backup techniques.
• Responsible for performing backups such as RMAN/HOT/COLD.
• Working with team to setup Disaster recover site using Oracle Dataguard and setting up physical standby databases for High Availability.
• Monitoring and managing teh Storage Usage by resizing older tablespaces, Creation of New tablespaces and relocation of data files for better Disk me/O.
• Performance tuning using major 10g tools like STATSPACK, AWR, ASH, Auto trace, Explain Plan and SQL tuning advisor.
• Database Memory management (shared pool, db buffer cache and log buffer).
• Analyzing Performance bottlenecks and provide appropriate solutions on SQL queries written by development team.
• Worked with development and operations staff in resolving problems quickly and efficiently.
• Wrote various scripts in PERL and SHELL for database health and space checks.
• Worked on various areas such as Development, Testing, Implementation and Training.

Environment: C, C++, Reports 2.5, Oracle 9i/8i, SQL Developer, RMAN, TOAD, SQL*PLUS, Red hat Linux 4.x, Solaris 5,MYSQL 5.1