{"id":111532,"date":"2026-07-29T12:00:00","date_gmt":"2026-07-29T12:00:00","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=111532"},"modified":"2026-07-14T12:31:24","modified_gmt":"2026-07-14T12:31:24","slug":"what-does-a-modern-dba-actually-do-6-key-points-from-a-senior-dba","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/career\/what-does-a-modern-dba-actually-do-6-key-points-from-a-senior-dba\/","title":{"rendered":"What does a modern DBA actually do? 6 key points from a senior DBA\u00a0"},"content":{"rendered":"\n<p><strong>The DBA role has always been misunderstood. But ask a senior database professional what their week looks like\u202f<\/strong><strong><em>today<\/em><\/strong><strong>, and it becomes clear how much it has evolved over the years. Cloud spend dashboards, AI-generated pull requests, 30-second downtime windows \u2013 these are just some of the new elements that make up the DBA role today.<\/strong>&nbsp;<\/p>\n\n\n\n<p><strong>We sat down with Lee Brownhill, a senior DBA and Redgate Ambassador with 20 years of experience, to get his honest take on where the role is heading \u2013 and what database professionals are actually focused on\u202f<\/strong><strong><em>right now<\/em><\/strong><strong>.<\/strong>&nbsp;<\/p>\n\n\n\n<p><em>This article is part of the <a href=\"https:\/\/www.red-gate.com\/simple-talk\/collections\/how-to-build-a-career-in-data-top-tips-from-those-whove-done-it-complete-series\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to build a career in data<\/a> series on Simple Talk.\u00a0<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-dba-role-of-today-a-brief-introduction\">The DBA role of today: a brief introduction<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.red-gate.com\/blog\/the-database-professional-of-the-future-headlines-from-redgates-keynote-at-pass-data-community-summit-2025\/\" target=\"_blank\" rel=\"noreferrer noopener\">The DBA role is dramatically broader than it was even a few years ago<\/a>. Cloud costs, DevOps, security &amp; compliance, AI oversight, and observability have all been added on top of the traditional core.&nbsp;<\/p>\n\n\n\n<p>Likewise, job titles vary significantly.\u202f<em>\u201cDatabase Reliability Engineer,\u201d \u201cDatabase Engineer,\u201d \u201cPrincipal DBA,\u201d<\/em>\u202fand\u202f<em>\u201cSenior DBA\u201d<\/em>\u202fcan all refer to essentially the same role. Seniority levels aren\u2019t standardized, either, so the title reflects the company \u2013 not necessarily the person\u2019s influence.&nbsp;<\/p>\n\n\n\n<p>So, how do you break through the noise and actually become a DBA, and succeed in the role? What should you be focusing on\u202f<em>right now?<\/em>&nbsp;<\/p>\n\n\n\n<p>Well, the team at\u202f<a href=\"https:\/\/www.red-gate.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Redgate<\/a>\u202frecently sat down with Lee Brownhill (a former guest of the\u202f<a href=\"https:\/\/www.red-gate.com\/simple-talk\/podcasts\/coffee-chat-with-lee-brownhill\/\" target=\"_blank\" rel=\"noreferrer noopener\">Simple Talk podcast<\/a>), to chat about his role as a Senior DBA and get the lowdown on what exactly the role entails today.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-dba-role-today-what-you-should-know-6-key-points\">The DBA role today: what you should know (6 key points)\u00a0<\/h2>\n\n\n\n<p>Here are the 6 key takeaways from the chat \u2013 and some may surprise you!&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-ai-s-had-an-impact-on-stability\">1. AI\u2019s had an impact on stability\u00a0<\/h3>\n\n\n\n<p><a href=\"https:\/\/www.red-gate.com\/products\/sql-prompt\/#ai-powered-code\" target=\"_blank\" rel=\"noreferrer noopener\">AI is enabling developers to generate more code, faster<\/a>. As a result,\u202f<a href=\"https:\/\/www.ibm.com\/think\/topics\/pull-request\" target=\"_blank\" rel=\"noreferrer noopener\">pull requests<\/a>\u202fare getting larger and broader in scope. The DBA often sits at the end of that pipeline as the final human control point \u2013 responsible for reviewing whether changes are safe, secure, and performant at scale.&nbsp;<\/p>\n\n\n\n<p>This can present challenges, with teams distributing review responsibility to \u201cperformance champions\u201d or \u201csecurity champions\u201d within sub-teams. In turn it\u2019s introducing additional risk, as these people often lack the DBA\u2019s depth of context about how <a href=\"https:\/\/www.red-gate.com\/simple-talk\/other\/what-is-sql\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQL<\/a> will behave under volume or in specific parts of the product.\u00a0<\/p>\n\n\n\n<p>As Lee puts it: \u201cHow to handle that (AI) in a proactive and safe manner is getting infinitely more difficult, with the sheer level of change coming into products \u2013 and the rate of change as well.\u201d&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-there-s-also-uncertainty-around-investment-in-ai\">2. There\u2019s also uncertainty around investment in AI\u00a0<\/h3>\n\n\n\n<p>There\u2019s industry&nbsp;pressure to\u202f<a href=\"https:\/\/www.red-gate.com\/solutions\/state-of-database-landscape\/2026\/ai-mini-report\/#adapting:~:text=Learn%20more-,FINDING%202,-AI%20adoption%20has\" target=\"_blank\" rel=\"noreferrer noopener\">adopt AI<\/a>, but the landscape shifts so fast that teams are caught between not wanting to fall behind\u202f<em>and<\/em>\u202fnot wanting to invest in something that doesn\u2019t mature. DBAs are being consulted, yes, but the decisions are typically owned by engineering managers and principal engineers.&nbsp;<\/p>\n\n\n\n<p>There\u2019s also growing\u202f<a href=\"https:\/\/www.ciso.inc\/blog-posts\/why-vendor-fatigue-is-the-silent-threat-to-mid-market-companies\/\" target=\"_blank\" rel=\"noreferrer noopener\">vendor fatigue<\/a>; the many AI pitches promising to \u201csolve all your problems\u201d have made DBAs cynical. Plain, honest messaging cuts through better than hype.&nbsp;<\/p>\n\n\n\n<p>\u201cThe landscape is shifting that much at the moment, it\u2019s hard to know what will stick and what won\u2019t,\u201d Lee says.\u201dI think some clear, non-AI kind of speech and messaging will go a long way.\u201d&nbsp;<\/p>\n\n\n\n<section id=\"my-first-block-block_e5d1c3fa8ddd490f258e640c4555d886\" class=\"my-first-block alignwide\">\n    <div class=\"bg-brand-600 text-base-white py-5xl px-4xl rounded-sm bg-gradient-to-r from-brand-600 to-brand-500 red\">\n        <div class=\"gap-4xl items-start md:items-center flex flex-col md:flex-row justify-between\">\n            <div class=\"flex-1 col-span-10 lg:col-span-7\">\n                <h3 class=\"mt-0 font-display mb-2 text-display-sm\">\u201cEveryone wants to move faster with AI, but few are truly ready for it.&#8221;<\/h3>\n                <div class=\"child:last-of-type:mb-0\">\n                                            What does the AI landscape look like in 2026? Get the full overview in Redgate&#8217;s 2026 State of the Database Landscape AI mini report >>                                    <\/div>\n            <\/div>\n                                            <a href=\"https:\/\/www.red-gate.com\/solutions\/state-of-database-landscape\/2026\/ai-mini-report\/\" class=\"btn btn--secondary btn--lg\" aria-label=\"Download the AI mini report: \u201cEveryone wants to move faster with AI, but few are truly ready for it.&quot;\">Download the AI mini report<\/a>\n                    <\/div>\n    <\/div>\n<\/section>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-cost-optimization-is-a-core-part-of-a-dba-s-day-to-day\">3. Cost optimization is a core part of a DBA\u2019s day-to-day\u00a0<\/h3>\n\n\n\n<p>Cost optimization has become a core part of the DBA\u2019s day-to-day \u2013 especially around the\u202f<a href=\"https:\/\/www.red-gate.com\/blog\/from-your-data-center-to-the-cloud\/#:~:text=The%20big%20lie%20%2D%20cost%20saving%20in%20the%20cloud\" target=\"_blank\" rel=\"noreferrer noopener\">cost of cloud adoption<\/a>\u202f\u2013 with lots of time spent in financial dashboards.&nbsp;<\/p>\n\n\n\n<p>The common pattern Lee outlined? Businesses scale\u202f<a href=\"https:\/\/azure.microsoft.com\/en-gb\" target=\"_blank\" rel=\"noreferrer noopener\">Azure<\/a>\u202fresources by bumping up a performance slider whenever volumes spike, until costs become unsustainable.&nbsp;<\/p>\n\n\n\n<p>So, tools that help surface right-sizing opportunities, idle resources, and evidence-based cost decisions, are highly valued now. In fact, they\u2019re no longer just a \u2018nice-to-have\u2019 \u2013 they are\u202f<em>top of mind<\/em> for today\u2019s DBA.\u00a0<\/p>\n\n\n\n<p>\u201cPretty much every engineering team I work with now\u2026 everybody almost has a cost initiative task to do, because cloud resources are not getting any cheaper,<em>\u201c<\/em>\u202fLee says.&nbsp;<\/p>\n\n\n\n<p>\u201cIt\u2019s never been more important to optimize your costs. I spend\u202f<em>so\u202f<\/em>much time in financial dashboards looking at cloud costs, looking at peaks and troughs in database usage.\u201d&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-4-dbas-are-now-key-security-and-compliance-stakeholders\">4. DBAs are now key security and compliance stakeholders\u00a0<\/h3>\n\n\n\n<p>In\u202f<a href=\"https:\/\/www.red-gate.com\/blog\/inside-perspectives-the-growing-importance-of-security-and-compliance\/#:~:text=The%20regulatory%20landscape\" target=\"_blank\" rel=\"noreferrer noopener\">regulated industries<\/a>, DBAs are being pulled increasingly into auditing and\u202f<a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/database-administration-sql-server\/sql-server-access-control-basics\/\" target=\"_blank\" rel=\"noreferrer noopener\">access control<\/a>\u202fdiscussions.\u202f<a href=\"https:\/\/www.red-gate.com\/simple-talk\/data-security-privacy-compliance\/\" target=\"_blank\" rel=\"noreferrer noopener\">Security<\/a>\u202fconstraints also directly limit AI adoption as anything that sends data\u202f<em>outside\u202f<\/em>the company\u2019s own tenant is a no-go.\u00a0<\/p>\n\n\n\n<p>Beyond AI, DBAs themselves are more deeply involved in security and audit conversations now.\u202f\u201cDBAs are getting increasingly pulled into auditing and access control situations and conversations,\u201d Lee points out.&nbsp;<\/p>\n\n\n\n<p>\u201cThat\u2019s where a lot of my time is being spent as well. They want a database professional who\u2019s there to give a level of authority from the data level in those questions.\u201d\u202f\u202f&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-5-devops-amp-automation-is-the-rule-not-the-exception\">5. DevOps &amp; automation is the rule \u2013 not the exception\u00a0<\/h3>\n\n\n\n<p>The shift from manual DBA work to fully code-driven\u202f<a href=\"https:\/\/www.red-gate.com\/simple-talk\/devops\/ci-cd\/why-every-project-needs-a-ci-cd-pipeline-no-matter-how-small\/\" target=\"_blank\" rel=\"noreferrer noopener\">CI\/CD pipelines<\/a>\u202fis stark. In Lee\u2019s previous role, he says, it was common to work with manual scripts \u2013 but now, everything is repository-based. DBAs who resist this shift, or don\u2019t have the <a href=\"https:\/\/www.red-gate.com\/blog\/devops-101-what-who-why-and-how\/\" target=\"_blank\" rel=\"noreferrer noopener\">DevOps<\/a> skills needed, are simply left behind.\u00a0<\/p>\n\n\n\n<p>As such, Lee \u2013 like many DBAs \u2013 is actively upskilling in database deployment automation. This includes using tools unfamiliar to him like\u202f<a href=\"https:\/\/www.red-gate.com\/products\/flyway\/\" target=\"_blank\" rel=\"noreferrer noopener\">Redgate Flyway<\/a>, and broader <a href=\"https:\/\/www.red-gate.com\/simple-talk\/cloud\/azure\/\" target=\"_blank\" rel=\"noreferrer noopener\">Azure<\/a> tooling. He acknowledged some DBAs find this uncomfortable, but sees it as unavoidable. It\u2019s just what you have to do to keep up as a DBA today.\u00a0<\/p>\n\n\n\n<p>It\u2019s also a good mindset to have in general. Personal development and learning new skills \u2013 especially the\u202f<a href=\"https:\/\/www.red-gate.com\/simple-talk\/opinion\/career\/from-anthropology-to-analytics-how-to-build-a-data-career-with-no-prior-experience-10-tips-from-a-microsoft-mvp\/#:~:text=4.%20Learn%20the%20tools%20that%20actually%20solve%20your%20problems%20%E2%80%93%20not%20the%20ones%20that%20sound%20impressive\" target=\"_blank\" rel=\"noreferrer noopener\">ones helpful to the role you\u2019re currently doing, or the role you want<\/a>\u202f\u2013 is more necessity than choice if you want to succeed.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-6-observability-amp-high-availability-have-never-been-more-important\">6. Observability &amp; high availability have never been more important\u00a0<\/h3>\n\n\n\n<p><a href=\"https:\/\/www.red-gate.com\/simple-talk\/opinion\/editorials\/why-a-monitoring-tool-is-an-essential-tool-for-growing-server-estates\/\" target=\"_blank\" rel=\"noreferrer noopener\">Real-time visibility into what\u2019s happening in the database<\/a> is now essential, with periods of downtime increasingly becoming unacceptable. \u00a0<\/p>\n\n\n\n<p>Knowing the \u2018hot points\u2019 of a database \u2013 the areas already under stress \u2013 is something experienced DBAs carry in their heads, and something AI-generated code changes often fail to account for.&nbsp;<\/p>\n\n\n\n<p>\u201cThe expectancy now for always available, always there \u2013 it\u2019s just a given,\u201d Lee says. \u201cYou can\u2019t have services unavailable for 30 seconds. It\u2019s just not a thing anymore.&nbsp;<\/p>\n\n\n\n<p>\u201cKnowing what is happening in your database in real time has never been more important\u2026 when you\u2019re fighting a performance problem, you need to see what\u2019s in flight right there, what it\u2019s affecting.\u201d\u202f\u202f&nbsp;<\/p>\n\n\n\n<section id=\"my-first-block-block_89c1b7ff88910d97636416530ea32f8c\" class=\"my-first-block alignwide\">\n    <div class=\"bg-brand-600 text-base-white py-5xl px-4xl rounded-sm bg-gradient-to-r from-brand-600 to-brand-500 red\">\n        <div class=\"gap-4xl items-start md:items-center flex flex-col md:flex-row justify-between\">\n            <div class=\"flex-1 col-span-10 lg:col-span-7\">\n                <h3 class=\"mt-0 font-display mb-2 text-display-sm\">Future-proof database monitoring with Redgate Monitor<\/h3>\n                <div class=\"child:last-of-type:mb-0\">\n                                            Multi-platform database observability for your entire estate. Optimize performance, ensure security, and mitigate potential risks with fast deep-dive analysis, intelligent alerting, and AI-powered insights.                                    <\/div>\n            <\/div>\n                                            <a href=\"https:\/\/www.red-gate.com\/products\/redgate-monitor\/\" class=\"btn btn--secondary btn--lg\" aria-label=\"Learn more &amp; try for free: Future-proof database monitoring with Redgate Monitor\">Learn more &amp; try for free<\/a>\n                    <\/div>\n    <\/div>\n<\/section>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-summary-the-dba-role-of-today-is-a-different-proposition-to-what-it-once-was\">Summary: the DBA role of today is a different proposition to what it once was\u00a0<\/h2>\n\n\n\n<p>\u201cI can\u2019t believe how narrow this role used to be\u201d, Lee says. \u201cI actually really enjoy dipping my hands into all these different technologies now \u2014 because I have to.\u201d&nbsp;<\/p>\n\n\n\n<p>\u201cWhen I first started as a DBA, it was more about: do our backups run nicely, and have we got maintenance running every night? Whereas now I spend so much time in financial dashboards, really looking at cloud costs, looking at peaks and troughs in terms of database usage.\u201d\u202f\u202f&nbsp;<\/p>\n\n\n\n<p>\u201cI\u2019m having to learn a lot more in the DevOps space than I\u2019ve had to before:\u202fcode\u2011driven\u202fpipelines\u2026new monitoring tools. And, interpreting logs from an observability point of\u202fview, to\u202fbuild up a picture of what happened last night at two in the morning.\u201d\u202f\u202f&nbsp;<\/p>\n\n\n\n<p><strong>What are your thoughts? Are you a DBA? Have any tips and advice you\u2019d like to share? Feel free to leave a comment below!<\/strong>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The DBA role has changed. Senior DBA Lee Brownhill shares 6 honest insights on what database professionals are focused on today &#8211; AI, cloud costs, DevOps, and more.&hellip;<\/p>\n","protected":false},"author":59127,"featured_media":103120,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[45105,143527,143516,143523,143512,53],"tags":[4362,4168,4170,4659,159406,4150],"coauthors":[7590],"class_list":["post-111532","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-career","category-database-administration-sql-server","category-database-devops","category-databases","category-devops","category-featured","tag-career","tag-database","tag-database-administration","tag-dba","tag-how-to-build-a-career-in-data","tag-sql"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/111532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/59127"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=111532"}],"version-history":[{"count":3,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/111532\/revisions"}],"predecessor-version":[{"id":111540,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/111532\/revisions\/111540"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/103120"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=111532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=111532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=111532"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=111532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}