What are the responsibilities and job description for the GIS Programmer/Database Analyst position at City of El Paso?
Education and Experience: A Bachelor's degree or higher in Computer Information Systems, Microcomputer Technology or related field, 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.
Salary : $60,780 - $95,630
