The Database administrator (DBA) or database administrators for example perform administration and engineering tasks for multiple databases and is responsible for complex multi-platform distributed database environments.
He has extensive knowledge of platforms such as UNIX / Linux, experience in network architecture, configuration and administration, data modeling, administration of servers in large-scale and geographically diverse environments, creation of automation tools to manage relational databases (auditing, account management, 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 role of consultant, assisting and advising the team and group of clients, 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 the use of big data technology (example: Redshift, S3, Hive, Hbase, Spark, EMR, etc.)
- Experience in database monitoring, maintenance, resource management, schema management, planning, and database performance optimization.
- Ability to work with multiple internal teams such as servers, storage, backup, and network management teams to coordinate and troubleshoot infrastructure related issues.
- Ability to support after hours 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 the networks.
Has an understanding of fundamental computing concepts such as system calls, memory management and program debugging, storage array networking, and disk configuration.
Example of requirements for a Database Administrator
A specialist in Database requires strong interpersonal and organizational skills, including the ability to meet deadlines.
During the performance of their tasks, a Database administrator can:
- Design, implement and support a platform that provides ad-hoc access to large data sets.
- Define backup and restore 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 the Database Engines.
- Design, install and configure the infrastructure on which a credit card payment service works.
- Design and implement services in public clouds