SUMMARY

• Quantified 8 years of Proficient Oracle Database Administrator having hands on experience on Database Installation & Management, Real Application Cluster Management(RAC) & Automatic Storage Management (ASM), Setting up and Configuring Data guard, Replication Using Golden gate, RMAN Backup & Cloning, Datapump, Upgradation, Migration, Patch execution (PSU & CPU) and Performance tuning.
• Flexible with database administration of Oracle 12c, 11g, 10g &9i in very large scale database environment and to run vital day - to-day on in Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Worked on distinguished platforms alike HP-UX, AIX, Sun Solaris, RED HAT Linux and Oracle Enterprise Linux (OEL) and Windows.
• Installed and maintained Oracle 12c/11gR1/2/10g/9i, RAC with ASM & Oracle Cluster File system2 (OCFS2).
• Excellent experience in configuring and tuning of Oracle 10g/11g RAC, CRS and ASM for high availability database.
• Created a Clone Database using RMAN on remote Server using SRVCTL commands for Real Application Cluster (RAC) Databases.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment.
• Skillful in employing ORACLE STREAMS for replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for Disaster Recovery (DR) and High availability(HA).
• Troubleshooting and performed switchover/failover using Data Guard manager command line and Graphical User Interface (GUI).
• Hands on experience in OracleGolden Gate installation, configuration, troubleshooting Golden Gate EXTRACTS,PUMPS and REPLICAT issues.
• Comprehensive experience in Database backup and recovery (User-managed), RMAN Backup, Recovery & Cloning with/without catalog database.
• Executed Logical Backup using Data Pump Utilities (Export/Import) and Physical Backup (Cold/Hot/Full/Incremental/ Cumulative) backup strategies in 11g/10g/9i.
• Configuring Backup Retention Policy, planned strategies for Incremental Backups of Data files and Rolling Forward Image Copies of Data files and Performing and Scheduling Backups with Enterprise Manager
• Upgraded database from 11.1.0.6 to 11.1.0.7 and applied a PSU patch set from 11.2.0.3.1 to 11.2.0.3.9.
• Performed Oracle Cross-platform Migration from Oracle 10g R2 on Solaris to the same version on Linux followed by Upgrading to 11g(Both platforms were x86-64).
• Writing scripts in UNIX Shell Scripting (cron, awk, scp, kill, top) for managing the user roles and privileges, scheduled backups (using Data pump /cold backups), manage statistics & Disk space management.
• Creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases about 4 years.
• Prompt and attentive in Oracle Installations, Upgrades, Patch set updates-Critical Patch Updates (CPU) in an assorted environments.
• Proficient in setting up the Network configuration (Listener & TCP/IP Connections).
• Data transferring and Refreshing with export/import utilities, Data Pump and Data loading using SQL*Loader and External tables.
• 6+ Years of experience in Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT & interpret Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) reports, Tuning of SGA, distribution of disk I/O, Resizing of tables and indexes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in advanced Oracle features such as table partitioning, Oracle Streams (Replication) Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases.
• Mastered the ability to Setup, Install, Configure, Maintain and Troubleshoot several Oracle tools and utilities similar to Oracle Grid Control, Oracle Enterprise Manager (OEM), Tool for Oracle Application Developers (TOAD), Oracle SQL Developer in diverse versions.
• Expert in planning, creation, administration and troubleshooting of Oracle 11g/10g/9i OLTP (multiple instances)/OLAP databases in production.
• Involved in designing of Disaster Recovery drill plan using Data Guard, and High Availability using RAC.
• Gathered high-quality exposure towards Exadata.
• Extensively used BMC Remedy, HP Quality Center ticketing systems & HP Java ITO (OVO) Console for monitoring.
• Enthusiastic & Resilient Team Member in establishing effective task priorities, customer-focused, in fast-paced and multitasking environment.
• Portrayed conviction in handling Severity issues within the team and won lots of Laurels to the organization and to the Team.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

RDBMS: Oracle 12c/11g/10g/9i, 12c/11g/10g Real Application Cluster (RAC), ASM

Tools: & Utilities: RMAN, TOAD, PL/SQL developer, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Golden Gate, Cloning, Migrations

Languages: C, SQL, PL/SQL, UNIX/NT Shell Scripting, Perl.

Tuning Tools: SQL Tuning ADVISOR/ TKPROF/ EXPLAIN PLAN /STATSPACK, ADDM, AWR.

Web Monitoring Tools: Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console, Oracle Enterprise Manager(OEM) 12c/11g/10g

PROFESSIONAL EXPERIENCE

Confidential, East Hanover, NJ

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11G R2 Real Application Cluster (RAC) 3 node RAC.
• Supporting more than 15 production, 35 development and 40 Test databases
• Installed and configured Oracle 12c on Golden gate with Oracle Enterprise Linux.
• Migrating single Instance Databases to 3 Node RAC environments.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Involved with installation and maintenance of ORACLE RAC 3 node and adding a node to this cluster database for high availability.
• Created custom services for RAC database for distribution of load across the nodes.
• Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.
• Installation and maintenance of Oracle 10g, 11g Data Guard.
• Standby database setup via Data guard for Database Disaster Recovery.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Installed STANDALONE servers on Automatic Storage Management (ASM), Red hat LINUX.
• Data Guard using physical standby database, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI
• Upgraded database from 11.1.0.6 to 11.1.0.7 and applied a PSU patch set from 11.2.0.3.1 to 11.2.0.3.9.
• Performed Backup and recovery strategies using RMAN.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Furnished technical support to Application Support team for performance and database related issues.
• UNIX shell scripting as and when required based on the requirement.
• Performed Migration / Up-gradations of Databases.
• OracleGolden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues.
• Responsible in Migrating the databases from SOLARIS to RHEL.
• On-Call 24x7 DBA support for production databases.
• Verify and notify for the success of whole migration process and make live production databases.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Creating and maintaining the Oracle databases.
• Createdand managing the database objects such as tables, indexesand views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Applying patch set and interim patches whenever required to make the database software up to date.
• Creation of new scripts to automate the procedures to generate statistics on database space supervision, performance and for proactive monitoring.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Involved in I/O tuning by moving data files and redo log files to faster disks..
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: O/S: Sun Solaris, Red Hat Linux; RDBMS: Oracle 9i/10g/11g/12c; Tools: RMAN, OEM,TOAD,SQL *Loader, Export/Import, Data Pump, Data Guard, Golden gate, Cloning, Migrations, Upgradtion; Languages: PL/SQL,SQL, Unix Shell Scripting; Tuning Tools: TKPROF, STATSPACK,AWR,EXPLAIN PLAN,OEM

