GIS Programmer/Database Analyst (Promotional)

The City of El Paso Texas; El Paso (TX); On-site; USD 65,000 - 95,000; Full time

Job summary

The City of El Paso Texas is seeking a skilled GIS/database professional to design and manage distributed databases in a GIS environment. You will build web applications with ArcGIS Server, Python scripting, and JavaScript, integrating data-rich content and services for interactive viewers.

Responsibilities include analyzing data requirements, ensuring data integrity, and providing technical support to users while adhering to FGDC/ CJIS standards and city guidelines.

Qualifications

• Bachelor's degree or higher in a related field and two years' experience in database programming.
• Experience with ORACLE or SQL relational databases and GIS software.
• Knowledge of HTML5, JavaScript, Python, and Typescript in GIS applications.

Responsibilities

• Develop and supervise multiple databases in GIS environments.
• Create GIS web applications using ArcGIS server and scripting (Python/JavaScript).
• Integrate multimedia and web services into GIS-driven sites.
• Analyze database designs for normalization and performance.
• Provide technical assistance and ensure database integrity and security.

Skills

Database programming

GIS

JavaScript

Python

HTML5

Typescript

Education

Bachelor's degree or higher in Computer Information Systems, Microcomputer Technology or related field

Tools

ArcGIS Server

Spatial Database Engine (SDE)

ESRI GIS products

Oracle

SQL relational databases

Job description

Requirements

MOS Codes: None

Education and Experience: A Bachelor's degree or higher in Computer Information Systems, Microcomputer Technology or related field or higher, and two (2) years' experience in database programming with ORACLE or SQL relational databases, network software support and development and support of GIS authored software applications (Web or client/server-based), HTML5, JavaScript, python, Typescript, Spatial Database Engine or other ESRI GIS products).

Licenses and Certificates

A Texas Class "C" Driver's License or equivalent issued by another state by time of appointment.

Special Requirements

Applicants for positions assigned to the Department of Information Technology Services must pass a Criminal Justice Information Systems (CJIS) finger-print based background check within the first six months from hire and maintain CJIS eligibility. CJIS requirements are related to system access and the following list of convictions and/or deferred adjudications will result in failure of the CJIS background check and disqualification and termination from employment: Felony Convictions, Felony Deferred Adjudication, Class A & B Misdemeanor Deferred Adjudication, Class B Misdemeanor Convictions, an Open Arrest for Any Criminal Offense (Felony or Misdemeanor), and Family Violence Convictions.

General Purpose

Under direction, plan, develop, supervise and control multiple integrated databases in a distributed, multi-tasking, wide area network system or GIS environment.

Typical Duties

Utilize software development tools and/or web authoring tools to create applications related to GIS, build tables, frames, forms, programming with ArcGIS server, Python scripting, JavaScript programming. Integrate video, animations, still images, text, PDF and audio into graphical design of web site. Create web services utilizing an ESRI product that integrates into client JavaScript viewers. Adhere to all standards as stated by the Federal Geographic Data Committee (FGDC).

Analyze logical and physical requirements for database applications. Review database designs for correct normalization. Determine impact of new or modified databases on other interactive applications and across entire system.

Analyze business procedures and problems to refine data for database management systems. Analyze, design and implement accurate, secure, efficient, logical and physical databases and coordinate database development applying knowledge of database design standards and database management systems.

Coordinate database design and operation. Utilize Spatial Database Engine (SDE) for GIS products. Develop standards regarding common data field structures. Create cross references for integrated databases. Write database descriptions and specify database identifiers. Develop data models, their elements and use. Implement, maintain and instruct users and technical staff on use of query and decision support tools. Identifies and resolves production and/or applications development problems related to the use of the database management system, software, or utilities.

Review project requests describing both GIS data layers residing in a database or a geo-database and determine needs. Studies existing data handling systems to evaluate effectiveness, and develops new systems to improve production or workflow as required.

Provide technical assistance to customers and the department. Respond to problem inquiries, guide technical staff in access of data. Conduct performance testing of programmer code to ensure efficient database access and proper use of indices.

Maintain database system integrity, accessibility, general security, and access privileges. Ensure accuracy of data conversion specifications, software installation, upgrades and maintenance. Develop, set up and initiate data recovery systems. Optimize system response and resources by tuning applications, database queries, system hardware and operating system. Maintain data file and data element references. Stay abreast of industry trends and all applicable technologies. Other duties as assigned.

General Information

Please note: This is an unclassified position.

This position is limited to City of El Paso employees presently working in the Streets and Maintenance department.

Please note: Applicants with foreign diplomas, transcripts, and degrees must have all documents translated and evaluated by an agency of the National Association of Credential Evaluation Services (NACES) prior to submitting them to the Human Resources Department.

A résumé and/or other documents will not be accepted in lieu of a completed application. Comments such as “See résumé” are not acceptable and will result in the application being considered incomplete.

To qualify for this position, required education, experience, knowledge and skills must be clearly stated on your application’s employment history. We do not use any information on your resume to review if you meet the minimum qualifications for this position.

Failure to fully detail all experience and job duties in the application, or copying/pasting directly from the job specification, or responses referring to your résumé will eliminate you from consideration for the position.

Determined by agreement

01. Do you have a Bachelor's degree or higher in Computer Information Systems, Microcomputer Technology or related field?

• Yes
• No

02. Do you have two (2) years' experience in database programming with ORACLE or SQL relational databases, network software support and development and support of GIS authored software applications (Web or client/server-based), HTML5, JavaScript, python, Typescript, Spatial Database Engine or other ESRI GIS products)?

• Yes
• No

03. Do you have a valid USA driver's license? If so, what type of driver's license do you have?

• Texas Class A - CDL or equivalent from another state.
• Texas Class B - CDL or equivalent from another state.
• Texas Class C or equivalent from another state.
• No, I do not have a valid driver's license.

04. This recruitment is limited to current City employees. Are you currently employed with the Streets and Maintenance?

• Yes
• No

05. Applicants with foreign diplomas, transcripts and degrees must have all documents translated and evaluated by an agency of the National Association of Credential Evaluation Services (NACES) prior to submitting them to the Human Resources Department. Have you had your diploma, transcripts, degree or other required documents translated and evaluated by an agency of NACES?

• Yes, it has been translated and certified and I can provide documentation upon a job offer.
• No, I have not had my degree translated and certified.
• N/A - my degree is from an accredited U.S. university or college.

06. Candidates will be evaluated based on the information provided on the application and the completeness of the responses to the Supplemental Questions. The following will disqualify you from moving forward in the recruitment process: Failure to fully detail all work experience and job duties. Failure to fully detail all lead, supervisory and managerial experience and duties if required. Overlapping dates of work experience. Copying and pasting directly from the job specification. Responses referring to your résumé.

• I acknowledge I have read and understand the above information.
• Required Question