Database Architect - Expert

Avenues - Albany, NY

Full-time - Senior

Albany, NY

Professional, Scientific, and Technical Services

About the position

The Database Architect position at Avenues International involves determining database structural requirements by analyzing client operations and applications. The role requires extensive experience in architecting, designing, and implementing data warehousing and enterprise application integration. The candidate will provide database support, resolve user issues, and ensure the effective integration of various systems.

Responsibilities

• Analyze client operations and applications to determine database structural requirements.
• Review objectives with clients and evaluate current systems.
• Provide database support by coding utilities and responding to user questions.
• Resolve problems related to database systems.
• Architect, design, document, and implement data warehousing and enterprise application integration.
• Develop data integrations for heterogeneous systems and business intelligence using SQL.
• Perform comparative analysis for designing new transactional databases and data warehouses.
• Implement systematic data error/recovery and cleanup procedures.
• Integrate with Kafka.

Requirements

• 84 months experience working with Agency/business subject matter experts to understand business needs/requirements.
• 84 months experience architecting, designing, documenting, and implementing data warehousing and enterprise application integration.
• 84 months experience in data modeling and designing normalized Data Warehouse environments for enterprise level applications.
• 84 months experience developing data integrations using SQL.
• 72 months experience performing comparative analysis for designing new transactional databases and data warehouses.
• 60 months experience in analytical reasoning 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.