• Over 7 years of experience as an Oracle Database Administrator in the Database Installation, Development and Production System Support leading global teams in a wide variety of cutting edge environments.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, streams, partitioning, database security, troubleshooting, database design, Unix shell scripting, korn shell scripting and documentation.
• Experience in OLTP/DSS database systems, managing large Oracle databases VLDB and data warehouse systems.
• 5 years of experience in Installation and Involved in Implementing RAC Database with 2, 3, 4 and 6 nodes on Linux/Aix/Solaris.
• Good experience on Oracle 11gR1 6-node cluster.
• Strong experience with Oracle Databases 11g/10g , RAC on different flavours of UNIX.
• 2 years of Proficient Experience supported by Data Guard for disaster recovery purpose.
• Administered Oracle ASM disk groups mirroring, compatibility with Oracle ASM Configuration Assistant ASMCA .
• Managing Oracle ASM File Access Control for Disk Groups.
• Proficient in implementation of Oracle Streams in unidirectional table level local capture .
• Managed streams for data replication, data protection.
• Implemented Goldengate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Goldengate issues such as extract, replicate rebuild and abend.
• Experience in installation and configuration of Oracle Goldengate GG both unidirectional and bidirectional .
• Proficiency with Installation and maintenance of replication tool Goldengate by creating extract process, extract pump, and replicate.
• Experience in using Goldengate in moving large volumes of transactional data, with minimal impact to online systems.
• Configured database 10g, 11g for ORACLE FLASHBACK TECHNOLOGY.
• Managed Materialized Views for data replication purpose.
• 6 years of strong experience in Hot/Cold Backup and Recovery.
• Strong Experience in Cloning of databases using RMAN, User-Managed Backup.
• Planning and preparing for TSPITR using RMAN.
• Very good experience in applying Patches Patching , Critical Patch Update CPU /Patch Set Update PSU and One-off Patches using OPatch and runinstaller, also involved in Upgrading and Migration of a Oracle server to higher version available.
• Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Applications.
• 5 years of Extensive Experience in Installing and Upgrading Oracle 9i/10g databases on production, test and development environments on Linux.
• 3 years of experience in Implementing Data Pump, Export and Import using transportable tablespace.
• 5 years of Extensive Performance Tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Involved in Monitoring, Optimizing Oracle database for Performance Tuning system/modules for Application Tuning using tools like AWR, ADDM, ASH, SQL TRACE, UTLBSTAT.
• I have strong experience in MySQL.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Strong skills in shell, perl and korn shell scripting to automate jobs.
• Experience in Troubleshooting oracle databases using sqltrace utilities.
• Excellent Knowledge on Oracle Support processes for technical requests with Metalink.
• 5 years of proficient experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Korn Shell Scripting, Partitioning, Data modeling, Oracle Data Dictionary meta data, Logical and Physical Database Design, Backup and Recovery procedures.
• Experiencing in basic and advanced replication.
• 4 years of Experience in using OEM, TOAD.
• 3 years of Experience in Implementing and configuring 10g OEM Grid Control.
• Good experience in installing 12c OEM Grid Control.
• Expertise in maintaining Database Security using auditing.
• Expertise in loading data from flat files using external tables, SQL Loader.
• Proven ability to adapt to demanding schedules and changing priorities.
• Very good experience in solving ORA-600, ORA-1555, ORA-7445 errors.
• I completed Oracle 10g certification.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.
• Result oriented, self-motivated, Team player, ability to work independently and within a team.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

Confidential

Role: Oracle DBA

Responsibilities:

• In this project I worked for data center migration.
• Worked on 6-node RAC to change the domain name.
• Involving SAN/NAS migration work.
• Set up, configured and maintained oracle data guard primary and standby databases to ensure disaster recovery, high availability and data protection.
• I worked in managing multi-terabyte databases more than 20 TB in this project.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager OEM .
• Implemented OEM 12c Repository database, OEM 12c Agent and goldengate plugin Installations.
• Extraction of data from different flat files into Oracle Database using SQL Loader and automated the process by using Basic Replication materialized views.
• Installed Goldengate 12c on IBM-AIX Platform.
• Installed, upgraded Goldengate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Cloning databases using scripts as well as RMAN.
• Set up backup and recovery procedure using RMAN and setup Autosys jobs.
• Installed and Implemented Backup Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Created duplicate databases using RMAN duplicate.
• Worked on TSPITR using RMAN.
• Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces and Packages.
• Troubleshooting the issues on Oracle Data Integrator establishment and replication setup.
• Applied CPU/PSU patches for oracle database version11.2.0.3.
• Utilized SQL loader and data pump import to load data into tables.
• Refresh schema-using Export/Import. Creating the database, tablespaces, tables, indexes, settings privileges and user logins.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Performance Tuning use of SQL diagnostic ADDM, SQL Adviser and Oracle utilities like AWR.
• I have very good experience in MySQL.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.
• I know how to solve these errors ORA-600, ORA-1555, ORA-7445.
• 24x7 production database support.
• A self-motivated, responsible and reliable team player with a set of strong technical skills.
• Excellent analytical, interpersonal and communication skills.
• Enthusiasm in learning new technologies.

