SUMMARY

• An IT consultant with 8+ years of Software Development Life Cycle experience involving Requirements, Analysis, Specification, Design, Development, Conversions, Installations, Maintenance, Upgrades etc.
• Experience in using GoldenGate to support data replication in the Oracle database environment.
• Experience with RMAN, Oracle Enterprise Manager (OEM), RAC, OEMGrid control, Data warehousing, Oracle Data Guard
• Extensive DBA experience in supporting multiple instances of ORACLE database including Development, Reporting, Data Warehousing, User acceptance testing & Production
• Well versed with Database Administration, Cloning of Database, Backup and Recovery strategy using RMAN.
• Experience in using data pump import/export utility of ORACLE.
• Experience in Database Migration by designing and implementing database logical and physical storage structures.
• Experience in working with ERP and E - Business Suite.
• Experience in Optimizing database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
• Extensive experience in daily batch and report monitoring, space management, index rebuilds statistics collection and other Oracle housekeeping tasks.
• Expertise in data modeling and database designing.
• Strong OraclePL/SQL development background besides DBA skills.
• Experience in database security strategies by creating database Implemented & monitored daily, weekly and monthly batch jobs in database.
• Worked with Automatic Storage Management (ASM) Oracle utility which provides a
• simple storage management interface that is consistent across all server and storage.
• Upgrading and Migrating Databases from lower versions to higher versions.
• Experience in analyzing database & rebuilding indexes to improve database performance.
• Applying oracle patches (CPU, PSU and ONE-OFF), using the OPatch utility and fixing bugs.
• Supported and provided Oracle DBA on-call after hours support for a 24x7 production environment.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g, 11gR2, SQL Server 2005 and 2008

Operating Systems: Red Had Linux, Sun Solaris and Windows

Languages: SQL, PL/SQL, C, JAVA, Shell Scripting, Perl Scripting.

Tools: RMAN, RAC, ASM, Oracle 10g Grid control, OEM Cloud control 12c, Data Guard, SQL*Loader, EXP, IMP, TOAD, Datapump, Golden Gate, SQL developer.

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, AUTO Trace.

PROFESSIONAL EXPERIENCE

Confidential, WA

Oracle DBA Consultant

Responsibilities:

• Installed and maintained Oracle 11g/11gR2 databases having good exposure on Linux, HP-UX and Windows
• Upgrade, patching Oracle databases
• Set up and administered table spaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redologs.
• Working with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Working with ERP Modules and E-Business Suite
• 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.
• 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 and TOAD.
• 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.
• 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..

Environment: Oracle 11g R2/11g, Oracle 10g (10.2.0.3/10.2.0.4),SQL,PL/SQL, RMAN, SQL Plus, TOAD, Solaris, RAC, HP-UX, LINUX, Golden Gate.

Confidential, MA

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 Tablespaces, users security of data accessibility and Configuring Archive log destinations
• Reorganized the database tables to improve report generation time.
• Database monitoring using OEM. Application and database tuning using stats pack.
• Improve application run time by building optimal indexes, gathering object statistics, analyze objects and using parallel query.
• Database refreshes, environment configurations, and troubleshooting.
• Performed several rollback to undo and dictionary to local extent management tablespace conversions.
• Troubleshot database errors, warnings, 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.
• Performing the logical and physical structures for tables, indexes, modeling, normalization and foreign key constraints.
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Installation, configuration and troubleshooting Golden Gate issues

Environment: UNIX Sun OS 5.6/ HP UNIX 11.11, Windows NT 5.0/ 2000, Oracle11g, 10g, RMAN, OEM, Toad, Golden Gate.

Confidential, LA

DBA

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 to 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 optimization using SQL Trace / Tkprof.
• 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.
• 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 RAC, SQL server 2005, Toad, Dataguard, Oracle Forms & Reports.

Confidential, Atlanta, GA

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.
• Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of various sizes - 10TB.
• 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 Consultant

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.
• 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.