SUMMARY:

• Dynamic professional with over seven years of Oracle Database Administrator (DBA) experience serving the Information Technology needs of various industries.
• Oracle DBA experiences for various kinds of applications in Linux, Solaris and Windows environments. Proven background of technical problem - solving.
• A self-motivated, responsible, and reliable team player with a set of very strong technical skills.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g and 12c.

Management Tools: PuTTY, TOAD and SQL Developer.

Performance Tools: Oracle OEM, Toad For DBA, Nagios, Ivante and SolarWinds.

Platform: Solaris, AIX, Linux and Window.

Languages: SQL, PL/SQL, J2EE, C++, HTML, .Net and Shell.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Oracle Database Administrator

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Oracle 12c/11g installation and Configuration.
• Implemented of the Oracle 11g physical standby database. Implement switch the standby to read-only mode for reporting purposes during business hours and switch to recovery mode at night to apply the logs.
• Design, document, implement and maintain all Disaster Recovery procedures.
• Frequently loaded bulk data to the database via SQL Loader.
• Migrating Oracle 11gR2 database to Oracle 12.1.
• Applied quarterly released oracle database Patch.
• Migrating production database to new server using Export/Import.
• Designing the security and database access strategies.
• Performing backups and recoveries using RMAN conventional backups.
• Cloning databases for development and testing using RMAN duplicate.
• Performance tuning Using TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM reports for the Better performance.
• Performance tuning involving Memory, Disk I/O tuning, PGA/SGA and SQL tuning.
• Partitioning strategies for very large tables and managed other database objects.
• Created scripts for RMAN backup schedule with Crontab, Autosys and scheduler.
• Install, configure and maintain Oracle 11gR2 Real Application Cluster (RAC).
• Set up and maintain Oracle disaster recovery site using DataGuard.
• Performed schemas and security administration activities, such as enrolling, granting privileges, and maintaining system security.
• Resolved replication issues in GoldenGate.
• Installed GoldenGate in Prod, Test and Dev instances.
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager (OEM).
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files and Trace files.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.

Confidential,Norwalk, CT

Oracle DBA

• Implemented database knowledge for support and development team for the use of Oracle products to secure downtime business and increase benefit.
• Implemented Data guard Oracle 11g for High-Availability and data protection to reduce downtime.
• Installed and configured OEM Grid Control
• Migrated and Installed Oracle 11gR2 servers wrote technical documents for team support and best practices.
• Performed database and application tuning, suggested improvements to the overall database.
• Performed performance monitoring through Oracle Enterprise Manager and SQL scripts.
• Designed and implemented Korn shell programs to implement backup and recovery.
• Configured on Linux and Solaris with Oracle11gR2 RAC (Real Application Clusters), including all options for storage and justifications for deployment.
• Provide Oracle DBA support and technical support for multiple applications in development, test, QA and production environments.
• Install, configure and maintain database instances, creates various database objects, creates users with appropriate roles and levels of security.
• Work with the data services team to design and maintain database schema and related infrastructure for real-time data access for customers, end-users and distribution partners.

Confidential, Hartford, CT

Oracle Database Admin

• Implementation of Enterprise wide Database Monitoring enabling Oracle Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise.
• Complete Oracle lifecycle from concept to design, architecture, hardware selection, installation and patches, database creation, backup/recovery scripting and testing, database performance monitoring, event notification, sql, waits, locks, tuning, automated scripted creation and refresh of reporting databases from production, mentoring and protecting the databases from the developers.
• Backup/recover using cronjob scripts, and Oracle Recovery Manager (RMAN).
• RDBMS developments include building data migration and analysis scripts using Oracle SQL*LOADER and UTL packages.
• Modified existing packages to add new functionality and to optimize the performance.
• Researched 11g new features and tested the install, upgrade process for the Finance database and created implementation plan for the upgrade.
• Responsible for automating cloning and refreshing development, test databases with production data.
• Assist in setting up RMAN scripts for backup.
• Tested and documented some Oracle10g new features, such as Automatic Storage Management (ASM).
• Production support for Oracle database 10g/10g RAC.
• Table fragmentation tuning, partitioning the exits large table by range via dbms redefinition.

Confidential,Hartford, CT

Oracle DB Technical

• Design, implementation and support of backup and recovery procedures.
• Support of multiple production, development and staging environments.
• Responsible for Installing, supporting, maintaining, troubleshooting and performance tuning the Database and Oracle apps server.
• DBA and Sys Admin activities for production support and day-to-day operations.
• Install various versions of databases on different platforms like Linux, Solaris and Windows 2008.
• Proficiency in applying patches.
• Clone and Refresh database from production to staging.
• Planned and actively participated in Knowledge sharing discussions within the Team.
• Documented procedures followed while installations and troubleshooting of problems.
• Refresh development/test databases from copies of production.
• Estimate Storage requirement, Creation of Tablespaces and other Database Primary Objects.
• Prepare backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.