TITLE: ENTERPRISE APPLICATION DESIGNER
GRADE: 18
JOB CODE: 2631
FLSA: EXEMPT
Job Summary
Responsible for the design, development, installation,
testing and documentation of enterprise database application software,
including server, client and web components.
Scope
This position works in the area of information
technology. Work contacts include
administrators, faculty professionals, staff and vendors. Equipment used
includes a full range of computer equipment and software.
Supervision Received
This position reports to an assigned administrator; receives
general direction regarding routine and standard matters; specific instructions
regarding non‑routine and sensitive matters.
Supervision Exercised
Depending on
location/department, may supervise the positions of Programmer, Programmer Analyst
and/or other assigned staff.
Representative Duties
Designs, develops and installs custom enterprise‑wide database applications using enterprise versions of Oracle, Sybase, Informix or MS/SQL; designs, recommends, installs and supports enterprise-wide computing systems and related infrastructure; develops policies, procedures and standards related to the development and maintenance of database applications; designs and implements application security for client and server configurations; identifies, recommends and implements appropriate design tools and methodologies; oversees analysis of data requirements from functional specifications; develops, maintains and implements application documentation standards; consults on database application design; coordinates changes to database applications; may develop and implement external access to and transactions with database systems using application programming interfaces (API), object‑oriented language (OO) macros, script/batch language interfaces (e.g., shell, Perl, tcl, awk) and electronic commerce solutions; supports the creation of custom reports, forms and queries; trains staff to support and maintain the application; performs related duties as assigned.
Knowledge and Abilities
Knowledge of: Oracle, Sybase, Informix; Structured query
Language (SQL) or MS/SQL; database design and application development tools
including CASE tools; relational database structure and data normalization;
operating systems (i.e., Novell, Windows, UNIX, VMS); client/server
architecture design and implementation; database application installation and
maintenance; world wide web (WWW) interfaces to database applications;
application level security design and implementation; C,C++, Perl, Java and CGI
programming; electronic commerce solutions.
Ability to: design, develop, test, document, implement and
maintain database applications; manage projects; interpret documentation and
manuals; supervise assigned staff; make oral presentations; communicate
effectively orally and in writing; establish cooperative working relationships
with persons contacted in the course of performing assigned duties.
Training and Experience
Any combination of education, training and experience that
provides the required knowledge and abilities.
An example of this would be a college degree in information technology,
computer science, software engineering or decision support systems with
specialized courses in database application design methodologies, tools and
development. Experience and training in process modeling, documentation and
multiple design methodologies. Experience in developing conceptual applications
from analysis of business processes and user needs as well as design, develop
and implement relational database solutions.
Special Conditions of Employment
Working Conditions
Positions in this class may require prolonged monitor
viewing. After‑hours and weekend
work may be required. On‑call via phone and/or page is required.
This class specification is intended to indicate the basic
nature of positions allocated to the class and examples of typical duties that
may be assigned. It does not imply that
all positions within the class perform all of the duties listed, nor does it
necessarily list all possible duties that may be assigned.