About This Role
Working under the supervision of a senior team member, the Database Administrator supports, maintains, and develops the County
Responsibilities
- 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; escalate 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
- Add new data and manipulate existing data in multiple work files; apply standards, procedures, commands and data dictionary terminology
- Assist with after-hours database support under guidance of senior staff
- Support implementation of roles, permissions, encryption, and retention controls mandated by CJIS, HIPAA, and County policy under the direction of senior staff
- Learn and contribute to database architecture, data integration, and performance troubleshooting in a team environment
Requirements
- Bachelor
- Internship, coursework, or 1
- Acceptable criminal background investigation, including an acceptable applicant fingerprint check required by the FBI
- Possession of a valid driver's license issued by the Commonwealth of Virginia
- Fundamental knowledge of T-SQL and SQL Server query development
- Basic understanding of SSIS or other ETL tools and concepts
- Basic experience with SSRS
- 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