SUMMARY

• Over 8 years of experience as Oracle Database Administrator, providing 24/7 support of both development and production Oracle 12c/11g/10g/9i databases on Various Platforms including Exadata.
• 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 9i, 10g, 11g in HP - UX, SUN SOLARIS,IBM AIX and UNIX/LINUX environment
• Poses strong Administrative skills in RHEL.
• Experience in 11g grid control and 12c cloud control
• 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.
• 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 10/11g on SUN-Solaris, HP-UX, IBM AIX, Linux and Windows
• Experience in Installation, configuration of Oracle 11g RAC & also used Oracle 11g features like - Memory Management, Reorganization / Rebuild Indexes, Gather statistics / Automatic Statistic Collection, SQL Baselines, SQL Profiles, invisible indexes.
• 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.
• Worked on 12c Multitenant databases.
• Setup unidirectional replication using Oracle GoldenGate
• Good experience in User and security management using Grants, roles, privileges, Oracle Vault, Wallet, FGA (Fine Grain Auditing)
• Experience in setting up DR solutions using RMAN, scripts, Data Guard standby solution.
• 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

Database: Oracle 10g, 11g and 12c, Microsoft SQL Server

Operating Systems: Linux, AIX, Solaris, Windows, Exadata

Tools: OEM, RMAN, SQL*Loader, TOAD, EXP, IMP, dpump, cloud control, grid control

Networking: LAN, WAN, TCP/IP, DNS

Technology: OLAP, OLTP, RDBMS, AD Server

Cluster: Real Application Cluster (RAC), Windows Cluster

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Confidential, Middletown, NY

Responsibilities:

• 24x7 Production Database administrations on Exadata.
• Installed, configured and managed 11g R2 RAC databases on Exadata.
• Established Disaster Recovery for 11g R2 Clustered database using Oracle Data Guard.
• Upgrade databases from 10g to 11g R2 to 12c multitenant.
• Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities
• Applied CPU / PSU patchesInstalled 12c database
• Worked on Multitenant databases
• Create and manage Enterprise Manager jobs, alerts and notifications
• Written Shell Scripts to automate jobs
• Configure alerts from cloud control.
• Created and managed ASM instance and ASM disk groups
• Installing ASM environment and migrating database from NON-ASM to ASM
• Configured Oracle networking for 11g RAC
• Worked on several Shell scripts to maintain the database activities
• Configured the Flash Recovery Area
• Helped developers in deployments.
• Provided on-call support

Oracle Database Administrator

Confidential, Chicago, IL

Responsibilities:

• Upgrade databases from 10g to 11g R2
• Installed 11g Oracle Software Release 2 on their UNIX and Windows platforms.
• Build 2 node RAC cluster on Linux.
• Worked on Oracle security.
• Created UAT databases from production backups by using Database Cloning technique and facilitated the testing for various new projects and enhancements.
• Used Oracle GoldenGate for Basic and Advanced Data Replication.
• Worked on Uni-Direction and Bi-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 and doing capacity planning for database growth and load.
• Administered the database and its users through Oracle Enterprise Manager (OEM) Tool.
• Technically reviewed, developed, tested & documented all the batch scripts that update the database on their scheduled run in the UNIX CRON.
• 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 oncall 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

Environment: Oracle DB 10g/11g R2 with RAC, RMAN, Oracle Enterprise Manager (OEM), 10g DATAGUARD, Putty

Oracle Database Administrator / Analyst

Confidential

Responsibilities:

• Installed Oracle Software 9i Release 2
• Created and designed database for new projects
• Provided 24/7 support for all production databases
• Database Cloning & Advanced Queuing Concepts
• Developed PL/SQL Code for migration of packages and procedures
• 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
• Using Pare do analysis methodology for incidents logged in the Remedy Action Request System, documented re-occurring issues that will be addressed infuture software maintenance releases against the Oracle ERP App Suite
• Got an overview and understanding of Oracle Apps architecture and demonstrated knowledge gained on Order Management module
• 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) on SUN Solaris 2.7.
• Involved the Post-migration task (Unit-testing) for every RAC & Standalone servers migrated to Canada.
• Worked on RAC on Red Hat Linux Advanced Server with 4 nodes server side load balancing using Automatic Storage Management
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• 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.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Communicate and coordinate with Oracle using TAR system for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using BMC, RMAN and SQL Backtrack
• Installing and Configuring from Oracle 9.2.0.1.0 (9i) database to Oracle 10g.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues disasters from happening.
• Upgrade the data’s from Existing Oracle 9i to Oracle 10g and Migration of database (from 9.2.0.5 to 10.2.0.1).

Environment: Oracle DB 9i/10g, Sun Solaris 10, AIX/V5.3, Linux 4.3, Windows Server, RAC, 10g DATAGUARD, Oracle Application Express, TOAD, IBM AIX UNIX, Oracle Reports 9i, Putt