IT Junior DBA/Data Engineer

Performs complex database development and management of County-developed database applications for specialized agency needs; installs, tests, implements, and maintains database management systems and related products operating multiple versions on multiple hardware platforms; handles special projects of all sizes and degrees of complexity from concept to completion; performs related work as required., We are seeking a motivated Junior Database Administrator to join our central IT team. This position focuses primarily on SQL Server administration and management, while also providing secondary support for data analysis platform setup and maintenance to enable our data analyst team. This position is ideal for an individual with database management abilities who also possesses an interest in building an analysis platform to interpret data for actionable business recommendations. The successful candidate will join an established team of DBAs responsible for maintaining the health and performance of our enterprise databases providing 24x7 enterprise database administration, guidance, and support to developers, user employees and/or application vendors in the installation, operation, application and maintenance of various database platforms while working closely with our internal developer teams, data analysts, and various county departments and offices on leveraging data to make insightful decisions on county business needs. The position will administer enterprise databases with a focus on Microsoft SQL Server. RDBMS support includes vendor turn-key applications and in-house development. This position will also be responsible for aiding in the software development life cycle that includes application and database analysis, design, coding, testing, and implementation. The position will report to the leadership of an IT Manager I (Lead Database Administrator). Highlighted DBA Responsibilities:

• Management: Install, configure, and maintain databases in both standalone and clustered high availability configurations, process monitoring, performance tuning, and general troubleshooting. In addition, the successful candidate will be able to support our OLAP, Reporting, and Data Transformation projects as well.
• Backup & Recovery: Help to safeguard the continuity of county operations by ensuring the integrity and reliability of our backup and restore procedures as well as our disaster recovery plans.
• Security: Implement and maintain database security (user and services accounts, permissions, etc.) and ensure compliance with department policies.
• Optimization: Monitor the health and performance of our systems, identifying and resolving bottlenecks before they can escalate to safeguard optimal database operations and minimal impacts on our applications.
• Operations: Work closely with our System Administrators, Network, and Security teams to support capacity planning, storage management, and other infrastructure-related duties.

Highlighted Data Analysis Responsibilities:

• Collaboration: A core capability of this position requires the ability to work closely not only with I.T. staff but also with the heads and business users of various county departments as well. The intention is to understand their data needs, provide analytical support, and anticipate future needs.
• Data Analysis Platforms: Assist in setting up and configuring the SSRS and Power BI reporting environment for organizational use. Maintain underlying data infrastructure for dashboards and reports.
• Query Development: Develop efficient SQL queries to extract, manipulate, and analyze data from various sources. Manage data connections and gateways to ensure secure and reliable access for reporting.
• Data Governance: Support the development and implementation of data governance policies and ensure data security, accuracy, and quality., IT Database Administrator I: Graduation from high school/GED including completion of some relevant coursework at the college level and two (2) years of relevant work experience; OR any equivalent combination of experience and training which provides the required knowledge, skills and abilities. (Grade HP.29 - $72,060.36 - $132,558.42), IT Database Administrator III: Four-year degree in a relevant IT field of study and two (2) years of relevant work experience; OR any equivalent combination of experience and training which provides the required knowledge, skills and abilities. (Grade HP.31 - $79,144.58 - $145,590.17)

• Ideal candidate will need to have hands-on working knowledge in one or more of the following RDBMS platforms: Microsoft SQL Server, PostgreSQL, MariaDB, MySQL or similar RDBMS platform.
• Candidate must have some experience and working skills in database administration, information theory, backup/recovery, performance, installation and patching. Working knowledge of Windows or Linux operating systems, storage devices, networking, shell scripting a plus.
• Knowledge of T-SQL, stored procedures, DDL (table, view and trigger definitions), Reporting Services, Analysis Services, and Integration Services; Ability to prepare technical reports; Knowledge of Information Technology practices, methods, principles and techniques relative to database administration; Have the desire and interest to stay informed of the latest developments in Information Technology and the ability to translate the information into enhancing database performance and availability; Available as a team member to provide 24x7 support; Desired, but not required is knowledge of Microsoft's SQL Server Always-On High Availability environment. Also desired is programming knowledge and experience supporting the software development life cycle.
• The candidate must be able to communicate clearly in writing and verbally, participate in design and implementation meetings, work under time constraints with minimal supervision, and work well as a part of a team composed of Information Technology personnel.

Preferred Qualifications:

