• 6 Plus Years of extensive experience as Oracle 11gR1/R2/10g/9i Database Administrator.
• Experience as a Production support/Operations DBA with Multi-Terabyte large databases and as well as Development/Engineering/Data Warehouse DBA.
• Hands on experience in 11gR2/10g RAC Real Application Clusters .
• Monitoring database activity for specific client performance issues.
• Experienced at SQL Loader, expdp, impdp, exp, imp and other Oracle utilities Used ERWIN for Logical Data modeling and creating physical database designs.
• Managed Oracle environment easily and consistently using Oracle Grid Control. Used Grid Control to manage Real Application Cluster.
• Created RMAN database backup and used OEM to manage the data, accounts and tuning.
• Effectively using Oracle Table partitioning, Parallel Query Execution and Parallel Processing
• Monitoring database for its smooth functioning and proactive steps will be taken as and when required.
• Installation, Configuration and Administration of Oracle 9i, Oracle 10g databases.
• Troubleshooting Oracle errors, fine-tune database parameters, and analyze STATPACK reports.
• Used STATSPACK, AWR, ADDM, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Expertise in SQL / PL SQL code tuning, analysing the trace files and explain plan, using stored outlines for plan stability, and optimizer parameter tuning.
• Worked on Golden Gate Replication tool.
• 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 DB's.
• Expertise in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Created partitions table to improve performance on RAC and Non RAC environment.
• Monitoring database activity for specific client performance issues.
• Migrated Databases from Windows to Linux.
• Knowledge of Oracle Exadata Database.

Software Skill Set:

• Operating Systems: MSDOS, Windows 95/ 98/ 2000, Win 2KSever, UNIX.
• Languages: C, C , Java, SQL, PL/SQL, Shell programming
• Database: ORACLE 8i/9i/10g/11Gr2, SQL Server, Sybase.
• RDBMS Tools: OEM, RMAN, TOAD, Shareplex, Autosys.
• Web Technologies: HTML, JAVASCRIPT.
• Front End Tools: Forms 6i,Reports 6i

Confidential

Oracle Database Administrator

Responsibilities:

• Expertise in Oracle Real time Application Cluster RAC with Installation, Converting stand-alone databases to RAC, Upgrading, Patching, Troubleshooting in RAC Environment.
• Good exposure to Golden Gate in implementation and supporting in day to day activities.
• Expertise in Performance Tuning of Oracle Instance, Oracle/OS Parameter, SQL/PLSQL Tuning, Code Optimization.
• Expertise in SQL / PL SQL code tuning, analysing the trace files and explain plan, using stored outlines for plan stability, and optimizer parameter tuning.
• Expertise in multiple DBA roles Database Architect, Production support, Development and Data warehousing environments .
• Expertise in Installation, upgrade and patching of databases from Oracle 8i, 9i, to Oracle 10g 11g.
• Good Exposure working with Streams in Oracle 11g.
• Effectively using Oracle Table partitioning, Parallel Query Execution and Parallel Processing
• Effective Designing for Oracle Databases Normalization and De Normalization of Tables
• Expertise in Backup and Recovery troubleshooting of production systems using RMAN
• Expertise in Performance and Security audits
• Expertise in Database Upgrade and Migration of large databases.
• Expertise in Implementing and managing the Data guard Logical and Physical Standby using DG-Broker solutions for Disaster Recovery.
• Strong leadership qualities and result oriented.
• Developed best practices for support with DBA teams.

Confidential

Oracle Database Administrator

• Supporting Production and Development, UAT Environments simultaneously. Database related changes will be applied in production only after the changes passed in staging and UAT environments.
• RDBMS installation and upgrade, Database creation and configuration, applying patches when needed.
• Applying the Data Structural Changes on to different Environments based on the standards provided by client.
• Refreshing data from live environment to their desired environment upon their request for their Testing purpose.
• Performing maintenance activities on the database before making the application live.
• Have been providing on call support and support to batch team in case of any issues.
• Monitoring the daily scheduled backups and resolving as and when there is a failure.
• Resolving issues raised by the users upon their request and providing support to client.
• Have been involved in migration of Database during Server up-gradation.
• Cloning the databases have been performed different methods like RMAN DUPLICATE, Hot and cold backup cloning and export/import.
• Capacity planning space management. Resolving issues related to space management, creating, managing table spaces as per the requirement.
• Performed table reorg and db reorg.
• Database user and role administration, Database security and permission password reset, granting/revoking special privileges
• Good exposure on Rman and Shell Scripting.
• Have worked with ERWIN Data Base model tool.
• Monitoring database for its smooth functioning and proactive steps will be taken as and when required.
• Database connectivity tnsnames, listener, Names Server database links, synonym etc.
• Estimating statistics using dbms stats package analyzing objects using compute estimate methods
• Perform index rebuilds in regular intervals and avoiding fragmentation
• Creating maintaining database objects ddl scripts and providing application support
• Performing support to issues related to the application.

Confidential

Position: Oracle Database Administrator

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i, Oracle 10g databases.
• Migrated oracle databases from 9i to 10g version.
• Perform capacity planning required to create and maintain database environments.
• Created RMAN database backup and used OEM to manage the data, accounts and tuning.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters RAC on different nodes with Automatic Storage Management ASM .
• Created a number of database instances for development, testing and production.
• Maintained Development databases, Test databases and applied Patches
• Managed Oracle environment easily and consistently using Oracle Grid Control. Used Grid Control to manage Real Application Cluster.
• Running imports/export utilities, off-line backup, on-line backup various PL/SQL server Applications utilities, used File Transfer Protocol.
• Worked on Golden Gate Replication tool.
• Used SQL server 2008 agent to automate the SSIS package execution.
• Cloning of databases from production to Dev QA Databases.
• Provided partitioning of the large tables to reduce the access time.
• Created and maintained databases: Creating table spaces, tables, indexes, and views and materialized views.
• Monitored table space size, resizing table space, relocating data files for better disk I/O.
• Created users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Written complex queries and stored procedures using sql plus and monitored databases using TOAD.
• 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 DB's.
• Experienced at SQL Loader, expdp, impdp, exp, imp and other Oracle utilities Used ERWIN for Logical Data modeling and creating physical database designs.
• Replicated materialized views with fast refreshes for transfers of information.
• Used STATSPACK, AWR, ADDM, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Troubleshooting Oracle errors, fine-tune database parameters, and analyze STATPACK reports.
• Configured disaster recovery site with physical standby database for high availability.
• 24 7 production support and on call rotation.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.
• Involved in testing stage of two-node RAC implementation on SUSE Linux.
• Extensively wrote UNIX shell scripts, PL/SQL, Stored Procedures and Triggers.

Environment: Oracle 9i/10g, Toad, SQL Plus, SQL Loader, Sql Server 2008, RMAN, RAC, Oracle Enterprise Manager OEM Grid Control, Golden Gate, ERWIN, RMAN,LINUX,HP-UX11i, AIX 5.1, 5.2.

Confidential

Oracle Database Developer.

Responsibilities:

• Complete Design of database, Logical and Physical modeling.
• Attended meetings with client on finalizing requirements.
• Developed PLSQL packages involving external tables that moves the files of different structures across the folders, extract , transform, validate and loads the data to oracle tables
• Created Common Database packages and packages for batch processing.
• Doing Data migration from Legacy to current system.
• Creating templates for oracle reports
• Preparing database design document, Size estimation document, Migration mapping document

Environment: Windows 2000, VISIO 2003, Oracle Designer, Oracle 9i, 10g, PL/SQL, SQL, TOAD 9, Reports 10g.