The fundamental reason the position exists is to manage and support all County server based applications and systems. Responsible for administrating Microsoft SQL Server database administration, Microsoft Office SharePoint Server and websites and server based equipment. Essential functions of the class include managing and maintaining all databases for the application systems, direct the installation maintaining, and upgrading all server hardware and software. Assist with and work on network equipment as it relates to County application systems, databases, and websites. The position reports to the Software Systems Manager. |
The following list was developed through a job analysis; however, it is not exhaustive and other duties may be required and assigned. A person with a disability which is covered by the ADA must be able to perform the essential functions of the job unaided or with the assistance of a reasonable accommodation. The list of essential functions is to be used as a starting point to determine essential functions for a specific position at a specific location at a specific time. The ADA was intended to be applied on a case-by-case basis with the understanding that one position may differ from another similar position. The performance of "non-essential functions" is not optional for employees not covered under the ADA.
ESSENTIAL FUNCTION: Manages and monitors County's WEB Server Farm in order to provide the highest level of support and functionality for the citizens of Montgomery County.
Designs, creates and implements Microsoft Office SharePoint Server (MOSS) websites according to internal and external user requirements.
Conducts and/or attends meetings discussing user needs/ideas for Internet and Intranet resources and capabilities and makes recommendations as needed to the Software Systems Manager.
Designs and transforms concepts into web pages by formatting, coding, and linking text using various development tools such as Microsoft Office SharePoint Designer and Microsoft Visual Studio .NET development tools.
Responsible for the administration of the Microsoft Office SharePoint Server Farm and websites.
Assists and instructs end-users how to use Microsoft Office SharePoint Server for creating, updating, and publishing changes to web pages in order to keep County's website up to date, accurate, functioning, and informative.
Reads technical publications, vendor materials, and attends training in order to stay current on Web Application Development benefits, trends, and methods.
Provides direction and support to external vendors with the design and development of various e-commerce applications for County departments.
Analyzes and monitor website usage and provides feedback to County Department Heads.
ESSENTIAL FUNCTION: Performs systems analysis for all County projects of moderate size and complexity as assigned by the Software Systems Manager. Serves as team leader in designing, developing, and implementation of all County applications and systems. Provides support and assistance when necessary to programmers, technical support staff, and external vendors with any software and or server hardware issues.
Performs research and analysis of desktop and server based systems by attending end-user meetings to determine hardware and system requirements and makes recommendations to the Software Systems Manager.
Routinely monitors and analyzes exiting County systems software and hardware to achieve the desired optimum utilization of County network resources.
Prepares and maintains documentation for system software and hardware specifications regarding County supported technologies that can be used by all County department heads in preparing request for proposals (RFP's) and other ITB bid specifications.
Documents database information and software versions in order to ensure proper application compatibility.
Installs or directs the installation of new software and upgrades to existing software packages, Microsoft operating systems, and Microsoft SQL Server software.
Assists and provides direction to technical support staff and external vendors to diagnose and resolve any software and server hardware issues.
Assist Software Systems Manager in providing direction and support to programming staff on County projects.
ESSENTIAL FUNCTION: Assists in installing and maintaining new server based technology hardware, software and the LAN equipment to include personal computers, printers, server systems, and other related equipment following vendor instructions and manuals in order to provide highest level of service for all County Elected Officials and departments.
Installs, configures, and performs minor repairs or reconfiguration on computer hardware and software and provides technical assistance and training to system users.
Investigates user complaint of computer-related problems by talking to users, interpreting error messages, utilizing diagnostic tools to troubleshoot problems, restoring systems to proper operation quickly, and tracking problems and fixes to minimize repeat problems and maximizing productivity.
Assists Technical Support staff in troubleshooting problems with network components such as switches, hubs, wireless access points, and routers.
Reviews Windows Server operating system log files to ensure servers are functioning properly.
Monitors server performance in order to identify and resolve problems and maintain acceptable levels of "quality of service" (QOS) levels for all County users.
Develops and implement backup strategy plans for new applications and equipment in order to ensure recovery of lost data and information.
ESSENTIAL FUNCTION: Manages Microsoft SQL Server resources by providing technical support for the database environment including overseeing the development and organization of application databases, assessment and implementation of new database server technologies.
Analyzes and determines space requirements for application system databases to ensure adequate space is allocated prior to system implementation.
Manages Microsoft SQL Server Database servers and monitors resources to ensure optimal performance.
Responsible for Installation, configuration and upgrading of Microsoft SQL Server database software and related products.
Implements and maintains database security by managing user access, security roles and assigned privileges for all County applications and systems.
Provides server hardware recommendations and reviews all server hardware orders for accuracy to ensure system specifications are compliant with system requirements.
Maintains and implements database backup plans and disaster recovery policies and procedures.
Consults with development staff and or third-party vendors in building of the logical databases and provides technical guidance during all phases of the development process.
Investigates user complaints of server related problems by talking to users, interpreting error messages, utilizing diagnostic tools to troubleshoot problems, restoring systems to proper operation quickly, and tracking problems and fixes to minimize repeat problems and maximize productivity.
Knowledge, Skills and Abilities
Knowledge of Database Administration for Microsoft SQL Server (MSSQL) including capacity planning.
Knowledge of troubleshooting and resolving MSSQL database problems including the use of Performance Tuning and Optimization (PTO), native monitoring and other various troubleshooting tools.
Knowledge of MSSQL Experience with backups, restores and recovery models to include High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
Knowledge of MSSQL indexes, index management, and statistics to provide maximum optimization of SQL queries.
Knowledge of SQL databases as needed to monitor databases for performance, ensure proper interfaces with various user applications.
Knowledge of Internet Software to include usage, function and maintenance as needed to provide Internet communication for users.
Knowledge of Web Page design utilities as needed to design and set up web pages.
Knowledge of Microsoft based technologies such as SharePoint Server to design, develop, and configure websites for County Elected Officials and Departments.
Knowledge of Google Analytics services to analyze and monitor website usage and provide feedback to County Department Heads.
Knowledge of Internet Information Server as needed to assign an IP address to a Domain Name Server to be published on the Internet.
Knowledge of Domain Name Server as needed to assign standard naming conventions to County server hardware.
Knowledge of IP sub-netting needed to assign multiple IP addresses to network interface cards.
Knowledge of domain infrastructure to include naming conventions of the Internet as needed to resolve any name to IP conflicts.
Knowledge of LAN protocol and IP addresses as needed to assign addresses and install networks.
Knowledge of network transmission methods and protocols to include Ethernet switches and routers.
Knowledge of various functions of departments in Montgomery County government as needed to understand users' requests, design computer systems, and help users with problems, questions, and concerns.
Knowledge of PC diagnostic utilities as needed to troubleshoot personal computer problems.
Knowledge of communications hardware and software systems and how they can be best utilized by County Elected Officials and Departments.
Knowledge of the operation of a personal computer to include keyboard layout, how to reboot a computer, how to clear and move between screens, passwords, and function keys as needed to troubleshoot problems, enter data and access information.
Skill at upgrading personal computers to include installing, reconfiguring, formatting, and restoring various application software, hard drives, network cards, printers, hardware or operating systems components as needed to increase the capability of the system.
Skill in verbal communications to include being clear and concise, breaking technical jargon into lay person's terms and adjusting communication to the level of the listener as needed to advise users and Information Systems staff.
Skill in listening to, understanding and advising other employees, personnel, and users on various issues to include problems with PCs, installations, procedures and missed communication as needed to isolate and resolve the problem.
Skill in resolving problems through the collection and the evaluation of information, isolating a specific problem and determining a logical, appropriate course of action to include the realization that data is missing, information has been omitted or the inability to retrieve information as needed to locate the data, include the information or recover the information.
Ability to read blueprints and logic diagrams as needed to interpret network diagrams and IP addresses and ensure addresses are correct.
Ability to interact with users, Information System employees and Director to include listening, being courteous, tactful and being rational.
Ability to read and comprehend text found in technical manuals and publications including using internet resources for comprehensive research analysis.
Ability to work independently with limited supervision to include weighing consequences of actions or making decisions, time management and prioritization of work as needed to complete work within time constraints and perform on-call work.
Ability to handle multiple tasks simultaneously to include interruptions, complaints and various assignments as needed to prioritize work, answer questions either by telephone or in the office, provide information and return to work immediately.
Ability to understand and carry out oral and written instructions to include verbal requests and memos as needed to work on special projects and comprehend assignments and discussions in regard to the needs of the department.
Ability to research various information to include technical resource manuals, and or instructions as needed to troubleshoot installation and configuration problems.
Ability to lift and maneuver heavy objects (up to 40 lbs.) such as laser printers, paper boxes, and computers as needed to relocate or install equipment and supplies for users.
Bachelor's degree in Computer Science or closely related field, and five (5) or more years experience in Microsoft SQL Server database architecture and applications design and analysis using Microsoft.NET based programming languages to include Visual Basic or C#; web development tools including ASP.NET; and report design software including Crystal Reports or SQL Server Reporting Services preferably for a windows-based system or an equivalent combination of education and experience.
Employees in this class must be willing to work extended hours for emergencies such as system failures.
City of Montgomery, AL - 12 months ago