About the Role
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. 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.
General Information
Please note: This is an unclassified position.
Note: Applicants are encouraged to apply immediately. This position will close when a preset number of qualified applications have been received.
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) priorto submitting them to the Human Resources Department. Please visit www.naces.org/members (http://www.naces.org/members) for more information.
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.