We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

SUMMARY:

  • Confidential is an analytical, detail - oriented, and pro-active Consultant who closely work with Project Managers/QA- developer staff in response to customer quotes, questions and/or issues possesses, an unrelenting work ethic, a strong desire to help people, and excellent follow-through skills with over 6 plus years of experience in the areas of Oracle DBA in very large Production Environments with Database Implementation on UNIX (Red Hat Sun Solaris, IBM- AIX, HP-UX, and Linux), VMS, and Windows.
  • Lead the development team activities including prioritizing requests, designing solutions, and supervising the development efforts.
  • Participate in architecture, design, implementation, software Installation and Upgradation, support. Work with business team, project managers, and systems analysts to review and qualify business requirements, functional specifications, use-cases, and test plans.
  • Design, prototype and coordinate with analyst teams to execute test plans and provide support during user acceptance testing.
  • Modify and enhance existing systems to in corporate new functionality and to optimize them for performance.
  • Work with developers, engineers to design and implement application features, including user interfaces, and business functionality enhancements.
  • Author technical design and support documentation.
  • Working on 24X7 Production environments.
  • Building databases, Creating schemas, data structures, testing, implementation, database security issues, maintenance, and control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.
  • Performing Oracle Linux installation on Oracle Virtual environment.
  • Experience on Installing VM Manager on Linux.
  • Extensive experience Oracle Virtual environment. Created Server pool Virtual machines.
  • Experience installing Oracle 11gR2, CRS, ASM and RAC Database on Oracle Virtual machine.
  • Experience in Intelligence solutions, strong knowledge of relational and multi-dimensional database architectures, database lifecycle design and application development.
  • Implementing automated backup strategy using the UNIX shell script CRON UTILITY.
  • Implementing RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
  • Communication and interaction with Oracle Support and reporting problems to Oracle and working towards resolving the same using TAR.
  • Installation and configuration of Oracle 10gR2, 11gR2 RAC software with ASM .
  • Upgrading RAC database from 10.2.0.4 to 11gR2 on Linux and windows env.
  • Maintenance and tuning of RAC Databases Used rapid install and other Oracle Application maintenance utilities like Oracle Enterprise Manager-Database Control, Grid Control.
  • Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, logical standby and physical standby databases.
  • Performing database cloning and refreshing.
  • Database Migration from single instance to Multiple instance environment
  • Logical and physical modeling using Erwin.
  • Experience in implementation of Oracle 1g new features like Data pump, Flash Back Technology and Automatic Workload Repository.
  • Database performance tuning, monitors with Explain Plan, Autotrace, TKPROF and Statspack utility and Tuning database using AWR, ADDM, OEM(Oracle Enterprise Manager),TOAD.
  • Scheduling and monitoring cron jobs for Backups and other activities.
  • Knowledge about PERL and Shell Scripting.
  • Knowledge about Oracle Gateway that allows Oracle to talk to other databases
  • Experience with Oracle Replication.
  • Managing Database Instances, rollback segments, temporary segments and monitoring of archive log activities.

TECHNICAL SKILLS:

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 8i, 9i, Oracle 10g Real Application Clusters (RAC) 11G. MS- Access.

LANGUAGES: SQL, PL/SQL, C#, C, C++, XML, UNIX Shell Scripting.

SOFTWARE / APPLICATIONS/ TOOLS: ORACLE 7.x/8.x/9i/10g,OAS 10g Recovery Manager (RMAN), Real Applications Cluster (RAC), ADDM Oracle Enterprise Manager, Datapump, STATSPACK, ERWIN, VERITAS Backup, Developer 2000, SQL Loader, TOAD

WEB TOOLS: HTML, XML, Cold Fusion, Java

