PROFESSIONAL SUMMARY:

• Around 8 years of Software Development Life Cycle experience involving Requirements.
• Analysis, Specification, Administration, Design, Development, Conversions, Installations, Maintenance, Upgrades etc.
• Oracle Certified Professional (OCP DBA) for oracle versions 11g, 10g, 8i and 8.
• Worked as Project lead and completed projects from initiation to completion.
• Managed production databases for 24X7X365 support.
• Architected and scripted RMAN backup and recovery for multiple projects.
• Received on oracle database administration, backup and recovery, performance tuning and network administration for oracle versions (8, 8i, 10g, 11g and 11i) from Oracle Corporation center.
• Designed developed and implemented complete RMAN backup and recovery solution for full/incremental backup and recovery of databases using Veritas Netbackup MML with and without catalog. Used RMAN to duplicate database from active database as well as from RMAN backup and also performed point in time recovery. Used RMAN to create standby database.
• Good at installation, upgrade, administration, backup, recovery, performance tuning, patching, network administration of oracle (RAC and grid control) OEM 12c, 11gR2, 11gR1, 10g, 9i, 8i, 7.3.4, primary and standby databases using dataguard, enterprise manager and shell scripts.
• Installed and configured 11g Real Application Cluster (RAC) on Oracle Enterprise Linux 5 and also 11gR2 on Redhat Linux on VMWare.
• Installed, upgraded, patched and maintained Oracle Applications 11i and Release 12 e - business suite.
• Knowledgeable about how to Configure, Migrate and Maintain, manage I/O Resource, Optimizing Database Performance of Exadata Storage Server
• Managed and architected development, test and production databases for Oracle, MS SQL Server 2005, MS SQL Server 2008, MySQL, Informix, Teradata etc.
• Primary skill set is Oracle DBA and secondary skill in Oracle Applications DBA, Unix system administration, Unix shell scripting and Informatica development and administration. Used TOAD, OEM, korn and perl scripts to manage databases.
• Developed UNIX korn shell/Perl scripts for automatic management of export, gathering of statistics, validation of invalid objects, monitoring of the database, alert log etc. These scripts are run automatically as crontab jobs (batch job on windows) and notify DBAs in case of any failure.
• Designed, developed and maintained data warehouses using Informatica, ERWin from initiation to completion of projects. Administered Oracle versions 6/7/8/8i/9i/10g/11gR1,11gR2 on UNIX, Linux and Windows NT/2000 platforms with High availability (HACMP), fail over, HP Service guard, Standby database Oracle Data Guard. Performed Unix System administration and developed shell scripts and VMS DCL Scripting. Supported databases of sizes up to few Tera Bytes.
• Supported the system 24x7.Ability to work beyond regular hours.
• Expertise in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Performs Golden Gate replication monitoring, tuning, and capacity planning.
• Install and configure Oracle Golden Gate Veridata 3.0.
• Configured Oracle Golden Gate and parameter files in an active-active architecture.

TECHNICAL SKILLS:

OPERATING SYSTEM: UNIX, LINUX, HP-UX, AIX, SUN SOLARIS, WINDOWS NT

TOOLS /UTILITIES:: ERWIN, TOAD, ETL, RAC, RMAN, Oracle Migration Workbench, SQL-Backtrack, STATSPACK, SharePlex, AWR, ADDM, OEM, OLTP, SQL* Loader, ASM, Crystal reports 2.5, Grid Control. Golden Gate, SQL developer, ORACLE APPLICATIONS 11i, Exadata. OEM Cloud control 12c, SQL*Loader, EXP, IMP, TOAD, Datapump.

RDBMS: ORACLE 8i/9i/10g/11gR1/R2, SqlServer2000,2005,DB2, MS Access

LANGUAGES: PL/SQL, SQL, UNIX Shell scripting, PHP, PERL

