• Follow us


Us and them: The DBA – developer conflict

Us (us, us, us, us) and them (them, them, them, them)And after all we're only ordinary men- Wright/Waters

“Us and Them”, as many will know, is a powerful song by the rock group Pink Floyd about conflict.  And, like it or not, conflict is a factor that runs through our lives, albeit limited (we trust) by good manners and the rule of law.  Similarly, in the business world, conflict is perennial and ceaseless:  sales v marketing; CFO (saving money) v COO (spending it); and, in the IT world, Database Administrator (DBA) (wants stability) v Developer (needs change).

I always enjoy the good natured banter at conferences between DBAs and developers.  A recent event was a good case in point.  Database administrators (DBAs) were portrayed acting like Gandalf and proclaiming to developers who tried to break “the rules” for application deployment, “You shall not pass!” There followed righteous indignation on social media – developers accusing DBAs of being boring and DBAs citing a catalogue of headaches that developers have caused them. 

Development functions have certain targets – responsiveness to business change, speed of development, quality of code.  However, their testing might not, for example, examine performance in a production environment. The DBAs might feel aggrieved that they have to pick up the pieces in tweaking the infrastructure to ensure the changes work at scale and in production.

Changing Fashions in TechnologyThe general sat/And the lines on the mapMoved from side to side- Wright/Waters

Development fashions have changed over the years, as technology has delivered faster and cheaper storage and processing power.  In the 60s and early 70s, the limits of computer technology meant that business applications tended to be created as monolithic chunks of code, integrated from top to bottom to perform a prescribed business function. Then database products such as IMS, DB2 and Oracle came along and separated the important functions of storing and accessing the vital business data, and the role of the DBA was born.  In the 90s, improving technology enabled the creation of a middleware layer to take over the inconvenient matter of brokering access between applications and data – and the thin end of the wedge was first driven between application developer and DBA. Company boards (the ”generals”) took very little part in this, provided that IT delivered the right business function without blowing the budget too badly, and they merely watched the lines moving from side to side as these technology fashions changed. 

In the last five years the rise of digital transformation has seen open source databases, especially NoSQL and Hadoop, become more attractive to developers allowing them to create database instances without the need to comply with the rules of structured relational databases.  This evolution has led to a proliferation of structured and unstructured data within organisations that needs to be managed; as such sprawl is often a cause of vulnerabilities and reliability issues it has helped to widen the chasm between developer and DBA.  For developers, open source gives them more choices that are easily downloadable without the hassle of complex purchasing processes.  Combined with DevOps this gives them the ability to move much more quickly to understand and respond to evolving customer and market demands.  DBAs, on the other hand, must integrate this data from diverse sources to optimise the deployment for performance and availability.  Yet, their more measured approach can sometimes lead to frustration among developers, who definitely feel DBAs are not moving at DevOps-speed!

Thankfully in the last two years we have seen the relationship shift again. Developers are beginning to realise that the relational data model isn’t so bad after all, as it imposes order for better interrogation of data and improved data accuracy.  When applications need to respond in real-time to meet the demands of customers online being able to query data in a structured way has clear advantages.  At the same time DBAs are beginning to embrace the DevOps/agile mindset.  They recognise the importance to the business of being able to move quickly to deploy applications.  They are starting to understand the pros and cons of new features and functions and whether and how they’ll scale and fit into a production environment.

The Need for TogethernessMe And you (you, you, you)God only knowsIt's not what we would choose (choose, choose) to do (to do, to do)- Wright/Waters 

An IT function is much more effective when DBAs and Developers choose to work together.

Developers should increasingly think about how changes will work in a production environment, for example with hundreds of thousands of users or transactions, rather than simply a test environment with dozens; they should consider data modelling much more closely. 

DBAs need to understand new features and functions as they come along and how they’ll fit into the infrastructure that it is their job to maintain.  Within this understanding there needs to be acceptance of a more agile, DevOps style implementation and management of databases - something that cloud database services go a long way to address.