RELEVANT EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

  • Size of datafiles, temporary, controlfile - to monitor growth of database
  • Tablespace statistics including total allocated space, used space, free space - to monitor & proactively add space to tablespace when needed.
  • Status of RMAN or Hot Backups in last 24 hrs
  • Top 10 expensive SQL's
  • Top 50 biggest Objects (tables, indexes) in terms of size
  • List of invalid objects (packages, triggers, procedures, views)
  • List of objects modified (DDL) in last 24 hrs
  • List of tables not analyzed in last 10 days
  • Any unusual messages, errors in alert.log, sqlnet.log, listener.log
  • Operating System, Storage/Space monitoring using top, freemem, df and du commands
  • General: Run AWR report and identify issue, Check CPU, memory resources consumption Make sure tables are analyzed on regular intervals. Ensure purge jobs are running and cleaning obsolete rows/objects. High transaction tables, indexes are reorganized. User Complaints on slowness: Check network connectivity speed, Check Logs (web server, alert.log, sqlnet, listener) for any errors. Try to identify high resource consuming sql using v$sql, v$session, v$process. Identify top Oracle OS process using top command on database server. Find Oracle SID,Serial# of OS process from v$session, v$process. Trace running session using oracle sid,serial#. Identify top expensive sql and identify cause, suggest sql tuning recommendation to developer
  • Creating oracle 11g, 12c database, Supporting and monitoring One node RAC and 3 node RAC database and Tuning database using AWR, ADDM, OEM (Oracle Enterprise Manager), TOAD.
  • Using Enterprise Manager Grid Control system management software for centralized monitoring, administration, and life cycle management functionality for the complete Oracle IT infrastructure, including systems running Oracle and non-Oracle technologies.
  • Relocating one node RAC database using srvctl command.
  • Generating AWR reports for monitoring database checking health of database.
  • Schema refresh from all the environments, using data pump export import.
  • User management by creating Roll’s and profile, password patterns.
  • RMAN recovery for accidentally dropped object in database. Using flash back technology.
  • Database cloning and creating standby database.
  • Creating database objects as per application team needed.
  • Providing 24/7 On-call support
  • SGA tuning and monitoring for such as session menanagment etc.
  • Tablespace management for oracle file system and ASM file system.
  • ASM disk management, creating and managing disk groups.

Environment: Oracle 10g,/11gR2 RAC, O/S- Linux Red Hat, Solaris AIX, IBM OMS, OEM (Grid Control), RMAN, ASM

Confidential, Kansas City, Missouri

Oracle Database Administrator

Responsibilities:

  • Proficient in Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Grid control.
  • Provided support for installation, configuration, creation and maintenance of Oracle 11g databases.
  • Managed users and database security, Developed Backup and Recovery Procedures, Performance Monitoring/Tuning, database network administration and Designing High Availability (HA) Databases.
  • Experienced in taking Online/ Offline backups, performing Point-in-time Recovery.
  • Provided Support to almost 100 databases in dev, test, break fix and Production.
  • Performing Oracle RAC and Single Instance 10.2 to 11.2 databases Upgrade.
  • Performed database administration, table spaces and data files through BRTOOLS and monitored archive logs; trace files, log files for troubleshooting.
  • Daily Monitoring activities like Analyzing ABAP Dumps, Update Monitoring, Alert Monitors, System Traces, Lock Entries Set Alert threshold, operation modes.
  • Using Database control, OEM, Grid Control for Database Monitor Performance and Tuning.
  • Performing space management for proactive management.

Confidential

Oracle Database Administrator

Responsibilities:

  • Oracle CRS, ASM, RAC server Installation and configuration.
  • Oracle Binary Installation and Database creation.
  • Installation and maintenance of database server, replication and client environments.
  • Performing Oracle RAC Installation and Single Instance 10.2 to 11.2 databases Upgradation.
  • Design, development and administration of Oracle databases.
  • Data Guard setup and monitoring Oracle Primary and Standby database.
  • Performance monitoring, reporting, and tuning of Oracle databases with AWR, ADDM and OEM.
  • Oracle tablespace management with proactive steps.
  • Management and maintenance of back-ups & recovery with RMAN.
  • Performing database security with User management policy.
  • Write shell script, creating and scheduling cronjob.
  • Oracle enterprise Linux (OEL) Installation and configuration.
  • Provision of support and assistance to development team in the design, development, testing, tuning and implementation of database applications.
  • Database refreshing with Export/Import tool.
  • Performing database cloning.

