SUMMARY

• 9 years of experience as Oracle Database Administrator, provided 24x7 production support as well as for Development databases on 12c/ 11gR2/10gR2/9i/8i databases on different OS Platforms.
• Experience on oracle 12c/ 11g/ASM/RAC and converting of standalone databases to 11g RAC databases.
• Installation, administration and maintenance of Oracle 11g/10g on OEL, RHEL, UNIX and Sun Solaris in OLTP environment.
• Configuration of Automatic Storage Management (ASM) for RAC databases using ASMLib and ASMCMD.
• Experience wif Recovery Manager (RMAN), Oracle Automatic Storage Management (ASM), Oracle Data Guard and Oracle Data Pump.
• Extensive experience wif Database Cloning and Refreshing pre - prod/dev databases wif prod/pre-prod databases.
• Delivering Oracle Database performance-tuning services for customers wif Explain Plan, TKPROF, AWR, ADDM, ASH, SQL Trace, ORADEBUG, 10g OEM Grid Monitoring, Oracle Diagnostics pack, Oracle Tuning Pack.
• Experience in regular Database Administration activities such as Upgrades, Migration and Patches which are downloaded from oracle metalink.
• Migratedsingle instance databases to multi node Oracle RAC environmentfor high availability and load balancing.
• Expertise in data migration techniques.
• Hands on experience in Grid Control, Streams and Gloden Gate replication.
• Installation and configuration of RMAN wif and wifout Recovery Catalog on Oracle 12c/11g/10g databases.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial also used Datapump export/import.
• Performance tuning the database server at Instance, Sql, Memory, Disk me/O and at OS level.
• Capacity planning, scripts development, and documentation.
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data guard.
• Skilled in using tools such as SQL Developer and TOAD and loading data from flat files using SQL Loader and External Tables.
• Experience developing and running PL/SQL scripts for Production, Development and Test databases.
• Experience working wif Database Resource Management.
• Involved in Replication of data using Streams.
• Writing shell scripts for automating various database activities like backup and recovery, performance tuning and managing archive data and dump and trace files.
• Awareness on Oracle Support processes for technical requests through Oracle Meta link.

TECHNICAL SKILLS

Operating System: Red Hat Linux, Solaris, HP-UX, Windows NT/2003/XP/7.:

Databases: Oracle 9i/10g/11g, RAC 10g/11g:

Languages: C++, SQL, PL/SQL, JAVA scripting, Shell scripting.:

Web Servers: Apache Tomcat, Web logic:

Tools: and Utilities(ORACLE): Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, Explain Plan, STATSPACK, AWR, ASH, ADDM, RMAN, FTP, TKPROF, ASM.:

Other Tools: WINSCP, Putty, TOAD.:

PROFESSIONAL EXPERIENCE

Confidential, IA

DataBase Administrator

Responsibilities:

• Provided support to customers to manage their operational dataranging from GB to TB in Oracle database, solving of space problem, data loading problem and other database maintenance operations.
• Involved in upgrades from oracle 9i to 10g, 9i/10g.
• Performed migration from 9i to 10g from AIX to Linux.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Data selection, filtering, transformation and column mapping, and Built-in functions inGlodenGate.
• GlodenGateinstallation, configuration and troubleshooting various GG issues.
• OracleGlodenGateinstallation, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• Involved in building backup and recovery plans for critical databases from failures wif minimum downtime.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them wif users.
• Creating and Managing Table spaces wif different block-sizes to prevent row chaining.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Environment and Database preparation forGlodenGateinstallation and setup.
• Experience wif oracleGlodenGatereplication setup in various modes like: unidirectional (for query offloading), Bidirectional (for Standby DB or Active-Active for HA), broadcast distribution and data integration.
• Supported Oracle 11gR2 RAC databases.
• Monitoring and supporting more than 100 database instances using scripts and daily health check like alert logs, invalid objects, table spaces usage, long running queries, backups, listener up and running, etc.. Writing UNIX shell scripts and set into cronjob to monitoring all databases and send an alerts in email.
• GlodenGateperformance tuning and troubleshooting production issues.
• Used variousGlodenGatetools/utilities like logdump, defgen, Reverse, convchk etc.
• Implementing necessary monitoring scripts forGlodengatein Unix Shell/Perl scripting.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Worked on DB deploys and supported developers, using internal tool AnthilProd.

Confidential, OH

ORACLE DBA

Responsibilities:

