Database Administrator

Orange County Government•Information Technologies, NC

2d•Hybrid

About The Position

The Orange County Information Technologies Department has an opening for a Database Administrator. The work involves the responsibility for installing, configuring, maintaining, and securing all County database systems across multiple versions and environments. An employee in this class follows best practices to produce secure solutions and works on a wide variety of systems, including disaster recovery and backup. This position is responsible for enhancing and expanding the use of existing database systems to improve security, automation, query scripting, performance monitoring, and alerting capabilities. The incumbent also investigates new industry developments, such as system productivity tools, design and programming methodologies, documentation approaches, and makes recommendations for current and projected use. Additionally, this role will support developers in implementing proper database design, configuration, and standards, as well as performance tuning and query optimization. Work is performed under the general direction of the Chief Information Officer while typically reporting to the IT Applications Manager or designee with considerable leeway to exercise independent judgment within the framework of applicable rules, regulations, policies, and procedures in the performance of duties, both in terms of planning and accomplishing work, and in making decisions regarding customer needs and requests and conducting project assignments. Supervision over others is not required of this position. Position does related work as required. Position location is Hillsborough, NC and this position does require in-office designated days each week. Background check is required. Division of Criminal Investigation (DCI) Check is required.

Requirements

Graduation from an accredited college or university with a Bachelor’s Degree in Computer Science, Information Systems, Information Technology, or a closely related field.
Five (5) years of work experience which primarily involved server administration, database system administration, and database design.
Three (3) years of which must include work experience in maintaining MS SQL database administration that includes security, data integrity, backups and restores.
Experience with paginated report development using SSRS and data visualizations using Power BI.
Possession of or ability to readily obtain a valid driver’s license issued by the State of North Carolina for the type of vehicle or equipment operated.
Ability to reliably commute to the office.
Demonstrate the ability to perform successfully in both in-person and remote work environments.

Nice To Haves

Certification as a Microsoft Certified Solutions Associate (MCSA): SQL Database Administration, MCSA: SQL Database Development, or Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics may be substituted for one (1) year of work experience.
Equivalent certifications for any currently supported version of Microsoft SQL Server may be accepted in place of those listed.

Responsibilities

Installing, configuring, maintaining, and securing all County database systems across multiple versions and environments.
Producing secure solutions following best practices.
Working on a wide variety of systems, including disaster recovery and backup.
Enhancing and expanding the use of existing database systems to improve security, automation, query scripting, performance monitoring, and alerting capabilities.
Investigating new industry developments, such as system productivity tools, design and programming methodologies, documentation approaches, and making recommendations for current and projected use.
Supporting developers in implementing proper database design, configuration, and standards.
Performance tuning and query optimization.