Description:
Visual Basic for Applications Programmer Excel 2007 / SQL Programmer

Job Purpose:
Accomplishes software requirements by developing and maintaining applications and databases.

Duties:
* Identifies requirements by establishing personal rapport with potential and actual clients and with other persons in a position to understand service requirements.

* Arranges project requirements in programming sequence by analyzing requirements; preparing a work flow chart and diagram using knowledge of computer capabilities, subject matter, programming language, and logic.

* Develops software applications by encoding project requirements in Visual Basic for Applications.

* Confirms program operation by conducting tests; modifying program sequence and/or codes.

* Provides reference for use of prime and personal computers by writing and maintaining user documentation.

* Maintains computer systems and programming guidelines by writing and updating policies and procedures.

* Protects operations by keeping information confidential.

* Contributes to team effort by accomplishing related results as needed.

* Develops and maintains applications and databases by evaluating client needs; analyzing requirements; developing software systems.

* Confirms project requirements by studying user requirements; conferring with others on project team.

* Protects database by developing access system; specifying user level of access.

* Maintains data dictionary by revising and entering definitions.

* Maintains client confidence and protects operations by keeping information confidential.

* Maintains technical knowledge by attending educational workshops; reviewing publications; establishing personal networks; participating in technical societies.

* Determines changes in physical SQL database by studying project requirements; identifying database characteristics, such as location, amount of space, and access method.

* Changes SQL database system by coding database descriptions.

* Maintains user reference by writing and rewriting database descriptions.

* Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;

* Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.

* Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.

* Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.

* Prepares users by conducting training.

* Provides database support by coding utilities, responding to user questions, and resolving problems.

* Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.

* Accomplishes information systems and organization mission by completing related results as needed.


Skills/Qualifications:
Strong knowledge of Microsoft Excel 2007 and all Office Applications, Microsoft SQL Server 2005, Visual Basic, Client/Server, User Interface Design, Problem Solving, Attention to Detail, Software Design, Software Debugging, Software Development Fundamentals, Software Documentation, Software Testing, Software Requirements

Teamwork, SQL Programming, Database Management, Requirements Analysis, Software Requirements, Problem Solving, Verbal Communication, MS SQL Server, Data Maintenance, Database Security, Database Performance Tuning, Database Design, Data Maintenance, Database Security, Teamwork, Project Management