Oracle DBA

CONSULTANT NAME

(Oracle DBA)

SUMMARY
  • Six plus years of experience in Information Technology as Oracle Database Administrator and knowledge in Systems Analysis and Design, Development and Documentation at various levels.
  • Performed Oracle 8i/9i/10g software and database installation and upgraded various versions.
  • 5.0 + Years of professional experience in different aspects of Oracle Apps Database Administrator/System Administrator of ERP (Oracle Applications 11.5.10.2/9/8) on 8.x/ 9.x production database
  • Experience in administering, tuning and monitoring database using Toad, OEM
  • Designed strategies for performing database backups and recovery
  • Debugging with procedures, Function, Triggers, Packages and other PL/SQL objects
  • Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask
  • 24x7 on-call Production support fordatabase activities.

  • TECHNICAL SKILLS
    Databases: Oracle 8i / 9i / 10g, SQL Server,MS Access
    Operating Systems: UNIX, Windows NT/2000
    Programming Languages: PL/SQL, UNIX Shell Script
    Database Tools: Toad, OEM, DBA Studio
    ETL Tools: SQL Loader, Erwin
    Version Control Tools: Visual Source Safe
    Telnet Tool: Putty, Hummingbird Connectivity (9.0)

    PROFESSIONAL EXPERIENCE
    Client Name From Date - To Date
    Oracle DBA
    Project : Maintenance and support for oracle 7/8i/9i/10g databases.
    Responsibilities:
  • Supporting more than 40 instances.
  • Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
  • Automated hot backups using a combination of incremental, differential and full RMAN backups.
  • Maintaining archive data on appropriate storage devices.
  • Tracing, troubleshooting with database performance and tuning issues.
  • Export/Import of oracle databases.
  • Tuning SQL queries.
  • Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
  • Analyzing and validating database objects.
  • Coordinating with team members.
  • On call support 24x7.
  • Environment: Oracle Server 7.0.3/8i/9i/10g, SQL Server, HP –UNIX, AIX, Sun OS, Clarify, SPIN, Business objects.

    Client Name From Date - To Date
    Oracle DBA
    Project: Maintenance and support for oracle 8i/9i databases.
    Responsibilities:
  • Supporting more than 30 instances.
  • Installing 9i database.
  • Upgraded oracle 9i /10g.
  • Extensively worked on Real Application Cluster (RAC).
  • Creating stand by database.
  • Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
  • Automated hot backups using a combination of incremental, differential and full RMAN backups.
  • Maintaining archive data on appropriate storage devices.
  • Tracing, troubleshooting with database performance and tuning issues.
  • Export/Import of oracle databases.
  • Tuning SQL queries.
  • Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
  • Analyzing and validating database objects.
  • Coordinating with team members.
  • On call support 24x7.
  • Environment: Oracle Server 9i/10g, Sun OS, FLS

    Client Name From Date - To Date
    Oracle DBA
    Project: Brodvision Maintenance and support for oracle 8i/9i databases.
    Responsibilities:
  • Installing 9i database.
  • Upgraded oracle 9i /10g.
  • Creating stand by database.
  • Extensively worked on Real Application Cluster (RAC).
  • Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
  • Automated hot backups using a combination of incremental, differential and full RMAN backups.
  • Maintaining archive data on appropriate storage devices.
  • Tracing, troubleshooting with database performance and tuning issues.
  • Export/Import of oracle databases.
  • Tuning SQL queries.
  • Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
  • Analyzing and validating database objects.
  • Coordinating with team members.
  • On call support 24x7.
  • Environment: Oracle Server 8i / 9i / 10g, Sun OS, Broadvision 7.1

    Client Name From Date - To Date
    Oracle DBA
    Project : Upgrade from oracle 8i to oracle 9i
    Responsibilities:
  • Installing 9i database.
  • Upgraded oracle 8i to 9i.
  • Provided and implement the DR solution.
  • Used Oracle Dataguard tool for creating the standby database.
  • Automated the process of oracle backup.
  • Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
  • Tracing, troubleshooting with database performance and tuning issues.
  • Export/Import of oracle databases.
  • Tuning SQL queries.
  • Maintaining archive data on appropriate storage devices.
  • Analyzing and validating database objects.
  • Coordinating with team members.
  • On call support 24x7.
  • Environment: Oracle 8i/ 9i, Windows 2000 Advanced server

    Client Name From Date - To Date
    Oracle DBA
    Project: Maximo Management System
    Responsibilities:
  • Installing ORACLE 8i Server and application tools.
  • Allocating system storage and planning future storage requirements for the database.
  • Involved in writing stored procedures/functions as per requirements.
  • Maintaining archived data on appropriate storage devices.
  • Controlling and monitoring user access to the database.
  • Database performance and tuning issues.
  • On call support 24x7.
  • Environment: Oracle 8i, SQL, PL/SQL, SQL Loader, Toad, Windows NT Maximo 4.1.

    Client Name From Date - To Date
    Oracle DBA
    Project : Payroll Management System The project involves maintaining the monthly payroll of employees of a company & handles the following functions. Maintaining the employee attendance, recording daily working hours, Calculation for standard deduction & net salary.
    Responsibilities:
  • Study and Analysis of Business requirements
  • Interacted with the Technical Design team and contributed in impact analysis and creation of the Technical specifications.
  • Consistently delivered work assignments within given timeframe, with high quality and zero defect work which was highly appreciated by the client
  • Was involved in database design and implementation.
  • Participated constructively to help and enable team members with their challenges
  • Provided technical assistance to the testing team to understand and setup the testing scenarios and to execute technical intervention test cases.
  • Involved in end-user training and creating user manual document
  • Environment: Oracle 8i, Forms 4.5, Windows NT, HP - UNIX

    EDUCATION
    Degree from Ozmania University - 1996
    CERTIFICATIONS
  • Oracle 9i DBA Track

    PLEASE LEAVE YOUR COMMENTS BELOW

  • Yet to be registered Copyright