Environment: Oracle 10g,/11gR2 RAC, Linux clustering, O/S- Linux Red Hat, OMS, OEM (Grid Control), RMAN, and Dataguard, ASM.

Confidential, Danbury, CT

Oracle Database Administrator

Responsibilities:

  • Performing Oracle server configuration.
  • Installing Oracle 10gR2 and Oracle 11gR2 CRS on Linux vm cluster.
  • Configuration and creation of database Oracle 11gR2 (RAC) cluster database on linix vm.
  • Performing Oracle 11gR2 Database Migration from one datacenter to another on linux and UNIX and windows based platform.
  • Creating and monitoring 10gR2 and 11gR2 RAC database.
  • Performing change manages control and implementing operational and dimensional logical and physical design documentation.
  • Configured RMAN for the hot backup on production environment. And Incremental backup for the development environment.
  • Performing schema refresh with export import utility.
  • Performing tablespace space management.
  • Performing hot cloning of with different Instance name of Oracle 11gR2 database.

Environment: Oracle 10g,/11gR2 RAC, Linux clustering, O/S- Linux Red Hat, OMS, OEM (Grid Control), RMAN, and Dataguard, ASM.

Confidential, NJ

Oracle Database Administrator

Responsibilities:

  • Installation and Configuration of Oracle VM Manager on Linux. Creating and managing user for VM Manager.
  • Created and Managing Server Pool on Oracle VM environment with oracle VM Manager.
  • Created Virtual Machine on Oracle Virtual environment manually as well as with Oracle VM Manager with iso file and oracle template.
  • Created Paravirtualized Oracle Virtual Machine with iso file for Installation of Oracle11gR2 Grid Infrastructure.
  • Created and managed iso pool, running pool to create and manage Oracle VM Machine, Manually configuration of vm.cfg files to manage Oracle VM Machine.
  • Installation and Configuration of Oracle Linux (OEL-5) on Oracle Virtual Machine.
  • Installation and Configuration of CRS, ASM and RAC Database on Oracle Virtual machine manually and with use of template.
  • Performed cloning of VM Machine, Created templates from VM Machine, Creating and adding shared disk to Oracle Virtual Machine, Tuning and Monitoring of Oracle VM machine with Oracle VM Manager.
  • RAC Database Upgradation from 10gR2 to 11gR2 on Linux and windows, adding node in to CRS cluster.
  • Dataguard setup and configuration of Primary and Physical standby database on Oracle 11gR2 ( RAC and Single Instance)
  • Reconfiguration of Oracle 10gR2 OCR and create all CRS service manually on windows.
  • Performed Day-to-day Activities database related activities.
  • Archive logging is essential for production databases where the loss of a transaction might be fatal created UNIX script to move Archive log.
  • Performed Defragment a tablespaces when an object's storage parameters are sized improperly.
  • Creating Users and assign roll and privileges.
  • Space Management, User management in production environment.
  • Performed physical standby database setup in oracle 9i.
  • Performed 11gR2 RAC database cloning using hot backup technology for production.
  • Configured RMAN for 11gR2 RAC environment.
  • Supported a large environment running various versions of Oracle.
  • Monitored Alert logs on continuous basis.
  • Working with space management adding new datafiles and managing tablespace, Created new tablespace. Performing defragmentation of tablespace.
  • Rebuild new indexes whenever needed.
  • Working with internal and external customers to develop new value-added programs and data solutions with existing data structure - Act as liaison with customers - Tests designed applications.

