GIS Programmer/Database Analyst (Promotional)

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

Job summary

City of El Paso is seeking a skilled GIS/Database Administrator to plan, develop, and manage multiple databases within a distributed GIS environment. You will build GIS web apps using ArcGIS Server, Python, and JavaScript, integrating multimedia and ESRI products into dynamic web interfaces.

Ideal candidates will hold a Bachelor's degree in CIS or related field with 2+ years of database programming experience, including Oracle/SQL and GIS tools.

Qualifications

• Bachelor's degree in CIS or related field and 2 years of database programming experience.
• Experience with Oracle/SQL databases.
• Experience with GIS software and ESRI GIS products.
• Proficiency in HTML5, JavaScript, Python, and TypeScript.
• Familiarity with web development and GIS web apps.

Responsibilities

• Plan, develop, supervise and control multiple integrated databases in a distributed GIS environment.
• Create applications related to GIS using ArcGIS server, Python and JavaScript.
• Integrate multimedia into web design and create web services with ESRI products.
• Analyze database requirements and designs for normalization.
• Coordinate database design and operation using SDE.

Skills

Database programming

Oracle/SQL

GIS

HTML5

JavaScript

Python

Typescript

Education

Bachelor's degree in CIS/related field

Tools

ArcGIS

Spatial Database Engine (SDE)

Job description

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.

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

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. Involves: 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. Involves: 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. Involves: Respond to problem inquiries, guides 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. Involves: 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.

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. Please visit www.naces.org/members for more information.

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.