HARDWARE: IBM RS 6000 servers, Sun sparc E 4500/5000/450 with EMC symmetric 8530and Raid 1 disk storage, HP 9000/E39, DELL Edge 2550/4500.

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Sr. Oracle DBA Consultant

Responsibilities:

• Installed and maintained Oracle 11g/11gR2 databases having good exposure on Linux, HP-UX and Windows.
• Upgrade (10g to 11g) and patching Oracle databases.
• Set up and administered tablespaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redologs.
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Monitor Oracle databases, server performance and capacity. Formulate and execute plans for resolving performance issues and meeting resource, growth/capacity demands.
• Investigate, diagnose, and quickly resolve database issues and problems in production and testing environments. Work closely with operations staff to quickly resolve production problems.
• Create, maintain, and test backup and recovery procedures for all databases.
• Install and configure database changes, builds and deployments in support of QA and production testing and release schedules.
• Managing users and resources, controlling user privileges, roles and auditing database use.
• Configuring the Data guard set up for Disaster recovery.
• Database cloning for development and testing.
• Served as rotating on-call DBA in support of 24x7 operational databases.
• Creation and maintenance of users and roles.
• Monitoring user sessions using OEM 12c and TOAD.
• Creation of data models and transporting data using tools like ERWIN.
• Worked with security team and generated audit reports.
• Supported backup and recovery using cold backup, hot backups, and flashback in 10g, written shell scripts for the UNIX environment.
• Worked on ASM redundancy levels, load rebalancing on RAC as well as standalone systems.
• Use of explain plans to tune SQL queries, building indexes to improve performance.
• Gather table/schema stats on regular basis to improve performance.
• Analyzing and applying of quarterly security patches.
• Experience with Oracle Golden Gate software.
• Involved in setting up and Managing Disaster Recovery sites.
• Monitoring Smart Flash Cache Activity on Oracle Exadata.
• Configured various Oracle Exadata Database Machine.

Environment: LINUX,UNIX, Oracle 11g R2/11g, Oracle 10g (10.2.0.3/10.2.0.4 ),SQL,PL/SQL, RMAN, Dataguard, SQL Plus, TOAD, Solaris, RAC, Golden Gate, ASM, Exadata.

Confidential, Oakland, CA

Sr.Oracle DBA Consultant

Responsibilities:

• Installed and configured Oracle 10g, 11g
• Review and apply latest CPU patches both for database and applications.
• Upgrade from 10gR2 (10.2.0.4) to 11gR1 database.
• Tablespace and Data File allocation and management
• Managing schema objects and rollback segments.
• Analysis and application of oracle quarterly patches in dev/qa/production.
• Applying application patches for bugs encountered.
• Database security such as establishing security policies.
• Managing users and resources, controlling user privileges, roles and auditing database use.
• Experienced in taking Hot, cold backups with and without RMAN.
• Restored development databases using RMAN.
• Experience with Oracle RMAN Backup.
• Performed Logical backups at schema level using Export/Import.
• Database instance tuning such as tuning memory allocation, tuning I/O, tuning contention, tuning related to sorts and free lists and check points.
• Installation of Oracle 10g software on various platforms like Red Hat Linux Adv.
• Administrated database regarding space related issues- monitoring Table spaces, users security of data accessibility and Configuring Archive log destinations
• Reorganized the database tables to improve report generation time.
• Database monitoring using OEM 12c. Application and database tuning using stats pack.
• Improve application run time by building optimal indexes, gathering object statistics, analyze objects and using parallel query.
• Configuring ASM on raw devices on RAC environment.
• Database refreshes, environment configurations, and troubleshooting.
• Performed several rollback to undo and dictionary to local extent management tablespace conversions.
• Designed a two node RAC on Redhat Linux.
• Implemented dataguard for physical standby, snapshot standby and active dataguard.
• Performing the logical and physical structures for tables, indexes, modeling, normalization and foreign key constraints.
• Troubleshot database errors, warnings, debugging and failed jobs to greatly reduce potential database downtime, and ensure database recoverability.
• Supported different databases like Production, Development, Testing, and .
• Resolving database storage management issues.
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Troubleshooting Golden Gate issues.

