Database Administrator

?? compatible
Investigative, Realistic, Enterprising
A Database Administrator is a highly qualified professional responsible for the performance, integrity and security of a database. They are also responsible for developing and implementing database strategies, systems and standards to ensure data integrity and quality.

The Database Administrator (DBA) or the database administrators for example performs administration and engineering tasks for multiple databases and is responsible for complex distributed database environments across multiple platforms.

Has extensive knowledge of platforms such as UNIX / Linux, experience in architecture, network configuration and administration, data modeling, server administration in large-scale and geographically diverse environments, creation of automation tools to manage relational databases (auditing, account administration, schema implementation).

The Database Administrator is able to quickly solve complex technical problems under pressure, implements scalable solutions, handles multiple client groups and has excellent interpersonal communication skills.

A Database Administrator has experience in the consultant role, assisting and advising the team and client group, with a profile defined by:

  • Good organizational skills.
  • Strong analytical thinking and excellent problem solving.
  • Must possess excellent oral and written communication skills and the ability to clearly define projects, objectives, goals, schedules and tasks.
  • Experience in one or more languages such as: Python, Perl, Bash.
  • Experience in data management and data storage.
  • Solid Knowledge in public clouds (AWS preferably).
  • Experience in using big data technology (example: Redshift, S3, Hive, Hbase, Spark, EMR, etc.)
  • Experience in database monitoring, maintenance, resource management, schema management, planning and performance optimization of databases.
  • Ability to work with various internal teams, such as servers, storage, backup and network administration teams to coordinate and troubleshoot infrastructure-related problems.
  • Ability to provide after-hours support as needed and be part of the on-call rotation.

Some of the responsibilities of a Database Administrator:

The Database Administrator can work on a variety of development and maintenance projects in coordination with project and support teams, has knowledge of all supporting infrastructure components, including operating systems, hardware/storage configurations and networks.

Has an understanding of fundamental computing concepts such as system calls, memory management and program debugging, storage array network configuration and disk configuration.

Example of requirements for a Database Administrator

A Database specialist requires strong interpersonal and organizational skills, including the ability to meet deadlines.

During the performance of their duties a Database Administrator can:

  • Design, implement and support a platform that provides ad-hoc access to large data sets.
  • Define the backup and restoration procedures for stored data.
  • Monitor the performance of an application. Carry out data backup and recovery procedures.
  • Monitor performance and respond to changes in requirements.
  • Provide technical support for technologies such as: MySQL, PostgreSQL and Oracle.
  • Implement data structures using best practices in data modeling, SQL, Redshift.
  • Install, configure and monitor Database Engines.
  • Design, install and configure the infrastructure on which a credit card payment service runs.
  • Design and implement services in public clouds
Database Administrator: what do they do?
Test programs or databases, fix errors and make necessary modifications. 79%
Modify existing databases and database management systems or direct programmers and analysts to make changes. 77%
Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. 75%
Work as part of a project team to coordinate database development and determine the scope and limitations of the project. 74%
Write and code logical and physical database descriptions and specify database identifiers to the management system or direct others in coding descriptions. 69%
Train users and answer their questions. 67%
Specify users and user access levels for each database segment. 65%
Approve, schedule, plan and oversee the installation and testing of new products and improvements to computer systems, such as the installation of new databases. 64%
Review project requests describing database user needs to estimate the time and cost required to carry out the project. 60%
Develop standards and guidelines to guide the use and acquisition of software and protect vulnerable information. 59%