JOB
This job opportunity is being re-announced. Applicants previously certified for this job do not need to re-apply. The Data Analytics Strategy Management (DASM) Division of the Fairfax County Fire and Rescue Department (FRD) is responsible for providing decision makers with accurate, up-to-date information across a wide variety of topics. As part of DASM, this position serves as the senior database administrator for the FRD overseeing the FRD’s mission critical data warehouse, and includes responsibilitiessuch as: Defining requirements, designing, developing, testing, debugging, and maintaining the agency’s data warehouse, associated system interfaces, and business intelligence solutions.Ensuring data integrity, availability, security, and reliable backups are performed.Facilitating data sharing with remote systems.Planning, evaluating, and implementing new database systems, including tables, views, functions, stored procedures, or upgrades to existing solutions that enhance operational and administrative functionality for the agency.Implementing optimization best practices at the query, table, database and server levels.Meeting with customers to determine system needs during implementation, system upgrades, or enhancements.Maintaining database technology refresh schedule for the agency.Organizing, preparing, and maintaining system documentation.Participating and recommending actions for the FRD Continuity of Operation Plan.Providing technical support to users and responds to ad hoc data requests.Participating in developing COOP and DR for agency systems and evaluating new technologies supporting agency tactical technology, IoT for public safety, and agency strategic planning.
EXAMPLE OF DUTIES
(The illustrative duties listed in this specification are representative of the class but are not an all-inclusive list. A complete list of position duties and unique physical requirements can be found in the position job description.)Serves as lead programmer for complex technology solutions;Defines, designs, and delivers technically advanced code and objects for applications;Writes, reviews, and deploys scripts, services, system interfaces, and integration logic;Plans, packages, and implements complex programs, routines, jobs, and utilities;Implements software in conformance with defined change / release control procedures;Follows system lifecycle standards and development procedures;Maintains and documents moderate to complex computer programs and/or application software;Develops advanced test scripts and data; tests, evaluates, and debugs software systems;Configures and/or provides administration of COTS applications and related databases;Defines and designs inputs, outputs, work flows, error handling, and complex functional logic;Monitors and evaluates efficiency/effectiveness of applications and underlying data structures;Suggests design and solution options when user enhancements are not feasible as requested;Seeks and identifies opportunities for new technology or system enhancements;Interacts with customer agency in scoping requirements, evaluating feasibility and priority;Confers with users to define requirements and validate conformance to acceptance criteria;Interfaces with users to provide technical assistance, diagnose and resolve software problems;Translates user requirements and interprets specifications of advanced complexity;Defines tasks, estimates resource needs, and organizes work for assigned projects;Prepares requests for programming, and recommends staff assignments;Produces or contributes to advanced designs, specifications, and deliverables;Prepares or delivers training, user manuals, and documentation for assigned projects;Oversees tasks assigned to subordinate clerical, technical, contractor, or project team staff;Supports a 24 x 7 environment, responding to emergencies and critical system failures;Assists in detecting, analyzing, and resolving non-routine application-related problems;Presents ideas and concepts to an audience and participates effectively in workgroup activities;Proactively engages and works with relevant functional areas in DIT in accomplishing work;Evaluates new tools and methodologies for software development effectiveness andapplicability;Assists in the development of requests for proposals and in the evaluation of responses;Monitors contract performance and writes technical reports;Assists in definition and adoption of new standards as needed;Provides mentoring, assistance, training, and guidance to less experienced programmers;Lends assistance and support to other staff as needed;and May require support beyond normal work days to instrumental business operations or systems that require 24x7 support;Performs other duties as assigned.
SUPPLEMENTAL INFORMATION
MINIMUM QUALIFICATIONS: Any combination of education, experience, and training equivalent to the following: (Click on the aforementioned link to learn how Fairfax County interprets equivalencies for "Any combination, experience, and training equivalent to")Graduation from an accredited four-year college or university with a degree in Information Systems, Computer Technology, Business, Economics, or related field, plus three years programming/analysis experience in a complex information systems environment.PREFERRED QUALIFICATIONS: Experience with public safety or emergency management information systems.Hands on technical knowledge designing, installing, configuring, maintaining, and troubleshooting.Microsoft SQL Server in a high-availability environment.Demonstrated analytical skills applied to understanding business functionality and translating them into data models, and technical writing experience.Knowledge of data warehousing best practices.Experience in Business Intelligence solutions, data analytics, dashboards, visualization, and Power BI.Excellent verbal and written communication skills.Ability to work well in a team environment or independently with little supervision, as required. NECESSARY SPECIAL REQUIREMENTS: The appointee to this position will be required to complete a criminal background check, credit check and sanctions screening to the satisfaction of the employer. PHYSICAL REQUIREMENTS: Work is generally sedentary and performed in a normal office environment. All duties may be performed with or without reasonable accommodations. SELECTION PROCEDURE: Panel interview; may include exercise. The population of Fairfax County is very diverse where 38.7% of residents speak a language other than English at home (Spanish, Asian/Pacific Islander, Indo-European, and others) and we encourage candidates bilingual in English and a foreign language to apply to this opportunity. Fairfax County Government prohibits discrimination on the basis of race, color, religion, national origin, sex, pregnancy, childbirth or related medical conditions, age, marital status, disability, sexual orientation, gender identity, genetics, political affiliation, or military status in the recruitment, selection, and hiring of its workforce. Reasonable accommodations are available to persons with disabilities during application and/or interview processes per the Americans with Disabilities Act. Contact 703-324-4900 for assistance. TTY 703-222-7314. DHREmployment@fairfaxcounty.gov. EEO/AA/TTY. #LI-SP1