What is a Database Administrator?
A Database Administrator administers databases and/or data management systems that allow for the secure storage, query, protection, and utilization of data.
Professional certifications
Core competencies of Database Administrator
- Vulnerability Management
- Enterprise Architecture
- Information Assurance
- Software Development
- Data Administration
- Network Management
- Forensics Analysis
- Data Management
- Security Policy
- Cryptography
Database Administrator must know:
- computer networking concepts and protocols, and network security methodologies.
- risk management processes (e.g., methods for assessing and mitigating risk).
- laws, regulations, policies, and ethics as they relate to cybersecurity and privacy.
- cybersecurity and privacy principles.
- cyber threats and vulnerabilities.
- specific operational impacts of cybersecurity lapses.
- data administration and data standardization policies.
- data backup and recovery.
- data mining and data warehousing principles.
- database management systems, query languages, table relationships, and views.
- digital rights management.
- enterprise messaging systems and associated software.
- network access, identity, and access management (e.g., public key infrastructure, Oauth, OpenID, SAML, SPML).
- operating systems.
- policy-based and risk adaptive access controls.
- query languages such as SQL (structured query language).
- sources, characteristics, and uses of the organization’s data assets.
- the characteristics of physical and virtual data storage media.
- database access application programming interfaces (e.g., Java Database Connectivity [JDBC]).
- Personally Identifiable Information (PII) data security standards.
- Payment Card Industry (PCI) data security standards.
- Personal Health Information (PHI) data security standards.
- current and emerging data encryption (e.g., Column and
- Tablespace Encryption, file and disk encryption) security features in databases (e.g. built-in cryptographic key management features).
- current and emerging data remediation security features in databases.
- an organization’s information classification program and procedures for information compromise.
- database theory.
Key skills of the Database Administrator include:
- allocating storage capacity in the design of data management systems.
- conducting queries and developing algorithms to analyze data structures.
- generating queries and reports.
- maintaining databases. (i.e., backup, restore, delete data, transaction log files, etc.).
- optimizing database performance.
Database Administratormust be to:
- maintain databases. (i.e., backup, restore, delete data, transaction log files, etc.