Environment: Oracle 10g,/11gR2 RAC, Oracle VM-Ware, Virtual Machine’s Storage, OMS (Oracle Management Server), OEM (Grid Control), RMAN, TKPROF, RAC and Dataguard, ASM. PL/SQL, and SQL *PLUS.

Confidential, MA

Oracle Database Administrator

Responsibilities:

  • Involved in creating DFD (Data flow diagram), Data modeling, Physical and logical database designing.
  • Develop data models and perform planning of architecture, functions, modules, recovery, standards and implementation.
  • Linux Installation Oracle 11gR2 binary installation and then created database.
  • Database replication experience, in addition to backup and recovery implementations either in a standalone or using recovery management tools.
  • Dataguard setup for production environment in oracle11G.
  • CRS, ASM, RAC Installation in oracle 11.2gR2
  • Performed Day-to-day Activities database related activities.
  • Performed Defragment a tablespaces when an object's storage parameters are sized improperly.
  • Creating Users and assign roll and privileges.
  • Managed sql query tuning, SGA performance and tuning with OEM.
  • Created and managed schedule jobs.
  • Installing, Configuring, Checking VERITAS NetBackup for Oracle and its integration with Oracle RMAN Monitored Alert logs on continuous basis.
  • Patching, performance tuning, database maintenance with ADDM.
  • Schema Refresh with export import.
  • Write shell script and created cron job support some database clean up, custom scripts to monitor the health of the database
  • Performance Tuning of database in monitors and assures DASD.
  • Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting to the management.
  • Space management - Creating new tablespace as well as adding space in to the existing tablespace. Performed data transfer using Export.
  • Monitor Oracle Internals (Memory, Dictionary, Optimizer, etc).

Environment: Oracle 10gR2/11gR2 RHEL5, Windows XP, RMAN, TKPROF, RAC and ASM. PL/SQL, and SQL *PLUS.

Confidential, Charlotte, NC

Oracle Database Administrator

Responsibilities:

  • Installed Oracle 10g and Oracle 11g on various development, test and staging servers.
  • Upgraded Oracle from Oracle 10.2.0.2 to 10.2.0.3 and 10.2.0.4. 11.2.
  • Performed Oracle server configuration.
  • Configuration and creation of database on RAC.
  • Performed Database Migration from test to production environment
  • Adding and deleting nodes for development, testing and production.
  • Created and managed the Database objects and schemas.
  • Managed data export import with data pump, Utilize Transport tablespace methodology whenever needed.
  • Handled Database Refresh.
  • Applied RDBMS patches using Opatch.
  • Maintained and involved with troubleshooting of Oracle Real Application Clusters (RAC). Installed RAC on test servers (Linux platform) based on request.
  • Involved in setup Primary and standby database in oracle 10g on Production environment.
  • Created new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
  • Wrote various Shell Scripts to monitor and maintain the Oracle Applications Database.
  • Cloned 10.2 Instances/Implemented Patches against known BUGS. Implemented Maintenance Pack (11.5.9).
  • Worked for Data warehousing methodologies which share a common set of tasks, including business requirements analysis, data design, architecture design, implementation, and deployment.
  • Working with space management adding new datafiles and managing tablespace, Created new tablespace. Performing defragmentation of tablespace.
  • Rebuild new indexes whenever needed.
  • Solved the crucial issue with help of Oracle MetaLink
  • Handled Oracle data migrations.

Environment: Oracle 10g, /11 g RHEL4, Solaris, SAN Storage, OMS (Oracle Management Server), OEM (Grid Control), RMAN, TKPROF, RAC and Dataguard, ASM. PL/SQL, and SQL *PLUS, DB2.

Confidential, Rhode Island

Oracle Database Administrator

