Database Administrator Senior/Lead

Maricopa County • Phoenix, AZ

2d • Hybrid

About The Position

The GIS Database Administrator Sr. is responsible for industry standard geospatial databases and ensuring the integrity of the County’s geospatial data infrastructure. In addition, this position researches, designs and develops data warehouses and extract, transform, load (ETL) processes. We are not afraid to get our hands on new technology and systems, and we are willing to take the time to study and learn from others. The environment is challenging, but we balance the challenges with rewards, and are looking for clever and innovative people to join us.

Requirements

• Four years of related professional level experience involving geospatial database, design, development and administration on an enterprise database management system (DBMS) such as SQL Server, Oracle or PostgreSQL
• Bachelor’s degree in Computer Science, Information Technology, Geographic Information Systems or a closely related field
• A combination of post-secondary education and/or job-related experience may substitute for the minimum qualifications on a year-for-year basis

Nice To Haves

• Experience building and maintaining ETL processes using industry-standard tools such as Python, FME, Talend or SSIS
• Knowledge of the full stack of Esri ArcGIS Technology including ArcGIS Pro, ArcGIS Enterprise, and ArcGIS Online with focus on Geodatabases

Responsibilities

• Design, build, implement, and administer spatial and non-spatial databases
• Manage enterprise geodatabases to support versioning, archiving and multi-user editing
• Develop and administer automated Extract, Transform and Load (ETL) routines using custom scripts and/or COTS products
• Develop SQL and/or Python scripts for data processing, analysis and/or reporting
• Develop and implement SQL Server stored procedures, functions and triggers when necessary
• Assist with developing and administering hosted map and feature services using ArcGIS Enterprise
• Implement best practices for SQL Server resource utilization, high-availability and disaster recovery
• Ability to obtain Esri certifications related to database management and system administration; Microsoft certifications related to data management
• Maintain a repository of technical documentation and GIS metadata

Benefits

• Tuition reimbursement, including reimbursement for Esri and other certifications
• Exceptional work-life balance, with hybrid and alternative work schedule options
• Opportunities for growth and development within Maricopa County, including training for Esri, FMA, and ETL
• Low-cost, high-value healthcare for you and your qualifying dependents
• Child care benefits, including access to our on-site center, Maricopa County Kids Club , dedicated to serving Maricopa County families
• Paid vacation, sick time, and parental leave
• Extensive wellness program, including an incentive
• Enrollment in the Arizona State Retirement System, a defined retirement benefit requiring a 12% monthly contribution rate that includes a 100% employer match on Day 1

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level