Preview

Data base administrator

Satisfactory Essays
Open Document
Open Document
529 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data base administrator
JOB DESCRIPTION:
JOB TITLE: DB2 DBA
LOCATION: xxxxx
SUMMARY:
This position is responsible for the performance, integrity and security of a database. Additional role requirements are likely to include planning, development and troubleshooting. DBA roles are generally identified by the databases, the processes they administer and the capabilities of the database management system (DBMS) in use.
REQUIRED KNOWELEDGE, SKILLS AND EXPERIENCE:
(1) A good knowledge of the operating system(s)
(2) A good knowledge of physical database design
(3) Ability to perform both DB2 and also operating system performance monitoring and the necessary adjustments.
(4) Be able to provide a strategic database direction for the organisation.
(5) Excellent knowledge of Oracle backup and recovery scenarios.
(6) Good skills in all DB2 tools.
(7) A good knowledge of DB2 security management.
(8) A good knowledge of how DB2 acquires and manages resources.
(9) Sound knowledge of the applications at your site.
(10) Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle.
(11) A good knowledge of the way DB2 enforces data integrity.
(12) A sound knowledge of both database and program code performance tuning.
(13) A DBA should possess a sound understanding of the business.
(14) A DBA should have sound communication skills with management, development teams,vendors,systems administrators and other related service providers

DB2 DBA RESPONSIBILITIES:
(1) Creates and maintains all databases required for development, testing, education and production usage.
(2) Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the DB2 Databases.
(3) Performs ongoing tuning of the database instances.
(4) Install new versions of the DB2 RDBMS and its tools and

You May Also Find These Documents Helpful

  • Satisfactory Essays

    I think this relates to database development in a number of ways. One is how it starts, gathering information and finding the intent of the system. Next you must plan out how to set up the database, which is the vital information? What are the minor details? Then you set up your database fill in some test information insure it works properly and make needed adjustments. Finally you implement your database design where in it works properly you merely maintain and fix any errors.…

    • 317 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Nt1330 Unit 1 Study Guide

    • 1178 Words
    • 5 Pages

    They are the responsible to manage the DBMS’s use and also creating, modifying and maintaining the database. Which to ensure the database is functioning properly.…

    • 1178 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Nt1310 Unit 1 Assignment

    • 533 Words
    • 3 Pages

    Art.1. The Database Management allows you to update the database password and quota, monitor the storage usage of your database, backup and restore your databases, and provides an example of a connection string name.…

    • 533 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Pm3110 Unit 1 Paper

    • 529 Words
    • 3 Pages

    • Data Administrator – control the access permissions and privileges, install the new DBMS, data available in consistent form, provide scope for data recovery and data security…

    • 529 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Dbm 381 Week 1paper

    • 885 Words
    • 4 Pages

    A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…

    • 885 Words
    • 4 Pages
    Good Essays
  • Good Essays

    * Excellent communication skills in transferring key company information seamlessly from senior management to peers, while providing exceptional customer service.…

    • 385 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Best Essays

    Database Administrator

    • 3175 Words
    • 13 Pages

    Abby states “that if you know who you are and you 're true to yourself, you will be more confident and assertive in your work environment.” We need to understand who we are as a person then we can be able to truly reach for success.…

    • 3175 Words
    • 13 Pages
    Best Essays
  • Better Essays

    The database administrator's job was to oversee any and all database-oriented tasks. This included database design and implementation, installation, upgrade, SQL analysis and advice for application developers.. The DBA was also responsible for back-up and recovery, which required many complex utility programs that run in a specified order. This was a time-consuming energy draining task. (Fosdick 1995) Databases are currently in the process of integration.…

    • 1186 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Ibm Db2 vs Oracle

    • 1231 Words
    • 5 Pages

    A decision between DB2 and Oracle should be based on what resources are available for use at the site. Is there specific hardware or software already onsite that can or will be used in the installation, if so this will have a major impact on the decision making process. Does the staff have an existing knowledge base that favors one or the other DBMS and is there a team that has unallocated time to dedicate to this project or will another project be put on hold to allow them to make this project their focus until completion. Finally, have the costs of ongoing maintenance for fixed and soft assets been considered? All of the above will impact the decision making processes prior to purchasing one of the DBMS 's. These factors aside, either DBMS will run as fast as the other provided that the environment has been optimized for it (Lim, 2002).…

    • 1231 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    In this assignment i will be explaining the term ‘Transferable skills’ and giving examples of where they would be relevant in the workplace.…

    • 583 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    DB2 10 for z/OS Database Administration: Certification Study Guide by Susan Lawson and Daniel Luksetich…

    • 490 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Many database development efforts begin by defining the key business and/or operational processes within the organization…

    • 969 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Database Paper

    • 440 Words
    • 2 Pages

    DB2 Express features are Time Travel Query, integrated tools environment, Graph Store Technology, SQL Compatibility Feature, and IBM Mobile Database sync and support. Its limitations are only 2 processor cores and 4GB of memory. [5]…

    • 440 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Works with programmers and other individuals to create computer code for an application. Make entirely new software, or produce an update for existing work…

    • 595 Words
    • 3 Pages
    Satisfactory Essays