• Installation and creation and maintenance of 10g RAC and 9i databases for Testing, Development and Production.
• Provided support to customers to manage their operational dataranging from GB to TB in Oracle database, solving of space problem, data loading problem and other database maintenance operations.
• Involved in upgrades from oracle 9i to 10g, 9i/10g.
• Performed migration from 9i to 10g from AIX to Linux.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Data selection, filtering, transformation and column mapping, and Built-in functions inGlodenGate.
• Extensive experienced in using Oracle Utilities & functions including RMAN Catalog, Data Guard, AWR, ASH, Statspack, Data Pump, exp/imp, OEM grid controls.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• GlodenGateinstallation, configuration and troubleshooting various GG issues.
• OracleGlodenGateinstallation, upgrade, setup, monitoring, performance tuning, and troubleshooting.
• Involved in building backup and recovery plans for critical databases from failures wif minimum downtime.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Extensive experience in configuring and managing Data guard on RHEL, OEL and Windows.
• Configuration of data guard broker on RAC.
• GlodenGateinstallation, Configuration of Bi-Directional and Unidirectional processes for ACTIVE-ACTIVE, Active-Passive environments and troubleshooting various issues.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them wif users.
• Creating and Managing Table spaces wif different block-sizes to prevent row chaining.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Environment and Database preparation forGlodenGateinstallation and setup.
• Experience wif oracleGlodenGatereplication setup in various modes like: unidirectional (for query offloading), Bidirectional (for Standby DB or Active-Active for HA), broadcast distribution and data integration.
• Supported Oracle 11gR2 RAC databases.
• Monitoring and supporting more than 100 database instances using scripts and daily health check like alert logs, invalid objects, table spaces usage, long running queries, backups, listener up and running, etc.. Writing UNIX shell scripts and set into cronjob to monitoring all databases and send an alerts in email.
• GlodenGateperformance tuning and troubleshooting production issues.
• Used variousGlodenGatetools/utilities like logdump, defgen, Reverse, convchk etc.
• Implementing necessary monitoring scripts forGlodengatein Unix Shell/Perl scripting.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Maintained SOX DB user’s inventory and monitored logons etc.
• Co-ordinated wif storage team and Production team (CONTROL +M) as and when required.

Environment: Oracle 10gR2/11gR2/12C, SunOS 5.10, HP-UX 11.11, Linux, Db artisan, AIX, Shell Scripting, RMAN, Gloden Gate, Data guard, Data pump, OEM Grid Control.

Confidential, SC

ORACLE DBA

Responsibilities:

• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Upgraded 10g OEM to 12C using 2 system upgrade on a 2 node RAC repository wif dual OMS for high availability.
• Deployed and configured 12c agents.
• Expertise in monitoring, troubleshooting OEM 12C.
• 24/7 Supported critical OLTP Production databases on RAC and non-RAC environments.
• Supported Oracle 11gR2 RAC databases..
• Attained proficiency in Oracle database administration wif RAC andGlodenGateReplication ver. 10x, 11x, 12c activities
• Installed and Configured 3 node 11.2.0.3 RAC wif Data guard setup on Linux.
• Monitoring and supporting more than 100 database instances using scripts and daily health check like alert logs, invalid objects, table spaces usage, long running queries, backups, listener up and running, etc.. Writing UNIX shell scripts and set into cronjob to monitoring all databases and send an alerts in email. Also, wrote scripts for monitor Shareplex and migration monitoring and purging.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Worked extensively on OracleGlodenGateImplementation, support and maintenance. TEMPHas Implemented the classicglodengate, Active - Active Bi-di wif CDR. TEMPHas also used mapping. ImplementedGlodenGateMulti directional replication in different region.
• Involved in building backup and recovery plans for critical databases from failures wif minimum downtime.
• Involved in creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers.
• Provided Assistance to application team at the time of SQL tuning in applications.
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc.. .
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Experience in Data modeling using Erwin tool.
• Installed, Configured and Supported application which had 4-way shareplex replication.
• Upgraded databases from 9i, 10.2.0.4 to 11.2.0.2.
• Worked on Table partitioning to increase performance.
• Responsible for network configuration and involved in a Client - Server environment using TNSNames, LISTNER, Net Configuration Assistant and other configuration files.
• Created and Managed users, user profiles, tables paces, data files, archive log.
• Monitored and troubles hooted database issues wif OEM grid control.
• Script and automate DBA activities includingGlodenGatemonitoring at process and checkpoint level.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: Oracle 9i/10gR2/11gR2, SunOS 5.10, HP-UX 11.11,Linux, Db artisan, AIX, Gloden Gate, Shell Scripting, RMAN, Datapump, Data guard, OEM Grid Control.

Confidential

ORACLE DBA

Responsibilities:

