Website Analysis & Design Specialist / Oracle

360 IT Professionals; City of Albany (NY); On-site; USD 80,000 - 100,000; Full time

Job summary

360 IT Professionals is looking for a Website Analysis & Design Specialist for an 8-month contract in Albany, NY. The role includes design and implementation of data collection systems, transforming legislative requirements into functionality.

The ideal candidate must have significant experience with Oracle PL/SQL and develop software solutions while also preparing documentation.

Qualifications

• 84 months experience developing Oracle PL/SQL using advanced techniques.
• 84 months experience using Oracle development tools.
• 48 months experience with database models including primary and foreign keys.

Responsibilities

• Analyze and design websites and data collection systems.
• Develop software including coding, testing, and implementation.
• Prepare technical and user documentation.

Skills

Oracle PL/SQL

SQL Plus

SQL Developer

SQL Loader

ETL techniques

Database modeling

Job description

Website Analysis & Design Specialist / Oracle

Contract

Duration: 8 month contract

Location: Albany, NY

Position Requirements / Technical Skills

Project Scope – duties of the position:

• Medical Malpractice Data Collection System (MMDCS).
• Update the legacy system (developed in 2002) which currently burdens DOH staff and claim reporters with manual data entry, and implement a new comprehensive system for tracking all malpractice claims and related data.
• Design and implement processes and systems for consistent investigation criteria, automate the detection of duplicate entries, and enable rapid research and accurate reporting to stakeholders.

Daily Tasks

• Analyze and design websites and data collection systems, transforming legislative requirements into system functionality.
• Design system architecture and user interface.
• Develop software—including coding, testing, and implementation.
• Prepare technical and user documentation.

Qualifications

Mandatory Requirement: 84 months experience developing Oracle PL/SQL using advanced PL/SQL programming techniques.

Desirable Qualifications (at least 3 of the following):

• 84 months experience using Oracle development tools such as SQL Plus, SQL Developer, and SQL Loader.
• 48 months experience designing and implementing logical and physical database models, including indexes, primary keys, foreign keys, and constraints.
• 48 months experience performing Extract, Transform, and Load (ETL) techniques.
• 24 months experience optimizing, performance tuning, and debugging PL/SQL.

Local candidates preferred. Immediate interview and placement! Any visa status.