Agile Programming Methodologies, Analysis Skills, ArcGIS, Communication Skills, Computer Networks, Data Migration, Data Modeling, Data Visualization, Database Administration, Database Programming, Database Triggers, Desktop PC, Documentation, ESRI, Entity Relationship Diagram (ERD), Geographic Information System Software, Geographic Information Systems (GIS), Graphics Software, Identify Issues, Information Technology & Information Systems, Internet Application, Leadership, Microsoft SQL Server, Object Modeling, Operational Support Systems (OSS), Oracle, Oracle 11i, Oracle Database, Procedure Development, Project Engineering, Project Lifecycle, Project Tracking, Project/Program Coordination, Project/Program Management, Quality Assurance, Realtime Communications, Regulatory Compliance, Risk Management, SQL Databases, Scrum Project Management and Software Development, Spatial Data, Technical Leadership, Telecommunications
655 15th St NW Washington DC, DC
We are looking for a Database Developer with GIS Experience (Min 10+ Yrs. Exp) ONSITE (In Person Interview).
POSITION DESCRIPTION
DIRECT CLIENT Position
Number of positions: 1
Length: 12-24 Months+
Work Address: Washington DC 20005
Immediate interviews (In Person Interview)
Please Note this position is ONSITE Work& ONSITE Interview
looking for a database developer to support a team that creates and maintains a telecommunication focused, web-based Operational Support System (OSS) application.
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. Currently this 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 the 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 11gDatabase 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 visualizing 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 3rdparty 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 is able to communicate problems as they arise. We seek lifetime learners who know how to work on a problem, propose solutions, and ask for help.
Suitable candidates will be expected to complete a \"Pseudo-Code Assessment\" form, which we will provide to those we select for the interview process. The form includes questions that are meant to demonstrate your competency in general database development.
JOB DESCRIPTION
Responsibilities:
1.Coordinates IT project management, engineering, maintenance, QA, and risk management.
2. Plans, coordinates, and monitors project activities.
3. Develops technical database platforms to support users.
4. Develops, implements, maintains, and enforces documented standards and procedures for the design, development, installation, modification, and documentation of assigned systems.
5. Provides training for system products and procedures.
6. Performs application upgrades.
7. Performs monitoring, maintenance, or reporting on real- time databases, real-time network and serial data communications, and real-time graphics and logic applications.
8. Troubleshoots problems.
9. Ensures project lifecycle is in compliance with District standards and procedures.
Minimum Education/Certification Requirements:
Bachelor's degree in IT or related field or equivalent experience
Required/Desired Skills
Candidates must have ALL the "Required" skills in order to be considered for the position. "Desired" or "Highly Desired" skills are a PLUS but may NOT be required.
Skill Matrix
Experience with Business workflow processes | Required / Desired | Amount | of Experience |
Oracle Database Developer Experience | Required | 3 | Years |
Database Administration Experience | Required | 2 | Years |
Experience with Spatial Queries and Geometry Objects | Required | 2 | Years |
Data Model Visualization (especially ERDs) | Required | 1 | Years |
Interest in using and/or learning GIS tools | Required | 1 | Years |
Experience with Esri products | Required | 1 | Years |
Version control systems (Example: Git) | Required | 1 | Years |
Bachelor's degree in IT or related field or equivalent experience | Required | 0 | Years |
Experience with planning, coordinating, and monitoring project activities | Required | 2 | Years |
Experience with leading projects, ensuring they are following established standards/procedures | Highly desired | 2 | Years |
Must be able to qualify for a journeyman level position. | Required | 6 | Years |