Responsible for the support, development, and ongoing maintenance of Work and Asset Management applications within Engineering and Property Management.
Design and develop tools to extend our Work and Asset management applications.
Customize interface behaviors.
Complete screen/application design and workflow to satisfy functional requirements.
Create automated processes for data management.
Troubleshoot application database and GIS database issues as they arise.
Interpret customer needs into application functionality.
Develop aggregate reporting datasets.
Perform maintenance of existing applications and interfaces with customers regarding issues.
Website development, administration and site deployment.
Keep abreast of new technology and software.
Performs other duties as assigned.
Associate’s Degree and five (5) years of related experience, a Bachelor’s Degree and three (3) years of experience or equivalent combination of education, work experience, and relevant industry/job specific knowledge, skills, and/or certifications may be considered. Related experience must be as a database developer/administrator using Microsoft SQL Server and experience with Microsoft Visual Studio and Visual Basic for Applications (VBA).
Microsoft SSRS (Reporting Services).
HTML web page language (HTML5 a plus).
Experience with Microsoft Visio.
Experience with Microsoft PowerPoint.
Experience with Microsoft TFS and/or Microsoft VSS (Visual Source Safe).
Experience managing ArcGIS Server/ArcSDE in an enterprise environment; experience with asset management systems (Azteca Cityworks) to support utilities/public works/engineering applications.
Knowledge, Skills and Abilities:
Advanced experience managing ArcGIS Server/ArcSDE in an enterprise environment; experience with asset management systems (Azteca Cityworks, Hansen) to support utilities/public works/engineering applications.
Ability to consider the business implications of the application of technology to the current business environment (and/or future business environment), to think strategically, to form and define system scope and objectives based on user needs, to work in some (or most) phases of systems analysis.
Knowledge of how to devise or modify procedures to solve moderately complex information systems problems.
Ability to complete screen/application design and workflow to satisfy functional requirements.
Knowledge of Microsoft Reporting Services, SQL Server, server and workstation operating system environments.
Knowledge of SDLC (requirement, design, implement, testing, documentation, and support), software testing and quality assurance, client-server technology and applications, analysis and trouble shooting skills, troubleshoot database components and functionalities.
Skills in writing business, functional and technical requirements.
Minimum of five (5) years of experience as a Database developer/administrator using Microsoft SQL Server writing/debugging/testing stored procedures, writing/managing SQL Server Agent jobs, and knowledge of database administration, including database creation, security, replication, performance tuning, and best-practices for maintenance, database tools.
At least five years of experience with Microsoft Visual Studio, stand-alone applications development in VB.Net and/or C#.Net, implementation, installation and testing.
Five years of experience in web site development, creation/administration, and site deployment (VB.Net and/or C#.Net).
Experience with Visual Basic for Applications (VBA). Experience with Microsoft Access required; other Microsoft Office applications beneficial.
Fluency in Microsoft Word and Excel.
Must be proficient in the Microsoft Visual Studio development arena using SQL Server to build stand-alone applications, web site applications, web services, and SQL Agent jobs.
Must be both self-sufficient and able to work in a team environment.
Able to demonstrate good interpersonal skills; be able to interact with customers for applications requirements, training, and maintenance.
Self-motivated and demonstrate an ability to innovate solutions to department problems.
Exhibit an ability to perform timely and effective maintenance of existing applications and to easily interface with customers having difficulty using these applications.
Demonstrate a desire for continuing education in technology, software, and techniques to beneficial to department users.
Up to market rate of $108,456 Depending On Qualifications.
How to Apply:
If you need assistance completing your online application, you are welcome to visit the City of Charlotte Human Resources Department lobby where we have workstations available. Our office is located at 700 East 4th Street, Suite 200, Charlotte, NC 28202. Our hours are Monday through Friday, 8 a.m. to 5 p.m. (EST), excluding official City holidays. Anyone seeking an accommodation to apply for a job may call (704) 336-2285 for assistance or you may email questions to firstname.lastname@example.org.
Conditions of Employment:
The City’s Background Check Policy requires background checks to be conducted on final internal or external candidate(s) applying for any position with the City of Charlotte. The type of information that will be collected as part of a background check includes, but is not limited to: reference checks, social security verification, education verification, criminal conviction record check, and, if applicable, a credit history check, sex offender registry and motor vehicle records check.
Background checks must be in compliance with all federal and state statutes, such as the Fair Credit Reporting Act (FCRA). The checks must be consistent with the guidelines set forth by these laws requiring organizations to obtain a candidate’s written authorization before obtaining a criminal background report, motor vehicle records check or credit report; and to properly store and dispose of information derived from such reports.
Final candidates must pass a pre-employment drug-screening test. During the selection process, candidates may be asked to take a skills test, and/or participate in other assessments. Some positions may require the ability to obtain a City Driving Permit. Candidates may also be required to pass a physical examination, polygraph exam, other skill evaluations and background check screens.
The City of Charlotte is an Equal Opportunity Employer.