Environment: Oracle Server 11g/10g, SQL, PL/SQL, RAC, RHEL6, SunOS

Confidential

Role: Oracle DBA

Responsibilities:

• Designed and developed database solutions for Oracle Customer Care and Billing application and Smartgrid application.
• Installed and upgraded versions of Oracle10g to 11.2.0.2
• Installed Oracle work flow monitor.
• Worked on the installation, configuration and upgradation of multi node RAC database on ASM Automatic Storage Management .
• Upgraded RAC databases from 10g to 11g.
• Worked on Cross Platform migrations using RMAN Conversion and Transportable tablespaces.
• Cloned databases across the environment using RMAN and export/import utilities.
• Installed and configured Goldengate Streams.
• Worked on RMAN backup and recovery scenarios.
• Worked on Oracle Database Vault and Audit Vault.
• Installed and upgraded 11g Oracle Grid Control.
• Setting up alerts and warnings using Oracle Grid Control.
• Participated in production On Call 24x7 support.
• Configured Oracle Dataguard to ensure successful replication of primary database to standby site in VCS cluster configuration in a maximum availability mode.
• Developed PL/SQL code for creating and maintaining stored procedures, packages, triggers, sequences for appropriate business functionality.
• Tuned long running batch jobs.
• Worked with developers to optimize long running SQLs and suggested performance tuning hints.
• Designed schema objects, integrity constraints and database links between upstream and downstream systems to interact with the core applications.
• Scheduled UC4 and UNIX Cron jobs to collect table, index statistics to enhance SQL performance, fine tune the database.
• Trained junior database analysts, developers in database aspects of the application.
• Documented troubleshooting techniques for various database alerts and PL/SQL errors.

Environment: Oracle 11g 11.2.0.1, 11.2.0.2 ,Oracle 10g 10.2.0.2 , , Solaris, PL/SQL developer, Toad 10.6, SQL profiler, Putty,UC4 scheduler

Confidential

Role: Oracle DBA

Responsibilities:

• Involved in 24x7 support for 800GB 2 Node production RAC database with on-call pager
• Worked with Application Development team on Test and Production tickets
• Setting up 9i Oracle Parallel server and 10g RAC for Development and Production Environment
• Installation and creation of 9i and 10g databases on Testing Environment.
• Installed, Setup, Configured Oracle 10.2.0.4 64 Bit on RHEL 4.8
• Upgrading of Database from 8i to 9i and to10g
• Installed, Configured, Setup, Maintenance and Supported Oracle 10g RAC, Physical Standby database
• Installed, Configured and setup Oracle Streams between Oracle Servers
• Used Oracle Streams for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• Used Oracle 10gR2 new features viz Oracle 10g Real Application Clusters RAC , Data Guard, Oracle Streams / Replication, automatic SGA tuning, enhanced RMAN with flash recovery area, Oracle data pump, big file table spaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flash Back Database and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects
• Implemented DATA GUARD Standby for high availability/disaster recovery purpose
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, administer database objects
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• Write SQL scripts to monitor table space and extent growth
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK
• Applying patches whenever required
• Data refresh from production to test and development
• Was involved in developing a Disaster Recovery DR plan implemented a DR exercise
• Installing and configuring Recovery Manager RMAN
• Setting and Installing Oracle Enterprise Manager OEM and Enterprise Backup Utility
• Setting up new Development Production environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Production and Development Database
• SQL Tuning for Performance of Objects
• Providing Solutions to the Problem Faced by end Users Or Programmers

Environment: Oracle 9i / 10g with RAC, Oracle Streams, Oracle Dataguard, HP-UX 11, Sun Solaris 9, 10, RHEL 4.x, TOAD

Confidential

Role: Oracle DBA

Responsibilities:

