In a world of constant and fast-changing technology, where everything seems to be at the distance of a click, a drag of a finger or even voice, where clouds came to take over, we have a whole set of tools at our disposal that allow us to quickly imagine and build solutions that ease our daily lives in the most diverse ways.
But there is a question that arises: what is common to all these applications, solutions? The answer is simple: they all manipulate information. And information is data.
“Being a database administrator, known as DBA, is not only to be aware of the daily component of technical management of the infrastructure but also to assist the design and development teams in incorporating and adapting new technologies to new business solutions. It is, in essence, to have a global vision and intervention.”
Data can come from numerous sources and is available in multiple formats ready to be worked on, analyzed, and consumed either for a simple query or, using Business Intelligence techniques, to detect patterns, trends that determine decision making.
Except for some cases of streaming for immediate consumption where it is immediately discarded, Data is made persistent in logical structures better known as databases. These may be the traditional relational database systems such as SQL Server, Oracle, PostgreSQL and MySQL, or in new implementations called NoSQL more common in Cloud environments such as Cassandra, MongoDB, Neo4J, among others.
This is where much of the magic happens when we must think, design, and maintain an entire infrastructure to support our data repositories, namely in terms of reading and writing performance, security, integrity, and data quality.
These are some of the challenges that make the role of a Database Administrator a daily adventure, being able to ensure the systems’ high level of performance taking into account many of the existing constraints, that might be related to hardware, application architectures, data volumes and number of users.
Being a database administrator, known as DBA, of an organization, regardless of the size of its structure and beyond the responsibility for the data that the function requires, is not only to be aware of the daily component of technical management of the infrastructure but also to assist the design and development teams incorporating and adapting new technologies to new business solutions. It is, in essence, to have a global vision and intervention.
Being DBA is a challenge for the future.
What's Your Reaction?
Nuno is a Database Administrator (DBA) at Affinity and has extensive experience, knowledge, and passion for the area. Graduated in electrical engineering, Nuno also enjoys quality time away from computers, doing puzzles or enjoying some outdoor activities!