Confidential

Oracle DBA

Responsibilities:

• Daily Health Checkup of the database using STATSPACK, Automatic Workload Repository(AWR), Automatic Database Diagnostic Monitor (ADDM).
• Accountable for administration and supporting Oracle 11g, 10g and 9i databases in Development(DEV), Quality Assurance (QA), User Acceptance Testing(UAT) and Production environments.
• Configuration of release 10g RAC R2 with Automatic Storage Management (ASM) and Raw Devices, 10g CRS & also with 11gR2.
• Created a Clone database using RMAN on remote server and used SRVCTL for RAC High Availability(HA).
• Installation and Setup of 4 node 11g RAC and adding a node in Linux environment in 11g R2 ASM on RAC databases.
• Planning and implementing DR & High Availability solutions using Oracle 10g Standby Database using Oracle Data guard, 9i and 10g RAC
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Supported Data Warehousing and OLTP projects and Database design tasks utilizing Oracle EXPRESS OLAP technology and Oracle 7.1.4, 8i RDBMS.
• Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g
• Setup, configuration and maintenance of Oracle Golden Gate to ensure disaster recovery, high availability and data protection
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM
• Performed Upgrade of development, production and QA databases from oracle 10.2.0.3 to Oracle 11gR1.
• Migration of database from oracle 10g to oracle 11g on Sun Solaris server.
• Worked on Automatic Storage Management (ASM) for managing data in SAN
• Monitoring and resolving tickets in different environments
• Export and Import of database objects to copy from one database to another database between different environments
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, RAW Devices
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Created UNIX shell scripts to automate batch jobs through Cron
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/Index analyze jobs and Monitoring database backup logs.
• Adhering and Pioneering the Service level Agreement(SLA) Reporting, Handling tickets / requests Troubleshooting the bottlenecks with the aid of Team members.

Environment: O/S: Red Hat Linux; RDBMS: Oracle 10g with RAC, Oracle 9i/10g/11g; Tools & Utilities: High Availability(Data guard, RAC) TOAD, RMAN, RAID, Data Pump, Data Broker; Language: UNIX,PL/SQL, Shell Scripting; Tuning Tools: TKPROF, STATSPACK, OEM

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 9i/10g and 11g R1 databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem.
• Successfully migrated databases from windows 2000/2003 running oracle 9i over to Linux 5 with Oracle10g.
• Installation, Upgrade and Configuration of Oracle 10g and 11g Databases on Red Hat Enterprise Linux & Solaris Platforms.
• Involved in designing of Disaster Recovery drill plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Materialized View ; Creating the database using DBCA (Database Creation Assistant) & manually; Create table spaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Used cross platform transportable table space (TTS) to transport table spaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash back Recovery in RAC Environment.
• Implemented backup strategies using Hot/Cold, Exp/Imp according to business requirement.
• Cloning of database & performed Tablespace-point in time recovery (TSPITR) using RMAN.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
• Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetric.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and STATSPACK.
• Performed conversion from single instance to Real Application Cluster (RAC) database instances.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Downsizing and defragmenting the Very Large Databases(VLDS) by Export / Import, Cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Storage Management Managing Table spaces, Segments, Extents, Rollback & Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.

Environment: O/S: Red Hat Linux, Windows 2000/2003; RDBMS: Oracle 9i/10g/11g R1; Tools & Utilities: High Availability, RMAN, Export/Import, ASM, SAN, Grid; Tuning Tools: TKPROF, STATSPACK, OEM, PL/SQL.

Confidential

Oracle DBA

Responsibilities:

• Installed, Configured and Maintained Oracle 9i & 10g versions on Sun Solaris and Red Hat Enterprise Linux platforms.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Created and Managed users, roles, schemas and rebuilding Indexes and granting privileges
• Revoked user privileges and roles as per requirement and killed blocking session.
• Assisted the Development team in developing new logic and modify PL/SQL code to make new enhancements or resolve bottlenecks.
• Responsible for Preparing Data Flow Diagrams for existing PL/SQL code.
• Configured Recovery Manager (RMAN) and Performed Hot and Cold backups for production databases using RMAN.
• Involved in taking logical backup using Data pump Expdp and Impdp Utility.
• Performed auditing on user activities on request and according to organization guiding principle.
• Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.
• Involved in coding of data extraction scripts as per technical specifications.
• Involvement in all phases of the project life cycle.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Involved in configuring the status of listener and restarting listener.
• Analyzed the table structures using Analyze command and to collect Stats on a Table.

Environment: O/S: Red Hat Enterprise Linux, Sun Solaris; RDBMS: Oracle 9i/10g; Tools & Utilities: TOAD, RMAN, Data Pump; Languages: UNIX, PL/SQL