Senior Database Administrator
Business Connexion (Pty) Ltd
Centurion, ZA
4d ago

Job Description

To provide guidance to junior database administrators and play a pro-active role in achieving of a stable and secure production database environment which performs in alignment with predefined standards and is recoverable in case of hardware failure or disaster situations

  • CPU utilization
  • Memory utilization
  • Database alerts / warnings
  • Software
  • Disk space utilization
  • Database Up Time
  • To assess the current status of the database and keep track of the changes in workload and performance.

    Monitoring the CPU utilization, Memory, Disk utilization, etc.

    Check all database log files

  • Alert Log files
  • Listener Log files
  • Backup log files
  • Trace Log files
  • Database log files need to be checked on a daily basis to ensure that no errors have been logged during the day or at night.

    E.g. Backup log file to ensure that the database backup completed successfully or if it failed.

    Fault escalation : Snr DBA or Vendor

    The DBA can identify complicated faults that require senior expertise while monitoring the databases. Such faults must be escalated to the Senior DBA or vendor for further investigation or assistance.

    The responsibility for resolving such faults still remains with the DBA.

    Software Upgrades

    The DBA is responsible for the installation of Database / Related software.

    The additional installation of software patches and fixes for The database. The installation of latest version of the Database software.

    The software must be investigated, tested and impact analysis has been done before implementation.

    Database documentation

    To provide accurate documentation of the database, system and processes.

    The processes such as how to create users, recover a database, creating tablespace, creating and implementing a backup procedure must be documented.

    Account, Role and Profile management

    The creating, maintaining, and deleting of users, roles and profiles.

  • System audits
  • To ensure that all policies and procedures are adhered to when creating users, database objects, database files (permissions), etc.

    To ensure that the database is setup according to the standards and policies applicable to the Database Environment.

    Task Automation

    To simplify the work of the database administration by creating scripts to assist them to automate jobs. E.g. backups, etc.

  • Software
  • Documenting the database’s configuration and keeping it current.

    The documentation should include the hardware and software configuration including system and disk space layout.

    System maintenance and administration

    The regular task performed by the database administrator on a day-to-day basis or by a request for service.

    Tasks such as creating tables, indexes, tablespaces, creating users, configuring profiles, writing scripts, compiling procedures, completing database checklist and assisting the users with request for service calls.

    Monitoring licenses

    Keeping the proper license information per database, per server and maintaining that information on regular basis.

    To ensure that all copies of licenses are kept and renewed with the relevant vendors when required as agreed by the client.

    Change control

    To ensure that change control procedures are followed when major changes are taking place in the Database Environment, such as upgrading or installing patches.

    Trouble shooting and problem resolution

    The identifying and solving of problems that may arise, by means of investigating and analysis of problem (referring to manuals, supports sites, etc.)

    Database Performance Tuning

    The DBA provides assistance with the database performance tuning.

    To optimize the performance on the database by prioritizing certain jobs and processes accordingly.

    To provide the client with relevant performance statistics by using tools.

    To fully utilize the potential of the CPU and memory on the servers.

    To allocate data across disks accordingly by making use of stripes sets, etc.

    Capacity Planning

    The DBA provides assistance with the capacity planning.

    To be able to forecast growth in data and to be able to provide information to the client that will allow the client to plan for the future.

    System configuration and implementation of all services

  • Software
  • Installing and customization of services and products when required, either during projects or for new projects for both hardware and software.

    Problem Reporting

    To provide accurate reports on all problems that occurs on databases.

    Impact Analysis

    To analyze any new changes to the database environment and to be able to analyze the impact the changes will have on the environment.

    System investigation, evaluation and innovation

    Evaluate new software on the market that will benefit the client and to improve on services offer

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form