Responsibilities:

  • Involved in the installation of Oracle 10g RAC (Real Application Clusters) on a 3 node cluster, configuration of ASM, and Oracle 1og (Test Environment).
  • Performed Migration of My-SQL to Oracle 10g.
  • Up gradation of Oracle databases from Linux from 9i to 10g.
  • Managing BCUdb2 production database.
  • Configure BCU db2 nodes (Test Environment).
  • Created on line as well as off line night backup script for db2 database.
  • Configured and maintained Replication, Grid Control Repository and Deployed OMS Agents on different database servers.
  • Performed data modeling, created DFD diagrams, Entity relationship Diagrams.
  • Performed Build databases, testing, Create schemas, data structures, implementation, maintenance, and control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.
  • Analyzing and translating business requirements into conceptual, logical and physical data models.
  • Performed successfully plan, manage, control and implementing operational and dimensional logical and physical design for Data Marts, Data Warehouse and Business intelligence solutions, deliver projects.
  • Designed the Logical and Physical database and created any necessary database objects.
  • Performed designing and implementing transformation, extraction and load process for Data Warehouse.
  • Configure RMAN to work with netback up for oracle database.
  • Used ETL tool for data warehouse application
  • To create security policies to control database access at the row and column level. Essentially, used Oracle Virtual Private Database adds a dynamic WHERE clause.
  • Involved in Installation of (TDP) Tivoli Storage Manager for Oracle backup solutions.
  • Setup physical standby database with Data Guard to protect mission critical from any failures.
  • Daily database administration tasks including scheduling backup, Verifying night backup and recovery through RMAN as well as using SAN (Storage Area Network) network specifically dedicated to the task of transporting data for storage and retrieval.
  • Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
  • Used TDA (Transparent Data encryption) in database to secure data while moving data from one place to remote safe place.
  • Performed data conversions between DB2 and Oracle.
  • Used SQL*Loader to move data from flat files into an Oracle database.
  • Utilized Oracle Enterprise Manager (OEM) Grid Control, command line to manage administration task like Tablespaces, indexes, sessions, schemas and monitor instance locks, long running queries, listeners, free space, extents growth, etc.
  • Refreshed schema with using of Import/Export.
  • Utilized to create and design ad hoc reports Using Report Builder, select data and design reports how and where the data is stored.
  • Monitor production and non-production database through Grid Control, Optimize queries, startup, shutdown and configure agents to communicate with grid control for various different maintenance tasks.
  • Applied patches or upgrades to the database as needed.
  • Used Logminer to extract information from redo logs.
  • Created number of LINUX shell scripts for various tasks on RHEL 4.
  • Raised iTAR’s in case of problems.
  • Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR and ADDM.
  • Tuned memory structures such as the database buffer cache, shared pool, and library cache.
  • Performed Backup and recovery on Real Application Clusters, backup of OCR and voting Disk.
  • Install Oracle binaries and build databases on new servers, copy files for refreshing databases between environments.
  • Performed to reading and writing complex SQL, pl/sql queries and Crystal Report.
  • Worked closely with application developers and system administrators to ensure all database needs are being met.
  • Worked on BCU, DB2 database.

Environment: Oracle 9i/10g, RHEL4, SAN Storage, OMS (Oracle Management Server), OEM (Grid Control), RMAN, TKPROF, RAC and Dataguard, ASM. PL/SQL, and SQL *PLUS, DB2.

Confidential

Oracle Database Administrator

