Mid-Level Database Administrator (DBA) Job Description Template

-

Monitor and ensure database availability and performance: Continuously oversee database operations, watching metrics like usage, transaction throughput, response times, and concurrency. Promptly address incidents (e.g. slow queries, outages) and perform tuning or indexing to keep systems running efficiently

.

-

Implement backups and recovery plans: Develop, execute, and regularly test backup strategies (full/incremental backups, transaction log backups) and disaster recovery plans to prevent data loss

. This includes scheduling backups, verifying backup integrity, and planning for high-availability features (replication, failover) so that critical data can be restored quickly after an incident.

-

Manage database security and access: Configure user accounts, roles, and permissions to enforce the principle of least privilege. Implement security policies (authentication, authorization, encryption) and monitor for any unauthorized access or anomalies

. Ensure compliance with

any relevant data governance or privacy requirements by setting up audit logs and security frameworks

-

Support database design and changes: Work with software engineers and analysts when new databases or changes are needed. This involves designing and normalizing schemas for new applications or features, adding tables/columns or indexes appropriately, and implementing data integrity constraints (primary/foreign keys, validations) to maintain reliable, accurate data The DBA reviews SQL queries or schema changes for efficiency and correctness before deployment.

-

Perform routine maintenance and optimization: Conduct regular -housekeeping- tasks such as updating database software patches, rebuilding indexes, updating statistics, and cleaning up old or fragmented data to improve performance

. Optimize configuration parameters (memory allocation, connection limits, etc.) to best utilize server resources

. Set up automated jobs/scripts for these repetitive maintenance tasks to reduce manual effort and errors

.

-

Set up monitoring and alerting systems: Use monitoring tools or scripts to keep track of database health. Configure alerts/triggers for conditions like high load, slow queries, low storage space, or failed backups so that the DBA is notified of potential issues proactively

. Regularly conduct health checks and audits to ensure everything is compliant and performing as expected

.

-

Troubleshoot and resolve database issues: Act as the point person for diagnosing database problems - whether it-s a query error, a locking/deadlock issue, data corruption, or connectivity failure. The DBA uses logs, execution plans, and systematic testing to find root causes and applies fixes or workarounds in a timely manner, minimizing downtime. They also document incidents and solutions for future reference.

-

Collaborate and communicate with stakeholders: Interface with developers, QA, product managers, and non-technical staff regarding data needs and issues. For example, assist developers in writing efficient SQL or using the database correctly, provide data exports or reports to business teams, and clearly communicate about upcoming maintenance or incidents. (This is observable in how the DBA writes announcements or explains technical issues to a lay audience.)

These responsibilities are concrete and observable through the DBA-s regular work outputs, such as monitoring dashboards, backup logs, change tickets, and performance reports. Each duty contributes to the smooth, secure operation of databases in the SMB-s IT environment

(Technical competencies required for the role) -Proficiency in SQL and Database Querying: Ability to write and troubleshoot complex SQL queries (including multi-table JOINs, subqueries, aggregate functions) and understanding of query execution plans for performance tuning . Should be fluent in using SQL to manipulate and query data across common SMB databases (MySQL, PostgreSQL, MS SQL Server). -Database Performance Tuning: Experience with indexing strategies, query optimization, and identifying bottlenecks. Knows how to use indexes, partitions, and other techniques to speed up data retrieval and ensure efficient database performance -Backup and Recovery Expertise: Hands-on knowledge of backup types (full, incremental, differential) and tools, as well as restore procedures and point-in-time recovery. Has implemented disaster recovery plans and can perform database restores under pressure -Database Security and Privacy: Familiarity with database security best practices-managing user accounts/roles, password policies, encryption (at rest and in transit), and understanding regulatory implications of data (e.g. handling personal or financial data responsibly)

. Should be able to safeguard data against unauthorized access or breaches. -Multi-DBMS and OS Experience: Comfortable working with common database management systems on both Linux and Windows environments. For example, can administer MySQL/MariaDB or PostgreSQL on Linux servers, and Microsoft SQL Server on Windows. Understands basic OS commands, networking, and storage as they relate to database performance (I/O, memory, CPU). -Scripting and Automation: Ability to write scripts (Shell, Python, PowerShell, or SQL scripts) to automate routine tasks like backups, monitoring, data loading, etc. This includes using cron jobs or Windows Task Scheduler and possibly infrastructure-as-code or CI/CD tools for database deployments. -Troubleshooting and Problem Solving: Strong analytical skills to diagnose issues such as query deadlocks, data inconsistencies, or connectivity errors. Familiar with using logs, error messages, and systematic testing to pinpoint problems and resolve them . -Tools and Technology Stack Knowledge: Proficient with DBA tools like MySQL Workbench, pgAdmin, SQL Server Management Studio (SSMS), or general clients (DBeaver, DataGrip). Familiar with monitoring tools

