Database Administrator - Geospatial, SQL Server, Data Architect

Hiring Transparency:

• Official Communication: All job offers and communication regarding them will arrive from email addresses ending in @innovateteam.com.
• Secure Information: We prioritize your data safety. We never request bank information via email or text. Instead, we follow a secure process through our dedicated payroll system., Innovate! Inc. is seeking a highly experienced Database Administrator - Geospatial, SQL Server, Data Architect to provide database administration and technical support for Microsoft SQL Server, spatial SQL, and enterprise geodatabase environments. This role will support schema updates, versioned environments, performance tuning, mosaics, rasters, indices, and the maintenance of development, test, and production environments. The position requires the ability to support secure data management requirements, maintain metadata completeness and FGDC/ISO compliance, handle sensitive datasets marked “not for public distribution,” manage version control and database relationships, and support storage, migration, or archiving of legacy study reports., * Maintain relational databases across development, test, and production environments.
• Support schema updates, versioning, tuning, and backups.
• Support both branch and traditional versioned environments.
• Implement change requests related to schemas, metadata, tables, and feature classes.
• Manage mosaics, rasters, indices, statistics, and database optimization.
• Publish and maintain geospatial services.
• Catalogue and organize marine minerals datasets.
• Maintain file structures on cloud servers.
• Ensure metadata completeness and FGDC/ISO compliance.
• Handle sensitive datasets marked “not for public distribution.”
• Support version control, reconciling, and posting operations.
• Store, migrate, or archive legacy study reports.
• Manage database relationships and schemas.
• Provide technical expertise in the use of databases and their integration with complementary business systems.
• Analyze, evaluate, and recommend basic architecture, workflows, and technology roadmaps to support user requirements.
• Perform administration and troubleshooting.
• Create GIS database products.
• Provide analysis and end-user support.
• Create documentation on data and workflows.
• Conduct testing of GIS applications.
• Perform QA/QC on data, processes, and workflows.
• May supervise others.

Do you have experience in Version control systems?, Do you have a Bachelor’s degree?, Embrace the opportunity to join Innovate! Inc. and become a valued member of our team. We are seeking driven individuals who are passionate about leveraging technology to tackle environmental challenges and drive positive change. If you thrive in a collaborative, fast-paced environment and are eager to contribute your skills and expertise to innovative projects, we invite you to explore this exciting opportunity further. Read on to learn more about how you can be part of our dynamic team., * Microsoft SQL Server proficiency.

• Spatial SQL knowledge.
• Enterprise geodatabase design.
• Versioned environment maintenance.
• Database tuning.
• Schema and content model updates.
• Application of metadata standards, including ISO 19115 and FGDC.
• Experience troubleshooting performance issues in complex cloud-hosted environments.
• Demonstrated capability designing, troubleshooting, and administering geospatially enabled databases.
• Technical expertise in database integration with complementary business systems.
• Ability to support administration, troubleshooting, documentation, testing, and QA/QC of GIS data, processes, and workflows.
• Ability to comply with DOI security and data management requirements., * BA/BS degree.
• 3 years of experience.
• Must be able to obtain a successfully adjudicated National Criminal History Check (NCHC) and National Agency Check with Inquiries (NACI)” and hold that for the duration of the contract.

$90,000 - $120,000 a year - Full-time, Contract, Pulled from the full job description

• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Dental insurance
• Life insurance

Innovate! Inc. is a certified woman-owned consulting firm founded in 2002 by Lily Thomas. We provide innovative solutions to management, technology, and program challenges, with a focus on performance, integrity, and building lasting partnerships with our clients. Our team of over 100 experts includes IT and geospatial specialists, program and project management consultants, environmental scientists, and communications and outreach strategists. Our clients include federal, state, tribal, and local governments, private industry, non-profit organizations, higher education institutions, and utilities. Recent awards we received for excellent service include the 2022 SAG Team Award and 2022 Esri Partner Conference High Potential Award.

Innovate is a fast-paced, rapidly growing group of entrepreneurs creating a culture of excellence. Rapid advancement within our organization is not only possible but also encouraged. To view our website, visit innovateteam.com.