Database Administrator Iii

Location
Fairfax, Virginia
Salary
$80,764.32 - $134,606.99 Annually
Posted
Apr 10, 2021
Closes
Apr 24, 2021
Ref
21-00656
Hours
Full Time
Job Announcement

Serves as a senior expert on a team of IT professionals, technical staff, and contractors in database management, data and reporting architecture functions for the Fairfax County IT enterprise, to include strategy, design, engineering, maintenance and operational oversight and support, responsible for the design, management, maintenance, and monitoring of SQL and other database environments. The incumbent should understand all components of SQL Server. Responsibilities include:
  • Database Engine: This part of SQL Server actually creates and drives relational databases, SQL Server Analysis Services (SSAS), the data-analysis component of SQL Server. Creating OLAP (OnLine Analytical Processing) cubes — sophisticated programming objects for organizing data inside a relational database — and data mining (pulling relevant data out of a database in response to an ad-hoc question), SQL Server Reporting Services (SSRS): SSRS, which provides reporting regardless of a database’s operating system, and SQL Server Integration Services (SSIS) that will ): SSIS is a component of SQL Server that does the Extract, Transform, and Load support the daily operations of coordinating the activities, and staff across the various technical specialties associated with enterprise-wide and independent applications databases, reporting and data analytics development.
  • Advises agencies’ IT Analysts in determining database environments and structure. Ensures seamless implementation and process for deploying technology solutions that support applications and data requirements for multiple data-base types; ensures operational reliability and continuity.
  • Acts as an integral part of the team, works closely with the applications and systems analysts, server and storage managers and analysts, other IT and business managers and analysts to develop and execute IT programs.
  • Develops COOP for ensuring database management coverage and response to troubles 24x7.
  • Advises DIT directors and managers, and departmental IT analysts on related IT policy, solutions and issues.
  • Requirement to be available on a 24x7 basis to respond to incidents, conduct tests, support operations maintenance, perform investigations, project implementation, and emergency event activation. Performs other duties as assigned.


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”)
Bachelor's degree in computer science, or related field; plus five years’ experience in the database management systems area, with three years’ experience in one specific system such as DB2, IDMS, or Oracle.

PREFERRED QUALIFICATIONS:
Hands on technical knowledge designing, installing, and configuring Microsoft SQL Server 2014, 2016, and 2017 in an always on state for fail-over. Hands on technical experience with migrating Oracle databases to SQL database on Windows on premise or Azure environment, and a strong background in database warehouse knowledge is a plus. Should have experience with Performance Tuning and Optimization of SQL databases, and have experience working with High Availability (HA), and Disaster Recovery (DR) across multiple datacenters in an enterprise environment. Should have extensive knowledge work with applications groups around integration of applications into our SQL environment. Experience running SQL, and/or HANA databases in a shared service environment. Azure or AWS is a plus. Strong background and experience with Integration & Test experience around SQL backup methodologies, and strong analytical and troubleshooting Windows Environments are a must. Should possess some knowledge in the design of Oracle databases, and their table structures, and backup methodologies. A good working knowledge of Windows Active Directory is a plus.

NECESSARY SPECIAL REQUIREMENTS:
The appointee to the position will be required to complete a criminal background check to the satisfaction of the employer.

PHYSICAL REQUIREMENTS:
Work is generally sedentary, performed in a normal office environment. All duties performed with or without reasonable accommodations.

SELECTION PROCEDURE:
Panel interview; may include exercise.

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 status as a veteran 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. EEO/AA/TTY.

Similar jobs