The URL can be used to link to this page

Home My WebLink About102-08 RESOLUTIONRESOLUTION NO. 102-08 A RESOLUTION TO APPROVE THE HIRING OF REPLACEMENT EMPLOYEES BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF FAYETTEVILLE, ARKANSAS: Section 1: That the City Council of the City of Fayetteville, Arkansas hereby approves the hiring of replacement employees for the following positions: (A) One Database Administrator position; (B) One Police Dispatcher PASSED and APPROVED this the 6th day of May, 2008. APPROVED: By: DA COODY, Mayor ATTEST: ......JTRf9.... .U• •�; FAYETTEVILLE: • e.,;,91,97iy �o ''., GTOt ,, By: ardIALI C 2 IVL17/6 SONDRA E. SMITH, City Clerk/Treasurer • • aye eyi.le DEPARTMENTAL CORRESPONDENCE TO: Mayor Dan Coody and Members of the City Council FROM: Paul A. Becker, Finance Director DATE: April 30, 2008 SUBJECT: Permission to Fill the Database Administrator Position Our current Database Administrator (Scott Caldwell) has submitted his resignation effective May 7, 2008. I am requesting to fill that position as soon as possible. Scott has been with the City for 12 years and his absence will create a void within the department. This position is responsible for the installation, creation, operation and maintenance of all hardware and software related to City database systems. Database systems collect, organize, store data and provide for reporting of that data. Examples include: Hansen Municipal Management system, District .Court software, GIS Spatial database systems, Document Management systems, Fleet Management systems, Access Fayetteville and City Net. These systems are varied and are utilized by almost every City employee on a daily basis. The Database Administrator must maintain a stable environment for City Business operations which ensures the security, backup and recovery of millions of records stored in the various databases. The Database Administrator must have the ability to troubleshoot complex hardware and software issues relating to database issues. The position must also provide interface programming among applications. In summary, the responsibility of the Database Administrator requires a unique combination of specialized skill, training and experience to be successful. We do not have personnel currently available in the IT division with background or time to absorb these responsibilities I believe the ramifications associated with not replacing this position would be severe. Therefore, I respectfully request permission to fill this position as soon as possible. Please find attached the Position Description for the Database Administrator for your review. Tim tayet !t ARKANSAS B CITY OF FAYETTEVILLE Position Description POSITION TITLE: Database Administrator EXEMPT (Y/N): Yes SUPERVISOR: IT Manager CITY/EEOC/JG CODES:366/U5 Job Grade: 120 DEPARTMENT: Finance DIVISION: Information Technology DATE REVISED: May 2007 ESSENTIAL DUTIES AND RESPONSIBILITIES: Note: All City of Fayetteville positions require the employee to provide good customer service to both internal and external customers, maintain positive and effective working relationships with other City employees (especially members of his or her own team), and have regular and reliable attendance that is nan- disruptive. Other essential duties of this position include the following: 1. Install, configure, administer and tune database management system software. Monitor system performance, implement changes as necessary. 2. Analyze business service areas and develop conceptual and logical information and database models to be used for actual information system databases. 3. Provide implementation, architecture, and operational support of purchased database application software, including financial management systems and work management systems.. - 4. Develop and maintain integration and interfaces among the City's Relation Database Management Systems (RDMS). 5. Develop and implement database backup and recovery plans. 6. Research and analyze complex technical problems, database -related system errors, or application software problems. Isolate problem areas. Recommend and/or develop and implement solutions. 7. Develop and implement physical database designs to ensure efficient and reliable information access. 8. Work with users and other IT staff to develop detailed data models; provide guidance and expertise in the development of database models. 9. Research and analyze upgrades and service packs of database management and operating system software. Recommend, install, or participate in installation of upgrades and service packs on multiple servers. Assists with preparing applications for upgrades when necessary. 10. Maintain development, test, and production RDBMS environments. Database Administrator May 07 coded.doc 1 10/19/2007 • 11. Create procedures and maintain various database related documents such as manuals and programmers handbooks. 12. Participate in design and support of regional shared databases, including geographical (GIS) data. 13. Research current and future trends in computer technology generally, and database technology specifically. Provide expertise and direction on the appropriate application of new database technology. 14. Implement and administer advanced SQL Server functionalities such as Data Transformation Services, Replication Services, SQL Server Job Scheduling. 15. Perform other related duties as assigned. SECONDARY DUTIES AND RESPONSIBILITIES include the following: 1. Secondary duties as assigned. MINIMUM QUALIFICATIONS I. Bachelor's degree (B.A. or B.S.) from four year college or university and three years of database administration experience. 2. Effectively communicate with others orally and in writing. 3. Thorough knowledge of Enterprise level servers, disk storage sub -systems and/or other related software programs. 4. Must have extensive knowledge of principles and processes of relational data base management and development, structured system analysis/design and programming, computer hardware/software and database management system software as well as operating systems and network capabilities. Database tools and design techniques. Computer programming languages used for personal computers, web based applications, and client server applications. 5. Must be proficient in the use of a personal computer and other related software programs. Must be able to effectively operate standard office equipment. 6. While performing the functions of this job, the employee is regularly required to communicate with others. The employee frequently is required to move from location to location; use hands to finger, handle, or feel; reach with hands and arms. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities to accomplish computer and office work. Database Administrator May 07 coded.doc 10/19/2007 • Wet evle ARKANSAS Departmental Correspondence yrr Fayetteville Police Department I fuaZ� 100-A West Rock 1 Fayetteville, AR 72701 M 124- 42 Telephone: (479) 587-3555 l ��ocS Fax: (479) 587-3563 To: Mayor Dan Coody and Members of the City Council From: Greg Tabor, Chief of Police iiYb`l� Date: May 2, 2008 Re: Replacement of Dispatcher • Recommendation: City Council approves the hiring of one (1) dispatcher to replace a recent termination. Background: On January 4, 2008, the Fayetteville City Council approved a hiring freeze for replacement employees funded by General Fund. This hiring freeze allowed replacement of these positions with Council approval. Discussion: The Fayetteville Police Department Central Dispatch currently has 18 authorized dispatch positions. We are currently training three dispatchers for the Night Shift and this vacancy is for that shift also. We have been covering this shift by using Shift Supervisors, Trainers and dispatchers from other shifts. It takes us six months to train a new dispatcher and any delay could cause a critical situation for this shift. Budget Impact: This is a budgeted position. ________- 11(5.7.08) Clarice Pearman - Hiring Freeze 2008.xls Date Approved/Rejected Comments Page 1 `ire Fighter 'ire Department .: Tony Johnson 2008 Hiring Freeze City Council Meeting Position Department Submitted By ,-. Appro./eel/Rejected Date Approved/Rejected Comments 15, 2008 `ire Fighter 'ire Department .: Tony Johnson Approved January 15 2008 January 15,2008 rite Fighter 9re Department `cony Johnson Approved January 15, 2008 Missy Cellar January 2008 Fire Fighler Ire Department Tony Johroon Approved January 15 2008 Approved January 15, 15, 2008 'olios Officer ?dice Department area Tabor Approved January 15, 2008 January . ...-- eebmery 5, 2008 dim Ommf- �erIts : ,- Police Department '-Greq - .. _ - Tabor .. .- .Approved •- . _� : - : -' February 5,2008 .- - TN8 - clition was reconsidera February po reconsidered -at the 19,-2008 City Camel] meetbrp 5, 2008 arks Petrol Polito Department Grog Tabor Approved eebruary 5, 2008 periled - February =ebmery 5, 2008 AnalsleM Animal Services Jill Hatfield Ppproved =ebmery 5 2008 Missy Cellar February lice Olspettlror ?dice Deparbnent 'ollce Department Grey Tabor ,3reg Tabor Approved Approved =ebmary52008 =ebniary 5, 2008 Approved 5, 2008 tice Officer February 2008 Police Dispatcher belice Department Greg Tabor Approve0 February 19, 2008 ApII 15, 2008 Senior Legal Assistant February 18, 'arcs Patrol .'dice - Department _ Greg Taber. - periled - - February 19, 2006 This position was approved Febdlery 5, 2008. The City Council moved to reconsider the position end the position was denial. 41 February 19, 2008' Administrative Assistant - Secretary Animal Services Officer Animal Services Jill Hatfield Approved Avarch 18, 2008 ApII 15, 2008 Senior Legal Assistant March 18, 2008 Animal Services Caregiver Animal Services Jill Hatfield Approved arch 18, 2008 - Mardi 18, 2008 Administrative Assistant -lumen Resources Missy Cellar Approved arch 18, 2008 Animal Services Caregiver -Full Time March 18, 2008 Jill Hatfdtl Approved - Secretary sty Proseoaafs Office Casey Jones Approved April 15 2008 ApII 15, 2008 Senior Legal Assistant City Prosecutor's Offs Casey Jones Approved April 15, 2008 Apia 15, 2008 Animal Services Caregiver -Part Time Animal Services Jib Hatfield Approved April 15, 2008 April 15, 15, 2008 Animal Services Caregiver -Full Time Anlmel SeMces Jill Hatfdtl Approved Apn 15, 2008 April 15, 2008 �mlNslrelor 4 6, 2006 _ - olpm Department Greg Taborf Approved rytay 6. 2008 jNay 6, 2008p'watcher Page 1 of 1 Clarice Pearman - Res. 102-08 Hiring Freeze Appeals From: Clarice Pearman To: Becker, Paul; Langehennig, Sherrie; Leflar, Missy; Tabor, Greg Date: 5.9.08 11:35 AM Subject: Res. 102-08 Hiring Freeze Appeals CC: Audit Attachments: Audit Ladies & Gentlemen: Attached is a copy of the hiring freeze appeals resolution for the following positiions: 1. Database Administrator 2. Police Dispatcher Please let me know if there is anything else needed. Have a good day. Thanks. Clarice file://C:\Documents%20and%20 S ettings\cpearman.000\Local%20 Settings\Temp\XPgrpwise\482436E4FA... 5.12.08