HIGHLIGHTS

• Around 7 years of experience as Database Administrator, providing 24/7 support of both development and production Oracle 9i, Oracle 10g and Oracle 11g on Various Platforms.
• Extensively worked as Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling Application Performance Tuning.
• Over 5 years of experience working with Oracle Data Guard Implement support.
• Planned, installed, configured and performed upgrades of Oracle DBMS software on various platforms.
• Working Experience of setup and configuration, implementation of ASM/Grid Control/Automation/RMAN.
• Extensive Knowledge of Automatic Workload Repository AWR , Oracle Data Pump,ASM,DataGaurd
• Generating statistics of database using ADDM and tuning the database accordingly.
• Experience working on SQL Trace, TKPROF, Explain Plan.
• Experience in creating different kinds of partitions on tables and indexes for managing large tables.
• Gathering of cost-based optimizer CBO statistics for tables with stale statistics performance tuning using Dbms Stats.
• Expertise in installation and configuration of oracle 9i, 10g, 11g on various platforms like IBM-AIX, SUNSOLARIS, HP-UX, RedHat Linux and Windows.
• Experience in upgrading CRS, ASM and Database and also applying oracle patches for CRS and RDBMS homes.
• Performed backups and tested crash recoveries using conventional hot cold backups and RMAN and Veritas Netback up.
• Hands on experience in using dbms packages like DBMS JOB, DBMS SCHEDULAR, DBMS SQL.
• Analyzed Tables, Indexes periodically to optimize the SQL queries and assigning proper indexes such as BIT map or B-Tree Index according to requirements.
• Used EXPDP IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Experience in using OEM, TOAD, Data Migrations using export/import.
• Proactive monitoring and identifying issues in database and its services using OEM Grid Monitoring 10G, 11G, 12C .
• Performed complete multi-master replication with updateable materialized views.
• Strong knowledge in SQL, PL/SQL.
• Expert experience in Hot and Cold Backup of databases.
• Experience in Extracting, Transforming and Loading ETL data using SQLloader utility.
• Managed Undo Segments in order to avoid Snapshot too old .
• Experience in Tablespace management both local and dictionary.
• Experience in ORACLE RAC installations.
• Created roles, profiles and privileges and assigned roles to users.
• Automated many common tasks with Scripts by scheduling jobs crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Experience in working high transacted OLTP systems.
• Experience in working with Reporting tools such as Crystal Reports.
• Strong Knowledge of Creating Public Synonyms, DBlinks, Ref Cursors, Raise Application Error, Parameterized Cursors.
• Experience in working with different FTP clients like Smart FTP, cute FTP, SFTP and SCP.
• Performed 24x7 production system problem analysis and recommend corrective measures in a timely manner.

Technical Skills

• Operating Systems : HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,
• Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP
• RDBMS : Oracle 9i, 10G, 11g , 11g RAC, 10g RAC.
• Languages : SQL, PL/SQL, C, C , PERL, UNIX Shell Scripting.
• Tools : RMAN, OEM, SQL Developer, EXP, IMP, expdp, impdp, TOAD, Foglight.
• Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDM
• Database Modeling : Erwin 4.0, Toad Data Modeler.
• Other : EMC, NetApp, Veritas NetBackup, TSM, HP OmniBack.

Experience

Confidential

Role : Sr Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Development, UNIX shell scripting, Oracle Linux, Solaris, RHEL.

Responsibilities:

• Configured, Setup, maintaining Oracle11g RAC two-node environment on ASM on EXADATA box.
• Applying PSU patches and other security patches on 11G RAC and Standalone Databases.
• Defining and Implementation of backup and recovery strategies.
• Discovering, Promoting and adding target hosts and databases in Enterprise manager 12C.
• Monitoring Database performance, identifying issues and resolving them using OEM Cloud Control 12C and Foglight.
• Managing complex Standby databases and Data Guard for disaster recovery.
• REFRESH/CLONING of Database using RMAN Duplicate for development, testing.
• Converted large Non-Partitioned tables to Partitioned tables following Range partitioning method, to improve the performance.
• Extensively worked on deployment/migration process, data flow control between production, development and reporting.
• Configured a job to gather the statistics of database objects using DBMS STATS on various databases.
• Optimization and tuning SQL queries using SQL TRACE, EXPLAIN PLAN and by monitoring STATS PACK report generated from snapshots taken at the peak business hours.
• Data refresh from production to test and development on quarterly basis.
• Wrote SQL scripts to monitor tablespace and extent growth.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Writing scripts for the system and database for effective functionality and report generation.
• Monitoring and Troubleshooting of Database Replication issues.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption.
• Detected locks and resolving in-doubt transactions manually.
• Tested many backup and crash recovery scenarios on test environment 10g, 11g , using RMAN tool.
• Management of schemas, objects partitioning the tables indexes.
• Installed and Configured Oracle Dataguard for Oracle 11g 10g for the maintenance of Standby database.
• Actively involved in group meeting and user interaction to get feedback from users and to meet business requirements.
• Developed, communicated and implemented Disaster Recovery plan for DR exercise.

