Database Administrator (Programmer Analyst III)

Job Announcement

• 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.
  
  

Illustrative 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 and
• applicability;
• 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.

Required Knowledge Skills and Abilities

(The knowledge, skills and abilities listed in this specification are representative of the class but are not an all-inclusive list.)

• Considerable knowledge of position-relevant computer languages and technologies;
• Considerable knowledge of programming principles, operating systems, and hardware;
• Considerable knowledge of system development life cycle concepts and activities;
• Considerable knowledge of modern information processing techniques and systems analysis;
• Considerable knowledge of the capabilities and operating requirements of various platforms;
• Considerable knowledge of centralized, distributed, client server, and Web architectures;
• Considerable knowledge of computer / database programming process and related practices;
• Considerable knowledge of conceptual and logical data, work flow, and process modeling;
• Considerable knowledge of report design and procedural report writing;
• Skill in defining and supervising the work of others in a project lead capacity;
• Skill in finding and presenting a range of options to resolve complex problems;
• Skill in writing advanced programs and debriefing changes made;
• Skill in designing and developing complex applications and components;
• Skill in performing unit testing and the related debugging of computer errors;
• Ability to establish and maintain effective business relationships;
• Ability to work independently, serves as a team lead, or add value as a team contributor;
• Ability to elicit requirements from stakeholders to support development of specifications;
• Ability to perform research and find relevant materials to assist in project tasks and assignments;
• Ability to seek root cause(s) and appropriate solution(s) for resolving complex issues;
• Ability to plan, to organize, and to conduct systems analysis and feasibility assessments;
• Ability to evaluate processes/procedures, to suggest improvements, and to design specifications;
• Ability to document necessary system modifications and enhancements to defined standard(s);
• Ability to assist users in troubleshooting and solving systems and programming problems;
• Ability to translate technical terminology into simple, non-technical language;
• Ability to provide guidance and assistance to technical employees and review their work;
• Ability to train less skilled technical workers and to plan, assign, and review their work;
• Ability to prepare clear, detailed programs of instruction for efficient system utilization;
• Ability to ask relevant questions to assure understanding of assignments and requirements;
• Ability to write easy to follow systems documentation tailored to the end user audience.

Employment Standards

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