• MS SQL Server DBA or similar certifications.
• Hands on experience in SQL 2016/2019/2022+ Always-On High Availability configuration, support, and troubleshooting.
• Experience of managing and developing SQL Server, BI Suite, database custom tools using SQL Server Data or similar.
• 1+ years of experience in supporting/maintaining Data Warehouses., IT Database Administrator II: Two-year degree in a relevant IT field of study and two (2) years of relevant work experience; OR any equivalent combination of experience and training which provides the required knowledge, skills and abilities. (Grade HP.30 - $75,519.45 - $138,921.57), IT Database Administrator Senior: Four-year degree in a relevant IT field of study and four (4) years of relevant work experience; OR any equivalent combination of experience and training which provides the required knowledge, skills and abilities. (Grade HP.32 - $82,943.73 - $152,578.89), A criminal history record check and fingerprinting is conducted on all persons conditionally offered employment, including a conditional offer of initial employment, or a conditional offer to promote, demote, or laterally transfer an employee. May require of a valid driver's license to provide support at locations Countywide.

The hiring department anticipates filling this position at the IT Database Administrator I or II level with an anticipated hiring range of $72,060.36 - $84,911.15 depending on the qualifications of the successful applicant and the needs of the organization at the time of hire. The position may be filled at the IT Database Administrator III or Senior level based on the qualifications and experience of the selected candidate. Salary placement above the anticipated range may be considered for candidates whose qualifications significantly exceed the expected requirements of the position and would correspond to the approved range for the hiring level.

Henrico County, a progressive employer of choice, provides job seekers with the promise of fair and competitive compensation; a close-knit atmosphere with low employee turnover; and a benefits package that helps secure financial stability. Established in 1611, Henrico County has deep historical roots. Henrico County borders the City of Richmond to the west, north and east and constitutes approximately a third of the Richmond metropolitan areas. Henrico County is among the top-rated counties in the nation and was one of the first localities to adopt the County Manager Form of Government. Citizens of Henrico County are represented by an elected Board of Supervisors representing five magisterial districts. Henrico County General Government currently has more than 30 agencies. Department Heads are appointed by the County Manager, with the exception of the elected constitutional officers. Henrico County is an equal opportunity employer and, when you join us, you will be surrounded by fellow associates who come from all walks of life, all types of cultural backgrounds and all ages., This position is part of a Career Development Plan (CDP), offering opportunities for advancement within the IT Application Developer series. The requirements of each level are listed below, Henrico County Public Schools expresses a divisionwide commitment to every student by communicating a vision of inclusiveness: "The right to achieve. The support to succeed." The school division also embraces four critical cornerstones: Student Safety, Academic Progress, Closing Gaps and Relationships. The school system serves the families of Henrico County, Virginia, a diverse community of more than 320,000 which wraps west, north and east of the independent city and state capital of Richmond. Henrico is Virginia's fifth-most populous county. HCPS is the sixth largest public school division in Virginia, and is comprised of 72 schools and program centers serving more than 50,000 students. The division's schools reflect the geographic diversity of Henrico County, and lie in bustling near-urban and suburban settings; small towns; and quiet rural areas. Academic excellence and opportunity are hallmarks of Henrico County Public Schools. Twenty-three division schools earned 2017 Virginia Index of Performance awards for advanced learning and achievement, presented by Gov. Terry McAuliffe and the Virginia Board of Education. HCPS was again tops in the Richmond region with the most schools earning the distinction. Short Pump Middle School was one of only nine schools in the commonwealth to earn the highest designation. HCPS also leads central Virginia in teachers certified by the National Board for Professional Teaching Standards. Completion of the rigorous process is the profession's highest mark of accomplishment. Henrico Schools has robust programs and support services for families of students with special needs; gifted students; homebound and homeschooled students; and students learning English as a second language. Each of the division's high schools is fully accredited and hosts an academic specialty center. The specialty centers allow students with clear interests the chance to focus on a preferred area, such as engineering, the arts or world languages. Three middle schools offer the International Baccalaureate Middle Years program and two high schools offer the International Baccalaureate Diploma program. The division also has cutting-edge programs in career and technical education, at individual schools and at two Advanced Career Education centers. From learning about sustainable seafood in culinary arts classes to applying technology concepts at Richmond Raceway, HCPS' Department of Career and Technical Education helps students become effective participants in the international economy. From academics to athletics, from the arts to career skills, Henrico County Public Schools is proud to be part of helping our community thrive by ensuring that each child has the right to achieve and the support to succeed.