Database Administrator

Lincoln Intermediate Unit 12- Special Projects

Yorktown (VA)

On-site

USD 60,000 - 90,000

Full time

19 hours ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, dental, vision insurance

Health savings account

VRS retirement program

Paid holidays and leave

Job summary

The County of York seeks an IT professional to support, maintain, and develop its SQL Server databases and related data systems. You will contribute to CAMA and document management systems, assist with data integrations using SSIS, and help produce SSRS reports and Power BI dashboards.

Collaboration with end users and vendors is essential. Responsibilities include backups, scripting in T-SQL, C#, PowerShell, and related languages, with a focus on secure, reliable database solutions and adherence

Qualifications

Bachelor's degree in computer science, information systems, or related field; or equivalent combination of education and experience.
Internship, coursework, or 1–2 years of database administration, development, or support preferred.
Ability to learn and grow in a professional IT environment.
Successful completion of pre-employment background checks including FBI CJIS Security Policy eligibility.

Responsibilities

Develop, maintain, and troubleshoot SQL Server databases and related data interfaces.
Create and maintain SSIS packages and data transfer scripts between systems.
Design and deliver SSRS reports and Power BI dashboards for business metrics.
Assist with data integration, governance, and security controls under CJIS/HIPAA requirements.
Support database backups, recovery testing, and performance tuning.
Document architecture, data dictionaries, and release deployments; communicate with stakeholders.
Collaborate with team members and vendors to translate business needs into reliable solutions.

Skills

T-SQL

SSIS

SSRS

Power BI

PowerShell

VBA

Python

Git

Cloud knowledge

Education

Bachelor's degree in computer science, information systems or related field

Equivalent combination of education and experience

Tools

Visual Studio

SQL Server

SSIS

SSRS

Power BI

Git

Job description

Description

Under the supervision of the Chief of Business Applications or a senior team member, assists with the support, maintenance, and development of the County's portfolio of Microsoft Structured Query Language (SQL) Server databases. Participates in maintaining real estate Computer-Assisted Mass Appraisal (CAMA) and document management systems, supports data integrations using SQL Server Integration Services (SSIS), helps generate SQL Server Reporting Services (SSRS) reports and entry-level single-page, interactive canvas used to monitor business metrics at a glance (Power BI dashboards), and assists with scripting tasks in Transact-SQL (T-SQL), C-Sharp (C#), the cross-platform task automation framework and scripting language (PowerShell), or similar programming languages. Works closely with team members, end users, and vendors to translate business needs into reliable and secure database solutions. Responsible for SQL and other database backups. Incumbent may be expected to assist with after-hours database support under guidance of senior staff. Work is characterized by developing SQL Server proficiency and a willingness to learn and apply best practices in database administration. Supports implementation of roles, permissions, encryption, and retention controls mandated by Criminal Justice Information Services (CJIS), Health Insurance Portability and Accountability Act (HIPAA), and County policy under the direction of senior staff. Learns and contributes to database architecture, data integration, and performance troubleshooting in a team environment.

Assist in the development, testing, and implementation of database solutions in support of County business applications.
Help create and maintain basic SSIS packages and supporting scripts to enable data transfers between systems.
Support the administration of real estate CAMA and document management systems; elevate advanced issues to vendors or senior staff.
Develop and maintain standard SSRS reports and contribute to foundational Power BI dashboards; perform basic data analysis.
Participate in requirements gathering and testing processes; help document test cases and outcomes.
Apply basic security and retention policies using predefined scripts and procedures; support recovery testing as assigned.
Assist in coordinating and documenting release deployments; communicate updates to stakeholders with oversight.
Help maintain diagrams, data dictionaries, and documentation knowledge base or shared repositories; participate in knowledge sharing with IT team members.
Assist with coordination of all database system development, integration, and maintenance.
Adds new data and manipulate existing data in multiple work files; apply standards, procedures, commands and data dictionary terminology.

Minimum Qualifications

Bachelor's degree in computer science, Information Systems, or related field; or an equivalent combination of education and experience demonstrating foundational database knowledge and the ability to learn and grow in a professional IT environment. Internship, coursework, or 1-2 years of experience in database administration, development, or support preferred.