And the CIO has a role to play here, in ensuring that the IT platform that underpins the business function has benefits for both developers and DBAs.  Postgres is a good example of such a platform – its extensibility enables it to work with a variety of programming environments and this appeals to a wider range of developers; and its architecture is less complex than the big databases, thus making the DBA’s life easier. 

Resolving the ConflictOut of the way, It's a busy dayI've got things on my mind- Wright/Waters

Developers and DBAs alike are busy people; by working together more closely, they can implement IT change more effectively, thus making both their lives easier, but both sides need to be aware of some key considerations.  For example, application developers must test meaningful data sets before they move into production environments and they should evaluate what application function would better fit into the database for overall system performance and reliability.  Above all, they should talk to the DBA about the database structure and how to build meaningful SQL, rather than just using the nearest handy development framework. 

However, it is not just the application developer’s responsibility to ensure the relationship works.  Database administrators must remember that it’s the application function that runs the business and be prepared to understand how new functionality fits within the business.  They should also be open to working with developers; rather than claiming lack of time, they should buy into the buzz of new things, such as DevOps and work out how the infrastructure can support these innovations.  DBAs can take steps to help developers with tuning queries that fit into the production environment.

Ultimately, co-operation, rather than conflict, must be the key. DBAs and developers must choose to work together more closely; and if they have access to a technology platform which facilitates this co-operation, then meaningful business function can go live that much more quickly and effectively.

 Jan Karremans, Senior Sales Engineer, EnterpriseDBImage Credit: Moon Light PhotoStudio / Shutterstock

Read More

Leave A Comment

More News

Latest ITProPortal news

The best antivirus software of 2019 2019-04-04 10:40:31Software choices to keep your computer safe

Huawei laptop software may have had backdoors 2019-04-04 07:30:00Security experts warn against Matebook management software.

Data breaches more common than rainy days in 2019-04-04 07:00:33Employees are still naive when it comes to cybersecurity.

Facebook app data exposed by third-party developers 2019-04-04 07:00:07Thousands of passwords were sitting on the open web for anyone who knew where to look.

Why business owners need to speak digital to 2019-04-04 06:30:20Many businesses are struggling to keep up with the digital era, the businesses that don’t will eventually shut down.

Industry 4.0 facing major security risks 2019-04-04 06:00:54From USB-borne malware to corrupted CAD files, there's a lot the manufacturing industry needs to care about.

Can AI solve the Brexit problem? 2019-04-04 06:00:54Nobody can solve the problem that is Brexit, but could AI?

Us and them: The DBA – developer conflict 2019-04-04 06:00:00In the past DBAs and developers have not always got on. So why is it changing now?

Energy efficiency: the foundation to building sustainable cities 2019-04-04 05:30:46Reducing energy consumption in the places where most people live and work needs to be top priority.

How tech accelerator programmes are creating the next 2019-04-04 05:00:18Modern business have adapted. The typical ‘9am-5pm’ working day isn’t as common as it once was.

Shining a light on shadow IT with unified 2019-04-04 04:30:43Is your business ignoring the root cause of shadow IT?

Can artificial intelligence replace humans in the fight 2019-04-04 04:00:36AI is becoming less constrained by the limits of human knowledge.

TechRadar: Internet news

Universal Pictures’ movie library will soon get upgraded 2019-04-04 15:19:20Universal Pictures Home Entertainment has joined the group of studios making HDR10+ content for Samsung and Panasonic TVs.

Industry 4.0 suffering major security issues 2019-04-04 14:31:48New research from Trend Micro has shed light on the security risks Industry 4.0 poses to the manufacturing sector.

The first 5G phone: our hands-on with the 2019-04-04 14:10:44Verizon and Motorola launched the world's first 5G phone, and we have one in-hand. Here's what we think of it so far.

