SUMMARY:

• I have 7 years of experience as Oracle Database Administrator, providing 24/7 support of both development and production Oracle 11g/10g/9i databases on Various Platforms
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation
• Excellent experience in Installation, Setup and configuration of Oracle 10g, 11g, 12c on Linux, Windows and Solaris.
• Poses strong Administrative skills in RHEL.
• Provide DBA support with proactive monitoring, identifying areas that need to be improved in the application and databases using Statspack, AWR, ADDM, and OEM Grid Monitoring.
• Over 6 years of experience working with Oracle Data Guard
• Good experience working with Cluster Server Management (Real Application Cluster) & have successfully completed projects on Oracle RAC - Install, Configure, implement, and support.
• Good experience in performance tuning of production and development databases.
• Strong experience in database backup & recovery procedures using conventional cold, hot & RMAN backups
• Highly proficient in SQL, PL/SQL, bash and korn scripting
• Experience in Installation and configuration of Oracle 11g and 12c on Linux.
• Excellent experience in using OEM, TOAD, Data Migrations using export/import
• Excellent experience in cloning of databases using RMAN duplicate database feature.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery support
• Management of schemas, objects & Partitioning the tables & indexes.
• Proficient in performance tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, ADDM
• Good Interpersonal communication skills and Documentation skills.
• Provided On-Call support.
• Good experience in User and security management using Grants, roles, privileges.
• Experience in setting up DR solutions using RMAN, scripts, Data Guard
• Setup Oracle 11g GoldenGate for replication needs.
• Poses strong DBA knowledge on SQL Server 2005 and 2008.
• Poses strong knowledge on RAID levels, NAS and SAN
• Worked extensively with SAN admins for ASM disks and Diskgroups.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Developed and implemented Materialized views for better performance of daily reports.
• Expertise in using Oracle Enterprise Manager (OEM) and Grid control and its components.

TECHNICAL SKILLS:

Programming: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, bash, ksh

Database: Oracle 9i/10g/11g, 12c, Microsoft SQL Server 2005

Operating Systems: Windows Server 2003, 2008, 2012, RHEL, AIX, HP-UX, Sun Solaris, Ksh, Bsh, VMware

Tools: SQL*Plus, PL/SQL, Oracle Enterprise Manager (OEM), RMAN, SQL*Loader, TOAD, EXP, IMP, data pump, export, import, DB Verify, SQL loader, statspack, tkprof, Data Pump, Grid-control, Database control, RMAN, Toad, Exceed, Confio, SQL Developer

Networking: LAN, WAN, TCP/IP, DNS, AD Server

Cluster: Real Application Cluster (RAC), Windows Cluster

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, TX

Responsibilities:

• Installed 11g and 12c Oracle Software Release 2 on their UNIX and Windows platforms.
• Build 2 node RAC cluster on Linux.
• Upgrade databases from 10g to 11g R2 to 12c
• Cloned Databases using various methods.
• Used Oracle GoldenGate for Basic Data Replication.
• Worked on Uni-Direction GoldenGate setup.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose
• Handled Administration, Backup & Recovery using Recovery Manager (RMAN) tool.
• Implemented Oracle 11g RAC within the Organization for various departments
• Migrated existing single instance databases to RAC environment
• Extensively used Oracle 11gR2 new features Data Guard, Replication, automatic SGA tuning, enhanced RMAN with flash recovery area, Oracle data pump, Database Control, AWR, ADDM, SQL Tuning/Access Advisors, Flash Back Database and several others.
• Performance Tuning and monitoring statistics of production databases
• Administered the database and its users through Oracle Enterprise Manager (OEM) Tool.
• Reviewed, developed, tested & documented technical steps.
• Shouldered a project which dealt with documenting the data sources and the architecture of Oracle database.
• Developed UNIX Shell Scripts and modified the existing ones to meet the organizations specific requirements.
• Extensively worked on 11g Grid Control.
• Familiar with 12c Grid Control setup an implementation.
• Documented new procedures and added to SharePoint.
• Provided support to Development team in SQL tuning and database design.
• Worked in on-call rotation and provided off hours support to both production and non-production databases.
• Worked with UNIX, Firewall and storage team for DR migration.
• Installed and configured SQL Server 2000/2005 components

Oracle DBA

Confidential, Ridgefield Park, NJ

Responsibilities:

• Installed Oracle Software 10g Release 2
• Created and designed database for new projects
• Provided 24/7 support for all production databases
• Database Cloning & Advanced Queuing Concepts
• Created shell scripts for automating various database tasks in UNIX platform
• Performance and Tuning of databases
• Creation and maintenance of standby databases
• Creating new users and manage roles and privileges
• Managing Rollback Segments, Redo logs, Control files, and Tablespaces.
• Developed and fine-tuned PL/SQL & UNIX shell scripts that update the data warehouse on their scheduled run
• Generated reports in Oracle Reports 9i by analyzing the database based on the specific business requirements
• Installation and configuration of Oracle Database Software 10g.
• Creation and Configuration of Oracle database.
• Performed the Pre-migration task for RAC & Standalone Database.
• Extensively involved in Real Application Cluster (RAC) nodes 10g database migration
• Migration of database (from 9.2.0.5 to 10.2.0.1)
• Involved the Post-migration task (Unit-testing) for every RAC & Standalone servers migrated to Canada.
• Worked on RAC on RHAS with 4 nodes server side load balancing using Automatic Storage Management
• Performance tuning of SQL queries
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Designed and Implemented database security using Oracle roles and privileges.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Managed Data Guard between Primary and Standby
• Successfully implemented physical standby database using Oracle Data Guard
• Successfully configured the databases to switchover, failover and fallback scenarios.
• Provided 24x7 production support
• UNIX Shell scripting for backup and monitoring of databases.
• Written scripts to automate repeated tasks

Jr. DBA

Confidential, Ridgefield Park, NJ

Responsibilities:

• Install Databases using scripts
• Ran deployment scripts
• Installed Oracle client
• Installed OEM clients on Windows XP
• Worked on TNS networking issues
• Created users
• Setup backups via RMAN
• Created documents and put on SharePoint.
• Shadow Sr. DBAs to learn new topics in DBA word
• Created Database links
• Used export import to clone users
• Worked on grants, permissions, roles and user security.
• Used TOAD
• Used Putty, Secure CRT and exceed
• Unlock users
• Installed databases using DBCA.
• Good exposure on RAC clusters
• Learn how to manage databases using 11g Grid Control.
• Worked on Memory management
• Worked on Tablespace management.