Environment: UNIX Sun OS 5.6/ HP UNIX 11.11, Windows NT 5.0/ 2000, Oracle 10g, 11g, RAC, OEM 11g,12c, RMAN, OEM, Toad, Golden Gate, ASM.

Confidential, CA

Oracle DBA Consultant

Responsibilities:

• OEM Installation and configuration.
• Installation of 9iR2/10gR2 oracle software.
• ASM to ASM cloning procedure development.
• RAC production administration, lock monitoring and troubleshooting, package migration to production RAC database.
• Migrate from 9iR2 to 10gR2 using export/import.
• Setting up physical and logical standby database / data guard at DR site for operational recovery.
• Cloning of Production instance both using manual clone and Rapid clone utility.
• Upgraded 11. .5.10.CU2 using adpatch.
• Performance tuning and monitoring of Databases through v$ views, statspack, ADDM etc.
• Analyzing the Tables and Indexes using DBMS STATS package.
• Establishing back-up policies (Hot, Cold)and Restore activity.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, and ADDM reports.
• Developed PL/SQL procedures, involving dynamic SQL .
• Periodic refreshing of the production data through export and import.
• Monitoring the test database as well as the production database.
• Experience and monitoring golden gate issues for data replication.
• Created and managed tablespaces monitored the data files space, resizing and adding new datafile etc.
• Doing Database Reorganization regularly to remove row migrations and fragmentation using table move, rebuild indexes and export/ import utilities.

Environment: Linux, Oracle (10g,11g) RAC, SQL server 2005, 2008, 2012 Toad, Dataguard, Golden gate, ASM, Oracle Forms & Reports, Performance Tuning,.

Confidential, Phoenix AZ

Oracle DBA Consultant

Responsibilities:

• Performed Installations of Oracle software on various Windows and UNIX servers.
• Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.
• Designed and implemented hot backups using a combination of incremental differential and full backups using RMAN and Hot/Cold.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Contributed to team effort by accomplishing related results as needed.
• Responsible for optimizing the queries and application tuning.
• Controlling and monitoring user access to the database for new and existing databases.
• Involved in numerous Shell Scripting pertaining to the activities of the DBA.
• Performing Management tasks on Schemas and objects using TOAD
• Using Export, Import in order to extract and Load Data.
• Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of various sizes - 10TB.
• Understanding the sox compliance to assure the integrity of financial statements
• Planning and scheduling for the backup of database information using Crontab jobs.
• Generated daily, weekly and monthly reports regarding total revenue management.

Environment: Windows-NT, Oracle 8x/9i/10g,Redhat Linux, Designer 2000, Reports, C++, TOAD, Export/Import utilities, Oracle Forms 4.5.

Confidential

Oracle DBA

Responsibilities:

• Worked under Sr. DBA to perform oracle software installations.
• Installed patches, performed database version upgrades with the Sr.DBA support.
• Execution of SQL queries to monitor usage and performance.
• Extensive user support which includes creation of users, granting privileges, roles, helping in troubleshooting SQL queries.
• Creating user accounts and appropriate privileges as well as maintaining database security.
• Enabled the Database in Archive Log Mode / No archive log mode
• Modifying the database structure, as necessary, to support activities of application developers
• Created Database storage structures Data Tablespace, Index Tablespace.
• Upgrade, patching Oracle databases.
• Worked on LDAP servers to reduce security issues and data Inconsistencies.
• Experience in performing system backups and restoration using PL/SQL scripting
• Involved in doing Hot, Cold backup with and without RMAN.
• Backups using export and import of schemas.
• Used Stats pack for troubleshooting SQL query performance issues.
• Creation of development and test databases using export/import of full database.
• Managing user, resources and privileges.
• Created and executed SQL reports for management.

Environment:, Oracle 9i/10g, SQL, PL/SQL, SQL Loader, TOAD, OEM.