PROFESSIONAL SUMMARY

• Over 5+ years of experience as an IT Professional having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, Unix shell scripting and documentation.
• Oracle Database Administration experience in variety of different environments like AIX, HP - UX, SUN SOLARIS, RedHat Linux and Windows.
• Good Knowledge in Designing, Installing, Administering, Implementation, Configuring, Troubleshooting, Performance and Fine tuning of Oracle and Cassandra databases.
• Installation and Configuring Oracle and SQL Server databases.
• Worked with Oracle Databases (12c,11g/10g/9i) on Unix/Linux/Windows platforms.
• Planned and implemented DR & high availability solutions using Oracle 11g RAC & 10g RAC, Standby Database (Oracle Data Guard).
• Worked on database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN and manual methods.
• Experience in trouble shooting RMAN issues in performing the Backup and Recovery process.
• Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Performing daily activities and troubleshooting the database issues using OEM Grid control.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, SQL TRACE, custom scripts troubleshooting oracle databases using sqltrace utilities.
• Have good Working knowledge of disaster recover models with experience in implementation and recovery of Oracle databases and RAC clusters.
• Experience in Upgrading databases, applying patches.
• Good experience on Oracle Support processes for technical requests through metalink and other Support Procedures.
• Experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Worked on all backup and restore scenarios for Oracle and SQL Server databases.
• Proven ability to adapt to demanding schedules and changing priorities and ability to function successfully in a highly stressful and critical environment.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris, AIX 5.1, 5.2, 5.3 RedHat Linux RHEL 2.1, 3.x, 4.x and Windows.

RDBMS: Oracle 11gR2, Oracle 10g, Oracle 9i,Oracle GoldenGate 11.2.1, Oracle 11g (RAC), Oracle 10g (RAC). SQL Server 2008,2012.

Languages: SQL, PL/SQL, UNIX Shell

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp,, TOAD, Golden Gate,

Tools/Utilities: Putty, Super Putty OEM GRID, SSH, WinSCP, Explain Plan, STATSPACK, AWR, ADDM, Spark.

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Provide support for ORACLE, SQL SERVER Databases.
• Provided disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data. Administer, maintain, and implement policies and procedures for ensuring the security and integrity of the database and evaluate and recommend available database management support products.
• Troubleshooting issues and tune memory parameters on oracle databases for better performance.
• Develop scripts for Startup and Shutdown and Health Check reports for Oracle Databases.
• Providing support for planned production activities for ORACLE, SQL Databases.
• SQL scripts to monitor Table spaces and Extent growth.
• Cloned environments to create patch test, development and QA environments for ORACLE and SQL SERVER databases.
• Coordinating with System Admin and Middleware Teams for smooth implementation of production Tasks.
• Provide ON-Call support for ORACLE databases.

Confidential

Senior DBA Analyst

Responsibilities:

• Involved in 24x7 support for Production database and applications with on-call pager.
• Installation and creation of 11g RAC databases for Testing, Development and Production.
• Supported upgrades from oracle 11g to 12c.
• Performed migration from 10g to 11g.
• Supported development, implementation and maintenance of Oracle server database.
• Supported migration, and performance tuning on Oracle server database.
• Installed and configured oracle 11g RAC for high availability.
• Data Refresh from Production to Test and Development environments using manual method and RMAN Duplication.
• Participated in designing and building OEM environments.
• Proficient in using OEM and grid control.
• Resolving Performance issues.
• Performed disaster recovery and provided business continuity plan for development and production environments.
• Installed and Configured GOLDEN GATE Extracts/replicate for multiple databases.  
• Implemented necessary monitoring scripts for Oracle in Unix scripting.  
• Performance tuning for optimized results using tools like AWR, SQL TRACE, TOAD.
• Setup of Standby Database (Data Guard). Performing Failover and Switchovers.
• Scripts for Cold Backup, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installation and configuration of Oracle Client software and Tools.
• Writing UNIX shell scripts for backup and recovery, import and export procedures.
• Automating the Database Maintenance tasks using PowerShell scripts.

Environment: Oracle 11g R2, Oracle Goldengate 11.2.1, RAC/11g RAC/10g, ASM, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, TKPROF.

Confidential

Senior Systems Executive

Responsibilities:

• Worked in an environment having technologies associated with oracle like Dataguard, RAC, RMAN and Golden Gate etc.
• Worked on User and Space management.
• Worked on DR activities as per the maintenance plan.
• Worked on performance tuning.
• Worked on script deployments as per the business need.
• Worked with Database build with RAC infrastructure and all High availability features including the installations of 12c agent.
• Setup of Standby Database (Data Guard). Performing Failover and Switchovers.
• Collaboration with OS teams during the OS level patching activities.
• Worked on Patching and upgrade as per the business requirement.
• Supported development, implementation and maintenance of SQL server and Oracle server database.
• Worked on all backup and restore scenarios.
• Troubleshooting first level of issues in high availability.
• Patching and upgrades of Oracle servers from different versions.
• Worked with concern teams on OS level patching both Windows and flavors of UNIX.

Environment: Oracle 11g/10g, IBM AIX, Sun Solaris, Red Hat Linux, Windows 2003, SQL*Plus, Grid Control, TOAD.

Confidential

Engineer Trainee

 Responsibilities:

• Gained knowledge on Oracle11g architecture.
• Basic Administration of Unix/Linux, Shell Scripting
• Performance tuning of the queries.
• Oracle Binaries Installation and database creation.
• Knowledge on Database upgradation.
• Gained knowledge on refreshing databases using RMAN.
• Knowledge on traditional export/import and Datapump Export/Import.
• Knowledge on performing database backups & restore.
• Monitoring critical Grid alerts and Alert log.
• Monitoring Cold, Hot and RMAN backup scripts of the databases supporting different applications.
• Creating Schemas, Users, Roles, Synonyms and providing privileges depending upon request.
• Dropping and unlocking the user accounts, monitoring the user accounts.
• Monitoring Jobs and Error Handling.