Before we begin let’s take a moment to remember the poor soul who accidentally deleted the production database on their first day. While it was junior who deleted the database, it’s the seniors in charge of database credentials and onboarding who are ultimately responsible. But the data technology landscape increasingly resembles a maze and even the most experienced of us find it tricky to navigate it successfully.
Even seasoned database administrators can find themselves feeling overwhelmed by the volume of tasks at their fingertips - The DBA Survivor, P160
Database roles, especially those such as the DBA, have always straddled the hardware/software line like few others working in tech. It used to be that our companies were Oracle, Microsoft SQL Server, or MySQL shops. Everything us database people did (be we DBAs, SysAdmins, or Database Developers), we did on the same platform. This meant it was easy to learn the platform, and therefore our specific database roles, extremely well. These days we’re dealing with all of the above plus Mongo, Redis, possibly Hadoop, and a mix of on-premise and cloud-hosted databases. It can get messy to say the least.
Alongside this, we’re still required to juggle a slew of tasks ranging from database development, networking and security, and admin. The rise of platforms has also seen data become fragmented across and within third party apps, meaning migration to in-house databases can be an almost continuous task. Introduce fast-moving technology cycles and a rapid move to cloud infrastructure and an already-complex environment becomes more complicated. Throw in continuous delivery and DevOps culture and picking your way through the maze becomes a job in itself.
How do you navigate it all?
A schema for success
As the saying goes, evolve or become extinct. In the database world this increasingly means a combination of:
- Having a set of go-to tools that actually streamline your work process (not ‘busy work’ tools)
- Spotting and keeping up to date with new technologies, skills, and trends
- Making new ways of doing things work to your advantage
Combine the three and you’ve got a schema for long-term success.
1. Tools of the trade
Tools can’t replace skills. Deep knowledge of backup and recovery methods and procedures will serve you much better than an army of backup and recovery tools. But knowing which tools enhance your skills in a range of environments means you can efficiently complete any number of tasks and easily overcome problems.
Nowadays many database platforms ship with integrated tools for managing a database. MySQL Workbench and SQL Server Management Studio (SSMS), for example. For simply running and managing data within a database, including a nice UI and ability to execute SQL, these tools are great. But it’s no longer wise, or efficient, to rely simply on these tools. There are just too many external demands for them to manage.
It makes sense for you to have a working knowledge of different types of tools that you can call on in certain scenarios. This is not a list of specific products for you to use because all platforms and databases are different. It’s more of a high-level overview of tools you can and should be using now and in the future.
Data modeling tools are vital for designing large-scale databases (e.g. ERwin and ER-Studio)
Performance monitoring and alerting tools
Scripting tools (e.g. Powershell)
Various APIs you can use to your advantage
Advanced query tuning tools
Source code and change management tools (e.g. Sqitch)
Backup and compression tools (many)
Migration and conversion tools like SQLizer
2. Tech trends
A current example is how the DBA role might continue to change as the sheer amount of data that’s generated and needs to be managed continues to grow. Some things to think about for this specific example might include:
- Mining the data we manage to gain insight from it
- Knowing how to manage unstructured data
- Gaining experience and knowledge with big data platforms
- The need for highly analytical, technical minds with skills with analytical tools
- Ability to consolidate data from a range of sources into various databases
3. Embracing change
In any organization or role it’s the people who don’t embrace change that lose their value. “The DBA is dead!” is an exaggeration that’s been called out time and again in the past decade as an ode to the DBA losing value. The most recent call has been from the widespread adoption of DevOps culture. But DevOps can work to our advantage as DBAs, especially if we embrace it.
SQL Soldier does a wonderful job of breaking down how DevOps has actually freed up DBA time:
- No longer need to deploy code (everyone deploys their own with continuous deployment)
- Can now spend time fine-tuning queries
- Can now analyze and correct database architecture decisions
- Help developers make good server decisions for works in progress
Thanks to DevOps, SQL Soldier reckons, DBA time has been freed up to work on things with a bigger impact and which the DBA should be spending the most time doing anyway. All because of embracing change.
Bringing it all together
A combination of monitoring and being aware of trends to enable consistent skill-development, embracing change when it comes and moulding it to our role goals, and knowing a set of tools that can strengthen your skills inevitably leads to a route through the database technology maze.
SQLizer helps DBAs around the world consolidate their fragmented data into MySQL or SQL Server. Upload a JSON, CSV, or Excel file and we’ll convert it to SQL complete with INSERT statements and TABLE definitions ready to import to your database. Use our API to further automate the process and stay ahead of the curve.
More from The Official SQLizer blog...
- Convert a CSV file to SQL in 2021 with SQLizer.io The most recently-updated version of SQLizer converting CSV to SQL. Convert your own CSV file to SQL now, for free. Video: SQLizer is free for...
- SQLizer Python library now available on Pypi Use this library to convert CSV, JSON, Excel or XML files to SQL databases within your python projects. It’s finally here! One of our most-requested...
- SQLizer adds support for custom delimiters SQLizer v3.0.5 has been released and here’s the headlines: Custom delimiters! We’ve moved tab delimiters into the new csv/tsv category, so you’ll now have the...
- Multiple API keys in your SQLizer developer account The SQLizer file to database conversion API is a powerful technology for harnessing the power of our file conversion engine in your own software. It’s...