Provide a short description of the Position: Act as Expert Database Architect working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below.
Provide a list of the day-to-day tasks to be performed by the Selected Candidate: " Interact with Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) products, and IT teams to determine and design application and system requirements. " Design and implement Enterprise datawarehouse and curate data for authorized individuals to access. " Identify internal and external data sources, collaborating with business subject matter experts to determine their data storage and organizational needs and use the information to create and maintain data infrastructure. " Participate in the entire Secure Software Development Life Cycle (SSDLC) including debugging and configuring solution. " Identify, recommend and implement ODI/ELT and ETL process and architecture improvements.
" Manage build phase and quality assured code to ensure fulfilling requirements and adhering to ODI/ELT and ETL architecture. " Resolve complex design and development issues. " Identifying areas for improvement in current systems " Coordinate with business, vendor and IT team members to reach project milestones and deadlines " Create processes to maintain data quality and high accessibility " Design and document all components of approved application solutions including system integrations. " Write readable, testable code using advanced analytical functions. " Test and debug including, but not limited to: perform system testing and development of testing plans. " Review and refactor code including, but not limited to: performance tuning of existing code, code reviews, and suggest changes that will best fit the Agency/business needs. " Use a ticketing system to track and manage incidents, service requests, problems, changes, and release/deployment.