Job description template

Database Administrator Job Description

Recruit skilled Database Administrators with this job description template. Covers database management, performance tuning, backup strategies.

The role in brief

A Database Administrator (DBA) is responsible for the design, implementation, maintenance, and security of an organization database systems, ensuring data availability, integrity, and performance. They manage both relational and NoSQL database platforms, handle backup and recovery procedures, optimize query performance, and enforce access controls that protect sensitive data. The role requires deep expertise in database internals, strong problem-solving skills for diagnosing performance bottlenecks, and the ability to plan for capacity growth. DBAs are essential to any data-driven organization, as the reliability and performance of database systems directly underpin application functionality and business operations.

Install, configure, and maintain database management systems including PostgreSQL, MySQL, Oracle, SQL Server, and MongoDB in production environments
Design and implement backup, recovery, and disaster recovery procedures ensuring RPO and RTO targets are consistently met
Monitor database performance using profiling tools and optimize queries, indexes, and configurations to maintain sub-second response times
Manage database security including user access controls, encryption at rest and in transit, and audit logging for compliance requirements

Turn this into an assessment →Read the full article ↓

Paste the description into Cohesyve and it generates a Database Administrator assessment with a scoring rubric. Ten candidates free, no card.

Responsibilities

Install, configure, and maintain database management systems including PostgreSQL, MySQL, Oracle, SQL Server, and MongoDB in production environments
Design and implement backup, recovery, and disaster recovery procedures ensuring RPO and RTO targets are consistently met
Monitor database performance using profiling tools and optimize queries, indexes, and configurations to maintain sub-second response times
Manage database security including user access controls, encryption at rest and in transit, and audit logging for compliance requirements
Plan and execute database upgrades, patches, and migrations with minimal downtime using rolling updates and blue-green deployment strategies
Design database schemas and data models in collaboration with development teams, advising on normalization, indexing, and partitioning strategies
Implement and manage high-availability configurations including replication, clustering, and failover mechanisms
Perform capacity planning and storage management to accommodate data growth while controlling infrastructure costs

Required skills

Administration of relational databases including PostgreSQL, MySQL, Oracle, or SQL ServerAdvanced SQL including query optimization, execution plan analysis, indexing strategies, and stored procedure developmentBackup and recovery procedures including point-in-time recovery, incremental backups, and disaster recovery testingDatabase performance tuning including memory configuration, I/O optimization, and connection pool managementHigh availability and replication technologies including streaming replication, clustering, and failover automationDatabase security including role-based access control, encryption, auditing, and compliance with data protection regulationsMonitoring and alerting using tools like pganalyze, Percona Monitoring and Management, or Oracle Enterprise ManagerCloud database services including Amazon RDS, Azure SQL Database, Google Cloud SQL, or managed NoSQL offerings

Cohesyve

Test these skills before the Database Administrator interviews

Cohesyve reads the description above and generates a role-specific assessment with a scoring rubric. Each candidate gets a different version, so questions cannot be shared.

Try it free →Book a 30-min demo

Nice to have

Experience with NoSQL databases such as MongoDB, Cassandra, or DynamoDB for specialized workloadsDatabase certifications such as Oracle OCP, Microsoft MCSA, or AWS Database SpecialtyScripting skills in Python, Bash, or PowerShell for automating database administration tasksKnowledge of database DevOps practices including schema migration tools like Flyway or LiquibaseExperience with data warehousing platforms and analytical database optimization

Qualifications

1Bachelor's degree in Computer Science, Information Technology, or a related field
23-5 years of experience in database administration with hands-on production management of at least one major RDBMS
3Proven experience managing databases with hundreds of gigabytes or terabytes of data in high-availability environments
4Strong understanding of database internals including storage engines, transaction isolation levels, and concurrency control
5Excellent documentation habits and the ability to create runbooks for operational procedures

Compensation and environment

Salary range

$95,000 - $145,000 per year, with senior DBAs earning $140,000 - $185,000. Specialized DBAs managing large Oracle or mission-critical financial systems can earn $180,000 - $220,000 or more.

Work environment

Hybrid or remote with on-call responsibilities for database-related production incidents. The work balances proactive maintenance and optimization with reactive troubleshooting. DBAs collaborate closely with development teams and other infrastructure engineers, with peak activity during migrations and capacity expansion projects.

Career growth

Database Administrators advance to Senior DBA, Lead DBA, Database Architect, or Director of Database Engineering. Many also transition into Data Engineering, Cloud Architecture, or Infrastructure Management roles. Specialization in emerging database technologies or large-scale distributed systems opens additional career paths.

Common questions

Is the DBA role becoming obsolete with managed cloud databases?

Managed database services like Amazon RDS and Azure SQL Database automate many routine tasks such as patching and backups, but they do not eliminate the need for database expertise. DBAs remain essential for schema design, query optimization, capacity planning, security configuration, and troubleshooting complex performance issues. The role is evolving from hands-on server management toward database architecture and optimization.

What is the difference between a DBA and a Data Engineer?

DBAs focus on the operational health, performance, and security of database systems, ensuring they are reliable and available. Data Engineers focus on building data pipelines, transforming data, and creating analytical datasets. While there is overlap in SQL skills and data modeling, DBAs are more operations-focused while Data Engineers are more development-focused.

Should DBAs learn NoSQL databases?

Yes. While relational databases remain dominant for transactional workloads, many applications use NoSQL databases for specific use cases such as document storage, caching, time-series data, or graph relationships. Understanding when and how to use MongoDB, Redis, Cassandra, or DynamoDB alongside relational systems makes a DBA significantly more versatile and valuable.

Cohesyve · Skill assessments for hiring

Assess Database Administrator candidates before you interview them

Cohesyve turns a job description into a role-specific assessment with a scoring rubric. Each candidate gets a different version, so questions cannot be shared between applicants.

1,500+

assessments completed

50%

faster time-to-hire

90%

completion rate

5 min

from JD to assessment

No credit card · 10 free candidates · Plans sized to your hiring volume

From the blog