Overview

Job Appointment: Full Time, RegularWork Schedule: Monday - Friday, 8:00 AM - 5:00 PM. Alternate schedules may be available.Work Location: This position has an exception to work primarily remotely. However, there will be instances when it is necessary to come onsite for work (with as much advance notice as possible). Remote work must be performed within Oregon or Washington. For more information, click here . Benefit: Please check our benefits tab for an overview of benefits for this positionUnion Representation: This position is represented by Professional Technical Employees, Local 17 (PROTEC17). To view this labor agreement, please click here .Starting Pay: The City of Portland follows the Oregon Equal Pay Act. Your salary is determined based on the experience listed in your resume that is directly related and equivalent to the position for which you are applying. Position Summary: The Bureau of Technology Services (BTS) Enterprise Geospatial and Data Services Team , seeks an experienced and skilled Geographic Information Systems (GIS) Enterprise Spatial Applications Developer to support and maintain the organization's GIS technology stack, with primary responsibilities for SQL Server-based spatial geodatabases under the Esri ArcGIS Platform and occasional development of web and desktop geospatial solutions. The Enterprise Spatial Applications Developer will be responsible for providing support for enterprise geospatial databases in SQL Server and GIS platforms, including spatial geodatabase development, geospatial data management, data architecture, application configuration, migration, automation, integration and technical troubleshooting to enable and support data-driven decision-making across the organization. This position combines SQL development, integration development, GIS application development and spatial analysis to deliver scalable, secure, and high-performing geospatial solutions. The role collaborates with cross functional IT teams, and GIS professionals to analyze business requirements, develop custom geospatial and data related applications and integrations, develop administer enterprise geodatabases, optimize processes and applications performance, and ensure data integrity and availability. The incumbent supports and maintains enterprise relational geospatial databases, develops complex SQL queries, stored procedures, and automated data workflows. The ideal candidate has experience with enterprise GIS platforms, relational databases systems, SQL programming, overall geospatial databases support and maintenance, and application development. This position requires strong analytical and problem-solving skills, the ability to manage multiple priorities, and a commitment to delivering reliable, innovative geospatial solutions that support organizational objectives. What You'll Do: Maintain, and support enterprise geospatial databases in a RDBMS Server environment (currently SQL Server), including schema development, data integrity, versioning, code development, code optimization, and code troubleshooting.Design, implement, and support geospatial data models including data migration, quality assurance, and developing and improving customized legacy scripts related to SQL Server stored procedures, functions, views, Python applications, SSIS packages for data imports and exports, and other ETL processes.Maintain overall applications stability in Enterprise RDBMS environments (currently SQL Server).Engage with project managers and other developers and analysts on larger efforts and perform project management tasks for smaller internal projects. Lead technical support and troubleshooting of spatial data, code development, and application issues.Assist SQL developers as needed with query tuning and optimization, other developers and analyst supporting spatial related applications. Author, update, and peer review documentation including standards, procedures, diagrams, applications, coding and management information.