Huawei fixes MateBook software following backdoor threat 2019-04-04 13:44:59Huawei has patched a security flaw in its MateBook laptops after it was discovered by Microsoft in January.

Fitbit price cut at Amazon: save $60 on 2019-04-04 13:37:12Amazon has slashed the price of the popular Fitbit Alta activity tracker to $69.

Windows 10 churned out rogue notifications that looked 2019-04-04 12:28:10A Microsoft staffer has dropped a clanger with a major testing (and spelling) fail.

LG TV lineup 2019: every LG TV model 2019-04-04 11:49:33This is the LG TV 2019 lineup – with ThinQ smart TVs, voice assistants, rollable OLEDs, and more AI than you can shake a stick at.

Apple Music finally comes to Amazon speakers in 2019-04-04 11:35:08The service arrived on Amazon speakers in the US at the end of last year.

The best Fitbit Inspire and Inspire HR bands 2019-04-04 11:05:40There are lots of bands available for the Inspire and Inspire HR. These are some of our favorites.

Nintendo Switch finally gets controller with a headphone 2019-04-04 10:27:08The officially licensed controller allows you to customize faceplates and programmable paddles.

The best Huawei P10 deals in April 2019 2019-04-04 09:55:15See all of the best Huawei P10 deals in the UK right now. A cheap Huawei phone to save you some money.

The best free Android apps of 2019 2019-04-04 09:46:24There are way too many free apps out there, so we've trawled through and found the top free ones to download.

TechCrunch » Enterprise

WeWork acquires Managed By Q 2019-04-03 13:24:26Managed By Q, the office management platform based out of New York, has today been acquired by The We Company, formerly known as WeWork. Financial ter

Google Drive adds workflow integrations with DocuSign, K2 2019-04-03 12:31:34Google today announced a few new workflow integrations for its Drive file storage service that’ll bring to the service support for some features

Torch takes $10M to teach empathy to executives 2019-04-03 10:11:53When everyone always tells you “yes,” you can become a monster. Leaders especially need honest feedback to grow. “If you look at ric

Rippling raises $45M at $270M to be the 2019-04-03 09:18:02Parker Conrad’s last startup, Zenefits, drowned in busy work. Now with Rippling, he wants to boil that ocean. Instead of trying to nail one thin

Okta unveils $50M in-house venture capital fund 2019-04-03 09:00:49Okta Ventures wants to fund the next generation of identity, security and privacy startups.

Enterprise blockchain startup Offchain Labs scores $3.7M seed 2019-04-03 09:00:30Two of the issues limiting blockchain adoption in the enterprise has been lack of scalability and privacy. Offchain Labs, a startup that spun out of r

Onfido, which verifies IDs using AI, nabs $50M 2019-04-03 08:10:31Security breaches, where malicious hackers obtain snippets of information that then get used to impersonate individuals in order to gain access to ind

Container security startup Aqua lands $62M Series C 2019-04-03 06:20:27Aqua Security, a startup that helps customers launch containers securely, announced a $62 million Series C investment today led by Insight Partners. E

How to handle dark data compliance risk at 2019-04-02 15:00:51Slack and other consumer-grade productivity tools have been taking off in workplaces large and small — and data governance hasn’t caught u

Densify announces new tool to optimize container management 2019-04-02 11:52:47Densify, a Toronto company that helps customers optimize their cloud resources to control usage and spending, announced a new tool today specifically

FireHydrant lands $1.5M seed investment to bring order 2019-04-02 10:00:46FireHydrant, an NYC startup, wants to help companies recover from IT disasters more quickly, and understand why they happened — with the goal of

Pixeom raises $15M for its software-defined edge computing 2019-04-02 09:30:19Pixeom, a startup that offers a software-defined edge computing platform to enterprises, today announced that it has raised a $15 million funding roun

Disclaimer and Notice:WorldProNews.com is not responsible of these news or any information published on this website.