When faced with smaller organisations where Database Administration is undertaken by an IT ‘generalist’, Infrastructure or Development team, we sometimes get asked “why do I need a DBA?”.
To summarise, a DBA’s job is to ensure data to the application tier is performant, secure and recoverable. A Database Administrator’s job is never done, and the bigger companies get and the more they rely on data and applications, the more critical the role of the DBA becomes.
A competent DBA, on a day to day basis, will typically perform the following tasks:
• Troubleshoot – typically calls from 2nd/3rd line, infrastructure and development teams, a DBA should be available immediately to ensure the problem doesn’t get any worse and, of course, resolve the reported issue
• Storage and Capacity Planning – A database’s primary purpose is to store and retrieve data. Therefore a good DBA should be able to monitor storage and CPU usage, track trends and ensure enough compute will always be available to meet service levels
• Data Security – Ensure security patches are applied and understand the implications these have to the application and infrastructure. A DBA should have fundamental understanding of Data Security, however this is sometimes a specialist field requiring specific knowledge
• Performance Tuning and Monitoring – Bottlenecks, slow processes and database usage stats; a good DBA will ensure the ongoing configuration of the environment. Good processes need to be in place in terms of OLAs/SLAs as to what baseline performance is expected from the database
• Backup and Recovery – DBAs will periodically test the backup for the databases they manage. Whilst a System Admin or Infrastructure guy may backup from a server perspective, the DBA needs to be able to recover at file level.
• Process / Procedure Adherence – being stuck between the Application and Infrastructure guys, Change Management and other applicable processes are essential for a DBA. A competent DBA will ensure none of the above tasks will have impact the overall service the IT as a team is providing. Changes to the Database must be documented and in line/agreement with the Infrastructure and Application teams.
These are just a few tasks and responsibilities of a competent DBA. Unfortunately, competent DBA’s are a rare breed. And the good ones often get bored to go contracting.
At dsp we offer a DBA Managed Service to resolve the headache of hiring a team of DBA’s. The service can plug in and adapt to an organisation’s team, reporting to either a Development or Infrastructure head. Whilst organisations may want to increase their headcount and want to exploit the “benefits” of hiring internally, when costs and service value is weighed up, it’s hard to see why our service wouldn’t be considered!
For more information or to schedule a demo please contact usContact us
DSP firmly established itself as one of the UK’s fastest growing proactive Database MSPs during 2016, signing £2.1m of new contracts and making its second acquisition, the Oracle DBA support division of IT Services provider ITSB.Read more
A main goal... how to future proof your applications environment through Oracle while becoming more efficient in terms of costs and productivity.
As well as the option of developing the fundamental steps you need to take to get ...Read more
In the age of big data, public cloud, private cloud it’s easy to be pushed into constantly thinking about the future... What should you optimise though and how can you be sure it’ll make a difference? Would knowing it could give you a competitive edge be worth considering?Read more