Database Administrator

Position Description

This position will report directly to the IJTD Director

Position Overview:

The Database Administrator is responsible for the activities related to the database administration and the development support of the Integrated Justice System. Responsible for standards and design of physical data storage, maintenance, access, and security administration. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.

Job Duties and Responsibilities:

• Defines data repository capabilities and monitors database(s) and related systems for performance issues and errors.

• Provide thorough guidance and recommendations for system improvement.

• Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, implement testing processes and procedures, data dictionaries and warehousing requirements.

• Supports multiple transactional, replication services, subscription activities, and databases of medium to high complexity (complexity defined by database size, technology used, systems feeds and interfaces) with multiple concurrent users, ensuring control, integrity, and accessibility of data.

• Create, maintain, and document system recovery scripts, database design and architecture. Perform data migration activities and upgrades.

• Provide performance monitoring reports

Harris County is an Equal Opportunity Employer

https://hrrm.harriscountytx.gov/Pages/EqualEmploymentOpportunityPlan.aspx

If you need special services or accommodations, please call (713) 274-5445 or email ADACoordinator@bmd.hctx.net.

This position is subject to a criminal history check. Only relevant convictions will be considered and, even when considered, may not automatically disqualify the candidate.

Requirements

Education:

• Bachelor's Degree in Computer Science, Information Systems, or other related field.

Experience:

• Five to eight years of related experience.

Knowledge, Skill & Abilities (KSAs):

• Must possess excellent interpersonal and written/oral communication skills.

• The ability to interact with staff at all levels.

• Strong knowledge of personal computers and software, specifically Microsoft Office.

• Thorough knowledge of structured query language, Microsoft SQL Server, Reporting Services, transactional replication, and Always on Availability Groups.

• Strong knowledge of transactional replication and publisher/subscriber configurations.

• Strong knowledge of database management and associated activities.

• Strong ability and skill to troubleshoot and focus on high priority issues during critical incidents.

Applicants for this position will be subject to a criminal background check that includes being fingerprinted. This applies to any position with network access to Criminal Justice Information Services (CJIS) or access to an area where CJIS is received, maintained, or stored either manually or electronically (i.e., custodian, maintenance).

Automatic Disqualification:

• Convictions, probation, or deferred adjudication for any Felony, and any Class A Misdemeanor

• Convictions, probation, or deferred adjudication for a Class B Misdemeanor, if within the previous 10 years

• Open arrest for any criminal offense (Felony or Misdemeanor)

• Family Violence conviction

NOTE: Qualifying education, experience, knowledge, and skills must be documented on your job application. You may attach a resume to the application as supporting documentation but ONLY information stated on the application will be used for consideration. "See Resume" will not be accepted for qualifications.

Preferences

Education:

• Advanced degree preferred

Knowledge, Skills, and Abilities:

• Criminal Justice data management experience preferred

General Information

Position Type and Typical Hours of Work:

• Monday - Friday | 40hrs

• Regular Full-time | Onsite Position

• Hybrid Schedule

• May be required to work more than forty hours during the workweek and/or weekends or on-call 24 hours a day to meet special projects or deadlines

• Subject to performing other duties as assigned

• Must live or plan to live in the Houston Texas metropolitan area

Location:

• Downtown Houston

Employment may be contingent on passing a drug screen and meeting other standards.

Due to a high volume of applications positions may close prior to the advertised closing date or at the discretion of the Hiring Department.

BENEFITS

Harris County offers a competitive benefits program, including comprehensive group health and related benefits plan as well as defined benefit retirement plan.

The following list of benefits is offered only to employees in regular (full-time) positions:

• Medical Coverage

• Dental Coverage

• Vision Coverage

• Wellness Plan

• Life Insurance

• Long-term disability

• Employee Assistance Program

• Ten (10) days of vacation each year for the first five (5) years of service

• Accrual rates increase based on years of service

• Eleven (11) County-observed holidays and one (1) floating holiday

• Professional development opportunities

• Dependent Care Reimbursement Plan

• Healthcare Reimbursement Account

• 457 Deferred Compensation Plan

The following benefits are also available to regular (full-time) employment and may be available to part-time employees:

• Retirement Pension (TCDRS)
• Flexible schedule (varies by department)
• Transportation Assistance (Metro RideSponsor Program)

In accordance with the Harris County Personnel Regulations, Group Health and related benefits are subject to amendment or discontinuance at any time. Commissioners Court reserves the right to make benefit modifications on the County's behalf as needed.

For plan details, visit the Harris County benefits website:

https://benefitsathctx.com/

01

Which of the following best describes your highest level of education completed as it relates to this position?

• High School or GED diploma

• Associate Degree

• Bachelor's Degree

• Master's Degree or higher

• None of the above

02

If you selected a college degree in response to the previous question, which of the following best describes your major?

• Computer Science

• Information Systems

• Other Related Field

• Unrelated Field

• N/A; No Degree

03

Please describe your educational background including level of education completed, area of study and completed major and minor programs.

04

Which of the following best describes your verifiable related experience? (To be considered, qualifying experience must be documented in your application's employment history)

• Less than five (5) years

• Five (5) years but less than six (6) years

• Six (6) years but less than seven (7) years

• Seven (7) years or more

• I do not have this experience

05

Please provide details about your verifiable related experience. Do not use "Please see Resume" or "See Resume" (To be considered, qualifying experience must be documented in your application's employment history) Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilities If you do not have this experience, please type "None" in the space provided.

06

Do you have Criminal Justice data management experience?

• Yes

• No

07

Please provide details about your verifiable Criminal Justice data management experience. Do not use "Please see Resume" or "See Resume" (To be considered, qualifying experience must be documented in your application's employment history) Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilities If you do not have this experience, please type "None" in the space provided.

08

Which of the following describes your level of proficiency using a personal computer and common office software such as MS Office Suite (Word, Excel, PowerPoint, and Outlook). Please select your level of proficiency based on the following descriptions: Advanced: A person with this level of skills is able to produce very large, complex formal documents that require a table of contents, footnotes, endnotes, bookmarks, and other special elements; a wide range of graphic effects, and use advanced techniques for analyzing and manipulating data. Has full mastery of Macro commands and skills to tie the objects together into a cohesive system by using Macros and Visual Basic for Applications code. Makes interactive presentations by using hyperlinks and action buttons. Intermediate: A person with this level of skills is able to customize toolbars, import and insert graphs, embed Excel data, and elaborate reports. Understands the concepts of databases and is able to work with charts and to use the list management capabilities of Excel. Able to use complex query techniques, create efficient forms and reports, and create Macros to automate these forms. Makes interactive presentations by using hyperlinks and action buttons. Basic: A person with this level of skills is able to use basic formatting, editing, printing functions, and understands the document page setup. Has the ability to enter and correct data, modify a workbook, format a worksheet, and use printing functions. Understands the different database concepts and structures and is familiar with data validation and is able to create a simple presentation in PowerPoint, run it, and print it. Entry Level: A person with this level of skills has the ability to open, create, save and modify documents in Word, send and receive email in Outlook and create spreadsheets in Excel. Format documents for printing, comfortable using the printer menu to preview documents. Has ability to change the font, the margins, insert or delete pages and use the built-in spellchecker and grammar check.

• Advanced

• Intermediate

• Basic

• Entry Level

• Not proficient

Required Question

Agency Harris County

Address 1111 Fannin St

Ste. 600

Houston, Texas, 77002

Phone 713-274-5445

Website https://www.governmentjobs.com/careers/harriscountytx