• Installed, migrated, upgraded, patched, tested different versions of Oracle and SQL Server.
• Installed and upgraded databases from Oracle9i to 10g and from Oracle 10g to 11g on DEV, QA, UAT and Production.
• Installed, configured and tested Oracle 11g version in a testing environment.
• Tuned the batch jobs on a 1 Terabyte database to decrease nightly batch job run time.
• Maintained documentation on root cause analysis on database performance issues.
• Worked with the development team to tune high resource consuming sqls.
• Technical Lead for Implementation of Oracle Database Vault and Oracle Audit Vault across all Applications supported by the DBA team.
• Created different Realms for different User groups according to the guidelines of Sarbanes Oxley Act.
• Trained onsite and offshore teams in US and India on the Administration of Database Vault and Security Realms.
• Installed OEM grid hosting over 80 databases
• Physical and Logical Design of database, database creation, tablespace creation, table and index creation and partitioning and also mapping of different objects with disks
• Migrated database schemas across servers of same application, across different databases as Data pump and Export/Import utilities.
• Installed, configured and tested Oracle Streams/Multimaster replication on IBM AIX server as a proof of concept.
• Installed, created, administered, and monitored a Real Application Clusters database with Automatic Storage Management ASM .
• Upgraded RAC from 10g to 11g.
• Performed patching of the RAC instances in a Rollover fashion.
• Configured RAC Backup and Recovery Using EM.
• Performed cloning from a single instance database to a Multi Instance RAC system.
• Worked with Development team to write standards for logical modeling and the deployment of the ERWin data modeling tool.
• Used Enterprise Manager OEM to monitor stress testing of the applications by the testing and the development teams and made suggestions for query tuning.
• Tuned the OLTP and Data warehouse databases for optimal performance.
• Provided database support for large databases of size more than 1 Terabyte which includes OLTP and Data Warehousing applications.
• Extensively worked in tuning ad-hoc SQL queries with both OLTP and data warehouse databases.
• Created partitions on various data warehouse data mart tables and OTLP tables as per functional requirements and for performance related issues.
• Installed, configured and used the reports of Orasecure, an in-house Oracle Security Administration and user auditing tool.
• Configured and managed Physical standby database using Data Guard for disaster recovery on a different node for different production servers
• Performed Data guard switchover/failover as per the requirements.
• Created monitoring scripts for monitoring and alerting space and out of sync issues.
• Cloned databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database
• Converted and migrated databases from Solaris to AIX servers both on source and target servers.
• Installed, configured, administrated and maintained SQL Server databases on Wintel Servers.
• Used SQL Server Management Studio for Database Administration.
• Installed, configured and administered using windows cluster service and SQL Server Cluster services 2 node cluster using SAN storage devices.
• Installed, configured and used Quest Light speed for backing up SQL Server databases.
• Configured standby database for disaster recovery of SQL Server 2005 production databases using database mirroring and log shipping.
• Performed switchover/failover of SQL Server production databases to standby databases.
• Used database tuning advisor and SQL Profiler for performance optimization.
• Extensively used T-SQL for application development and database related activities
• Setup of automated jobs, alerts using SQL Server Agent
• Designed and implemented backup strategies for SQL Server databases
• Tuned T-SQL queries using SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Analyzer
• Wrote PL/SQL blocks, stored procedures and packages for performing tasks related to few of the tools that are used for administrations such as DB Check list etc.
• Resolved database connectivity issues from application servers, users with Oracle 9i and 10g databases.
• Interacted with customers for specifications, data gathering, trouble shooting, testing and SQL tuning.

Environment: Oracle 9i 9.2.0.8 , Oracle 10g 10.2.0.2,10.2.0.3,10.2.0.4 , 11g, IBM AIX 5L 5.3 , Solaris 9 SunOS 5.9 , SQL Server 2000,2005 2008, Wintel Server, Microsoft Office, Putty, ERWin, Quest Toad, Team track, Oracle Enterprise Manager, Virtual Tech, SSH Tectia Client, IBM, Sun Fire, Quest light speed, SQL Server Management Studio SSMS , SQL Profiler.

Confidential

Role: Oracle DBA

Responsibilities:

• Implemented 2 node RAC Database on Linux Operatin System.
• Proficient with Standby Database, Data Guard and Replication.
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
• Installed and supported OEM on Linux.
• Create table spaces, tables, and users for custom applications.
• Implemented and worked Streams, Data Pump, Export and Import utilities.
• Implemented and Involved in local and downward streams.
• Implement Hot, Cold and RMAN backup plans.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Performed database cloning to setup test and development database on different operating systems.
• Refresh/Cloning of Database and applications for development, testing.
• Database patching using opatch.pl perl script.
• Upgrading development and production databases to Oracle 9i to 10g.
• Performance Tuning of the database Memory Allocation Tuning, I/O Tuning, Tuning Contentions .
• Experience in SQL tunning using STATSPACK, EXPLAIN PLAN and TKPROF.
• Data refresh from production to test and development.
• Installed and Configured Grid monitoring tool for Oracle 10g Database.
• Good knowlede of Developer Environment Setup, Support, Cloning and Refreshes.
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Diagnose and troubleshoot Database problems and failures.
• Conducting sizing capacity planning for Oracle databases.
• Perform SQL tuning and assist developers with coding PL/SQL
• Performed PL/SQL querying and troubleshooting errors in queries using TOAD tool.
• Write Korn shell scripts to monitor and maintain the Oracle database.
• Write SQL scripts to monitor tablespaces and extent growth.
• Resolve various application failures due to data entry errors or system errors.
• Involves identifying problems and implementing corrective actions.
• Providing Solutions to the Problem Faced by end Users Or Programmers
• Automation of Startup Shutdown on all Production and Development Database.
• Worked with team to support 24x7 production environments.

Environment: HP-UX 11, Sun Solaris 2.8/2.9 RHEL 4.x, PL/SQL