SUMMARY

• 7 years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.
• Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g on a variety of operating systems including UNIX/LINUX, Solaris and Windows environment.
• Experience in Migration Projects. Hands on experience in - migrating from Oracle 9i to 10g (10.2.0), 10g to 11g and applied oracle patches.
• Deploying WIT’s and CR’s scripts in Oracle and SQL databases.
• Experience in Management Studio 2008 and 20012 within a SQL Server environment.
• Deploying and Restarting of SQL Jobs using Management Studio.
• Monitoring Filegroups in SQL databases.
• Implemented strategy for partitioning and management of historical data tables in 11g R2RAC.
• Oracle RAC 11gR2 Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Installed, Configure and troubleshoot Oracle GoldenGate.
• Expertise in replication technologies using Golden Gate.
• Experience in Tuning the performance of Oracle Golden Gate.
• Experience in Data Integration, Transactional change data capture using Golden Gate.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
• Evaluated the procedures done in testing and analyzing computer applications by using knowledge of Perl programming.
• Good experience in SQL, MSQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan.
• Have implemented ORACLE STREAMS.
• Oracle Database Gateway for ODBC to integrate with low-end data stores such as MySQL, Foxpro, Access, dBase and non-relational targets like Excel.
• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM.
• Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 11g/10g/9i/10gRAC.

Languages: SQL, PL/SQL, MySQL, C, C++, Perl, C#, VB.NET, JAVA, XML, UNIX Shell Scripting.

DB Management: OPTIM, OEM, DBArtisan, OEM Grid Control.

Tools: /Utilities: RMAN, OEM, Goldengate, Oracle Management Server, SQL*Loader, Export/Import, TOAD, Data pump,, MS Access,.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDR.

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 0, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. Oracle DBA

Responsibilities:

• Cloning and Refreshing oracle databases from Production Database.
• Upgraded from 11.2.0.2 to 11.2.0.3 applied patches to databases
• Deploying WIT’s and CR’s scripts in Oracle and SQL databases.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Checking Alert log, Backup-Log and other files.
• Implemented High Availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Implemented Stream, Golden Gate for Active-Active Replication between Datacenter for high-availability.
• Working on Tablespace growth and managementincreasing the size if necessary.
• Backup management, Hot and Cold backups.Restarting the Backups.
• Experience in taking Backups of Tables and Schemas using Exporting and Importing Datapumps.
• Experience in Management Studio 2008 and 20012 within aSQLServer environment.
• Deploying and Restarting of SQL Jobs using Management Studio.
• Monitoring Filegroups in SQL databases.
• Monitoring and Managing log space and Disk space on SQL Clusters.
• Performance tuning of Queries by maintaining Aggregates, Compression, Partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Daily routineDBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• 24x7 production support on holidays, weekends and beyond regular hours.

Environment: Oracle 11g, Sun Solaris, Red Hat Linux, AIX, OEM GC, RMAN, STATSPACK, AWR, ADDM, TOAD, SQL Managment Studio 2008, TFS Control System. ITSM Ticketing tool.

Confidential, StLouis, MO

Sr. Oracle DBA

Responsibilities:

• Configuration, maintenance and tuning of Oracle 10g/11g .
• Peer review on all Production 10g and 11g RAC Databases.
• Great experience in working with ORACLE EDM PROFILES.
• Extensively worked with ASMCMD for managing ASM environment.
• Implemented backup/recovery procedures using RMAN, Data Pump, and performed database recoveries.
• Implemented backup/recovery procedures using RMAN, Data Pump, and performed database recoveries.
• Creating and Implementing RMAN Validate Scripts.
• Providing security to privileged accounts to access to sensitive data using Data Vault.
• Implemented Data Vault to protect old database transparently .
• Installation and Implementation of Oracle Data Vault on 10g.
• This helped to maintain the security feature in well-controlled manner and as of single point with role.
• Experience in Configuration of 11g R2.
• Expertise in replication technologies using Golden Gate.
• Experience in Tuning the performance of Oracle Golden Gate.
• Experience in Data Integration, Transactional change data capture using Golden Gate.
• To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data.
• Performance tuning of Queries by maintaining Aggregates, Compression, Partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Working and Completing daily Work request and Problem Tickets on time.
• Estimate the size of the Database and its Objects (in large database of 1 to 2 Terabyte).
• Responsible for Analyzing, Designing and Coding of the applications by utilizing the Perl.

