We provide IT Staff Augmentation Services!

Oracle Dba Resume

CT

PROFESSIONAL SUMMARY:

  • Over 8 years of IT experience in Oracle 9i/10g/11g as Database Administrator.
  • Experience in installation, configuration, administration, backup and recovery, tuning, migration, patching & upgrades and troubleshooting of Oracle databases 9i/10g/11g in UNIX and Windows operating systems.
  • Experience in implementation of Oracle Real Application Clusters (RAC).
  • Experience in Installing and administering OEM 12c .
  • Experience with RAC Cluster ware configuration and patching, RAC Backup and Recovery.
  • Experience in Oracle Automatic Storage Management (ASM), Cluster Interconnects, Load Balancing and designing failover systems on UNIX platforms.
  • Expertise in Configuring & Maintaining Oracle Data Guard(Physical & Logical Standby Database)
  • Experience in Database upgrading and migration of Oracle server (9i, 10g, 11g).
  • Experience in upgrading database from 11g to 12c
  • Unidirectional table replication using oracle streams and also performed proof of concept on the replication using oracle Golden Gate.
  • Expertise in Designing, implementing and managing Backup strategy using Oracle Utility RMAN, Export/Import and Data Pump.
  • Experience in cloning/replicating Production database using RMAN.
  • Performed Tablespace point in time recovery (TSPITR) using RMAN
  • Proficient in using Flashback technology to provide faster recovery of database.
  • Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows.
  • Performance Tuning of Oracle database using OEM GC, Cost optimizer, SQL analyzer , Performance Manager, Stats pack, AWR, ADDM, ASH, RDA, Explain plan (10046), TKPROF, SQL TRACE and Ordebug
  • Installed and configured Oracle Enterprise Manager Grid Control 11g/12C for database monitoring, performance, diagnostics
  • Experience performing History pull to synch-up data between Oracle to Non-Oracle databases using GoldenGate
  • Experience in configuring Integrated Extract and Co-ordinated Replicate after upgrading Golden gate software to 12.1
  • Data transferring using Export/Import utilities and SQL*Loader.
  • Expertise in creating and maintaining databases to Oracle Optimal Flexible Architecture (OFA) standards in very large scale database environment (VLDB) and mission critical OLTP and DSS systems.
  • Experience in using TSM for storage management.
  • Resolved database network problems using Oracle Net Configuration Assistant , Orcle Net Manager , Netstat and ping utility .
  • Involved in writing stored Procedures, Functions and Triggers in PL/SQL to interface application with database system.
  • Developed shell scripts for regular administration tasks that include various Cron jobs for alert logs, Backups, restore and recovery.
  • Created service requests with Oracle support for troubleshooting database issues.
  • Experience in creating partition tables and Materialized views.
  • Expertise in Database Security and Auditing.
  • Experience in Managing Database Structure, Storage Allocation, Table/Index segments, Undo segments, Constraints, Database Access.
  • Performed root cause analysis (RCA) and implemented recommendations.
  • Handled escalation processes.
  • Helped in fixing bugs and enhancements without breaching SLA.
  • Solid understanding of SDLC and CMM models
  • Provided 24 x 7 support and flexible to work beyond regular hours.
  • Strong ability to handle multiple projects simultaneously and ability to work independently or in a team environment and function successfully in a highly stressful environment

TECHNICAL SKILLS:

Operating Systems: RH Linux, Windows NT/2000/2008, Sun Solaris, HP-UX, AIX

RDBMS: Oracle 9i/10g/11g

DB Tools: Oracle streams, Export/import, Data pump, RMAN, SQL*Loader, LogMiner, AWR, ADDM, STATSPACK, TKPROF, EXPLAIN PLAN (10046), Oracle SQL Developer

Other Tools: OEM GC, AUTOSYS, VNB, TOAD, VVM, BMC Patrol, Erwin, TSM, Legato Net Worker, HPDP, WinSCP, MS Office

Networking: TCP/IP, Cisco Switches, Cisco Routers and Hub connections.

Languages: SQL, PL/SQL, Unix Shell Scripting, Java, Html

PROFESSIONAL EXPERIENCE:

Confidential, CT
Role: Oracle DBA

Confidential is a leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance - as well as investment products, annuities, mutual funds, and college savings plans. Confidential Group serves millions of customers worldwide - including individuals, institutions, and businesses - through independent agents and brokers, financial institutions, and online