Requires an acceptable criminal background investigation, including an acceptable applicant fingerprint check required by the FBI's Criminal Justice Information Services Security Policy.

Possession of a valid driver's license issued by the Commonwealth of Virginia.

This job is contingent upon successful completion of pre-employment checks to include criminal history, background and DMV record checks.

Supplemental Information

Fundamental knowledge of T-SQL and SQL Server query development.
Basic understanding of SSIS or other ETL tools and concepts.
Basic experience with SSRS; introductory exposure to Power BI is a plus.
Familiarity with development environments such as Visual Studio and scripting or programming languages including C#, PowerShell, VBA, or Python.
Familiarity with line-of-business applications or eagerness to learn domain-specific systems like real estate or document management.
Ability to troubleshoot system and end-user issues efficiently and effectively.
Ability to follow a methodical process for reviewing, testing, and implementing technology solutions.
Ability to communicate technical concepts effectively to both technical and non-technical audiences.
Preferred: Familiarity with source control systems (e.g., Git) and introductory knowledge of cloud-based database platforms and services.

Physical Demands

Must be physically able to operate a variety of machinery and peripheral equipment. Must be able to lift and move components weighing up to 55 pounds as needed. Physical demand requirements are for those of Moderately Active Work.

For a more detailed description: View Document

To view our Total Compensation Calculator, click here.

The County of York offers a comprehensive benefit package for full-time employees to include medical, dental, and vision insurance, health savings accounts, VRS retirement, group life insurance, deferred compensation, flexible spending accounts, employee assistance program, paid holidays and paid leave.

Which best describes your level of education?

No Diploma/GED
High School/GED
Some College
Associate's Degree
Bachelor's Degree
Master's Degree or higher

Type in your major field of study in which you received your degree. If you have not received a degree, type in "None".

Please indicate your level of experience with Microsoft SQL Server and T-SQL.

No experience
Coursework/academic experience
Less than 1 year
1-2 years
3-5 years
More than 5 years

Please indicate your level of experience with Microsoft SQL Server administration, including tasks such as backups and restores, database maintenance, monitoring, troubleshooting, user access, or performance tuning.

No experience
Coursework/academic experience
Less than 1 year
1-2 years
3-5 years
More than 5 years

Please indicate your level of experience with SQL Server Integration Services (SSIS), ETL processes, or transferring data between systems?

No experience
Coursework/academic experience
Less than 1 year
1-2 years
3-5 years
More than 5 years

Please indicate your level of experience developing, modifying or maintaining reports using SQL Server Reporting Services (SSRS), including report design, queries/datasets, parameters, and report deployment.

No experience
Coursework/academic experience
Less than 1 year
1-2 years
3-5 years
More than 5 years

Please indicate your level of experience with SQL Server security, including user accounts, permissions, roles, authentication, or access controls.

No experience
Coursework/academic experience
Less than 1 year
1-2 years
3-5 years
More than 5 years

Which programming or scripting languages have you used? Select all that apply.

C#
PowerShell
VBA
Python
Other
None

How experienced are you with end-point, network and cybersecurity concepts relevant to supporting database systems?

None
Minimal
Moderate
Advanced
Expert

If selected for this position, you will be considered an essential employee (County designation as ALPHA) and will be required to report to work during inclement and extreme weather conditions, often outside normally scheduled work hours. Are you able to comply with these provisions?

This position requires the successful candidate to obtain and maintain FBI Criminal Justice Information Services (CJIS) Security Policy Level 4 certification/access as a condition of employment. Are you able to meet all eligibility requirements necessary to obtain and maintain FBI CJIS Security Policy Level 4 certification after hire?

Do you have a valid driver's license from the Commonwealth of Virginia?

This position will require the employee to be in office (Not remote or hybrid). Are you able to meet this requirement?

Were you encouraged to apply for this particular position by a current York County government employee? If so, please write their full name and the department or division they work in below. Otherwise, write N/A.

Are you a current York County government employee? (This does not include the employment with the Offices of General District Court, York-Poquoson Social Services, Colonial Behavioral Health, or York County Schools)