Environment: Oracle 10g, Oracle 11gR2 RAC, Data Vault, MySQL, Toad, Sun Os 5.10, RHEL Windows 2003,OEM.

Confidential, Durham, NC

Sr. Oracle DBA

Responsibilities:

• Oracle Clusterware installed to provide infrastructure for RAC and configured 3 node Oracle 10g/11g R2 RAC with ASM.
• Configuration, maintenance and tuning of Oracle 11g/10g/9i RAC.
• Performed various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
• Experience in Configuration of 11g R2 RAC.
• Responsible for Analyzing, Designing and Coding of the applications by utilizing the Perl.
• Evaluated the procedures done in testing and analyzing computer applications by using knowledge of Perl programming.
• Experience in Upgrading and Migrations from R11 to R12.
• Responsible for setting up Oracle Streams to help in propagating information within and between databases.
• Upgrading development and production databases to Oracle 10g.
• Applied Security patches and Patch set on Oracle Databases.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Extensively worked with ASMCMD for managing ASM environment.
• Implemented backup/recovery procedures using RMAN, Data Pump, and performed database recoveries.
• Implemented flashback technology.
• Installation and Implementation of Oracle Data Vault on 10g. This helped to maintain the security feature in well-controlled manner and as of single point with role.
• Extensively used AWR, ADDM, TKPROF, SQL and MySQL Trace for database performance statistics.
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Tuning Query performance by creating indexes
• Used and maintained Bitmap indexes, materialized views.
• Considerable knowledge of design, Administration, and performance tuning of MySQL.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Troubleshoot user related and database related issues using Oracle Support Services.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

Environment: Oracle 9i/10g/11g, Sun Solaris, Red Hat Linux, AIX, OEM GC, ASM, RMAN, STATSPACK, AWR, ADDM, TOAD, Perl scripting, Shell scripting, SQL*Loader, MySQL, Data guard, Stored Procedures, Grid Control,.

Confidential, Wayne-NJ

Oracle DBA

Responsibilities:

• Performing all the Database Administration activity like space management in database, User and Roles administration, Schema management, checking alert log of all the databases using OEM.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Implemented strategy for partitioning and management of historical data tables in RAC.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, MySQL, PostgreSQL, TKPROF, TOAD and OEM.
• Performance tuning of Queries by maintaining Aggregates, Compression, Partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Estimate the size of the Database and its Objects (in large database of 1 to 2 Terabyte).
• Devised & Implemented backup strategies using Hot, Cold, and Exports based on the business requirements.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
• Used SQL*Loader for loading legacy systems database data.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle Data pumps.
• Verifying MySQL replication integrity with pt-table-checksum.
• Developed UNIX and Windows Batch shell scripts to perform the above tasks efficiently.

Environment: Oracle 10g with RAC, ORACLE 9i,SQL, MySQL, Dataguard, PL/SQL, Toad, Pl/SQL Developer, Erwin, And O/S: RHEL 4.2, HPUX, Windows 2003, And OEM.

Confidential, San Antonio-TX

Oracle DBA

Responsibilities:

• Installation, Implementation and Maintenance of the Oracle database.
• Created and managed the database objects such as tables, indexes and views
• Create the users and roles
• Created and managing the database storage structures which includes data table spaces, index table spaces, rollback table spaces and rollback segments
• Loading the database with SQL*Loader
• To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data
• Performing the logical and physical structure of tables, indexes, modeling normalization and foreign key constraints
• Database maintaining including backups, recovery, imports/exports
• Monitoring the database daily activities

Environment: Oracle 9i, SQL, PL/SQL, TOAD, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Linux.

Confidential

Oracle DBA

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system
• Use TOAD tool to access the database
• Used PL/SQL developer to create PL/SQL Procedures
• Testing PL/SQL procedures against the test cases.
• Involved in creating use cases and test cases

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database Tools/Utilities, Oracle Enterprise Manager.