Database Architect

24-month contract position with the State of New York Department of Health. In-person interviews required.

Responsibilities

• Analysis and design of database objects and data collection systems, including transformation of legislative requirements into system functionality
• Data modelling
• Software development tasks including Oracle PL/SQL and MS SQL Server coding, testing, and implementation
• Troubleshooting application issues to find solutions
• Preparation of technical and user documentation

Requirements

• 84 months of experience interpreting physical database models and working with relational database concepts (indexes, primary and foreign keys, constraints) using both Oracle and Microsoft SQL Server
• 84 months of experience developing with Oracle PL/SQL, including database packages, procedures, functions, and triggers
• 84 months of experience with Oracle version 11g or later
• 84 months of experience using Oracle programming tools (SQL*Plus, SQL*Loader, or other Oracle database programming tools)
• 60 months of experience developing with Microsoft Transact-SQL (T-SQL)
• 60 months of experience designing relational databases
• 24 months of experience integrating multiple database schemas
• 18 months of experience using Git

Required Documentation

• Résumé
• Copy of candidate identification (e.g., driver’s license, green card, visa, passport)
• Any documents referenced in the qualifications (e.g., professional certifications, degrees)