Senior Computer Programmer Analyst; Nc - Database Administration

The County Law Enforcement Applied Regionally (CLEAR) section of the Enterprise Technology Solutions (ETS) division is currently seeking to fill the position of Senior Computer Programmer Analyst with a talented and motivated individual with strong Database Programming and Database Administration skills. This employee assists in the analysis of city, county, and criminal justice agencies' data processing needs; assists in the design, testing, and implementation of systems;

performs database design, implementation, and maintenance of databases; administration of new and existing databases. Performs other related duties as required.

Employee performs a variety of professional, technical, and analytical duties in the operation of enterprise, client/server, and desktop computer systems and networks. Employee assists in the analysis of city, county, and criminal justice agencies' data processing needs; assists in the design, testing, and implementation of systems; performs network design, implementation and maintenance, data/database analysis/administration, and modifications to existing computer applications. Performs related duties as required.

(Illustrative only. Any one position may not require all of the listed KSAs nor do the listed examples include all the KSAs which may be required.)

• Principles of computer data processing.
• Design, installation, and maintenance of enterprise, distributed, client server, and desktop computer systems.
• Principles and practices of computer network systems analysis and design.
• Current trends and new technologies in data processing.
• Desktop software packages and operating systems.
• Principles of effective documentation.
• Principles of providing effective customer service.

• Database management systems.
• Database design.
• Database tools.
• Data/file management tools.
• Database utilities.
• Data warehouse and multi dimensions.
• File and data recovery.
• Database security methods and techniques.
• Physical control standards and procedures.
• Database software (Oracle, SQL, etc.)

• Methods and practices of installation for upgrading of client servers and desktop computer, hardware and software.
• Computer system configurations.
• Operating system structures.

• Principles of computer network systems analysis and design.
• Local area network hardware and transmission protocols.
• Data communication concepts and principles.
• Internet and intranet architecture.
• Network security policies, techniques, and procedures.
• Network configuration, maintenance, and diagnostic procedures and techniques.
• Licensing Agreement enforcement.

• Standard programming languages.
• Computer operating systems/hardware.
• Program design and analysis.
• Principles and techniques of programming.
• Programming languages (Java, C, C++, Visual Basic, etc.) and utilities.

• In-depth graphic design.
• User interface design.
• Advertising and marketing.
• Information architecture.
• Management of e-commerce.
• Front-end web code such as HTML and JavaScript.

• Business systems analysis.
• Business software packages.

• Desktop GIS software for analysis, query, and visualization (e.g., ESRI's Arc View).
• WEB-based GIS application interfaces and data presentation.
• Desktop or Workstation GIS advanced software for data creation, geo processing, and conversion (e.g., ESRI's Arc Info).
• Geo-locational and Geo-relational dataset concepts and database structures.
• Engineering/surveying principles and practices as related to GIS and GPS (global positioningsystems) applications.
• Interface and integration of GIS database systems with other public enterprise systems such as permitting, licensing, and financial systems.

• Install, configure, upgrade and maintain hardware and software, including that related to local and wide area networks.
• Perform hardware modifications such as chip replacement and board swaps.
• Troubleshoot and resolve network hardware and software problems.
• Use and maintain networking test equipment.

• Read and prepare clear and concise reports and technical documents.
• Work with minimal supervision.
• Provide…