SUMMARY

• Around 9 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 training on oracle database administration, backup and recovery, performance tuning and network administration for oracle versions (8, 8i, 10g and 11g) from Oracle Corporation training center.
• Designed developed and implemented complete RMAN backup and recovery solution for full/incremental backup and recovery of databases using VERITAS Netback up 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 data guard, enterprise manager and shell scripts.
• Installed and configured 11g Real Application Cluster (RAC) on Oracle Enterprise Linux 5 and also 11gR2 on Red hat Linux on VMware.
• Installed, upgraded, patched and maintained Oracle Applications 11g and Release 12 e - business suite.
• Knowledgeable about how to Configure, Migrate and Maintain, manage me/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 teh 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 TB.
• Supported teh system 24x7.Ability to work beyond regular hours.
• Expertise in Oracle Gloden Gate installation, configuration, troubleshooting GG issues.
• Performs Gloden Gate replication monitoring, tuning, and capacity planning.
• Install and configure Oracle Gloden Gate Veridata 3.0.
• Configured Oracle Gloden 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. Gloden Gate, SQL developer, ORACLE APPLICATIONS 11i, Exadata. OEM Cloud control 12c, SQL*Loader, EXP, IMP, TOAD, Data pump.

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, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• Responsible for supporting both production databases development/test databases with sizes of databases varying from 500 GB to 6TB while coordinating with Unix Team and storage team to configure teh OS infrastructure for Oracle Databases.
• Implemented Upgradation and Migration of Database’s from 11.2.0.1 to 11.2.0.4 and applying quarterly patches whenever required.
• Monitoring database performance and database operation to prevent downtime, and slowness of teh services.
• Performed proactive database maintenance procedures to ensure optimal performance and uptime.
• Worked on setting up/installation and configuration of release 11gR2 RAC with ASM and Raw Devices and 11g CRS.
• Implemented Data Pump, Export and Import on day to day basis.
• Responsible for zero level and incremental backup using RMAN and full logical backup using data pump Export/Import.
• Worked closely with teh system operations team on database deployment processes and database capacity planning.
• Implemented backup and recovery procedures (Cold/Hot backup, RMAN Incremental backups & Import/Export).
• Involved to Monitor activities like availability of database & listeners, space utilization, gathering statistics for teh cost base optimizer, index rebuilding etc.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 11g features: Streams, 11g Grid Control and Automatic Storage Management (ASM).
• Perform Space Management & Troubleshooting teh database issues.
• Gather table/schema stats on regular basis to improve performance.
• Actively involved in monitoring teh lock processes, releasing locks in case of resource blockage and gathering statistics.
• Installed Oracle spatial 10g and migrated Arcsde data to Oracle spatial at Virtual DBA. Wrote PL/SQL code for Geocoding application.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Worked on quarterly switchover exercise to ensure proper switchover and failover process incase necessary.
• Worked on ASM redundancy levels, load rebalancing on RAC as well as standalone systems.
• Creating and Managing Primary Objects like Custom tables, Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Experience in monitoring database using Oracle Enterprise Manager (OEM).
• Refreshed multiple databases for Development and Testing upon short request.
• Monitoring and maintaining 5 node RAC database on Red Hat Linux. Providing support to teh development team and handling release schedules.
• Involved in monitoring teh lock processes, releasing locks in case of resource blockage and gathering statistics.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, migrated, configured and tested Oracle 11g databases in various environments.
• Extremely dedicated, self - motivated, Pro-Active and willing to assume responsibility.

Environment: LINUX, UNIX, RHEL 6.x, Oracle 11gR2, RAC, ASM, RMAN, OEM Grid Control 12C, Exp/Imp, Data pump, Data Guard, SQL Developer, Oracle spatial, TOAD, EXADATA, Gloden Gate.

Confidential, NYC, NY

Sr. Oracle DBA

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 table spaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redo logs.
• 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.
• Implemented and deployed, managed Oracle Spatial using various ESRI files from different vendors (me.e. NavTeq, TomTom, Nokia, etc.) supported ArcGIS infrastructure; used spatial programming; spatial models and algorithms.
• Helped Development teams with POC fororacletext andoraclespatial. Implementedoraclequeues for downstream applications.
• Managing users and resources, controlling user privileges, roles and auditing database use.
• Configuring teh 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 teh 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 Gloden 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, Data guard, SQL Plus, TOAD, Solaris, Oracle spatial, RAC, Gloden Gate, ASM, Exadata.

Confidential, Oakland, CA

Sr. Oracle DBA

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 me/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 teh 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 table space conversions.
• Designed a two node RAC on Red hat Linux.
• Implemented data guard for physical standby, snapshot standby and active data guard.
• Performing teh 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 Training.
• Resolving database storage management issues.
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Troubleshooting Gloden 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, ASM.

Confidential, LA, 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 ad patch.
• Performance tuning and monitoring of Databases through v$ views, stats pack, ADDM etc.
• Analyzing teh 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 teh production data through export and import.
• Monitoring teh test database as well as teh production database.
• Experience and monitoring Gloden Gate issues for data replication.
• Created and managed table spaces monitored teh data files space, resizing and adding new data file 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, Data guard, Gloden 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 teh queries and application tuning.
• Controlling and monitoring user access to teh database for new and existing databases.
• Involved in numerous Shell Scripting pertaining to teh activities of teh 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 me/O, buffers and locks.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Expertise in Oracle Architecture, me/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 teh sox compliance to assure teh integrity of financial statements
• Planning and scheduling for teh backup of database information using Contabo 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 teh 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 teh Database in Archive Log Mode / No archive log mode
• Modifying teh 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.