We provide IT Staff Augmentation Services!

Oracle Dba Resume Profile

Jersey City, NJ

Professional Summary:

  • Over 7 years of Information Technology experience in Oracle Database Administration 12c/11g/10g/9i/8i and Oracle RAC Administration 11g/10g/9i in Installing, Administering, Migrating, Upgrading, Tuning, Troubleshooting and Managing over Multi-terra byte of databases on Linux, Sun Solaris, HP-UX, AIX and Windows Operating systems on Production, Pre-Prod, UAT, Staging, Development environments.
  • Experience in installing, configuring and maintaining Oracle 11.2.0.3 Grid Infrastructure Cluster RAC .
  • Excellent understanding of Oracle Internals, Architecture, Data Dictionary, Data Management, Automatic Storage Management ASM and System Management.
  • Experience in installing and configuring Oracle Enterprise Manager OEM 10g/11g Grid Control and Cloud Control 12c for database monitoring/performance/diagnostics.
  • Experience in database upgrade and migration using Oracle Transportable tablespaces TTS from Oracle 10gR2 to 11gR2 and from Linux to Solaris.
  • Implementation of Oracle Backup and Recovery strategies using RMAN with Data Guard in RAC environment.
  • Expert skills on Oracle Data Guard implementation by the log shipping process between primary and standby and also for disaster recovery DR .
  • Experience in installing, configuring and managing Oracle GoldenGate for replication.
  • Experience in installing, configuring and maintaining Oracle 9i/10g Real Application Clusters RAC for High Availability on Linux, Solaris, AIX, HP-UX and Windows for high scalability and availability.
  • Experience in cloning/duplicating production databases on testing and training environments using Recovery Manager RMAN .
  • Experience in Performance tuning using various aspects of the database utilities like TKProf, Explain Plan, and Stats pack/AWR/ADDM.
  • Extensive working experience in various RDBMS, OLAP and OLTP databases.
  • Complete range of Oracle DBA activities including day-to-day production database monitoring includes alert log, trace file, and achieve files, Troubleshooting production issues and Performance Tuning issues.
  • Experience in recommendations/suggestions on Physical Database design.
  • Experience in writing Shell scripts to backup, restore database and automate daily activities.
  • Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-production databases.
  • Experience in create and initialize Database Security roles and auditing using HIPPA/SOX.
  • Designed and implemented Backup and Recovery strategies by taking cold backup and hot backup and RMAN.
  • Testing and implementing different physical and logical backup and Recovery methods like point in time, media recovery, full/partial and export/import.
  • Experience in partitioning tables and indexes for better performance in warehouse environments.
  • Experience in writing Shell scripts to backup, restore database and automate daily activities.
  • Good Knowledge on VERITAS Netbackup, EMC and Netapps storage practices. MML
  • Versatile team player with excellent analytical, communication and inter personal skills.
  • Applying quarterly PSU/CPU patches, release upgrades and ONE-OFF patches.
  • Monitoring Reorganizing Tablespaces/Tables/Indexes and Granted Users the resources by Creating Profiles, Managing Sessions, Privileges and Roles.
  • Provided 24 x 7 support and flexible to work beyond regular hours.

Technical Skills

Operating System: RHE Linux AS 4.x, 5.x, UNIX, IBM-AIX 5.x/4.x, Sun Solaris 10/9, HP-UX 11.31. Windows server 2008/2005

Databases: ORACLE 11g/10g/9i, MS SQL Server 2000/2005, MySql

Application Servers: Oracle 10g/9iAS, Internet Information Server, Weblogic

Web Servers: Apache Webserver

Languages: C, C , Java, SQL, PL/SQL, Unix Shell Scripting, PERL Scripting

Networking: TCP/IP, Internet, sqlnet, Net8

Storage Clusters: EMC, Veritas Sun clusters

Tools/Utilities/ETLs: Oracle 10g/11g Database control/Grid Control, AWR, ADDM Attunity for Oracle-CDC, TKProf, SQL Loader, RMAN, Export/Import, Data pump, Oracle Dataguard, TOAD SQL Developer, VNB, Erwin 3.x, srvctl, crsctl

Professional Experience

Confidential

Role: Oracle DBA,

