GIS Database Administrator - Senior Job at Sanborn Map Company, Denver, CO

T3U1Qmp2amt3UDlFY0VuVWg0ODY5MEpK
  • Sanborn Map Company
  • Denver, CO

Job Description

GIS Database Administrator – Senior

SUMMARY

The Spatial Database Administrator will have senior-level professional knowledge and experience in developing, documenting, implementing, securing, and maintaining geospatial and alphanumeric data models and databases in Relational Database Management Systems (RDBMS) in both on-premises and cloud environments. This will include skills in Structured Query Language (SQL) and database procedural code such as T-SQL. The Spatial Database Administrator will have expertise in managing and administering spatial data in geodatabases and associated editing workflows, including publishing and management of geospatial web service-based editing workflows using ArcGIS Enterprise, PostGRE/GIS, and Geoserver. They will also have experience with database instance management, configuration, and disaster recovery for spatial and alphanumeric data. Experience with or willingness to learn how to leverage cloud data storage, processing, and analytics in Microsoft Azure or Amazon Web Services (AWS) since the technical stack is a hybrid cloud environment.

COMPENSATION & BENEFITS
Salary Range: $105,000 - $130,000
Comprehensive federal benefits package available to full-time employees, including health insurance, paid time off, and retirement plan participation.

ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

  • Development, Maintenance, and Operations of Enterprise Geodatabases and associated SQL Server or Postgres Instances.
  • Create functional specifications and recommend solutions for alphanumeric and geospatial data systems.
  • Develop and maintain databases and data systems, reorganizing data in a readable format. Use automated tools to extract data from various sources, remove or repair corrupted data, and fix coding errors and related problems.
  • Define database physical structure and functional capabilities and current and future storage requirements.
  • Develop and document appropriate metadata records (business, technical, process, and operational) for the contents of developed data management systems and data standards.
  • Develop and maintain enterprise data d architecture to support business requirements.
  • Develop and implement physical data models for both tabular and geospatial data systems and reverse engineer physical databases as needed by various business units/program areas.
  • Monitor and optimize database(s) performance and user access, plan for backup and restoration/recovery of database information, manage and monitor data replication.
  • Publish geospatial web services to support feature service editing workflows and branch versioning. Configure Enterprise Geodatabases and web services to support various workflows in support of customer requirements.
  • Maintain database and instance performance by calculating optimum values for database parameters.
  • Implement new releases, completing maintenance requirements.
  • document and develop these processes to better align with security best practices and to support the development of our Authority to Operation (ATO), and
  • Possess familiarity with, and willingness to learn, unstructured and NoSQL data patterns such as graph databases, JSON document and key-value stores, and other emerging technologies that best fit with identified customer requirements.
  • Implement and monitor applicable security controls as defined by the most recent release of the applicable Security Technical Implementation Guide (STIG) under the direction and supervision of the IT Security Officer (ITSO).
  • Provide input to Plan of Action and Milestones (POAM) for any non-compliant Authority to Operate (ATO) boundary checks related to SQL databases.
  • Respond to and remediate security alerts concerning administered databases instances

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION & EXPERIENCE

  • Bachelor’s degree in Information Systems, Data Management, Business Administration, Computer Science, or a related field is required; a Master’s degree in a relevant discipline is strongly preferred.
  • Minimum of 4 years’ experience with Enterprise Geodatabases on MS SQL Server and PostGre/GIS, including SQL Instance management.
  • Minimum of 3-years’ experience publishing geospatial web services using ArcGIS Enterprise, ArcGIS Online, and open-source GIS Content Management Platforms.

SUPERVISORY RESPONSIBILITY

  • Supervision may be required for this position.
  • As a Senior level personnel, this position may provide oversight of others.

WORK ENVIRONMENT

  • Work can be performed at the contractor's facility or at the National Park Service (NPS) facility at Building 50, Denver Federal Center, Lakewood, CO 80225.
  • Remote work is allowed with COR or task inspector approval.

Applicant must live in the U.S. and be authorized to work in the U.S.

Sanborn offers a comprehensive health and wellness program which includes medical, dental, vision, 401k, holiday, PTO, EAP, disability and life insurance benefits.

TO APPLY: Visit our website: www.Sanborn.com under the Careers menu option to apply. We are accepting applications for this position until July 19, 2025. Sanborn is a Veteran/Disability Equal Opportunity Employer.

Job Tags

Full time, For contractors, Remote work, Live in,

Similar Jobs

Chainalysis Inc.

Staff Blockchain Engineer, Protocols Job at Chainalysis Inc.

 ...team at Chainalysis is driven by the challenge of solving complex technical problems and building products that foster trust in cryptocurrencies. We are a globally distributed organization with teams in Denmark, the UK, Canada, and the USA, who thrive on tackling... 

Paramount

Accountant Job at Paramount

 ...Paramount Pictures is a subsidiary of Paramount, which connects with billions of people worldwide through its global brands including MTV, CBS, Paramount Network, Nickelodeon, Comedy Central, BET and streaming service Paramount+. Paramount is an equal opportunity... 

Chainalysis Inc.

Blockchain Engineer II Job at Chainalysis Inc.

 ...engineering team at Chainalysis is inspired by solving the hardest technical challenges and creating products that build trust in cryptocurrencies. Were a global organization with teams in Denmark, UK, Canada, the USA who thrive on the challenging work we do and doing it... 

First Coast Mulch

Accounting Intern Job at First Coast Mulch

 ...company of First Coast Mulch, EZ Mulch, and Innovative Mulching, is seeking a detail-oriented and motivated Accounting Intern to join our team. This internship offers the opportunity to gain hands-on experience in a dynamic, multi-entity organization, working directly... 

Chainalysis Inc.

Associate Investigator - APAC (Based in Indonesia) Job at Chainalysis Inc.

 ...at our key customers. The team of investigators at Chainalysis are world-class problem solvers adept at conducting complex cryptocurrency investigations. We help our customers with the biggest and most complex investigations and along the way, make the world a safer...