(e.g. Grafana/Prometheus, CloudWatch, New Relic) to track DB performance, and version control systems (Git) for managing SQL scripts or database code.

(Interpersonal and cognitive skills critical for success) -Communication Skills: Excellent written and verbal communication to explain technical information in clear terms . This includes writing user-friendly documentation and effectively communicating with non-technical managers or end-users (e.g. explaining the cause of a downtime in plain language) as well as with technical teams (developers, IT peers) for coordinated work. -Analytical & Problem-Solving Mindset: A logical approach to breaking down complex problems. The DBA must be able to analyze issues (e.g. a sudden slowdown or a data inconsistency) and methodically identify causes and solutions, rather than just patching symptoms

. They should enjoy puzzle-solving and digging into data to find root causes. -Attention to Detail: Diligence in following procedures and checking work. Small mistakes in a database (like a misplaced comma in a script or a mis-set permission) can have large consequences, so the DBA must be detail-oriented. This is evident in tasks like reviewing scripts before execution, verifying backup logs daily, and maintaining accurate documentation. -Organization & Time Management: Skill at juggling multiple tasks and priorities - for instance, handling routine maintenance while also responding to an urgent issue. A mid-level DBA in an SMB often manages a ticket queue of requests (new user setups, query optimizations, etc.), so they need to prioritize effectively and meet deadlines. Good at documenting changes and keeping track of schedules (backup times, maintenance windows). -Teamwork & Collaboration: Ability to work closely with cross-functional teams. The DBA should be approachable and willing to collaborate, whether it-s helping a developer optimize a query or coordinating with the IT support team during an incident. Good listening skills and a service-oriented attitude go a long way in meeting user needs and resolving conflicts. -Adaptability: Flexibility to adjust to changing business needs or technologies

. In an SMB, new priorities can emerge quickly (e.g. integrating a new SaaS application-s database or migrating to a cloud service). The DBA must handle shifting requirements and learn new tools or methods on the fly, maintaining a positive attitude toward change. -Business Awareness: (Nice-to-have) Understanding the business context of the data. Knowing which data is most critical to the company (sales, customer info, etc.) helps the DBA prioritize protection and performance for those areas. It also involves awareness of how downtime or slow queries affect operations, enabling better decision-making (like scheduling maintenance in off-hours and communicating effectively with stakeholders) .

Hiring-for-Attitude Traits: (Cultural and attitude-based qualities to ensure a good long-term fit) -Continuous Learning & Curiosity: A genuine interest in keeping up-to-date with the latest database technologies, versions, and best practices 29 . The ideal candidate proactively learns (through blogs, courses, community forums) and enjoys experimenting in safe environments, demonstrating a growth mindset. -Ownership & Accountability: Takes responsibility for the databases entrusted to them. This means owning up to mistakes (e.g. if a configuration error caused an issue) and focusing on how to fix and prevent them, rather than deflecting blame. A candidate with this attitude will proactively put monitoring in place and address issues before they escalate, showing reliability. -Proactivity and Initiative: Doesn-t just wait for problems to occur - actively seeks improvements. For example, a proactive DBA will notice a performance trend and tune indexes before it becomes a major issue, or suggest archiving old data to improve performance. In interviews, look for examples of the candidate going above and beyond their basic duties to improve systems or processes. -Customer-Service Orientation: Treats internal clients (developers, staff) with respect and aims to help solve their data problems. An attitude of -How can I help you?- rather than -That-s not my job.- This trait is crucial in a small business where the DBA serves many roles - being approachable and solution-oriented builds trust. -Calm Under Pressure: Databases are high-stakes - if production is down, the DBA is in the hot seat. A strong candidate remains calm and methodical during emergencies, following runbooks and best practices rather than panicking. They should have a temperament that handles on-call incidents or urgent issues with focus and composure. -Integrity and Ethical Judgment: Since the DBA has access to sensitive information, they must demonstrate honesty and respect for confidentiality. Look for an attitude of adhering to policies (e.g. not abusing access privileges, following compliance requirements) and doing the right thing even when not supervised. -Flexibility in Work Hours/Tasks: Willingness to occasionally work outside 9-5 when emergencies or maintenance windows require (common in IT roles), and to handle tasks that might be outside the strict DBA scope if needed (common in SMB IT teams). A can-do attitude about pitching in where needed (within reason) is a plus in a small company environment.