Responsibilities:

  • Duties included all aspects of Oracle Database administration including oracle installation and upgrade Oracle databases from Tru64 hardware to Sun or IBM AIX hardware to Oracle 9i to 10g,configuration of ASM, to RAC, 11g (Test environment).
  • Performed database design, testing, implementation, maintenance, Create schemas, data structures and Seed data, control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.
  • Setup Primary and physical database for Data guard.
  • Used SQL execution plans and handling administration tasks in a command line environment.
  • Performed designing and implementing transformation, migration, extraction and load process for Data Warehouse.
  • Involved in creating DFD (Data flow diagram), Data modeling, Physical and logical database designing using ERWIN.
  • Created database objects and maintain production environment.
  • Used enterprise-wide client/server development, for application partitioning, which separates parts of the application onto different machines.
  • Patching, performance tuning, database maintenance with ADDM.
  • Applied schema level cluster.
  • Used RMAN to perform HOT database Backup and Recovery.
  • Utilized SAN (Storage Area Network) to transporting data for storage and retrieval.
  • Performed database transfer using SQL *Loader, Import/Export and Datapump.
  • Performed Cloning of the databases from production to test environment and done subsequent refreshing.
  • Utilized Oracle Enterprise Manager (OEM) Grid Control to manage Tablespaces, indexes, sessions, schemas and monitor instance locks, long running queries, listeners, free space, extents growth, etc.
  • Utilized TDA (Transparent Data encryption) key based access control for security and integrity of the databases.
  • Utilized Oracle Optache to the database as needed.
  • Scheduled jobs using and Cron jobs for night backup, verifying night backup.
  • Performed point in time data recovery with RMAN
  • Tuned memory structures such as the database buffer cache, shared pool, library cache
  • Performed data conversions between DB2 and Oracle
  • Install Oracle binaries and build databases on new servers Copy files for refreshing databases between environments.
  • Worked with Data Replication.
  • Provided guidance to developers for writing optimal code for better performance.
  • Performed backup and recovery of Oracle 10g RAC databases and tuned it for optimal performance
  • Written Perl Scripts and shell Script on Linux environment for DBA .
  • User directly or indirectly accesses a table, view, or synonym that is protected with an Oracle Virtual Private Database policy, dynamically modifies the SQL statement of the user used VDP.
  • Performed tuning by various tools like STATSPACK and Tkprof,V$View.
  • Utilized to create and design ad hoc reports Using Report Builder, Crystal Report select data and design reports how and where the data is stored
  • Created pl/sql procedure.
  • Created number of UNIX shell scripts for various tasks on RHEL 4.

Environment: Oracle 10.2.0.3, OEM (Oracle Enterprise Manager) Grid Control, RAC and DataGuard, ASM, SQL *PLUS,PL/SQL, RHEL, RMAN, OEM, Statspack, Tkprof, Shell Scripts, Sharable for replication from online server to reporting server.

Confidential

Oracle Database Administrator

Responsibilities:

  • Provided 24/7 Database support to customers in HP-UX, Windows NT, Oracle 8i, 9i OLTP environment.
  • Performed installation, configuration of Oracle 9i database.
  • Performed Day-to-day Activities database related activities.
  • Involved in creating DFD (Data flow diagram), Data modeling, Physical and logical database designing.
  • Created database schema objects like table, synonyms, sequence, and index.
  • Transfer data from Oracle 8i to Oracle 9i with Export/import.
  • Load Ms- Access database to Oracle 9i Database with Sql*Loader.
  • Performed Backups of databases like Hot Backups, Cold Backups and export/import utilities for schema based backups.
  • Performed recovery activities using Flashback technology on Test environment
  • Coordinated with System administrators for space management on various servers.
  • Managed database objects like Table spaces, Tables, Indexes, Views, and Synonyms etc.
  • Performed Defragment a tablespaces when an object's storage parameters are sized improperly.
  • Managed sql query tuning, SGA performance and tuning with OEM.
  • Created and managed schedule jobs.
  • Configured online and offline Database Backup using RMAN
  • Scheduled backup with shell scripting and verifying backup.
  • Monitored Alert logs on continuous basis.
  • Performed Cloning Activities from Production to test environment and refreshed it periodically.
  • Performed designing and implementing transformation, extraction and load process for Data Warehouse.
  • Used ETL tool for data warehouse application.
  • Created number of UNIX shell scripts for various tasks.
  • Written pl/sql procedure, trigger, created functions.
  • Worked on all customer request related to database.

Environment: Environment: Linux, Oracle 8i/9i, RMAN, PL/SQL, Sql*Loader, STATSPACK, RMAN, Export/Import, OEM, SQL Trace, Explain Plan.

Hire Now