Oracle GIS Developer

AHU Technologies Inc; Washington (District of Columbia); Hybrid; USD 100,000 - 150,000; Part time

Job summary

AHU Technologies Inc. seeks a database developer to support an OSS web application for telecommunications. You will build and maintain an Oracle database (11g/19c) in a GIS-enabled environment and integrate data from SQL Server and Esri tools.

In the Washington, DC area, the role is contract W2/1099/C2C with hybrid onsite/remote schedule; you will work in an Agile/Scrum team, develop data models, ERDs, and procedures, and guide migration while ensuring existing functionality.

Qualifications

• Oracle Database Developer Experience – 3+ years (required)
• Database Administration Experience – 2+ years (required)
• Experience with Spatial Queries and Geometry Objects – 2+ years (required)
• Data Model Visualization (ERDs) – 1+ year (required)
• Interest in using GIS tools – 1+ year (required)
• Experience with Esri products – 1+ year (required)
• Version control systems (Git) – 1+ year (required)
• Bachelor’s degree in IT or related field or equivalent experience (required)
• Experience with planning, coordinating, and monitoring project activities – 2+ years (required)
• Experience with leading projects, ensuring they follow established standards/procedures – 2+ years (highly desired)
• Must be able to qualify for a journeyman level position – 6+ years (required)

Responsibilities

• Maintain and enhance the Oracle database for the OSS web application.
• Migrate data from Oracle 11g to Oracle 19c stepwise while preserving functionality.
• Develop data models using SQL, triggers, and PL/SQL with multistep transactions.
• Visualize data models with ERDs and other methods.
• Integrate data from SQL Server and GIS sources (ESRI).
• Collaborate in an Agile/Scrum team and communicate issues clearly.
• Provide technical guidance and seek solutions proactively.

Skills

Oracle Database Developer Experience

Database Administration

Spatial Queries & Geometry Objects

Data Model Visualization (ERDs)

GIS Tools Interest

Esri Products

Git / Version Control

Project Planning & Coordination

Project Leadership

Journeyman Qualification

Education

Bachelor's degree in IT or related field

Tools

Esri ArcGIS Server

ArcGIS Pro

Microsoft SQL Server

Job description

Job Description

The client is looking for a database developer to support a team that creates and maintains a telecommunication focused, web-based Operational Support System (OSS) application.

Employment type: Contract w2/1099/C2C

The database developer will be an integral part of our Agile/Scrum team, responsible for maintaining and enhancing the database for an internal web application. This role will develop and maintain an Oracle database that supports the OSS. The database for this application currently utilizes spatial data and integrates with GIS software.

We are seeking a candidate who lives in the Washington, DC‑MD‑VA region. The position can work remotely one (1) day per week and onsite at the customer office in downtown Washington, DC four (4) days per week.

This project primarily uses an Oracle Database. A major focus of the initial phase of this project will be to migrate data from the current Oracle 11g Database to a more current Oracle 19c Database. This process needs to be done in a stepwise fashion to ensure that the current functionality that relies on the Oracle 11g Database continues to function properly while the data model and objects are seamlessly upgraded to using Oracle 19c.

The database developer will be expected to create sophisticated data models using SQL, triggers, procedural SQL that handles multistep transactions, and visualize data models with entity–relationship diagrams and other methods.

In addition to the Oracle databases (11g and 19c) the application also integrates data from other third‑party applications that store their data in Microsoft SQL Server databases. The project also uses ESRI’s GIS Server and Desktop product lines (e.g. ArcGIS Server, SDE, ArcGIS Pro) for geospatial visualization of the Oracle data and to fulfill more sophisticated mapping and analysis requests.

We expect the candidate to be a mature team member who can take directions, provide technical guidance, and communicate problems as they arise. We seek lifetime learners who know how to work on a problem, propose solutions, and ask for help.

Skills and Experience

• Oracle Database Developer Experience – 3+ years (required)
• Database Administration Experience – 2+ years (required)
• Experience with Spatial Queries and Geometry Objects – 2+ years (required)
• Data Model Visualization (especially ERDs) – 1+ year (required)
• Interest in using and/or learning GIS tools – 1+ year (required)
• Experience with Esri products – 1+ year (required)
• Version control systems (e.g. Git) – 1+ year (required)
• Bachelor’s degree in IT or related field or equivalent experience (required)
• Experience with planning, coordinating, and monitoring project activities – 2+ years (required)
• Experience with leading projects, ensuring they follow established standards/procedures – 2+ years (highly desired)
• Must be able to qualify for a journeyman level position – 6+ years (required)