100% Remote|| SQL Developer/database developer @MN

Job Description:

Potential Assignments are:

• Improving maintenance scripts that handle address hierarchy, parent/child relationships, and address history/lineage
• Improving spatial SQL scripts related to GIS boundary data and topography using the SQL Server Geometry datatype.
• Reconcile address and parcel datasets received from external partners and develop procedures to automate reconciliation.
• Integrate addressing system with consuming business systems.

Skills Required

• Demonstrated expertise in development of database structures and data modeling
• SQL and Spatial SQL expertise is required. In particular, experience with SQL Server geometry data type.
• Some experience in developing in Python.
• Experience with Azure DevOps or Team Foundation Server

Deliverables:

• The developer will need to provide technical documentation on any automated processes and scripts created.
• The developer will participate in design and code reviews with City IT.
• The developer will maintain any developed source code in City IT’s source control repository (Azure DevOps).