Social Services Administrator

Minimum Training & Experience Bachelor's degree; at least 2 years of experience that is directly related to the duties and responsibilities specified. A degree in Computer Science and on-the-job training with a particular database product or more extensive experience with a range of database products, preferably in a government setting, or any equivalent combination of training and experience which provides the required skills, knowledge, and abilities. 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. Possession of a valid Florida Driver’s License with an acceptable driving record and maintain an acceptable driving record.

EMERGENCY DECLARATION STATUS

Non-essential employees will not be required to work during a declared emergency but may be required to work during an undeclared emergency or in the aftermath of an event associated with a declared emergency. On an incident by incident basis, the employee’s Department Head will make the determination when the employee will be required to work and if they are re-assigned based on the needs of the City.

GENERAL STATEMENT OF JOB

Under general supervision, performs specialized professional and technical work to design, implement, and maintain relational database management systems (RDBMSs) that support municipal business applications. Ensures logical data models are mapped effectively and efficiently into physical data models that take advantage of the characteristics of the specific database management system used. Responsible for technically supporting multiple databases that run city-wide business applications which are accessed by multiple departments. Employee is responsible for designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. Employee is expected to stay abreast of emerging technologies and new design approaches with respect to relevant state-of-the-art technology, equipment, and/or systems. Employee must exercise initiative and independent judgment in all phases of work. Reports to assigned supervisor.

SPECIFIC DUTIES & RESPONSIBLITIES

Essential Job Functions 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.

Monitors relational databases to optimize database performance, resource use, and physical implementations of databases; addresses a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.

Plans, coordinates, and implements security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure, to include specifying users and user access levels for each segment of the database(s).

Approves, schedules, plans, and supervises the installation and testing of new products and improvements to computer systems, such as the installation of new databases.

Establishes and calculates optimum values for database parameters, using manuals and calculators.

Maintains development, test, and production RDBMS environments.

Monitors and maintains database security and database software, in cooperation with data security administrators.

Maintains availability and integrity of databases through multiple access schemes; facilitates sharing of common data by overseeing proper key and index management and data dictionary maintenance.

Develops methods for integrating different products so they work properly together, such as customizing commercial databases to fit specific needs.

Evaluate and recommend testing and evaluation of new procedures, software, and hardware.

Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required.

Work 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.

Test programs or databases, correct errors and make necessary modifications.

Provides technical support to end-users.

Assist managers with the coordination and implementation of in-house training classes, which include determining the needed classes, developing the lesson plans, and student handouts, arranging for the use of the necessary computer equipment, and conducting the classes.

Plans, conducts, facilitates, and presents at various types of meetings

Assists in the planning and development of the budget

May be assigned to shift work. May be required to work weekends and holidays. May be required to respond to after hour calls.

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

Health Insurance: Health care plan options include HDHP, OAPIN and OAP through Cigna.

Dental Insurance: Dental coverage is offered in three plans that include DHMO & PPO High/Low plans.

Vision Insurance: Vision coverage includes an annual eye exam, frames and lenses or contact lenses in lieu of eyeglasses.

Life Insurance: The City of Palm Bay provides each employee with life insurance in the amount of one time their annual base salary at no cost. Additional coverage is available at the employee's cost up to the Guaranteed Issue amount of $250,000.

Dependent/Spouse Life Insurance: The City of Palm Bay provides each employee with dependent/spouse life insurance in the amount of $5,000 per dependent at no cost. Additional coverage is available at the employee's cost.

Short Term Disability: Coverage pays 66 2/3% of employee's annual base salary during a short-term disability period not to exceed 26 weeks.

Long Term Disability: Coverage pays 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: Accrue 96 hours of vacation and sick leave per year. Accrued vacation hours increase after 10 years of service. Administrative leave for exempt employees – 48 hours per year.

01

Do you have a valid Driver's License?

• Yes
• No

02

This position requires a Bachelor's Degree in Computer Science. Select your highest level of education.

• None
• High School Diploma, GED or Equivalent
• Some College (working on degree in Computer Science)
• Associate's Degree in Computer Science
• Bachelor's Degree in Computer Science
• Master's Degree

03

How many years of experience do you have in database administration (as described in the minimum qualifications)?

• None
• Less than 2 years
• 2 to 3 years
• 3 to 4 years
• 4 to 5 years
• 5 to 6 years
• More than 6 years

04

Select the Database products you have current experience with.

• Structured Query Language
• SAP
• HTE
• Oracle-based database mgmt software

05

Do you have previous municpal government experience?

• Yes
• No

06

Do you have experience in RPG programming, GIS and Computerized Maintenance Management Systems?

• Yes
• No

07

Do you have experience working with IBM AS400?

• Yes
• No
• Required Question