Responsibilities:

  • Installation, configuration and administration of oracle 10g/11gR1/11gR2.
  • Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors, Collaborate with Oracle support for bugs issues resolutions and personal research.
  • Responsible for installing and managing Oracle 11.2.0.3 Grid Infrastructure Cluster RAC hosted on RHEL 5.7 servers for PROD/DEV/TEST/UAT environments.
  • Experience in installing OEM Cloud Control 12c Installation and configuration and experience in OEM 12c Agent upgrades.
  • Responsible for database Cross-Platform upgrade and migration using Oracle Transportable tablespaces TTS from Oracle 10g to 11gR2 and from Red Hat Linux Little Endian to AIX Big Endian .
  • Responsible for Database cross platform upgrade and migration from Oracle 10g to 11gR2.
  • Responsible for installing, configuring and managing Oracle GoldenGate for replication.
  • 24X7 production support for different Oracle databases on UNIX and Windows environments.
  • Applied Quarterly security Patches CPU/PSU , Patchset and One-off Patches on Oracle RDBMS and Grid.
  • Design and implement database backup and recovery procedures using RMAN.
  • Responsible for Database Upgrade and migration from Oracle 10g to 11gR2.
  • Migrating non-ASM databases to ASM databases 11.2.0.2 on RHEL5.
  • Responsible for building the Oracle 11g Grid Control and installing agents on various targets.
  • Implemented Oracle Active Data Guard.
  • Partitioning Strategies for very large tables.
  • Tuned the databases for optimal performance using EXPLAIN PLAN, SQL Optimizer, AWR, ADDM and ASH Reports.
  • Installed OEM 12c Cloud Control and OEM Grid Agents 11.1.0.1.0 on Linux and UNIX for monitoring of production databases.
  • Refresh/Cloning of Database from production environment to test environment using RMAN Duplicate feature.
  • Scheduled the maintenance jobs and alerts through OEM Grid Control 11.1.0.1.0 .
  • Troubleshooting Database performance issues using Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM and SQLTXPLAIN in order to diagnose the SQL statements.
  • Monitoring Tablespaces, Resizing, Relocating data files for better disk I/O.
  • Proactively identified issues/bottlenecks that are potential problems, Involved necessary support teams Application, Linux, Network, Storage etc. and took a corrective action to rectify the issues.
  • Interacted and worked with Oracle Support SR whenever production issues were faced.

Technologies: Oracle 11gR2/11gR1/10gR2/9i RAC, ASM, OEM Cloud Control 12c, OEM Grid Control 11g, Redhat LINUX4.7/5.4, AIX,HP-UX, Sun Solaris, Windows, Data Guard, Golden Gate, Performance Tuning, AWR/ADDM, Shell, RMAN, Veritas NetBackup, RDBMS, Autosys.

Confidential

Role: Oracle DBA,

Responsibilities:

  • 24X7 production support for different Oracle databases on UNIX and Windows environments.
  • Installing, Configuring, Monitoring, and Troubleshooting 10gR RAC, 11g RAC databases on ASM and OCFS2.
  • Proactively identified issues/bottlenecks that are potential problems, Involved necessary support teams Application, Unix, Network, Storage etc. and took a corrective action to rectify the issues.
  • Responsible for creating and managing db links which enables developers to access objects on another database.
  • Implemented backups using RMAN, Oracle Utilities Export/Import DataPump and OS methods.
  • Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Configured RMAN for scheduling backup directly to tape using VERITAS NetBackup.
  • Designed Backup and Recovery strategies using RMAN both on standalone and cluster environments.
  • Refresh/Cloning of Database from production environment to test environment using RMAN Duplicate.
  • Identified and fixed the logical block corruption using RMAN.
  • Responsible for Oracle database migration using Oracle datapump utility.
  • Involved in Disaster Recovery team and responsible for smooth completion of annual DR testing.
  • Intensively used 10g Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM reports for the health check of the databases and used the notification tool to send the alerts in OEM Grid Control.
  • Used SQL Tuning advisor in OEM to get the recommendations for poor performing queries and assisted the developers.
  • Responsible for SQL query tuning, optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL Trace.
  • Supported Developers and Testing Team with connection related issues and structural changes in the database.
  • Scheduled and Monitored OEM Grid and Cron Jobs for RMAN and exports on Unix Platforms. Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Applied required security patches on oracle databases using Opatch utility.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
  • Developed Unix shell scripts and automated nightly jobs using Cron to schedule the Backups, Refresh tables in test databases from production, cleanup trace files, analyze non-system tables, analyze non-system indexes, delete old backup files etc.,
  • Assisted developers in testing PL/SQL procedures stored procedure, triggers, function, cursors and packages for maintaining tables, retrieving data from tables and managing users using different oracle tools.
  • Regular Coordination with DBA teams in India supporting Nightly activities.
  • Intensively used Toad for Oracle Database Administration.

Technologies: Oracle 11g/10g/9i RAC, ASM, OEM Grid Control 10g, Solaris 10, HP-UX, Window 2003, Datagaurd, Performance Tuning, AWR/ADDM, Shell Scripting, RMAN, Veritas NetBackup, RDBMS,PL/SQL, TOAD .

Confidential

Role: Oracle DBA,

