Oracle Cloud Infrastructure
Coming soon ...
Apps R12.2
  • R12.2 Architecture
  • Cloning Error (RC-50208)
  • Apps R12.1
  • Major changes from 11i
  • R12:HTTP Debug Logging
  • Compile Apps Schema invalid objects in R12
  • Apps 11i
  • Apps Components and Architecture
  • Concurrent managers
  • Patching
  • Using AD Patch
  • Using AD Control
  • FNDCPASS utility
  • Single-node Installation
  • Multi-node Installation
  • Find Apps Version
  • Cloning
  • Upgrade 11.5.9 to 11.5.10.2
  • Upgrade from 11.5.10.2 to R12
  • Upgrading 9i to 10g with 11i
  • 11i/R12 General Topics
  • AppsDBA System Management Utilities Guide
  • Identifying Long Idle Sessions
  • Identifying High Active Sessions
  • Change hostname for EBS
  • Oracle 12c Database
  • Oracle12c PSU Apply
  • Oracle12c Datafile moved Online
  • Oracle 11g Database
  • Upgrade 10g to 11g R1
  • Upgrade 11.2.0.2 to 11.2.0.3
  • Database 9i-10g
  • Top 99 Responsibilities of a DBA
  • General Info
  • Database Patching
  • 10g:ASM
  • 10g:Data Pump
  • 10g:Data Guard Installing
  • 10g:Rollback Monitoring
  • 10g:Flashback Table
  • Tablespace Management
  • Materialized Views
  • 10g:Enterprise Manager
  • 10g:Upgrade
  • Error:Ora-01631
  • DBA Scripts
  • Disk I/O,Events,Waits
  • Tablespace Information
  • Session Statistics
  • Hit/Miss Ratios
  • User Information
  • Rollback Segments
  • Full Table Scans
  • Contention/Locking
  • Redo Log Buffer
  • Data Dictionary Info
  • Oracle10g Application Server
  • Oracle10g Application Installation
  • (Re)Securing OAS Control
  • Oracle AS10g null protocol issue
  • Oracle Backup & Recovery
  • RMAN
  • RMAN Setup
  • Backup Recovery
  • Flash Recovery Area
  • Oracle10g Discoverer with Apps
    Coming soon ..............
    Troubleshooting
  • Discoverer Troubleshooting
  • Access EBS in mozile
  • Linux and Unix Platforms
  • How To configure NFS
  • Unix/Linux Command
  • Change hostname in Linux
  • SENDMAIL configuration
  • This Oracle Application DBA Portal is the biggest knowledge gateway for the people in the world of Oracle...
    Friday, April 3, 2009
    Top 99 Responsibilities of a DBA
    Database Architecture Duties

    1. Planning for the database's future storage requirements
    2. Defining database availability and fault management architecture
    3. Defining and creating environments for development and new release installation
    4. Creating physical database storage structures after developers have designed an application
    5. Constructing the database
    6. Determining and setting the size and physical locations of datafiles
    7. Evaluating new hardware and software purchase
    8. Researching, testing, and recommending tools for Oracle development, modeling, database administration, and backup and recovery implementation, as well as planning for the future
    9. Providing database design and implementation
    10. Understanding and employing the optimal flexible architecture to ease administration, allow flexibility in managing I/O, and to increase the capability to scale the system
    11. Working with application developers to determine and define proper partitioning

    Backup and Recovery

    12. Determining and implementing the backup/recovery plan for each database while in development and as the application moves through test and onto production
    13. Establishing and maintaining sound backup and recovery policies and procedures
    14. Having knowledge and practice of Oracle backup and recovery scenarios
    15. Performing Oracle cold backups when the database is shut down to ensure consistency of the data
    16. Performing Oracle hot backups while the database is operational
    17. Performing Oracle import/export as a method of recovering data or individual objects
    18. Providing retention of data to satisfy legal responsibilities of the company
    19. Restoring database services for disaster recovery
    20. Recovering the database in the event of a hardware or software failure
    21. Using partitioning and transportable tablespaces to reduce downtime, when appropriate

    Maintenance and Daily Tasks

    22. Providing adjustment and configuration management of INIT.ORA
    23. Adjusting extent size of rapidly growing tables and indexes
    24. Administering database-management software and related utilities
    25. Automating database startup and shutdown
    26. Automating repetitive operations
    27. Determining and setting critical thresholds for disk, tablespaces, extents, and fragmentation
    28. Enrolling new users while maintaining system security
    29. Filtering database alarm and alert information
    30. Installing, configuring, and upgrading Oracle server software and related products installation
    31. Logging Technical Action Reports (TARs); applying patches
    32. Maintaining the "Database Administrator's Handbook"
    33. Maintaining an ongoing configuration for database links to other databases
    34. Maintaining archived Oracle data
    35. Managing contractual agreements with providers of database-management software
    36. Managing service level agreements with Oracle consultants or vendors
    37. Monitoring and advising management on licensing issues while ensuring compliance with Oracle license agreements
    38. Monitoring and coordinating the update of the database recovery plan with the site's disaster recovery plan
    39. Monitoring and optimizing the performance of the database
    40. Monitoring rollback segment and temporary tablespace use
    41. Monitoring the status of database instances
    42. Performing housekeeping tasks as required; purging old files from the Oracle database
    43. Performing database troubleshooting
    44. Performing modifications of the database structure from information provided by application developers
    45. Performing monthly and annual performance reports for trend analysis and capacity planning
    46. Installing new and maintaining existing client configurations
    47. Performing ongoing configuration management
    48. Performing ongoing Oracle security management
    49. Performing routine audits of user and developer accounts
    50. Performing translation of developer modeled designs for managing data into physical implementation
    51. Performing correlation of database errors, alerts, and events
    52. Planning and coordinating the testing of the new database, software, and application releases
    53. Providing a focal point on calls to Oracle for technical support
    54. Working as part of a team and providing 24x7 support when required

    Methodology and Business Process

    55. Coordinating and executing database upgrades
    56. Coordinating upgrades of system software products to resolve any Oracle/operating system issues/conflicts
    57. Creating error and alert processes and procedures
    58. Creating standard entry formats for SQLNet files
    59. Creating processes and procedures for functional and stress testing of database applications
    60. Creating processes and procedures of application transport from DEV, to TEST, to PROD
    61. Defining and maintaining database standards for the organization to ensure consistency in database creation
    62. Defining database standards and procedures to cover the instance parameters, object sizing, storage, and naming. The procedures define the process for install/upgrade, corporate database requirements, security, backup/recovery, applications environment, source code control, change control, naming conventions, and table/index creation.
    63. Defining the database service levels necessary for application availability
    64. Defining methodology tasks for database software integration
    65. Defining a methodology for developing and improving business applications
    66. Creating a process to determine whether a new release is "stable" enough to be placed on the development system
    67. Developing data-conversion processes for customization, testing, and production
    68. Developing database test plans
    69. Developing database administration procedures and responsibilities for production systems
    70. Developing production migration procedures
    71. Establishing and providing schema definitions, as well as tablespace, table, constraint, trigger, package, procedure, and index naming conventions
    72. Facilitating design sessions for requirements gathering and defining system requirements
    73. Providing database problem reporting, management, and resolution
    74. Providing final approval for all technical architecture components that manage and exchange data, including database management software, serve hardware, data distribution management software, server hardware, data distribution management software, transaction processing monitors, and connecting client applications software
    75. Providing processes for the setup of new database environments
    76. Providing risk and impact analysis of maintenance or new releases of code
    77. Providing standards and methods for database software purchasing
    78. Providing standards and naming conventions
    79. Handling multiple projects and deadlines

    Education and Training

    80. Attending training classes and user group conferences
    81. Evaluating Oracle features and Oracle-related products
    82. Understanding the Oracle database, related utilities, and tools
    83. Understanding the underlying operating system as well as the design of the physical database
    84. Understanding Oracle data integrity
    85. Knowing the organization's applications and how they map to the business requirements
    86. Knowing how Oracle acquires and manages resources
    87. Knowing enough about the Oracle tool's normal functional behavior to be able to determine whether a problem lies with the tool or the database
    88. Processing sound knowledge in database and system performance tuning
    89. Providing in-house technical consulting and training
    90. Staying abreast of the most current release of Oracle software and compatibility issues
    91. Subscribing to database trade journals and web sources

    Communication

    92. Interfacing with vendors
    93. Disseminating Oracle information to the developers, users, and staff
    94. Training application developers to understand and use Oracle concepts, techniques, and tools that model and access managed data
    95. Assisting developers with database design issues and problem resolutions, including how to run and understand the output from both TKProf and the Explain Plan utilities
    96. Training interim DBAs and junior-level DBAs

    Documentation

    97. Creating and maintaining a database operations handbook for frequently performed tasks
    98. Defining standards for database documentation
    99. Creating documentation of the database environment

    Labels:

    posted by Srinivasan .R @ 1:53 AM  
    5 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Srinivasan .R
    Home: Chennai, India

    About Me:
    I am working as an Oracle Applications DBA specializing in EBS 11i/R12 with Over 14+ years of experience, mainly in different versions of Oracle Database & Application administration on various platforms like HP-UX, SOLARIS, AIX, Red hat Linux & Windows
    See my complete profile
    High Availability
  • Oracle10g RAC Installation
  • A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
  • Implementing Oracle 10g RAC with ASM on AIX
  • Locked objects for whole RAC
  • Monitor Memory RAC
  • Sessions RAC
  • Install Oracle 11g RAC On Linux
  • Migrating Oracle10g DB to ASM
  • Helpful Links
  • Good Metalink Notes
  • Discoverer:Metalink Notes
  • Logs Scripts:Metalink Notes
  • Support:Metalink Notes
  • Previous Post
  • A Quick Reference for Oracle Database 10g RAC on L...
  • Implementing Oracle 10g RAC with ASM on AIX
  • DBA
  • Archives
    Download Software
  • Oracle 11g
  • Oracle 10g
  • 10g Express Edition
  • Oracle 9i
  • Oracle Apps
  • Oracle Linux
  • Oracle VM
  • App Server
  • Solaris
  • Fedora
  • Fedora
  • OpenSUSE
  • Ubuntu
  • Advertisement Links
    INTUIT Technology

    MACHS DATA

    Add Ons
    Locations of visitors to this page

    Add to Google Reader or Homepage

    Template by
    Sreene



    Oracle Application DBA Portal