30% NT/SQL Administration:

• Coordinates all operation and administrative activities as they relate to the NT/SQL file servers and application servers.
  
  
• Sets up and maintains user accounts and login scripts. Manages and administers the NT/SQL servers.
  
  
• Works with customers and developers to ensure that production requirements are met.
  
  
• Participates in Application System Design and other activities where specific networking technologies are impacted or are of concern.
  
  
• Ensures the logical and physical security and integrity of the NT servers and data.
  
  
• Ensures that modifications to the system are well planned, tested and documented before being implemented.
  
  
• Develops, maintains and documents appropriate policies and procedures to ensure the viability and security of the NT server environment, including tape backup and restore, user access control, production change control, and disaster recovery.
  
  
• Monitors the NT/SQL system for security violations on a regular basis.

40% SQL Development, Web-based Development, and Custom Reporting:
Design·

• Translates functional requirements into a technical design.
  
  
• Ensures unit test data is prepared and maintained.
  
  
• Develops accurate and meaningful detail design documents and ensures their completeness and accuracy by confirming approach with other MIS staff and the customer.
  
  
• Participates in the receipt of management and customer approval of design.
  
  
• Defines and ensures design is complete, standards are met, and interfaces are addressed.
  
  
• Evaluates proposed hardware and software products.

Programming

• Develops accurate and efficient programs, which meet specifications and standards.
  
  
• Conducts code reviews with other developers.
  
  
• Prepares and tests plans.

Testing

• Prepares integration test plans.
  
  
• Integrates testing and stress testing.
  
  
• Identifies system deficiencies as errors or enhancements.
  
  
• Recommends possible solutions and implements approved solutions.

Documenting

• All supporting activities outlined above should be documented clearly, accurately, and consistently.

30% Support the Administrative Production Systems:

• Monitors the production systems to ensue successful daily processing. This includes the monitoring, maintaining, performance tuning, backup and recovery of the Informix databases consistent with our Level of Service agreements with the customer.
  
  
• Troubleshoots production exceptions. Analyzes and prioritizes problems and impacts along with the customer and/or Business Analyst. Researches and implements solutions with customer and/or Business Analyst involvement.
  
  
• Installs software upgrades (applications or tools) and conducts technical tests on these upgrades to ensure they are fully tested and acceptable before migrated to a production environment.
   

• Keeping up-to-date with related technologies at WHOI, features and function of PC operating systems, the development environment, which may be HP, Informix, SQL, C++, and application software. This is a significant undertaking as the personal computer and networking technologies are in a constant state of change.
  
  
• Understanding, at a detailed level, how Bi-Tech is technically structured to best support the operational needs of the administrative area.
  
  
• Maintaining a coordinated, flexible and successful business approach within a fast-paced changing environment.
  
  
• Managing multiple requests from internal and external sources, often with conflicting or non-integrated needs and responsibilities.
  
  
• Building and maintaining teamwork with other departments