Database Architect; COTS, ODI, SQL, Kafka

DOT, Database Architect, Expert

30 month contract

Virtual Interview

Selected candidates are expected to work in Albany office 2-3 days per week

• Write clean, 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.
• Deploy fully functional applications.
• Use a ticketing system to track and manage incidents, service requests, problems, changes, and release/deployment.

Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problem

• 84+ months:
  Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 months experience working with Agency/business subject matter experts to understand business needs/requirements, Vendors of Commercial Off the Shelf (COTS) Business products, and technology teams to determine and design data warehouse, application and system requirements.
• 84 months experience architecting, designing, documenting, and implementing data warehousing, COTS and Custom business application integrations, and master data management.
• 84 months experience data modeling and designing normalized Data Warehouse environments for enterprise level applications; and, implementing those designs using Oracle Data Integrator (ODI) and Extract, Transform, Load technologies
• 84 months experience developing data integrations for heterogeneous systems and business intelligence using SQL (Structured Query Language).
• 72 months experience performing database comparative analysis for designing new transactional databases and data warehouses, as well as improvements in existing transactional databases and data warehouses.
• 60 months experience in analytical reasoning, computation, interpretation, and presentation of data to solve business problems.
• 48 months experience implementing systematic Data Error/Recovery and Cleanup procedures
• 24 months experience integrating with Kafka.