Oracle Data Warehouse Developer Jobs in Georgia (NOW HIRING)

Under general supervision, designs, codes, tests, modifies and debugs Esri ArcGIS software.
Job Summary:
The Georgia Dept. of Transportation (GDOT) is seeking a technical GIS developer for configuring and developing custom Esri ArcGIS Enterprise 11x, 12x (ArcGIS Maps SDK, Experience Builder, ArcGIS Portal/Online/Hub, Field Maps) applications. Applications are deployed within SharePoint web sites. Custom GIS solutions will be integrated within .NET based applications, GDOT databases (Oracle/Oracle Exadata, SQL Server), data warehouse (Oracle Exadata), and enterprise reporting (Oracle Business Intelligence Enterprise Edition (OBIEE), Data Visualizer, or Power BI). The candidate will have application programming/development, implementation, and support experience.

• Under broad supervision, designs, codes, tests, modifies and debugs computer software and applications. Researches and analyzes program or systems problems, provides resolutions, and completes documentation. Translates business requirements into development activities in secure, commented, and maintainable code.
• Candidate will be working in the Enterprise GIS Team of IT Applications. Candidates will work with supporting IT team members (database, network, server, etc.) and interacting with management, architects, developers, and business units. The candidate will follow internal SLDC, standards, and accepted best practices for developed solutions.
• The Enterprise GIS team is composed of a support analyst, 2 ArcGIS developers, 2 System Administrators, a data manager, and team leader. The team supports over 180 ArcGIS Desktop users and approximately 60,000 annual ArcGIS Server web visits. Applications support GIS portal, feature mapping, project planning, emergency operations, permitting, safety, and traffic records.
• The team develops enterprise GIS services, applications, and databases. The team coordinates with client, server, network, and database/data warehouse personnel to support and develop the underlying IT solutions.

Responsibilities:

• Designs and develops customized web applications, webservices, mobile, and enterprise solutions
• Designs and develops geoprocessing and GIS web services
• Designs and develops GIS web editing/mapping applications
• Conducts performance, unit, system, integration, and quality assurance testing of applications
• Maintains existing applications/services
• Upgrades and migrates existing applications/services to current version/systems architecture
• Implements controls to protect system/data security
• Documents GIS solutions and provides required documentation/artifacts
• Works closely with other developers and architects
• Collaborates on IT Project teams, estimates work effort and completes tasks on-time as per agreed project schedule(s)
• Addresses critical or complex GIS support issues/problems
• Engages vendor/IT staff in complex troubleshooting or system correction
• Automates data processing via ETL scripts
• Ensures alignment with standards/guidelines, provides technical guidance/strategy, and mentors GIS staff

Work Terms and Conditions:

• 8 Hour workdays on a fixed schedule (i.e. not a flex-schedule), starting no earlier than 7:00AM Eastern Time, starting no later than 9:00AM Eastern Time, Monday - Friday, 40 hours per week
• GDOT has NOT specified a number of days onsite vs remote. However, local candidates (i.e. able to come in office) will be preferred over an out of state candidates (i.e. remote worker). GDOT prefers candidates who can demonstrate they have the capability to work a hybrid work schedule which is a combination of remote and in-office work. Candidate capacity (i.e. days they could come into the office) to work a hybrid work schedule will be discussed during interviews.

