Under general direction, the Web and Database Administrator coordinates the design, development, programming, and maintenance of the City’s Internet and Intranet web sites; maintains on premise and cloud databases and related services, including the security, effectiveness, efficiency, appeal and troubleshooting of databases; and develops databases and/or web applications that are in compliance with applicable city government requirements, standards and best practices.
Duties may include but are not limited to the following:
- Strategically plan, develop, execute and manage the City website (architecture, format and design) in a way that makes it user friendly and effective;
- Design and optimize city Intranet site on SharePoint, using feedback from department leads and power users.
- Ensures the clear, comprehensive and accurate presentation of the City’s on-line presence in the Internet/Intranet web sites.
- Design, develop and maintain web site documents, templates, graphics and navigational tools;
- Work cross-functionally among City departments to determine needs and ensure web solutions are developed to address those needs;
- Collaborate with the Communications and Marketing team to ensure proper branding and messaging is integrated into the architecture and content of the web sites;
- Track, measure and report on key website metrics for effectiveness of customer engagement;
- Keep current on emerging trends to ensure optimal user experience and engagement;
- Design, develop and maintain highly available databases, developing project plans that translate department needs into technical requirements.
- Execute complete database solutions from evaluation to implementation. This may include researching and implementing “off the shelf” database applications or the development of unique in-house applications which should be protected by an appropriate authorization constraint;
- Develop and enforce data management standards and/or new development protocols that promote standards and ensure that all applications are fully compliant with applicable regulations and best practices;
- Work closely with IT peers to maintain the integrity of the city’s data through multiple access schemes; facilitate sharing of common data by overseeing proper key and index management. Monitor database backups, install, upgrade and maintain database software; restore and/or recover data as necessary;
- Create data flow and data life-cycle documentation; develop and maintain internal database documentation describing requirements, design specifications, implementation and ongoing changes in applicable procedures for use by end users as well as other network personnel.
- Developing and managing websites and web applications using open source tools, languages, libraries and current standards-compliant code;
- Web development using HTML, CSS, Drupal, WordPress, ASP, ASP.NET, VB.NET, XML, XSL, XSLT, Java Script and AJAX, PHP;
- Support requirements of large database applications and systems including performance analysis and tuning of high-volume transaction systems;
- Building and maintaining SharePoint and Team sites;
- Project management, systems analysis and design for secure web-based and database application development;
- Developing front-end applications and their connections back-end data.
- Standards such as LDAP, HTTP, RSS, ATOM;
- Common enterprise technologies and techniques including caching, locking, fail over and encryption;
- Browser devices and platform differences and idiosyncrasies;
- Different website platforms including Civic Plus, Microsoft Azure, etc;
- Database software including SQL Server and cloud-based object storage systems like Salesforce; Web applications, server, database, and web security protocols.
- Design and implement complex web services and data storage architectures;
- Design and manage relational databases;
- Develop a vision for future computing needs and to develop an implementation plan to meet those needs;
- Maintain knowledge of new and current technology and trends;
- Develop workarounds to accommodate specialized user/client needs to address compatibility issues;
- Work well independently or as a team member;
- Work under pressure, take initiative and prioritize tasks; good time-management, problem solving, and customer service skills;
- Train staff in the use web applications and operating procedures;
- Always maintain and exercise sound judgment and discretion in handling confidential information and keep sensitive information strictly confidential and secure.
EDUCATION AND EXPERIENCE
Any combination equivalent to experience and education that provides the required knowledge, skills and abilities would be qualifying. A typical way to obtain the knowledge, skills and abilities would be:
Bachelor’s degree in Computer Engineering, Computer Science, Information Systems, Digital Media, Interaction Design or a closely related field and five (5) years of progressively responsible professional level work in technology or web-based products and programs.
- Must possess a valid California driver’s license in order to travel independently within and outside City limits to fulfill assigned duties and responsibilities.
- Must successfully complete a background check, which includes fingerprinting and verification of education and experience.
Retirement: CalPERS enrollment in either 2% @ 60 (Classic Employees) or the new 2% @ 62 (New Employee) formula is dependent on the individual’s eligibility, as per AB 340. The City does not participate in Social Security therefore there are no Social Security tax deductions (except 1.45% Medicare).
Life Insurance: Premium is paid by the City. Life insurance and AD&D is equal to $100,000 each. Long-term and short-term disability insurance premium is shared by the City and employee. Additional voluntary supplemental life insurance is available.
Medical/Dental: The City provides up to $2,000/month to purchase medical, dental and vision benefits.
Leaves: 8 hours of sick leave/month with no limit on accumulation; 10 days of vacation per year for the first three years of service; 11 paid holidays per year plus 3 floating holidays.
Other: Educational Reimbursement for approved coursework; 9/80 work schedule, with alternate Fridays off. Deferred Compensation Plan available.
** Interested applicants are encouraged to apply immediately. The first review of applications will occur on November 8, 2019.**
Application and resume should be completed on-line via the CalOpps website.
Resumes will not be accepted in lieu of a completed application. Application and resume will be reviewed and evaluated using, in part, the criteria contained in this brochure.
The selection process may consist of one or more of the following components: a written exam, an oral interview, and medical exam. Only a limited number of persons whose application materials clearly demonstrate that they meet the needs of the City in terms of training, experience, education, and other job related characteristics will be invited to participate in the selection process. Meeting the minimum qualifications does not guarantee an invitation to participate in the process.
Applicants who are invited to continue in the selection process will be notified by e-mail. Successful candidates’ names will be placed on an employment eligibility list. The eligibility list will remain in effect for a minimum of one year from the date the list is established. Additional vacancies that occur for this classification may be hired from the list.
The City of Union City provides reasonable accommodations for applicants with disabilities, upon request. Please contact the Human Resources Department if you will need reasonable accommodation for any aspect of the selection process.
The City of Union City is an Equal Opportunity Employer and values diversity at all levels of its workforce.