SUMMARY

• Years of experience working as a Database Administrator/Production Support with Strong communication skills. History of providing on - site support to wide range of clients. Provided 24x7 production support for RHEL, Windows, Linux Red hat enterprise 6 and Oracle 12c/11g/10g/9i/8i databases on various platforms in clustered and non-clustered environments. Excellent technical skills with hands-on expertise in mission critical applications, performance tuning, troubleshooting, data pump, RMAN, and problem solving. Years of experience on installations and configurations.
• 7 plus years of IT experience in teh field of database administration and system administrator working with Red hat Linux enterprise 6, Windows 2008, RHEL, Oracle 12c/11g/10g/9i,8i, Oracle RAC, DataGuard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, Putty, TOAD, SQL*Plus/SQL, Exp/imp/Data pump, Performance Tuning etc.
• Years of experience working with VMware workstation, SQL Developer, Putty, TOAD, OEM, SQL*Plus/SQL, Exp/imp/Data pump, Performance Tuning etc.
• Troubleshooting database servers, Install and configure oracle, RHEL, RAC and DataGuard
• 7 years plus as production support working on windows 2008, RHEL, CentOS, Ubuntu, databases, RAC, and Oracle
• Use Nagios to monitor databases and operating systems
• Installed and configured Data Guard RAC
• Installed red hat linux, Solaris, Windows 2008 from scratch, configured them for Oracle Installation, installed Oracle Software on them by running. runInstaller, and created oracle databases using DBCA, used netca to configure teh listener and tnsnames.
• Provided 24x7 production support for Oracle 12c/11g/10g/9i/8i databases on various platforms
• Maintain teh Oracle 10g/11g/12c RAC environment and troubleshoot performance problems.
• Deploying code in production databases in times of release activities or any maintenance tasks.
• Proficient in all DBA responsibilities such as Installation, Configuration, Perform Oracle Upgrades from 10.2.0.3 to 11.2.0.3 for DEV, Stage & Production environment, Patches, Performance Tuning, Backup, Recovery, Cloning, Space management.
• Implement Oracle Enterprise Manager Grid Control (OEM 11g/10g) for centralized monitoring and administration.
• Planned and implemented high availability solutions using Oracle 11g/10g RAC R2; Standby Database using Oracle Data Guard and Replication
• Operating Systems: Installation and Configuration of Unix/Linux, Windows NT 2000-08 for Oracle database, ASM and Oracle discoverer installation.
• Involved indatabase upgrade from 11.1.0.6 to 11.1.0.7for DEV and TEST environments.
• Upgradethe production and development databases from10.2.0.1 to 10.2.0.4
• Set up Oracle Data Guard on Oracle 10g/11g for high availability, data protection and disaster recovery, also manually created physical standby database using data guard.
• Use Oracle Enterprise Manager (OEM) to monitor teh database, cloning and many more.

PROFESSIONAL EXPERIENCE

Confidential - Cleveland, OH

Oracle DBA/Production Support

Responsibilities:

• Proactively monitoring databases and systems using nagios monitoring tool; troubleshooting every error dat comes up from teh datatabase and system
• Perform data pump Exports/Imports of schemas requested by end users and developers.
• Proactively monitoring tablespace sizes and increasing them if needed
• Writing SQL queries daily selecting data from tables requested by end users or clients
• Creating tables, inserting data in teh tables for clients
• Performing cloning of teh database for end users to test certain applications on it or for our clents upon request.
• Perform database installation and migration
• Configured daily and weekly backups for all our database servers.
• Maintain teh Oracle 10g/11g/12c RAC environment and troubleshoot performance problems for multiple clients
• Troubleshoot issues from linux, oracle, windows 2008, RAC, DataGuard and RMAN
• Build, install and configure servers in both a physical and virtual environment
• Created Users, Index, Tablespaces, Views, Profiles, Privileges.
• Work with DataGuard, RAC, Linux, RMAN, Toad, putty, Windows 2008 and many more
• Running complex queries to retrieve data from multiple tables, ensuring fast and secure access to business application for about 60 users in remote location around teh clock.
• Installed and maintained Oracle 2 nodes Real Application Clusters (RAC) on Linux systems.
• Configured Oracle Grid Control systems and Enterprise Manager for database diagnostics and
• monitoring.
• Automated RMAN full and incremental backups through Shell scripting.
• Working closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes
• Managed all our RMAN backups, restore and recovery
• Managed all our daily and weekly backups
• Write SQL queries to retrieve data from database for end users and clients
• Performing cloning of database for our UAT environment
• Helping developers and end users with any database and system issues
• Proactively monitoring databases and systems
• Operate 24/7 production support
• Troubleshooting every issue from databases and systems
• Use Nagios to monitor databases, applications and operating systems.
• Data migration between databases using Both Oracle 11g and 10g export/import utility and Oracle 11g export/import data pump.
• Work with DataGuard, RAC, Linux, RMAN, Toad, putty, Windows 2008 and many more
• Perform troubleshooting and resolving databases and systems problems
• Use Nagios to monitor databases, applications and operating systems.
• Work with DataGuard, RAC, Linux, RMAN, Toad, putty, Windows 2008 and many more
• Troubleshoot issues from linux, oracle, windows 2008, RAC, DataGuard and RMAN
• Did Performance Tuning and Optimization (PTO), using monitoring and troubleshooting tools
• Installed and configured oracle RAC and DataGuard for our clients
• Perform database clone for our UAT for testing purposes.
• Perform backups, restores and recovery using RMAN in our oracle databases
• Scheduled daily and weekly backups for all our database servers
• Writing SQL queries to retrieve data from tables for our end users or clients
• Perform database cloning for our end users and clients
• Use datapump to export schemas to another database for developers to use for testing purposes
• Helping developers with database related issues
• Implementing operational automation using scripts
• Operate 24/7 production support
• Create indexes, index management, and statistics
• Troubleshoot and analyze cause of performance problems;
• Create database Objects, Table spaces, Schemas as needed.
• Management of table spaces, logs, grants, roles, users, and indices, apply patches and upgrade, manage storage.
• Perform troubleshooting and resolving database problems
• Use datapump to export schemas to another database for developers or end users for testing purposes
• Did Performance Tuning and Optimization (PTO), using monitoring and troubleshooting tools
• Perform backups, restores and recovery models for SQL server databases, oracle and MySQL
• Implementing operational automation using scripts
• Create indexes, index management, and statistics
• Work with DataGuard, RAC, Linux, RMAN, Toad, putty, Windows 2008 and many more
• Troubleshoot and analyze cause of performance problems;
• Use Nagios to monitor databases and operating systems and applications
• Managed all our daily and weekly backups
• Operate 24/7 production support
• Performing troubleshooting in all our servers including databases and application servers
• Performing cloning of our databases for our developers for testing purposes
• Helping end users and developers with any database and system related issues
• Wrting complex queries to select and retrieve data from tables for our clients
• Setup dataguard and RAC for our end clients
• Proactively monitoring all our database, systems and applications servers
• Operate 24/7 production support