International Web Association (IWA)

Profile WSP-G3-006. DB Administrator

This section is normative.

The profile sheet, listed below and described in appendix B, is an integral part of the document, “G3 Web Skills Profiles – version 1.0 – Generation 3 European ICT Professional Profiles”, official specification of 14 February 2013” [WSPG3-03].

Summary definition

Professional position with the duty of carrying out and maintaining the operability of the databases used or managed by the organisation as part of its Web-related activities, managing the processes and accurately and comprehensively documenting those within his or her area of expertise.

Assignment

The DB Administrator defines, plans, and optimises database structures. He or she ensures database security by administering suitable data backup and recovery policies, ensuring high reliability of the databases and implementing monitoring strategies, and improving database services using tuning techniques.

Documentation produced

Accountable

  • Data model
  • Document describing the database architecture
  • Conceptual, logical, and physical planning
  • Database structure
  • Physical planning
  • Existing solution
  • Test procedures
  • Incident management
  • Design and define database models and diagrams
  • Create and optimise database models and diagrams
  • Apply standard methods and tools to measure and report on a broad set of performance indicators (response time, availability, security, integrity)
  • Approve and implement data processing procedures
  • Identify, research, and correct database problems or incidents
  • Provide database training, support, advice, and guidelines for other IT system professionals
  • A.6. Application Design: Level e-3
  • B.1. Design and Development: Levels e-3, e-4
  • B.2. Systems Integration: Levels e-2, e-3
  • C.4. Problem Management: Level e-3
  • D.10. Information and Knowledge Management: Level e-3
  • Be able to administer, configure, and optimise the Database Servers
  • Knowledge of security issues related to database access
  • Knowledge of various DBMS
  • Knowledge of the specific architecture and functions of the database used
  • Knowledge of the query language for the specific database used
  • Knowledge of the stored procedures for the specific database used
  • Knowledge of XML
  • Knowledge of Triple Stores
  • Knowledge of SPARQL
  • Knowledge of RDF
  • Knowledge of XML Databases
  • Knowledge of VLDB
  • Knowledge of UML
  • Knowledge of WS/WSDL
  • Existing database
  • Consistent with the SLA (Service Level Agreement): availability, confidentiality, performance
  • Problem resolution
  • European ICT Professional Profiles “Database Administrator”
  • “CIW (Certified Internet Web Professional) – Database design Specialist” Certification
  • Problem solving
  • Teamwork
  • Spirit of initiative
  • Good knowledge of the national language or the language used by the working group – minimum level: C1 QCER.
  • Good knowledge of the English language – minimum level: B2 QCER

Responsible

Contributor

Primary duties

Assigned e-CF skills

Abilities, knowledge

Technical

Information Technology

For development

Area of application of the KPI

Qualifications and certifications

Personal aptitudes

Interpersonal and Organisational

Linguistic

Relationships and reporting lines

(This section is for informational purposes)

Interacts with

  • Web Server Administrator
  • Knowledge Manager
  • Web Security Expert
  • Online Store Manager
  • User Experience Designer
  • Server Side Web Developer
  • Web Project Manager

Reports to


Appendices

Appendix A. Glossary

 

Informational

For the purposes of information and not required for compliance.

Note: The content required for compliance is referred to as “normative”.

Normative

Required for obtaining compliance.

Note: Content listed as “informational” or “non-normative” is never necessary for compliance.

Appendix B. Profile Sheet Structure

The Web skills profiles are identified by an unambiguous code and are structured in reference to paragraph 4.2 of the official CEN reference document, “European e- Competence Framework version 2.0 – CWA Part II: User guidelines for the application of the European e-Competence Framework 2.0” [CWA-01].

 

  • Profile Title. Name – including the identification code – of the Web skill profile according to the unambiguous international catalogue from the IWA/HWG.
  • Summary definition. Lists the primary purpose of the profile. The purpose is to give all stakeholders and users a brief, concise description of the specified Web skill profile, written in a form understandable by ICT professionals, managers, and Human Resources staff.
  • Assignment. Describes the basic assignment of the profile. The purpose is to specify the working role defined in the Web Skill Profile.
  • Documentation produced. Describes the documents produced by the job description as manager (guarantee), representative (support), and employee (contribution).
  • Primary duties. Provides a list of typical tasks carried out by the profile. A task is an action undertaken to achieve a result in a broadly defined context and contributing to the definition of the profile.
  • Assigned e-CF skills. Provides a list of the skills necessary (taken from the e-CF references) to carry out the assignment. A skill is the outcome of the previous definition of the Profile and helps to differentiate profiles.
  • Abilities, knowledge. A list of abilities and knowledge necessary for the definition of the profile, subdivided into technical, IT, and improving abilities (strengthening the profile).
  • Area of application of the KPI. Based on KPI (Key Performance Indicators), the area of application of the KPI is a more generic indicator, consistent with the grade level of the overall profile. It applies for adding depth to the assignment.
  • Qualifications and certifications. These are the recommended, but not essential, qualifications and certifications for carrying out the activities in the profile. However, these qualifications and certifications may be used for developing knowledge of specific skills within the profile.
  • Personal aptitudes. A list of aptitudes supporting the abilities and knowledge, subdivided into interpersonal/organisational and linguistic. This section reports references to the QCER [CE-01], which promotes the understanding of specific language certifications, purely for informational purposes.
  • Relationships and reporting lines. A list of Web skills profiles and not with whom the profile discusses (relationships) or reports (reporting lines). This section is for informational purposes.
  • [CC-01] Creative Commons – Attribution – No derivative works – 3.0  (CC BY-ND 3.0)
    http://creativecommons.org/licenses/by-nd/3.0/
  • [CWA-01] CEN – European e-Competence Framework version 2.0 – CWA Part II: User guidelines for the application of the European e-Competence Framework 2.0 (September 2010)
    http://www.ecompetences.eu/site/objects/download/5999_EUeCF2.0userguide.pdf
  • [WSPG3-01] IWA – IWA Italy Web Skills Profiles Group

Appendix C. References

http://www.skillprofiles.eu

  • [WSPG3-02] IWA – IWA Italy – International Webmasters Association Italia

http://iwa.it