Confidential

Role : Sr Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Development, UNIX shell scripting, AIX, RHEL.

Responsibilities:

• Installed and configured Oracle database Setup on brand new machines including Oracle software installation, Oracle database creation, and backup setup on multi-node RAC environment.
• Created and maintained Oracle11g database on RAC four-node environment on ASM.
• Upgraded Oracle database from 10.2.0.5 to 11.2.0.3 and applied oracle patches to rdbms homes from 11.2.0.3.0 to 11.2.0.3.6.
• Wrote shell scripts for various database activities like space cleanup, datapump refresh, RMAN refresh.
• Migrated data using import/export, oracle datapump, transport tablespaces and standby databases.
• Converted single instance to three-node Real Application Cluster RAC database instances.
• Reorganized existing database to standardize the placement of various databases related files.
• Implemented Standby Database Physical/Logical using Data guard for faster Disaster Recovery and HA.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection.
• Converted/altered existing manual Partitioned tables for large customer related data in to Interval-Partitioned tables.
• Was involved in developing a Disaster Recovery DR plan implemented a DR exercise.
• Used DBMS STATS to gather the statistics along with analyze command.
• Monitored and configured, oracle 9i, 10G and 11G databases using OEM 11G.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Performed logical backup using export and import utilities.
• Migrated oracle databases from oracle 10.2.0.4 to 11.1.0.7 on AIX to RHEL.
• Health Check Up of the Database using STATSPACK, AWR, ADDM. Performance tuning of Database objects by fixing row chaining, I/O and CPU bottle necks.
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL Trace and TKPROF, STATSPACK.
• Continuous performance monitoring through TOAD, OEM tuning pack, diagnostics pack, StatsPack and Unix Shell Scripts like system resources, hit ratios, I/O, locks and Latch contention.
• Migrating Data from Legacy Databases 9i/10g to target databases.
• Maintaining data integrity and tune database for optimum performance and availability.

Confidential

Role : Database Administrator

Environment: Oracle 11g/10g/9i, SQL, PL/SQL, SQL Development, UNIX shell scripting, AIX, Sun Solaris, Windows NT/2003.

Responsibilities:

• Involved in 24x7 support for both production and development databases with on-call pager.
• Supporting both production and development activities.
• Installation and creation of 10g and 11g databases for Testing, Development and Production.
• Installation of Oracle version 10g Release2 64 Bit on Solaris 10 and HP-UX11.
• Clone/Refresh of Production databases to Testing and Development environments to test simulate few technical challenges.
• Supported Production Database Oracle 9i RAC 4 Node with High Level Evaluation, performance tuning, instance recovery, load balance.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK, AWR, ADDM.
• Upgraded of Database from 9.2.0.6 and to 10.2.0.2 and applied patches whenever required.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Configuration and Maintenance of RAC, Standby database.
• Extensive use of Oracle Dataguard for protection of critical production data provide disaster recovery support.
• SQL tuning with Extensive SQL and PL/SQL experience.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Created and Managed Tablespaces with different block-sizes to prevent row chaining.
• Configured Oracle Data Guard on Oracle 11G and 10G databases for Disaster Recovery.
• Supported custom application development team including database objects deployment, migration and troubleshooting.
• High speed data transfer between one database to other by using two utilities of oracle data pump which are expdp Data Pump Export and impdp Data pump Import .
• Load balancing, Databases/Schema/Table Re-organization for faster performance using export/import Move procedures.
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Established a dblink between two Oracle Servers.
• Using SQL Loader and External tables to load data from flat files.
• Provided Solutions to the Problem Faced by end Users.

Confidential

Role : Database Administrator

Environment: Oracle 9i, SQL, PL/SQL, RHEL 2.1, Windows 2000 Server.

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Created and Managed Physical Standby database for failover and switch over operations.
• Perform other regular DBA activities including space management and performance monitoring.
• Helped Development team to troubleshoot and establish Oracle Connection to Oracle Database through ODBC and JDBC.
• Responsible for setting and managing user accounts, granting required privileges to users.
• Automation of data load using Korn shell scripting and SQL Loader.
• Management of schemas, objects partitioning the tables indexes.
• Customization and development of Korn shell scripts.
• Involved in taking Backups using Oracle RMAN Recovery Manager and TSM Tivoli Storage Manager .Defined Data Storage policies like number of backup versions to keep, the retention period for inactive copies etc. Installed and configured TDP using dsm.opt, tdpo.opt files.
• Implemented Hot, Cold and Logical backup plans.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• Applied patches to Oracle Databases and Oracle Applications.
• Involved in Upgrade of production and development databases to Oracle 9i.
• Conducting sizing capacity planning for Oracle databases.
• Used Oracle Streams for propagation and management of data, transactions and events in the data stream to ensure smooth and transparent data flow.
• Installed and created Oracle 9i and 10g databases in development, Production and QA environment including configuration, backup performance tuning.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Application Clusters, and Oracle Standby.