Database Administrator (Open Until Filled)

Roanoke County - Roanoke, VA

Full-time - Entry Level

Roanoke, VA

About the position

The Database Administrator I (DBA) position at Roanoke County is a full-time role that operates under general supervision. The DBA will assist in various database security, maintenance, support, and troubleshooting tasks, which include production-related work. This encompasses full-development life-cycle support for database applications, monitoring and tuning production performance, creating and defining database objects, and making capacity estimates in both development and production systems. The DBA will collaborate with the data services team to plan, design, implement, secure, and support the County's database management system. This role is crucial in supporting database server instances that run county-wide business applications and involves daily DBA functions such as database backups, restores, performance monitoring, capacity planning, security, replication, and addressing other distributed data issues. In addition to these responsibilities, the DBA will work closely with business application staff on system installations, upgrades, and troubleshooting problems related to the database environment. As part of the Infrastructure Services team, the DBA will also collaborate with the network services team in planning, designing, and implementing network, server, and storage architecture to support the County Database Systems. The work is performed under the supervision of the Database Services Supervisor, ensuring that all tasks align with departmental goals and standards.

Responsibilities

• Perform database administration functions such as creating and maintaining user security, sizing databases, creating database files, schemas, views, stored procedures, functions, and other related database objects.
• Support staff in the use of database software products for business applications, query, and reporting; includes development of stored procedures and views for accessing and retrieving data.
• Maintain Production and test environments; oversee database migrations, troubleshooting, and perform backup and recovery procedures while ensuring department retention policies are followed.
• Maintain user and system security for data integrity, and coordinate with department staff on requests and changes.
• Monitor servers and databases and optimize performance to gain efficiencies and maximize return on investment.
• Support staff with extract transform and load (ETL) software such as Integrations Services, Visual Studio, and other third-party development extensions and tools; help plan training material for best practice procedures.
• Support staff on troubleshooting ETL processes and best practices.
• Maintain awareness of upcoming database technology changes and lead strategic planning efforts to ensure the department remains innovative and sustainable into the future; includes license compliance.

Requirements

• Associates degree in computer science or related field or equivalent combination of education, experience, and training.
• Experience in database administration with Microsoft SQL Server or any of the following Microsoft Role-Based Certifications: Azure Administrator Associate, Power BI Data Analyst Associate, Azure Data Fundamentals, Azure Data Engineer Associate, Azure Data Scientist Associate, MCSA, MCSE, MCSD.
• Must possess a valid Virginia driver's license and have a good driving record.
• Knowledge of SQL Server Administration duties.
• Understanding of performance monitoring and alerting tools.
• Understanding of index and query optimization.
• Experience writing SQL statements.
• Experience with SSRS, SSAS, SSIS, Power BI, and other Power Platform Applications is a plus.
• Knowledge of SQL Server architecture, such as objects, schemas, system database, SQL Services, and SQL Agent.
• Knowledge of SQL Server backup/restores and other maintenance strategies.
• Knowledge of certificates and symmetric keys used in database encryption tasks.
• Ability to troubleshoot and solve SQL Server performance issues.
• Ability to manage a variety of tasks effectively.
• Good interpersonal and communication skills.
• Must be highly organized and able to handle multiple priorities.
• Work with other team members and independently.
• Must have strong communication skills and good technical writing skills.
• Knowledge of Microsoft Windows Server installations, Storage, VMware technologies, Azure, Azure DevOps, Visual Studio, Access, Visual Basic, C# is a plus.

Nice-to-haves

• Experience with ETL processes and best practices.
• Familiarity with database technology changes and strategic planning efforts.

Benefits

• Progressive Flexible Leave Plan with cash-in option
• Twelve paid holidays
• Short Term Disability Insurance
• Long Term Disability Insurance
• Health, Vision and Dental Insurance
• Life Insurance
• Flexible Spending Accounts - Medical and Dependent Care
• Virginia Retirement System - Membership in VRS is automatic upon hire into a covered position. County contributes and employees pay their membership contribution.
• Deferred Compensation Plan with County Match
• Employee Assistance Program
• Credit Union Membership