Roanoke County, VA
Database Administrator (Open Until Filled)
Roanoke County, VA, Roanoke, Virginia, United States, 24000
Salary:
$59,997.18 - $65,996.90 Annually
Location :
Roanoke, VA
Job Type:
Full Time
Job Number:
201003231
Department:
Information Technology
Opening Date:
08/02/2024
Closing Date:
Continuous
GENERAL DESCRIPTION
Under general supervision, the Database Administrator I (DBA) assist in database security, maintenance, support and troubleshooting tasks including production related work, such as full-development life-cycle support for database applications, monitoring and tuning production performance, creating and defining database objects, and making capacity estimates in development and production systems. Will operate with supervision and work with the data services team to plan, design, implement, secure, and support the County's database management system. This position helps support database server instances that run county-wide business applications. This position helps with every-day daily DBA functions such as database backups, restores, performance monitoring, capacity planning, security, replication, and other distributed data issues. This position works with business application staff on system installations, upgrades or other problems related to the database environment. As part of Infrastructure Services, this position works with the network services team in planning, design and implementation of network, server, and storage architecture to support the County Database Systems. Work is performed under the supervision of the Database Services Supervisor.ESSENTIAL JOB FUNCTIONS
Performs 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.Supports 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.Maintains Production and test environments; oversees database migrations, troubleshooting, and performs backup and recovery procedures while ensuring department retention policies are followed.Maintains user and system security for data integrity, and coordinates with department staff on requests and changes.Monitors servers and databases and optimizes performance to gain efficiencies and maximize return on investment.Supports Staff with extract transform and load (ETL) software such as Integrations Services, Visual Studio and other third-party development extensions and tools. Helps plan training material for best practice procedures.Support staff on troubleshooting ETL processes and best practices.Maintains awareness of upcoming database technology changes and leads strategic planning efforts to ensure department remains innovative and sustainable into the future; includes license compliance.
REQUIREMENTS/PREFERENCES
Education: Required: Any combination of education, experience, and training equivalent to the following: Associates degree in computer science or related field.
Experience:Required: Experience in database administration with Microsoft SQL Server or any for 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)
Certifications/ Licenses:Required: Must possess a valid Virginia driver's license and have a good driving record.
Knowledge, Skills and Abilities:
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 AgentKnowledge of SQL Server backup/restores and other maintenance strategiesKnowledge of certificates and symmetric keys used in database encryption tasksAbility to troubleshoot and solve SQL Server performance issuesAbility to manage a variety of tasks effectivelyGood interpersonal and communication skillMust be highly organized and able to handle multiple prioritiesWork with other team members and independentlyMust have strong communication skills and good technical writing skillsKnowledge of Microsoft Windows Server installations, Storage, VMware technologies, Azure, Azure DevOps, Visual studio, Access, Visual Basic, C# is a plus.
Additional Requirements:Successful applicant must not have been convicted of any criminal offenses and will undergo a background investigation to determine suitability for the position. May be subject to DMV driving record review as required by amount of work related driving, specified by support responsibilities. Must also be able to perform the job as described in the Physical and Environmental Demands section of this job description.
Supervisory Responsibilities:None
OTHER INFORMATION
Full-time employees are eligible for a comprehensive benefit package that includes:•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
$59,997.18 - $65,996.90 Annually
Location :
Roanoke, VA
Job Type:
Full Time
Job Number:
201003231
Department:
Information Technology
Opening Date:
08/02/2024
Closing Date:
Continuous
GENERAL DESCRIPTION
Under general supervision, the Database Administrator I (DBA) assist in database security, maintenance, support and troubleshooting tasks including production related work, such as full-development life-cycle support for database applications, monitoring and tuning production performance, creating and defining database objects, and making capacity estimates in development and production systems. Will operate with supervision and work with the data services team to plan, design, implement, secure, and support the County's database management system. This position helps support database server instances that run county-wide business applications. This position helps with every-day daily DBA functions such as database backups, restores, performance monitoring, capacity planning, security, replication, and other distributed data issues. This position works with business application staff on system installations, upgrades or other problems related to the database environment. As part of Infrastructure Services, this position works with the network services team in planning, design and implementation of network, server, and storage architecture to support the County Database Systems. Work is performed under the supervision of the Database Services Supervisor.ESSENTIAL JOB FUNCTIONS
Performs 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.Supports 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.Maintains Production and test environments; oversees database migrations, troubleshooting, and performs backup and recovery procedures while ensuring department retention policies are followed.Maintains user and system security for data integrity, and coordinates with department staff on requests and changes.Monitors servers and databases and optimizes performance to gain efficiencies and maximize return on investment.Supports Staff with extract transform and load (ETL) software such as Integrations Services, Visual Studio and other third-party development extensions and tools. Helps plan training material for best practice procedures.Support staff on troubleshooting ETL processes and best practices.Maintains awareness of upcoming database technology changes and leads strategic planning efforts to ensure department remains innovative and sustainable into the future; includes license compliance.
REQUIREMENTS/PREFERENCES
Education: Required: Any combination of education, experience, and training equivalent to the following: Associates degree in computer science or related field.
Experience:Required: Experience in database administration with Microsoft SQL Server or any for 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)
Certifications/ Licenses:Required: Must possess a valid Virginia driver's license and have a good driving record.
Knowledge, Skills and Abilities:
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 AgentKnowledge of SQL Server backup/restores and other maintenance strategiesKnowledge of certificates and symmetric keys used in database encryption tasksAbility to troubleshoot and solve SQL Server performance issuesAbility to manage a variety of tasks effectivelyGood interpersonal and communication skillMust be highly organized and able to handle multiple prioritiesWork with other team members and independentlyMust have strong communication skills and good technical writing skillsKnowledge of Microsoft Windows Server installations, Storage, VMware technologies, Azure, Azure DevOps, Visual studio, Access, Visual Basic, C# is a plus.
Additional Requirements:Successful applicant must not have been convicted of any criminal offenses and will undergo a background investigation to determine suitability for the position. May be subject to DMV driving record review as required by amount of work related driving, specified by support responsibilities. Must also be able to perform the job as described in the Physical and Environmental Demands section of this job description.
Supervisory Responsibilities:None
OTHER INFORMATION
Full-time employees are eligible for a comprehensive benefit package that includes:•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