JOB SUMMARY

As the Spatial Database Administrator, you will provide ArcGIS Enterprise Geodatabase administration and development for the design, enhancement, implementation and operational readiness for MnDOT’s Enterprise Geodatabases. This role provides primary administration spatial data warehouse design, operational standards, and recommends tools to manage data lifecycle and integration. This position works closely with ArcGIS administrators, database administrators, server administrators, spatial data owners, and end users. This position also supports extract, translate, and load (ETL) processes and procedures working with Oracle, SQL Server, PostgreSQL and their associated PL/SQL languages.

This position requires an employee to be onsite at 395 John Ireland Blvd, St. Paul, Minnesota at least 50% of the time, with some opportunity to perform work from a telework location.

• Telework for Minnesota IT Services is available on a limited basis.
• Candidates residing within 50 miles of the work address listed above are eligible for telework.
• Candidates residing 50 miles or more in Minnesota from the work address listed above may be eligible to telework more than 50%. Finalist requires an additional review prior to telework approval.
• Candidates residing 50 miles or more from the work address in a state bordering Minnesota (Iowa, North Dakota, South Dakota, or Wisconsin) are not eligible to be hired, unless planning to relocate within 50 miles of the work location in Minnesota or more than 50 miles in Minnesota.

MINIMUM QUALIFICATIONS

Candidates must clearly demonstrate all of the following qualifications in their resume. Resume tips here.:
This position requires a minimum of four (4) years of IT related experience providing GIS support and development of data with ESRI desktop software ArcGIS.

Experience must include:

• Extensive expert skills with the ESRI ArcGIS suite of software, including ArcGIS Server, SDE repositories, ArcGIS client, and ArcGIS Online
• Extensive Python programming experience in an ESRI ArcGIS environment
• Expert experience of Common Relational Database Techniques and Platforms
• Demonstrated experience of ETL (Extract, Transfer, and Load) of spatial and standard tabular data, including demonstrated experience administering and supporting common ETL platforms and commercial tools such as FME, informatica, and ESRI
• Demonstrated experience supporting application, data, and web service developers with data development services, including systems and process documentation.
• Customer service skills that include active listening, empathy, and problem-solving.
• Ability to deliver effective verbal or written messages that facilitate mutual understanding.

A master’s degree in Information Technology or an IT related field substitutes for three (3) years of experience, OR an IT related bachelor’s degree substitutes for two (2) years, OR an IT related associate’s degree substitutes for one (1) year.

PREFERRED QUALIFICATIONS

• Knowledge of MNIT’s services, standards and processes.
• DBA Experience on Oracle, SQL Server, or PostgreSQL.
• Python Scripting against ArcGIS APIs in the automation of geoprocessing and ArcGIS server administration. This includes demonstrated experience using code management systems for storing, versioning and tagging Oracle objects and code.
• Extensive knowledge of computer systems concepts and the techniques of systems analysis.
• Expert experience in IT business analysis for potential solutions.
• Experience estimating development costs.
• Experience developing a comprehensive system and software test plans.

ADDITIONAL REQUIREMENTS

It is the policy of Minnesota IT Services that a successful candidate must pass all legally required checks prior to employment which may consist of the following:

• SEMA4 Records Check (applies to current and past state employees only).
• Criminal History Check
• Reference Check
• Social Security and Address Verification
• Education Verification
• Driver’s License Record Check
• Other legally required checks

Minnesota IT Services does not participate in E-Verify. Minnesota IT Services will not sponsor applicant for work visas, including F-1 STEM OPT extensions. All applicants must be legally authorized to work in the United States.

APPLICANTS WITH DISABILITIES

Minnesota state agencies make reasonable accommodations to their employees and applicants with disabilities. If you have a disability and need assistance in searching or applying for jobs with the State of Minnesota, call the Careers Help Desk at 651-259-3637 or email careers@state.mn.us and let us know the support you need

At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities.
Join the 2,800+ professionals of Minnesota IT Services (MNIT) who connect Minnesotans to services that will improve their lives in government IT. This position serves our partners at the Minnesota Department of Transportation (MnDOT). MNIT MnDOT supports an agency with technology integrated into all areas of business. From business intelligence and solutions for critical transportation infrastructure to planning and operating a safe, efficient, and reliable multimodal transportation system, the team connects people and markets across Minnesota.