Untitled Page

Job Title: Programmer II
Department: Information Technology
Reports To: Director, Technology Services or
Director, International & Domestic Procedures
Grade: 07
Job Code: 1038
Effective Date: 04-2006

SUMMARY

The Programmer II is responsible for the program and design of interactive web programs, in-house applications and secure credit card processing applications. Supports the four corporate primary objectives: safe and responsible diver acquisition and retention; member acquisition and retention; financial prosperity; global operational alignment.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

Develop database secure driven websites and applications using Active Server Pages (ASP) and ASP.net programming languages.

Develop secure e-commerce solutions.

Create and maintain in-house applications for the M2project using .net platform.

Incorporate Creative Services and design staff into the development of custom graphics and page design and seek their assistance in developing the overall artistic look of the sites.

Create and maintain documentation on applications developed and website logic flow.

Develop, maintain, and promote a high level of customer service at all times both internally and externally.

QUALIFICATION REQUIREMENTS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION and/or EXPERIENCE

Requires four to six years experience in a programming position.
Bachelor's degree (B.S.) in computer science field recommended.

LANGUAGE SKILLS

Ability to read, analyze, and interpret general business periodicals, professional journals, or technical procedures. Ability to write reports and business correspondence. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

REASONING ABILITY

Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

BEHAVIORAL REQUIREMENTS

The ability to follow directions from a supervisor; the ability to interact well with co-workers; the ability to understand and follow posted work rules and procedures; the ability to accept criticism.

CERTIFICATES, LICENSES, REGISTRATIONS

Certified Diver preferred, but not a requirement of the position.
MCAD 70-305 or MCTS 70-528 certification required.

OTHER SKILLS AND ABILITIES

Working knowledge of TCP/IP, routers, and LAN/WAN technologies is a plus.
Must either have or develop a working knowledge of PADI Educational System.
Must have excellent organizational skills.
Must have working knowledge of: advanced .net framework knowledge, VB.net, XML, classic ASP, IIS config, web services development, active directory understanding, UML, understanding of different browsers, asp.net security best practices, understanding of Object Oriented programming, javascript, DHTML, HTML, SQL knowledge (how to use stored procedures and fundamentals of relational databases), CSS, Visual Studio.net (Team Developer edition), advanced use of Team Server, basics of Flash MX recommended, basics of Photoshop and Dreamweaver recommended, website layouts/stylesheets, ADO.net and LDAP.

Must specifically be able to demonstrate:

To separate user interface resources from business logic and data layer.
Add web server controls, HTML server controls, user controls and HTML code to asp.net pages
o Set properties on controls, load controls dynamically and apply master pages
o Set styles on asp.net pages by using cascading style sheets.
Implement navigation by managing data during post back events and to use session state to manage data across pages
Implement error handling in user interface
o Config custom error pages and writing errors to log and/or database
o Implement global.asax, application, page level and page event error handling
Display and update data
o Transform and filter data
o Bind data and user interface
o User controls to display data
Instatiate and invoke web services as components
o Instantiate and invoke a web service
o Instantiate and invoke a COM component
o Instantiate and invoke a .net component
o Call native functions by using platform invoke
Handle events
o Create event handlers
o Raise events
Use and edit intrinsic objects – include response, request, session, server and application
Create web custom controls and web user controls
Access and manipulate data from MS SQL database by creating and using ad hoc queries and stored procedures
Access and manipulate data from a data store to include relational databases, XML documents, excel files and flat files.
Handle data errors
Implement and understand tracing
o Add trace listeners and trace switches to an application
o Display trace output
Debug, rework and resolve defects in code
Configuration of web application as it relates to modifying the web.config file an dthe machine.config file
Select and config authentication types – windows authentication, IIS or custom authentication
Config and implement session state
Create and manipulate datasets
o Manipulate a dataset schema
o Manipulate a dataset relationship
o Create a strongly typed dataset
Access an XML file using an XMLreader
o Transform dataset data into XML data
o Write a SQL statement that retrieves XML data from an SQL server database
o Update a SQL server database by using XML
Design entity keys
o Include foreign key constraints
o Include primary key constraints
o Include unique key constraints
Create and alter database objects. Objects include constraints, indexes, stored procedures, tables, triggers, user defined functions and views
Retrieve, filter, group, summarize and modify data by using transact-SQL