Database Architect (In-Person Interview)

****In-Person Interview****

Description

ITS is seeking database architect to help support several projects for the NYS Department of Environmental Conversation.

Duties

• Develop and execute complex queries and procedures.
• Manage and maintain scripts and code in source control repository.
• Interact with the development team and business users to understand business process flow and business rules.
• Document data models, data migration and data quality requirements and solutions.
• Guide and coordinate cross-functional teams (developers, DBAs, business analysts) to ensure successful project execution.
• Monitor project progress, identify and resolve roadblocks, and escalate issues as needed.
• Write complex SQL queries, stored procedures, and functions to retrieve, manipulate, and analyze data.
• Utilize analytic functions and other advanced SQL techniques for data aggregation and transformation.
• Optimize SQL queries for performance.
• Use SQL to extract data for data analysis, reporting, and business intelligence.
• Develop and maintain reports and dashboards to track key performance indicators (KPIs).
• Analyze existing systems and data flows to identify areas for improvement.
• Communicate technical concepts to both technical and non-technical audiences.
• Provide technical guidance and mentorship to junior team members.
• Document data flows, system integrations, and data governance processes.
• Provide knowledge transfer to other data management team members.
• Data Modeling:
  • Design, develop, and implement conceptual, logical, and physical data models for OLTP systems.
  • Maintain and update existing data models to reflect changing business requirements.
  • Maintain Entity Relationship Diagrams for each model.
  • Maintain a complete data dictionary for all new models
  • Each table and column should be fully described.
  • Generate and publish data definition language (DDL) from physical data model to target databases.
  • Manage the promotion of database changes throughout the environments.
  • Ensure data models are aligned with data governance principles and standards.
  • Manage, monitor and troubleshoot issues.
• Data Migration
  • Design, develop, and implement data migration strategies, including data extraction, transformation, and loading (ETL) processes for the migration of data.
  • Perform all stages of data migration from data analysis to pre go-live validations, user acceptance testing, user sign-off, cut-over planning and post go-live validations.
  • Interact with business users to understand business process flow, business logics and to assess major data objects, data volume for data migration.
  • Document data migration processes and procedures.
  • Test and validate data.
  • Select and implement appropriate integration patterns and technologies for data migration (e.g., APIs, message queues, bulk data transfer).
  • Develop and maintain data migration scripts and tools.
  • Ensure data quality and integrity throughout the migration process.
  • Develop data quality reports for the business to identify and drive data cleansing and remediation efforts.
  • Ensure data migration activities comply with industry standards, best practices, and organizational guidelines (e.g., data security, privacy regulations).
  • Manage, monitor and troubleshoot issues.

Mandatory Requirements

• Experience (15+ Years)
• 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 problems.

Requirements