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 (9i, 10g, and 11g) Databases.
• Extensive working experience in using tools like RMAN, Data pump, exp/imp, flash - Back Recovery, AWR, ADDM, OEM, Golden gate, 12C Cloud Control monitoring and Flashback Technologies-Flashback Databases, Flashback Tables etc.
• Experienced in performing Backup/restore/recovery in using cold and hot backup and expert in RMAN backup concepts.
• 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 SQL and PL/SQL in writing PLSQL blocks, Stored procedures, 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, SQL Server 2005/2008

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 Solaris, Windows 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, 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.
• 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 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, Data Guard, ASM, RMAN, ASM, SQL * PLUS, OEM, SQL developer, Shell Scripting, TOAD, Linux 4.0/5.0 (RHEL), Windows Server 2005/2003.

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.
• 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 I/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 the 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, SQL Developer, Erwin, RMAN, RAC, ASM, Data Guard, SQL Server 2005, Linux 4.0/5.0 (RHEL), Sun Solaris, Windows 2003/2000.

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 I/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 the 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 the databases.
• Responsible for Instance Tuning, I/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 the database.

Environment: Oracle 8i/9i/10g, Oracle 10g/9iOAS, 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.
• Involved in creation of triggers and handling exceptions.
• Monitoring and managing the Storage Usage by resizing older tablespaces, Creation of New tablespaces and relocation of data files for better Disk I/O.
• Setup connectivity to databases using NET 8 for clients and server side.
• Configured STATSPACK for tuning databases.
• Database Memory management (shared pool, db buffer cache and log buffer).
• Analyzed performance bottlenecks and provide appropriate solutions.
• 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.
• 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 and Windows server 2003/2000.