Responsibilities

  • Provide 24 x 7 database administrative activities over different database servers.
  • Supported different Databases like Production, Development, Testing, UAT and Training.
  • Responsible for Oracle 11g RAC EE installation and configuration on RHEL5 X86 64.
  • Responsible for upgrade and migration of data from 10g RAC to 11g RAC environment SE using ASM on RHEL4.
  • Responsible for data migration of various OLTP and OLAP databases.
  • Responsible for Data Guard setup with one Primary and two Standby databases and scheduled cron job to monitor the replication between primary and standby every 15mins.
  • Responsible for planning, testing and implementing different backup and recovery strategies.
  • Performed Database Cloning to create testing and development instances from production.
  • Applied latest releases of the RDBMS patches from Oracle to the Production and test instances to resolve few technical challenges issues.
  • Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and monitoring the statspack report, generated from snapshots taken at the peak business hours.
  • Daily Monitoring of alert log files for errors, trace files and archive log destination files.
  • Designed and implemented hot backups using a combination of incremental, differential and full backups using RMAN.
  • Installed Oracle Enterprise manager grid control agent on all production databases using agent download script on different platforms windows, linux, solaris, .
  • Responsible for network configuration and involved in a Client Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
  • Planned, tested and implemented backup strategy using RMAN, Oracle Utilities Export/Import and OS methods.
  • Upgraded database and migrated data from 10.2.0.3 to 11.1.0.6.
  • Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan and provided the ADDM reports per request.
  • Scheduled and monitored OEM job scripts for exports, hot backup, analyze schema, rebuild indexes.

Technologies: Oracle 9i/10.2.0.3/11.1.0.6/11.1.0.7, RHEL4,RHEL5,Solaris 10,Window 2003, MS SQL Server 2000/2005/2008, Oracle Enterprise Manager Grid Control, AWR/ADDM/Statspack, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, Dataguard

Confidential

Role: Oracle DBA,

Responsibilities

  • Responsible for creating Production, Test and Development Databases, setting proper initialization tuning parameters, Installing implementing Oracle 9i and 10g for various customers on various operating system platforms as part of the implementation team
  • Responsible for Data load on different databases using SQL Loader
  • Recovered critical databases from failures with minimum downtime.
  • Responsible for planning, testing and implementing different backup and recovery strategies.
  • Conducted daily routine checks on alert logs and trace files.
  • Designed and Configured RAC environment on Two Node architecture.
  • Performed database system level space management and monitoring.
  • Real Application Clusters monitoring, tuning, load balanced using OEM Oracle Enterprise Manager .
  • Utilize, managing and monitoring hot Standby Database using Data Guard as well as monitoring standby for latency issues.
  • Involved in replication setup, configuration and maintenance of replication process
  • Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.
  • Responsible for entity relationship data modeling using Erwin data modeler.
  • Responsible for network configuration and involved in a Client Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
  • Created and configured database manually using Oracle Database Configuration Assistant.
  • Planned, tested and implemented backup strategy using RMAN, Oracle Utilities and OS methods.
  • Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from Quest software DB Tuning .
  • Responsible to identify the specific bottleneck areas implementing Oracle Wait Interface and improvements has been targeted to those areas.
  • Scheduled and monitored OEM job scripts for exports, hot backup, analyze schema, rebuild indexes.
  • Provided 24x7 support. Willingness to work beyond regular hours based on business demands.

Technologies: Oracle 10.2.0.2, AIX, Linux, Window 2003, Oracle Enterprise Manager, RDBMS, SQLDBA, PL/SQL, TOAD 8.0, Shell Scripting, Stored Procedures

Confidential

Role: Junior Oracle DBA

Responsibilities:

  • Migration of Oracle 8i/9i test databases to 10g Grid Control setup on SUN Solaris and Windows Server and to test the migrated database in different scenarios with different loads.
  • Installed and Configured RAC with 4 nodes on Oracle 10g on SUN Solaris using Automatic Storage Management and VERITAS Cluster ware on Production, Development, UAT, Staging environments..
  • 24x7 production support for Oracle 11g databases on Redhat Linux Servers, working on a primary/secondary pager rotation.
  • Actively worked on performance tuning of instance SGA and PGA and Physical database that included resolving fragmentation and disk contention. Use Partitioning and indexing feature of Oracle 10g to improve performance.
  • Performed Database Cloning to create TEST and DEV instances.
  • Created and maintained standby databases using database replication Data Guard for high availability.
  • Disaster recovery planning - implemented database backups and disaster recovery strategies using RMAN and data pump export, import.
  • Involved in Migrating Informix development databases to the Oracle platform using Oracle Migration Workbench.
  • Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle and SQL server. Responsibilities included configuring and monitoring the SQL database 2000.
  • Writing and testing PL/SQL procedures stored procedure, triggers, function, cursors and packages for maintaining tables, retrieving data from tables and managing users. Responsibilities included working with developers.
  • Experienced in optimizing SQL tuning using CBO, explain plan, TKPROF, Statspack, ADDM, AWR.
  • Responsible for Data load on different databases using SQL Loader.
  • Resolved critical issues and worked over TARs.
  • Configure Oracle 10g Spatial.
  • Conducted daily routine checks on alert logs and trace files.

Technologies: Oracle 8i/9i/10g, Oracle 10.1.0.1 RAC,OEM Grid Control, SUN Solaris, Redhat Linux, Windows 2003, MS SQL-Server 2005, ASM, RMAN, Oracle Migration Workbench, AWR/ADDM/Statspack, VERITAS Cluster Server/Net backup, ODI, TOAD 8.0, Perl scripting, SQL Loader, Datagaurd, Stored Procedures

Hire Now