Social Services Administrator

About the role

This position is General Exempt and is covered under Personnel Policies and the Administrative Code.

Responsibilities

• Reviews, develops, and designs data models using standard diagramming techniques, in conjunction with application development teams;
• Creates logical data models and translates into physical database structures that integrate with existing or proposed database structures;
• Maintains development, test, and production RDBMS environments;
• Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required;
• Works with network personnel on issues of hardware/software that affect the City’s data and/or databases;
• Creates, procures, and maintains various database related documents such as manuals and programmers handbooks using technical writing skills;
• Tests programs or databases, corrects errors and makes necessary modifications;
• Provides technical support to end-users;
• Affords technical support to managers with the coordination and implementation of in-house training classes.

Requirements

• Minimum Training & Experience: Bachelor's degree; at least 2 years of experience that is directly related to the duties and responsibilities specified.
• Current experience with one or more of the major database management products preferred: Structured Query Language, SAP, HTE, or Oracle-based database management software.
• Structured programming background preferred.
• Experience working with IBM AS400 preferred.
• Experience in municipal government preferred.
• Experience in RPG programming, GIS and Computerized Maintenance Management Systems is helpful.

Qualifications

• Required Education: Bachelor's Degree in Computer Science.
• Required Experience: 2 to 3 years of experience in database administration.
• Preferred Experience: Previous municipal government experience, experience in RPG programming, GIS and Computerized Maintenance Management Systems, experience working with IBM AS400.

Skills

• Structured programming background.
• Experience working with IBM AS400.
• Experience in RPG programming, GIS and Computerized Maintenance Management Systems.
• Experience in municipal government.
• Experience with Structured Query Language, SAP, HTE, or Oracle-based database management software.

Benefits

• Health Insurance: HDHP, OAPIN and OAP through Cigna.
• Dental Insurance: DHMO & PPO High/Low plans.
• Vision Insurance: Annual eye exam, frames and lenses or contact lenses in lieu of eyeglasses.
• Life Insurance: One time their annual base salary.
• Dependent/Spouse Life Insurance: $5,000 per dependent.
• Short Term Disability: 66 2/3% of employee's annual base salary during a short-term disability period not to exceed 26 weeks.
• Long Term Disability: 66 2/3% of employee's salary at time of disability after a 180 consecutive day waiting period.
• Defined Contribution Retirement Plan: City contributes a base of 3%, employees may contribute up to 6% and the City will match the employees contribution.
• Holidays: 10 holidays and 1 birthday holiday.
• Paid Leave: 96 hours of vacation and sick leave per year, accrued after 10 years of service.
• Administrative leave for exempt employees – 48 hours per year.

Pay

Salary range: TBD

Schedule

Shift work may be required.