CAREER OBJECTIVE:

An accomplished Oracle Database administrator (DBA) with expertise, technical skills and knowledge beneficial for the growth of the company, interested in a fast paced environment with constantly evolving state of the art technology which challenges my critical and analytic thinking and approach to problem solving.

CAREER SUMMARY:

• 6+ years of growth driven and result oriented IT professional as an Oracle Database Administrator (10g, 11g 12c) in IT Industry
• Dedicated professional with strong work ethic & self - motivation and a very dedicated team player. Also a fast learner, and highly adaptive to new changes within the workplace and the latest technological advancement.
• Passionate about data security, integrity and high availability.
• Proficient in SQL Tuning, Shell scripting in an Oracle Environment.
• Expertise in Oracle RAC & ASM Administration/Installation.
• DataGuard and Active DataGuard| Disaster Recovery Implementation, Fail-Over, Switch to Standby.
• RMAN Backup and Recovery procedures RMAN Duplicate/Recovery Catalog.
• Database Migrations from 10g, 11g 12c on different platforms, Migration from EXADATA to a SCALABLE systems such as ASM(AUTOMATIC STORAGE MANAGEMENT) on CLUSTERED and NON-CLUSTERED RDBMS servers.
• RMAN/User Managed Database Backup and Recovery (Hot and Cold Backups) and Logical Backup.
• Oracle GoldenGate| Configuration, full database Migration, datafiles, tablespaces.
• Manage Oracle RAC database configurations using GoldenGate and Data Guard to ensure maximum availability and data protection.
• Install, configure and support uni-directional and active-active Oracle-to-Oracle replicated environments utilizing GoldenGate.
• Developed shell scripts for the automation of daily jobs and reports to schedule in crontab.
• Database Links, Creating and Managing Tablespaces and Datafiles, Creating and Rebuilding Indexes.
• Data Movement and Reorganization Using Sql Loader, Data Pump IMPDP/EXPDP.
• Performance Tuning Using SQL diagnostic and tuning tools like AUTOTRACE (AWR/ADDM Reports).
• Performance information and monitoring/interpreting alert log and trace files (ADRCI), Flashback Procedures/ database Refresh Table Space Point In Time Recovery.

TECHNICAL SKILLS:

Primary Skills: Oracle Database (Oracle 10g, 11g, 12c)

Operating Systems: Windows 7, 8, 10, Linux 4x, 5x, 6x, 7x, Ubuntu, SUN Solaris and UNIX.

Servers and Storage Systems: Oracle Linux, Oracle VM Server, VM VirtualBox

Applications: GoldenGate, Active DataGuard, SQL*Plus, Grid Control, SQL*Loader, AWR, Scheduler, Data Pump, Shell Scripting, Oracle Enterprise Manager, SQL* Developer.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ORACLE DBA

Environment: Oracle 12c, 11gR1&2, 10g.

Responsibilities:

• Involved in 24x7 support for 8TB 3Node Production RAC database with on-call rotation
• Installation and creation of 12c, 11g (R1 &2), and 10g databases for Testing, Development and Production
• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers
• Migration to EXADATA from an ASM RAC clustered environment.
• Experienced in Installation and configuration of RAC on different nodes with ASM (automatic storage management).
• Skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• USED PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and AUTOSYS scheduler)
• Database Refresh from Production to Test and Development environments using RMAN Duplication.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like AWR, ADDM, Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.and Rollback segment using different methods and detecting locks.
• Installed, configured and administered Standby Database (DATAGUARD) and tested for business continuity/Disaster recovery plan.
• RMAN BACKUP (HOT & COLD) and RESTORE plan (FULL OR PARTIAL POINT IN TIME DATABASE RECOVERY), RMAN database CLONING.
• Configured and built Golden Gate Extracts/replicat for multiple databases. Implemented High availability using GoldenGate Replication.
• Implanted active-active Bi-directional replication using GoldenGate. Creating and rebuilding RMAN DATABASE CATALOG for Test, Development and Production.
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, Patch sets as per the oracle recommendations.
• Experience in Logical backup using and full/ partial export/import and Data Pump EXPDP/IMPDP.
• Highly Experienced in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.
• Extensive work experience in a DATABASE MIGRATION project team, serving in both an advisory and technical capacity.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Mentor and assist new employees in grasping new technologies, also providing necessary challenging stimulus for new employees to adapt quickly within my environment.
• Worked with Incident & Problem Management and Change Release Management to meet business SLAs (Service Level Agreement).
• Develop database structure, implement applications, enhance system and ensure security.
• Design scripts and develop tools to automate periodic task and improve monitoring of system.
• Author database documentation and guidelines to help support system operations.
• Provide after hour maintenance, coordinate with consultants and manage vendors for patches and upgrades.
• Create and maintain data dictionaries, physical databases and logical database models.
• Take on initiatives to enhance information systems and optimize performance tuning.
• Research and evaluate innovative technology solutions, collaborating with Development teams to determine feasibility of deployment.

Confidential, Newark, NJ

ORACLE DBA

Environment: Oracle 10g,11g. RedHat Linux 5.x, IBM AIX

Responsibilities:

• Involved in 24x7 support for both Production and Development databases
• Installation, creation of 10g and 11g databases for Testing, Development and Production
• Performed Cloning/Refresh to setup Test and Development database
• Installation and Maintenance of Standby database
• Installed, configured and administered Standby Database. Cloned databases for testing.
• Loaded data from flat files to Oracle databases and migrated from older Oracle versions.
• Managed Users access control and security by creating appropriate roles and profiles.
• Implemented and configured Oracle Net and resolved connectivity issues.
• Assisted Application team in Database Installations,
• Moving the database on the network 24 x 7 support on pager call duty,
• Troubleshooting and Problem resolution Exports/ Imports, Hot and Cold Backups, Shell Scripting, Restoration Space Management, Tuning Memory, SGA, I/O.
• Objects sizing and strategizing Backups including usage of RMAN Database Recovery
• Upgrade and Migration of Database from Oracle 10g to 11g and applying patches when required
• Responsible for optimizing the queries and application tuning
• Partitioned large tables to increase the performance

Confidential, Atlanta

Oracle DBA

Environment: Oracle 10g, 11g SQL, Shell Scripting, UNIX, RHEL 4x, 5x.

Responsibilities:

• Installed and configured Oracle Servers on UNIX, Linux and Windows. Applied Oracle Corporation recommended patches and created development, test and production databases.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics, snapshots and reports.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.
• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases
• Configured Oracle servers and optimized initialization parameters in INIT.ORA (DB Block Size, DB Block Buffers, Shared Pool Size, and Sort Area Size) and adjustment of OS Kernel parameters.
• Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
• Installed Oracle 10g RAC database on RHEL and applied all current patches
• Scheduled several backups through RMAN.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Used Flashback table to restore tables which is a new feature of Oracle 10g.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Executed file system, server based (RMAN) backups and logical (exp) backups. Executed complete and incomplete media recovery procedures (Time/Change/Cancel-based).