Responsibilities:

  • Installation, configuration and maintenance of Oracle 10g and 11g databases on AIX.
  • Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
  • Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
  • Taking the RMAN incremental and cumulative backups.
  • Scheduling the databases backup using Cron tab.
  • Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
  • Monitoring the Oracle Instances, Users, Tables, Table spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
  • Creation of Users and granting them the required Roles and Privileges accordingly.
  • Involvement in space management, rectification of lock problems, managed quotas.
  • Configuration of Listener and Net Service names using NETCA.
  • Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
  • Expertise in Installing and configuring ASM and RAC for high availability databases.
  • Worked on Multiple RAC clustered, converting single node instance to RAC and adding instance to the existing 4 Node RAC.
  • Experience in installing 12c databases and upgrading databases from 11g to 12c
  • Required Monitoring experience Oracle, MYSQL Monitor, OEM Cloud control 12c
  • Involved in migrating databases from single instance to RAC environment.
  • Cloned schemas, objects and data on new server using Data pump.
  • Responsible for capacity planning, recovery planning and installing patches.
  • Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.
  • Responsible in installing and setting-up GoldenGate from source to target to provide active data replication
  • Responsible in switching over/switching back to Physical standby database and vice-versa and starting GoldenGate processes accordingly
  • Configured Data guard for disaster recovery purposes.
  • Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability.
  • Installed 12c agents on hosts and discovered targets.
  • Configured and implemented Oracle Golden Gate replication.
  • Translated business requirements into working logical and physical data models
  • Resolving the conflicts between the target and source database in Oracle Golden Gate.
  • Comprehensive knowledge in Database Architecture & Implementation, Data Models, Database design.
  • Experience in Designing the Data models for OLTP & OLAP database system
  • Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc
  • Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
  • Install, maintain and monitor Web Logic server as part of OEM Grid Control setup.
  • Involved in 24x7 production database maintenance and on-call support

Environment: Oracle 11g/10g/9i, HP-UX, UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, Explain Plan, SQL Developer, PL/SQL Developer, Erwin ,Data Pump, Business Objects, Toad 10.X, PUTTY, SFTP, SCP.

Confidential, MN
Role: Oracle DBA

Responsibilities:

  • Installation, configuration and maintenance of Oracle 10g and 11g databases on OEL.
  • Involved in construction of DR sites for all the Production databases.
  • Involved in installation and maintenance of ORACLE RAC for high availability.
  • Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date and associated with RMS.
  • Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
  • Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
  • Taking the RMAN incremental and cumulative backups.
  • Scheduling the databases backup using Cron tab and VERITAS net backup.
  • Installation, migration, upgrade, patching and administration of Oracle and SQL server databases.
  • Extensive experience in RMAN recovery in RAC and stand-alone database.
  • Involved in implementing load balancing and testing failover on RAC database.
  • Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
  • Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
  • Monitoring the Oracle Instances, Users, Tables, Table spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
  • Creation of Users and granting them the required Roles and Privileges accordingly.
  • Configured and implemented Oracle Golden Gate replication.
  • Involvement in space management, rectification of lock problems, managed quotas.
  • Configuration of Listener and Net Service names using NETCA.
  • Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
  • Cloned schemas, objects and data on new server using Data pump.
  • Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
  • Responsible for capacity planning, recovery planning and installing patches.
  • Worked extensively on monitoring 10G Grid Control database, configuration of error notifications, installing listeners, and adding them to the grid control.
  • Experience in using 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
  • Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.

ENVIRONMENT: Oracle 10.2.0.4, OEL, HP-Unix 11.11, Red Hat Enterprise Linux, RAC, ASM, SQL*Plus, OEM, PL/SQL Developer, Data Pump, TOAD.

Confidential, NY

Role: Oracle DBA

Responsibilities:

  • Installation and configuration of Oracle 11g/10g/9i on Windows and AIX series.
  • Monitoring and supporting more than 40 databases.
  • Involved in construction of DR sites for all the Production environments.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Extensive experience in RMAN recovery testing, RAC and standalone database
  • Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC).
  • Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
  • Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests
  • Perform troubleshooting of streams environment.
  • Monitoring Day-Day Backups, Log’s & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
  • Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
  • Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
  • Responsible for capacity planning, database security, recovery planning and installing patches
  • Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle 11g/10g, Oracle 10g/RAC, UNIX, Solaris 10, Informatica, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN, Business Objects XI, DataGuard.

Confidential

Jr. Oracle DBA

Responsibilities:

  • Performed full and incremental Backup Using RMAN Utility for Production databases.
  • Involved in Upgrading the databases using Database Upgrade Assistance (DBUA)
  • Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
  • Handling service requests within Service line agreement.
  • Involved in configuration files like Listener.ora, Tnsname.ora for Client–Server environment using network configuration assistant.
  • Identified and fixed the logical block corruption using RMAN.
  • Performed Data load on different databases from flat file using SQL*Loader.
  • Performed Hot backup, cold backup and incremental backup for production database using RMAN.
  • Monitored ALERT Log files to keep tracking the Oracle Errors and make necessary actions to rectify them.

ENVIRONMENT: Oracle 9i/10g, Sun Solaris 11.x, AIX 5.2, Windows XP, GRID, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, RMAN, Import/Export, Tuning Advisors, TOAD.

Hire Now