Database Administrator Job Description Template

We are seeking an experienced Database Administrator to design, develop, and support database installations to suit business demands. This role focuses on offering solutions and assistance for data availability and integrity. Successful performance in this role depends on having a solid understanding of relational database management systems’ actions and procedures (RDBMS) best practices and proven problem-solving abilities. The database administrator communicates closely with the management and application development teams to guarantee database operational security, integrity, and availability. 

Typical Duties and Responsibilities

• Plan, administer, implement and manage data repositories
• Monitor databases and proactively manage blocking and performance tuning concerns
• Advise the application development team regarding database design, stored procedures, functions and queries
• Oversee the administration and upkeep of data reporting systems, including establishing and setting up security access
• Implement and manage long-term retention schedules, off-site compression, and database backup and recovery
• Design, implement, and maintain Infrastructure for databases that supports high availability and catastrophe recovery 
• Design, implement, and maintain phased migration and environment control processes
• Gather data to give cost-effective suggestions for project implementation and future improvements
• Create and maintain recovery documentation, implementation plans and policies and procedures
• Create and update policies and guidelines to guarantee secure access to production system data
• Research new database management solutions, features, languages, and standards
• Evaluate current software and systems to suggest changes or enhancements
• Perform server builds, including virtual machine sizing, SQL install, and configuration
• Oversee the development and implementation of disaster recovery exercises

Education

• Bachelor’s degree in computer science or a related technology field

Required Skills and Experience

• 6+ years of experience in database administration or systems development
• 6+ years of Microsoft SQL Server administration experience
• Expertise in relational database systems (Microsoft SQL Server, PostgreSQL, etc.), Structured Query Language, Extract Transform Load (ETL) tools and processes, stored procedures, and functions
• Knowledge of PowerShell and/or other scripting tools and techniques, as well as SQL-based query languages
• Strong familiarity with and comprehension of SQL Server Integration Services (SSIS).
• Knowledge of relational database security design principles, physical database design, network topologies, server hardware and data storage (SAN, RAID, etc.), server operating systems (Microsoft Windows and/or Linux/UNIX), and system monitoring
• Strong verbal and written communication abilities.
• Proven track record of successfully coordinating and resolving highly technical database management problem
• In-depth understanding of the technological options that can be used for enterprise data/information management disciplines, including but not limited to the content of pages and extents, b-tree and columnstore indexes, statistics, optimizer, query plans, plan/buffer cache, partitioning, log growth, and files and filegroups

Preferred Qualifications

• Knowledge of the Azure Database Services from Microsoft (Azure SQL Database, Azure SQL Managed Instance, Azure Cosmos DB, etc.)
• Knowledge of Azure DevOps and ServiceNow
• Knowledge of MDX queries and multidimensional models
• Understanding of the Microsoft licensing scheme