• Involved in 24x7 supports for Production database and applications wif on-call pager.
• Installation and creation and maintenance of 10g RAC and 9i databases for Testing, Development and Production.
• Provided support to customers to manage their operational dataranging from GB to TB in Oracle database, solving of space problem, data loading problem and other database maintenance operations.
• Involved in upgrades from oracle 9i to 10g, 9i/10g.
• Performed migration from 9i to 10g from AIX to Linux.
• Migration of databases (Oracle 10g/11g) across Heterogeneous platforms using Gloden Gate.
• Setup Gloden Gate Database User wif necessary privileges
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Use of RMAN for Backups, Rebuild Data guard using RMAN, Rebuild out of sync Data guard wif incremental backup using RMAN.
• Configured 10g Active Data guard, Monitor and maintain data guard, Switchover Primary to Standby.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them wif users.
• Creating and Managing Tablespaces wif different block-sizes to prevent row chaining.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Resolving SQL tuning issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from flat files and from text files.
• Worked on Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard. Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Setup Gloden Gate Database User wif necessary privileges
• Implemented OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM), Oracle Sales Analyzer (OLAP front-end) in Oracle 8i / 9i environment, Data Migration as part of enterprise data warehouse project. Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Performed scheduling of Change Control-activities and scheduling jobs.
• Tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule these activities.
• Setup Gloden Gate replication during database migration from AIX to Linux server
• Contact oracle metalink to resolve database issues and to raise SR’s

Environment: 10g RAC/9i, ASM, AIX, Sun Solaris, Red Hat Enterprise Linux, OEM, Gloden Gate, Explain Plan, Data guard, Tkprof, SQL*LOADER, Oracle Express.

Confidential, DALLAS, TX

ORACLE DBA

Responsibilities:

• 24x7 Production on call Database support.
• Performing 9i and 10g Oracle Databases Administration, Monitoring and Patch application.
• Installation, Configuration, Designing and Maintaining of Oracle 10g on AIX 5.3, HP-UX 11.11.1, Sun Solaris 10 and Red Hat Linux.
• Installed and Configured Oracle 10g RAC (2 node cluster), CRS using ASM.
• Upgrade/Migration of Databases from Oracle 9i to 10g and 10g to 11g.
• Experience in Upgrading database 10.1 to 10.2 and applied patch set 10.2.0.2 to multiple databases.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups wif ASM.
• Used Data guard cluster techniques to provide a high level of data protection and data availability.
• Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintain primary and standby databases.
• Monitoring servers, reports generation and administrating physical Standby database.
• Configuring and troubleshooting RMAN backup & recovery issues.
• Worked on 24X7 critical Data Center applications.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases wif the Catalog.
• Experience of installing, configuring Gloden Gate and troubleshooting Gloden Gate issues.
• Experience in Uni-directional and Bi-directional replication through Gloden Gate.
• Recovered successfully two production databases from RMAN backups due to an unexpected media failure resulting in data corruption errors and loss of control files.
• Performed CDC (Change Data Capture) along wif data replication and MDM (Master Data Management) capabilities of Gloden Gate.
• Extensively used Oracle utilities -Export, Import, data pump and Sql loader etc.
• Creating physical databases, as well as the schemas and objects wifin the database.
• Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day-to-day tasks.
• Monitoring the database, Managing sessions, listeners, underlying physical components against performance and availability thresholds.
• Creating user accounts wifin the database and granting roles and privileges as requested, in accordance wifin the security compliances.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• SQL tuning and Database tuning TEMPhas been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, AWR, Explain Plans, ADDM and monitor the database performance on daily basis.

Environment: Sun Solaris, SUN SPARC, HP-UX, Windows 98/NT/2000, IBM X Series Server, Oracle 9i, Oracle Enterprise Manager, Gloden Gate, Data guard, STATSPACK, TKPROF, EXPLAIN PLAN

Confidential, HERDON, VA

ORACLE DBA

Responsibilities:

• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems.
• Logical and Physical Modeling using ERWIN Data Modeler.
• Management of table spaces for different users by granting quota on Default & Temporary table spaces.
• Estimated Storage capacity for database objects.
• Assisted in designing, planning and managing the data migration process.
• Monitored the growth of the database objects java scripting. Implemented for capacity planning.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Expertise in Oracle Gloden Gate installation, configuration, troubleshooting GG issues.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.
• Implemented and maintained streams for synchronization of data at various sites.
• Utilized SQL*loader and data pump import to load data into tables.
• Installation and configuration of GOLDEN GATE Cross Platforms.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Took a logical backup of the entire database using import/export utility.
• Created and implemented Oracle database backup and recovery strategies using RMAN.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.

Environment: Oracle 10g/9i, HP-UX, AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TPROF, Gloden Gate, Explain plan, STATSPACK, SQL* Loader, Windows NT/2000.

Confidential

ORACLE DBA

RESPONSIBILITIES:

• Responsible for maintenance of production.
• Created tables, views, materialized views
• Database administration tasks included performing regular Hot&Cold Backups,Job Scheduling.
• Managing Database Structure, Storage Allocation, Table/Index segments
• Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT
• Configured and managed OEM to stabilized oracle database into healthy environment.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Assisted in designing, planning and managing the data migration process.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
• Maintenance & modification of Shell Scripts.
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes and Loaded bulk data wif SQL*Loader.
• Develop, document and enforce database standards and procedures.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
• Troubleshooting and fixing database listener issues.

Environment: Oracle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell Scripts, RMAN, OEM/Grid Control, SQL*Loader, Data Pum