Address
Form of workSalary: $70,705.18 - $90,278.50 Annually
Location : Champaign, IL
Job Type: Full Time
Job Number: DB ADMIN - JAN 2024
Department: METCAD, Champaign County 9-1-1
Opening Date: 01/19/2024
Description
Are you an Information Technologies expert looking for an opportunity to use your talents and skills to improve the quality of life for the residents of our community and support local public safety agencies? Then consider applying to be a Database Administrator at the Metropolitan Computer Aided Dispatch Center (METCAD 9-1-1).
Responsibilities of Position
The Database Administrator is part of a team of professionals responsible for ensuring the 9-1-1 emergency response services provided by METCAD 9-1-1 are available to residents and first responders 24/7/365. They perform technical management and operational maintenance of all database and related computerized information systems used by METCAD including backups integrity checks, restores, and user permissions/access. They assist with the planning, installation, and testing of new software and maintain software interfaces. The Database Administrator trains and provides technical support to internal and external end users and is a liaison with vendors. Due to the sensitive nature of METCAD's data, they keep up to date on Criminal Justice Information Systems (CJIS) and other relevant data standards regulations. They conduct research and data analysis and maintain GIS layers. The position requires on-call status with 24 hour-a-day responsibilities and the ability to respond in a timely manner during emergencies.
Required Qualifications
• Education equivalent to an associate degree in computer science, information systems, or a related field. Completed coursework without a diploma will be considered.
• Relevant certifications in database management, application support, or similar areas will be considered in lieu of an associate degree.
• Advanced database, software, or comparable administration experience such as database design, development, maintenance, administration, support, implementation, installation and/or upgrades.
• Ability to provide quality customer service and maintain effective working relationships.
• Ability to troubleshoot complex issues and convey to audiences of all technical ability levels.
• Ability to perform essential functions that require physical agility as noted in the job description, such as remain stationary for periods of time, move around inside an office, bend, turn, reach, stretch, climb, kneel, stoop, negotiate obstacles, climb ladders, lift up to 50 pounds, with or without accommodation.
• Current valid state-issued driver's license and good driving record.
Preferred Qualifications
• Experience maintaining multi-layer GIS maps using ESRI or similar mapping software.
• Experience with Public Safety computer systems or databases.
• Experience with SQL Server.
• Experience with Microsoft Excel DSS, Excel SSMS, IIS, and/or Active Directory.
Drug screening, criminal history record check, and driving abstract will be required. The annual starting salary range is $70,705 - $80,491, DOQ, plus an excellent fringe benefits package. Applications must be submitted online no later than Sunday, February 4, 2024.
Other Information
The City of Champaign is an Equal Opportunity Employer. Women, minorities and individuals with disabilities are encouraged to apply. The City of Champaign is committed to promoting a work environment and a community that values and supports diversity and inclusion. Contact the Human Resources Department at (217) 403-8770 Monday through Friday from 9 a.m. to 4 p.m. if you require an accommodation to complete this application or during any phase of the application, interview, or employment process.
The following locations offer free Internet access and assistance: Champaign Public Library, the Illinois WorkNet Center and the City of Champaign City Building.
Our mission is to provide responsive, caring, cost-effective service in partnership with our community.
These values guide our work:
Personal Integrity
We act in the best interests of the City
We behave in an ethical and legal manner
We are open and honest
We follow through on commitments
We are loyal to the City
Responsibility
We anticipate issues, problems, and opportunities
We take initiative
We act to prevent and solve problems
We take responsibility for the outcome of our actions and decisions
We hold ourselves and others accountable
Respect
We treat others in a fair, courteous, and equitable manner
We actively listen and seek understanding
We provide a direct response
We embrace ethnic and cultural diversity in the community and our workplace
We are positive and cooperative
We are willing to apologize
Teamwork
We know and respect our roles and responsibilities
We ask who needs to be involved and we involve others appropriately
We define and agree upon the goals
We collaborate to achieve organizational goals
We help others accomplish their goals
We share authority, responsibility, and credit
Results
We take pride in our work
We complete assignments and projects on time and within budget
We evaluate outcomes and seek feedback on our performance
We learn from our mistakes
We innovate
This position is classified as Non-Bargaining Unit Exempt.
HEALTH INSURANCE
The City offers employee's a choice between two excellent health insurance plans - a Health Alliance HMO or POS 3 Tier Deductible Plan.
The City of Champaign pays up to $580 of the employee (single) health insurance premium and 50 percent of the dependent premium for continuous full-time employees or 25 percent of the dependent premium for continuous part-time employees. Premiums for single employee coverage above $580 per month are shared by the employee and the City. For the 2023/2024 plan year, NBU employees contribute 1.075 percent of their salary for the HMO plan and 0.653 percent for the POS 3Tier Deductible plan of their salary. Premiums may be made on a pre-tax basis, through the City's Section 125 plan. Health insurance coverage begins on the date of hire and ends effective the date of employment separation.
Rates are available under the Fringe Benefit Summaries section on the City's website at
DENTAL AND VISION INSURANCE
Employees may purchase dental and/or vision insurance through payroll deduction. Employees pay 100 percent of the monthly premium for this coverage. Premiums for dental and vision insurance may be made on a pre-tax basis, through the City's Section 125 plan. Dental and vision insurance begins after waiting for one complete calendar month (e.g., if hire date is in the month of January, coverage begins on March 1st).
The dental plan has two options: Delta Dental Network Low Plan (PPO) and Delta Dental High Plan.
Vision insurance is provided by EyeMed.
Rates are available under the Fringe Benefit Summaries section on the City's website at
LIFE INSURANCE
The City provides a term life insurance policy equal to annual salary rounded to the next highest thousand dollars (up to a maximum of $100,000), or $30,000, whichever is greater. Employees may elect to purchase voluntary supplemental life insurance for themselves up to 5x their annual salary or $500,000 (whichever is lower), through payroll deduction. Employees may also purchase term life for their spouses/dependents.
• Employee voluntary supplemental life insurance coverage can be purchased in $10,000 increments and the price is calculated based on the employee's age.
• Employees may purchase voluntary supplemental life insurance for their spouses up to half the amount purchased for themselves in $5,000 increments. Cost is calculated based on the employee's age.
• Employees may purchase voluntary supplemental life insurance for their dependent children in the amount of $10,000 for any/all eligible children.
• Employees may purchase Basic Life Insurance for their spouse and eligible dependent children.
o Option #1: $3.60/month for $10,000 for spouse and $5,000 for any/all eligible children.
o Option #2: $1.80/month for $5,000 for spouse and $2,000 for any/all eligible children.
PENSION
Illinois state law requires that eligible municipal employees be covered by the Illinois Municipal Retirement Fund (IMRF). Employee contributions to IMRF are 4.5 percent of salary and are tax-deferred. For 2023, the City contributes 7.42 percent of eligible employee's salaries to IMRF. In addition, IMRF members are covered by Social Security (FICA). Obtain additional information by contacting IMRF at 1-800-ASK-IMRF. Employees are eligible to contribute additional funds to IMRF through Voluntary Additional Contributions. Contact HR for details.
RETIREMENT HEALTH SAVINGS (RHS)
A retirement health savings plan administered by the Mission Square Retirement Corporation has been established for NBU employees. NBU employees participate in a mandatory contribution of 1 percent of pre-tax salary into an RHS investment account. This account is available for use by the employee at retirement or separation of service. Eligible uses of the funds include medical expenses such as health insurance premiums, dental/vision expenses, coinsurance, and co-pays for employees, spouse, and/or dependents. Note: Upon separation, a mandatory 50 percent of accrued vacation, compensatory and payout-eligible sick leave will be contributed to your RHS balance.
HOLIDAYS
New Year's Day
Martin Luther King, Jr.'s Birthday
Memorial Day
Juneteenth
Independence Day
Labor Day
Veterans Day
Thanksgiving Day
Friday after Thanksgiving
Christmas Eve
Christmas Day
PERSONAL LEAVE
At the beginning of each fiscal year July 1st, continuous full-time employees are credited with three personal days (24 hours); personal days are pro-rated for continuous part-time employees. Personal leave may not be accumulated and carried over into the next fiscal year. Personal leave during the first year of employment varies based on the date of employment.
VACATION
Vacation accrual rates are based on years of service and pro-rated for part-time employees. Vacation may be taken after six months of employment. Requests for leave to be taken during the initial six months of employment must be approved by the employee's supervisor and may be permitted through a combination of personal leave, unpaid leave, flex time, and/or compensatory time.
SICK LEAVE
Continuous full-time employees accrue sick leave at the rate of 3.69 hours per pay period (approximately 1 day per month); sick leave accrual is pro-rated for continuous part-time employees. The maximum accumulation of sick leave is 1,200 hours. T
LONGEVITY PAY
Employees receive longevity pay based upon their years of continuous employment with the City. Longevity pay is an addition to the employees' base wage rate.
CREDIT UNION
Employees may join the Credit Union I. Payroll deduction for savings and credit union loan payments are available as well as a deduction for a savings bond program and Christmas Club. Additional information can be obtained by contacting the Credit Union directly at (800) 252-6950.
DEFERRED COMPENSATION PLAN
The City of Champaign offers employees the opportunity to participate in a tax-deferred annuity plan of the Mission Square Retirement Corporation through payroll deduction. This is an optional plan with no City contributions. More information may be obtained by contacting Client Services (1-800-669-7400).
01
Please select the option below that best describes your highest level of education.
02
If you selected "Associate degree or higher" to the question above, please state the type of degree and major and/or field of study.
03
If you selected "High school diploma or equivalent" to question #1, please describe your relevant experience and training that demonstrates your qualifications for this position.
04
List any certifications you have earned in database management, application support, or similar areas. Please provide the certification name and issuing agency/organization.
05
Select from below the areas in which you have advanced database or software professional work experience. Check all that apply:
06
Please describe your professional work experience in the areas checked above. Enter N/A if you selected "None of the above."
07
Please describe your experience with helping end users with troubleshooting issues. Enter N/A if you have no experience in this area.
08
Please describe your experience with conduct training to end users. Enter N/A if you have no experience in this area.
09
Please describe your experiences and abilities troubleshooting complex software issues both internally and working with software vendors.
10
Do you currently possess a valid state-issued driver's license? Y/N
11
Are you able to perform the duties of the job, including remaining stationary for periods of time, move around inside an office, bend, turn, reach, stretch, climb, kneel, stoop, negotiate obstacles, climb ladders, lift up to 50 pounds with or without accommodation? Y/N
12
This position requires 24-hour on-call duty, including physically responding to METCAD facilities for emergency system response with little or no notice within a timely manner. Are you willing and able to fulfill this job duty? Y/N
13
Please describe your working knowledge of and experience with maintaining multi-layer GIS maps using ESRI or similar mapping software. Be...
Location : Champaign, IL
Job Type: Full Time
Job Number: DB ADMIN - JAN 2024
Department: METCAD, Champaign County 9-1-1
Opening Date: 01/19/2024
Description
Are you an Information Technologies expert looking for an opportunity to use your talents and skills to improve the quality of life for the residents of our community and support local public safety agencies? Then consider applying to be a Database Administrator at the Metropolitan Computer Aided Dispatch Center (METCAD 9-1-1).
Responsibilities of Position
The Database Administrator is part of a team of professionals responsible for ensuring the 9-1-1 emergency response services provided by METCAD 9-1-1 are available to residents and first responders 24/7/365. They perform technical management and operational maintenance of all database and related computerized information systems used by METCAD including backups integrity checks, restores, and user permissions/access. They assist with the planning, installation, and testing of new software and maintain software interfaces. The Database Administrator trains and provides technical support to internal and external end users and is a liaison with vendors. Due to the sensitive nature of METCAD's data, they keep up to date on Criminal Justice Information Systems (CJIS) and other relevant data standards regulations. They conduct research and data analysis and maintain GIS layers. The position requires on-call status with 24 hour-a-day responsibilities and the ability to respond in a timely manner during emergencies.
Required Qualifications
• Education equivalent to an associate degree in computer science, information systems, or a related field. Completed coursework without a diploma will be considered.
• Relevant certifications in database management, application support, or similar areas will be considered in lieu of an associate degree.
• Advanced database, software, or comparable administration experience such as database design, development, maintenance, administration, support, implementation, installation and/or upgrades.
• Ability to provide quality customer service and maintain effective working relationships.
• Ability to troubleshoot complex issues and convey to audiences of all technical ability levels.
• Ability to perform essential functions that require physical agility as noted in the job description, such as remain stationary for periods of time, move around inside an office, bend, turn, reach, stretch, climb, kneel, stoop, negotiate obstacles, climb ladders, lift up to 50 pounds, with or without accommodation.
• Current valid state-issued driver's license and good driving record.
Preferred Qualifications
• Experience maintaining multi-layer GIS maps using ESRI or similar mapping software.
• Experience with Public Safety computer systems or databases.
• Experience with SQL Server.
• Experience with Microsoft Excel DSS, Excel SSMS, IIS, and/or Active Directory.
Drug screening, criminal history record check, and driving abstract will be required. The annual starting salary range is $70,705 - $80,491, DOQ, plus an excellent fringe benefits package. Applications must be submitted online no later than Sunday, February 4, 2024.
Other Information
The City of Champaign is an Equal Opportunity Employer. Women, minorities and individuals with disabilities are encouraged to apply. The City of Champaign is committed to promoting a work environment and a community that values and supports diversity and inclusion. Contact the Human Resources Department at (217) 403-8770 Monday through Friday from 9 a.m. to 4 p.m. if you require an accommodation to complete this application or during any phase of the application, interview, or employment process.
The following locations offer free Internet access and assistance: Champaign Public Library, the Illinois WorkNet Center and the City of Champaign City Building.
Our mission is to provide responsive, caring, cost-effective service in partnership with our community.
These values guide our work:
Personal Integrity
We act in the best interests of the City
We behave in an ethical and legal manner
We are open and honest
We follow through on commitments
We are loyal to the City
Responsibility
We anticipate issues, problems, and opportunities
We take initiative
We act to prevent and solve problems
We take responsibility for the outcome of our actions and decisions
We hold ourselves and others accountable
Respect
We treat others in a fair, courteous, and equitable manner
We actively listen and seek understanding
We provide a direct response
We embrace ethnic and cultural diversity in the community and our workplace
We are positive and cooperative
We are willing to apologize
Teamwork
We know and respect our roles and responsibilities
We ask who needs to be involved and we involve others appropriately
We define and agree upon the goals
We collaborate to achieve organizational goals
We help others accomplish their goals
We share authority, responsibility, and credit
Results
We take pride in our work
We complete assignments and projects on time and within budget
We evaluate outcomes and seek feedback on our performance
We learn from our mistakes
We innovate
This position is classified as Non-Bargaining Unit Exempt.
HEALTH INSURANCE
The City offers employee's a choice between two excellent health insurance plans - a Health Alliance HMO or POS 3 Tier Deductible Plan.
The City of Champaign pays up to $580 of the employee (single) health insurance premium and 50 percent of the dependent premium for continuous full-time employees or 25 percent of the dependent premium for continuous part-time employees. Premiums for single employee coverage above $580 per month are shared by the employee and the City. For the 2023/2024 plan year, NBU employees contribute 1.075 percent of their salary for the HMO plan and 0.653 percent for the POS 3Tier Deductible plan of their salary. Premiums may be made on a pre-tax basis, through the City's Section 125 plan. Health insurance coverage begins on the date of hire and ends effective the date of employment separation.
Rates are available under the Fringe Benefit Summaries section on the City's website at
DENTAL AND VISION INSURANCE
Employees may purchase dental and/or vision insurance through payroll deduction. Employees pay 100 percent of the monthly premium for this coverage. Premiums for dental and vision insurance may be made on a pre-tax basis, through the City's Section 125 plan. Dental and vision insurance begins after waiting for one complete calendar month (e.g., if hire date is in the month of January, coverage begins on March 1st).
The dental plan has two options: Delta Dental Network Low Plan (PPO) and Delta Dental High Plan.
Vision insurance is provided by EyeMed.
Rates are available under the Fringe Benefit Summaries section on the City's website at
LIFE INSURANCE
The City provides a term life insurance policy equal to annual salary rounded to the next highest thousand dollars (up to a maximum of $100,000), or $30,000, whichever is greater. Employees may elect to purchase voluntary supplemental life insurance for themselves up to 5x their annual salary or $500,000 (whichever is lower), through payroll deduction. Employees may also purchase term life for their spouses/dependents.
• Employee voluntary supplemental life insurance coverage can be purchased in $10,000 increments and the price is calculated based on the employee's age.
• Employees may purchase voluntary supplemental life insurance for their spouses up to half the amount purchased for themselves in $5,000 increments. Cost is calculated based on the employee's age.
• Employees may purchase voluntary supplemental life insurance for their dependent children in the amount of $10,000 for any/all eligible children.
• Employees may purchase Basic Life Insurance for their spouse and eligible dependent children.
o Option #1: $3.60/month for $10,000 for spouse and $5,000 for any/all eligible children.
o Option #2: $1.80/month for $5,000 for spouse and $2,000 for any/all eligible children.
PENSION
Illinois state law requires that eligible municipal employees be covered by the Illinois Municipal Retirement Fund (IMRF). Employee contributions to IMRF are 4.5 percent of salary and are tax-deferred. For 2023, the City contributes 7.42 percent of eligible employee's salaries to IMRF. In addition, IMRF members are covered by Social Security (FICA). Obtain additional information by contacting IMRF at 1-800-ASK-IMRF. Employees are eligible to contribute additional funds to IMRF through Voluntary Additional Contributions. Contact HR for details.
RETIREMENT HEALTH SAVINGS (RHS)
A retirement health savings plan administered by the Mission Square Retirement Corporation has been established for NBU employees. NBU employees participate in a mandatory contribution of 1 percent of pre-tax salary into an RHS investment account. This account is available for use by the employee at retirement or separation of service. Eligible uses of the funds include medical expenses such as health insurance premiums, dental/vision expenses, coinsurance, and co-pays for employees, spouse, and/or dependents. Note: Upon separation, a mandatory 50 percent of accrued vacation, compensatory and payout-eligible sick leave will be contributed to your RHS balance.
HOLIDAYS
New Year's Day
Martin Luther King, Jr.'s Birthday
Memorial Day
Juneteenth
Independence Day
Labor Day
Veterans Day
Thanksgiving Day
Friday after Thanksgiving
Christmas Eve
Christmas Day
PERSONAL LEAVE
At the beginning of each fiscal year July 1st, continuous full-time employees are credited with three personal days (24 hours); personal days are pro-rated for continuous part-time employees. Personal leave may not be accumulated and carried over into the next fiscal year. Personal leave during the first year of employment varies based on the date of employment.
VACATION
Vacation accrual rates are based on years of service and pro-rated for part-time employees. Vacation may be taken after six months of employment. Requests for leave to be taken during the initial six months of employment must be approved by the employee's supervisor and may be permitted through a combination of personal leave, unpaid leave, flex time, and/or compensatory time.
SICK LEAVE
Continuous full-time employees accrue sick leave at the rate of 3.69 hours per pay period (approximately 1 day per month); sick leave accrual is pro-rated for continuous part-time employees. The maximum accumulation of sick leave is 1,200 hours. T
LONGEVITY PAY
Employees receive longevity pay based upon their years of continuous employment with the City. Longevity pay is an addition to the employees' base wage rate.
CREDIT UNION
Employees may join the Credit Union I. Payroll deduction for savings and credit union loan payments are available as well as a deduction for a savings bond program and Christmas Club. Additional information can be obtained by contacting the Credit Union directly at (800) 252-6950.
DEFERRED COMPENSATION PLAN
The City of Champaign offers employees the opportunity to participate in a tax-deferred annuity plan of the Mission Square Retirement Corporation through payroll deduction. This is an optional plan with no City contributions. More information may be obtained by contacting Client Services (1-800-669-7400).
01
Please select the option below that best describes your highest level of education.
- High school diploma or equivalent
- Associate degree or higher
02
If you selected "Associate degree or higher" to the question above, please state the type of degree and major and/or field of study.
03
If you selected "High school diploma or equivalent" to question #1, please describe your relevant experience and training that demonstrates your qualifications for this position.
04
List any certifications you have earned in database management, application support, or similar areas. Please provide the certification name and issuing agency/organization.
05
Select from below the areas in which you have advanced database or software professional work experience. Check all that apply:
- Maintenance
- User Permissions Management
- Administration
- Support
- Implementation
- Installation
- Upgrades
- None of the above
06
Please describe your professional work experience in the areas checked above. Enter N/A if you selected "None of the above."
07
Please describe your experience with helping end users with troubleshooting issues. Enter N/A if you have no experience in this area.
08
Please describe your experience with conduct training to end users. Enter N/A if you have no experience in this area.
09
Please describe your experiences and abilities troubleshooting complex software issues both internally and working with software vendors.
10
Do you currently possess a valid state-issued driver's license? Y/N
- Yes
- No
11
Are you able to perform the duties of the job, including remaining stationary for periods of time, move around inside an office, bend, turn, reach, stretch, climb, kneel, stoop, negotiate obstacles, climb ladders, lift up to 50 pounds with or without accommodation? Y/N
- Yes
- No
12
This position requires 24-hour on-call duty, including physically responding to METCAD facilities for emergency system response with little or no notice within a timely manner. Are you willing and able to fulfill this job duty? Y/N
- Yes
- No
13
Please describe your working knowledge of and experience with maintaining multi-layer GIS maps using ESRI or similar mapping software. Be...
