SUMMARY:

• Serve as an Oracle DBA/Production support for multiple Oracle applications and serve as the Global Operation Center point of escalation on Oracle application in a 24X7 production environment. Oracle support includes problem analysis, monitoring and implementations for Production hosts. Interface with other DBA's to provide front line support for all production hosts. Provided 24x7 production support for Oracle 12c/11g/10g/9i/8i databases on various platforms.

TECHNICAL SKILLS:

Technology and Tools: Provided 24x7 production support for Oracle 12c/11g/10g databases on various platforms. Proficient in all DBA responsibilities such as Installation and Configuration Perform Oracle Upgrades from 11.2.0.3 to 12.1.0.3 for DEV, Stage & Production environment Perform Patches, Performance Tuning, Backup, Recovery, Cloning, Space management, Database Security, Troubleshooting, Unix Shell and Documentation. Planned and implemented high availability solutions using Oracle 11g/12C database Operating Systems Installation and Configuration of Unix/Linux, Windows NT for Oracle database Tools SQL*Plus, TOAD data pump, Grid Control, SQL Loader, Oracle Recovery Manager (RMAN), Automated Workload Repository (AWR), Scheduler, Data Pump, Unix Shell Scripting, Automatic Storage Management (ASM), TOAD, MobaxTerm, SecureCRT, Enterprise Reporting with Oracle Reports, SQL Developer Install and configured Oracle RDBMS 11.2.0.3

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Provided database architecture consulting for multiple clients
• Use data pump for database refreshes and the migrate data or schema from one database to another
• Use Rman for database backups, restore, recovery and to clone database
• Created tablespaces, redo logs and resize tablespaces and SGA for multiple clients.
• Installed, configured, and supported many databases for clients.
• Use Toad to write SQL queries
• Provided remote database upkeep and maintenance for multiple clients (UNIX, Windows).
• Installed and configured Oracle database software and utilities for multiple clients.
• Performed database and SQL tuning for multiple clients.
• Provided OS reconfiguration recommendations to improve database performance for multiple clients.
• Performed capacity planning for multiple clients.
• Provided recommendations to Sys Admins.to enhance performance of our database servers.
• Made changes to development and production databases in response to developer requests.
• Used SQL - Loader utility to load data into oracle database from external files.
• Monitoring database connectivity and database growth.
• Maintain the Oracle clustered environment and troubleshoot performance problems.
• Upgrading Oracle Databases from 11gR2 to 12C
• Building test strategies, backup & recovery models for Oracle. Refreshing test databases.
• Managing backup & Recovery for Oracle on Linux using RMAN
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Linux shell scripting for monitoring oracle Database status, security & backups.
• Monitored Tablespace size, resizing Tablespace, relocating data files for better disk I/O.
• Created user, allocation of appropriate tablespace quotas with necessary privileges and roles
• Created backup plan design and implementation using cold/hot backups, Flash copy, Volume copy and RMAN backup technology.
• Installed and configured Oracle Enterprise Red Hat Linux operating system versions and Windows 2008 servers for Oracle Relational (RDB) installation and Oracle grid infrastructure database software to meet the required expansion needs of the company.
• Effectively managed daily backups and recovery for Oracle on Linux using RMAN
• Created users, allocation of tablespace, quotas with appropriated privileges and roles for Oracle & SQL Server databases.
• Managed a project with a team of 7 to successfully analyzed and implemented an active Oracle Data Guard to facilitate data protection, site redundancy and disaster recovery.
• Successfully upgraded multiple databases and carried out short term performance tuning, maintenance and for continuous operation
• Carried out Oracle Database maintenance such as base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository (AWR)/ Automatic Database Diagnostic Monitor (ADDM) to create performance reports, monitoring database performance, securing & protecting information/database with unique secure configurations, data encryption and masking procedures as well as with sophisticated auditing skills.
• Worked with Developers to design, develop, test and maintain Oracle PL/SQL packages, triggers, storing procedures and functions to support multiple clients.
• Executed complex queries to retrieve data from multiple tables within Oracle and SQL Server databases, ensuring fast and secure access to business application

Confidential

Oracle DBA

Responsibilities:

• Installed and configured oracle 12C
• Created users, roles and granted permission
• Write queries using toad and sql developer
• Performance tuning and patching
• Create control files, redo logs and tablespaces
• Use data pump to migrate data between databases
• Troubleshoot and performed root cause analysis and recommended solutions to solve them
• Oversee data load and monitor load balancing tools

Confidential

Intern

Responsibilities:

• Installed and configured oracle 11g and 12c
• Installed Red Hat linux and configured oracle installation
• Write queries using sql developer
• Created users and roles
• Checked alert using adrci
• Performed backups and recovery using RMAN
• Performed cloning using RMAN duplicate
• Monitor tablesplace and resized