• The consultant will follow all applicable State of Georgia and GDOT policies, procedures, standards, guidelines, and accepted best practices.
• The position end date is set for the end of the GDOT Fiscal Year. GDOT may exercise the option to renew contracts in one-year increments. Several successful consultants have continued working for several years with contract extensions. However, GDOT is under no obligation to extend contracts and may terminate employment at any time.
• When teleworking or working remotely, consultant must have suitable internet connection and environment to comply with GDOT telework policies.
• GDOT will reimburse authorized travel expense lodging and meals. GDOT will reimburse authorized travel use of a personal vehicle. Any travel expenses to start work or relocate to Georgia or will not be reimbursed. All travel expense reimbursement shall be in accordance with State Accounting Office Travel Policy: https://sao.georgia.gov/travel/state-travel-policy
• The Department has 13 holidays, which consultants are not allowed to work nor make up any time for those holiday weeks without management's approval. Consultants are not to take extended leave during their first year of service (e.g. greater than 1week).
• Consultant must have cell phone which can be used for business calls.
• GDOT does not provide free parking. All routine commuting expenses are the responsibility of the consultant.

Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceProgramming/application development experienceRequired4YearsPL/SQL, SQLRequired4YearsPython Scripting or ArcPyRequired4YearsEsri ArcGIS Server services and GeoProcessing services developmentRequired3YearsArcGIS Online, ArcGIS Enterprise Server (i.e. Portal for Organizations), or Hub/Community experience as AdministratorRequired3YearsEsri Web/Experience Builder, ArcadeRequired3YearsDesktop GIS (ArcGIS Pro, ArcMap) Required2YearsExperience with modern web technologies including HTML5, CSS3, JavaScript (ES6+), Git, and frameworks such as Angular or React, etc.Required0Bachelor's in geography, GIS, computer science, or a related fieldRequired0Ability to clearly communicate technical ideas, whether to other technical peers or non-technical project managers or customersRequired0Excellent communication, collaboration, and teamwork skillsRequired0Ability to isolate/solve any number of problems from code bugs to database connectivity to application server or operating system failuresRequired0Knowledge of geospatial and mapping concepts such as spatial analysis, map projections, etc.Required0Knowledge of IT security concepts and implementation patterns within Esri technologyRequired0Experience with ArcGIS Apps - Field Maps, Navigator, Survey 123, Operations Dashboard, etc.Required0Esri Javascript SDK (must be capable of developing widgets and not just using Experience Builder)Highly desired0Esri Geoevent Server/Velocity, Roads and Highways, and/or Image Server ExperienceHighly desired0Geodatabase Administration experience with multi-user versioned environmentHighly desired0Experience with Esri Roads and Highways, Dynamic segmentation and linear referencing systems/methods, transportation data modelsHighly desired0URISA GISP or Esri Developer/Enterprise CertificationHighly desired0Experience with SafeSoftware Feature Manipulation Engine (FME)Highly desired0ArcGIS Pro add-in Development experienceHighly desired0Experience with current technology implementation patterns including service-oriented and cloudDesired0
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement?Question2What is your candidate's email address?Question3If selected for engagement, your candidate's hourly Pay Rate must be at least $53.76. Your candidate can be paid more; however, the hourly SRP Rate cannot exceed $72.56. Do you agree to these requirements?Question4If selected for engagement, your candidate's hourly Pay Rate must be at least $53.75. Your candidate can be paid more; however, the hourly SRP Rate cannot exceed $72.57. Do you agree to these requirements?Question5The maximum mark-up for this engagement's SRP rate is 35%. To be competitive on pricing, a mark-up below the 35% threshold is suggested. Do you agree to propose a mark-up at or below 35%?Question6This assignment is contingent upon customer renewal and availability of adequate funding. Do you agree to this requirement?Question7If selected for engagement, your candidate will be expected to start no later than 2 weeks (10 business days) after the client's selection date? Do you agree to this requirement?Question8This position is Hybrid (Remote and Onsite). The candidate first day is onsite and onsite on demand basis. Preference will be given to candidate local to Atlanta Metro area / State of Georgia. Indicate if candidate has full-time residency within the Atlanta Metro area, within the State of Georgia, or if candidate resides outside of the State of Georgia.Question9Preference will be given for candidates who are US Citizens, Permanent Residence Card (aka "Green Card") or have Employment Authorization Document (EAD). Indicate if candidate citizenship or visa status is a US Citizen, Permanent Residence Card, EAD, H1B, or Other.Question10This position is in Atlanta, GA. Your consultant is required to travel to Atlanta for their first day for onboarding. Travel will be at no expense to GDOT in order to obtain your candidate's computing equipment and ID/Security badge. Do you accept this requirement?Question11GDOT will not be providing any raises within the first 2 years. After that point the rate increase will be based on performance and budget dependent. Do you accept this requirement?Question12While the intent may be a long-term tenure, this position is subject to annual budget restrictions. The initial contract is through the end of this fiscal year and is anticipated to be renewed July 1st. Do you accept this requirement?