Jobs via Dice
Database Architect (In-Person Interview)
Jobs via Dice - Albany, New York, United States
Work at Jobs via Dice
Overview
- View job
Overview
Database Architect (In-Person Interview)
Join to apply for the
Database Architect (In-Person Interview)
role at
Jobs via Dice Database Architect (In-Person Interview)
2 days ago Be among the first 25 applicants Join to apply for the
Database Architect (In-Person Interview)
role at
Jobs via Dice Get AI-powered advice on this job and more exclusive features. Dice is the leading career destination for tech experts at every stage of their careers. Our client, Sligo Software Solutions Inc.,, is seeking the following. Apply via Dice today!
Greetings from
Sligo Software Solutions, Inc.
!!
This is
Yashwanth
from SLIGO. We have an urgent requirement for
Database Architect (In-Person Interview)
position with our client.
Title
: Database Architect (In-Person Interview)
Location
: Albany, New York
Duration
: 24 Months
Client
: NY State - Information Technology Services (ITS)
Job ID:
SLG - 19 - 10963
Respond by:
08/15/25 5:00 PM
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
This is an 100% Onsite 84 months experience leading and executing end-to-end data migration projects (e.g. planning, design, execution, validation) using different integration patterns and technologies, ensuring compliance with industry standards, best practices, and organizational guidelines. 84 months' experience in designing and implementing data models for OLTP systems to support various business needs. This includes conceptual, logical, and physical data modeling. 84 months of experience using various SDLC methodologies (e.g., Agile, Waterfall, Iterative) and experience applying them in software development projects. 84 months of experience in systems analysis, including requirements gathering, process modeling, and system design. 84 months' experience in relational database management systems (RDBMS) (e.g. SQL Server, Oracle.) 84 months experience using SQL to query, manipulate, and analyze data for data analysis, reporting, and business intelligence, with a background in analytic functions and other advanced SQL techniques for data aggregation and transformation. 84 months experience in data governance principles and practices, to ensure data quality, traceability (data lineage), and data asset management. R sum Copy of Candidate Identification (i.e., Driver's License//Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Information Technology Industries Software Development Referrals increase your chances of interviewing at Jobs via Dice by 2x Sign in to set job alerts for “Database Architect” roles.
HBITS-07-14199-Database Architect-Expert
Data Systems Architect Stf - 1LMX / CloudPak
HBITS 07-14182 Systems Architect - Expert
Lead Database Architect (SQL Server / Oracle)
Albany, NY $130,000.00-$150,000.00 1 month ago Managed Services - Solution Architect - Data Platforms & Integrations - Senior Manager
Albany, NY $124,000.00-$280,000.00 1 week ago Troy, NY $144,000.00-$329,100.00 6 days ago Albany, NY $144,000.00-$329,100.00 6 days ago Managed Services - Test Data Management (TDM) Architect - Manager
Albany, NY $99,000.00-$232,000.00 2 weeks ago Albany, NY $80,000.00-$130,000.00 1 year ago Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)
Albany, NY $182,700.00-$263,900.00 2 days ago Discovery Database Administrator (DBA) (Top Secret Clearance Required)
Albany, NY $142,100.00-$192,850.00 2 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr
Join to apply for the
Database Architect (In-Person Interview)
role at
Jobs via Dice Database Architect (In-Person Interview)
2 days ago Be among the first 25 applicants Join to apply for the
Database Architect (In-Person Interview)
role at
Jobs via Dice Get AI-powered advice on this job and more exclusive features. Dice is the leading career destination for tech experts at every stage of their careers. Our client, Sligo Software Solutions Inc.,, is seeking the following. Apply via Dice today!
Greetings from
Sligo Software Solutions, Inc.
!!
This is
Yashwanth
from SLIGO. We have an urgent requirement for
Database Architect (In-Person Interview)
position with our client.
Title
: Database Architect (In-Person Interview)
Location
: Albany, New York
Duration
: 24 Months
Client
: NY State - Information Technology Services (ITS)
Job ID:
SLG - 19 - 10963
Respond by:
08/15/25 5:00 PM
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
This is an 100% Onsite 84 months experience leading and executing end-to-end data migration projects (e.g. planning, design, execution, validation) using different integration patterns and technologies, ensuring compliance with industry standards, best practices, and organizational guidelines. 84 months' experience in designing and implementing data models for OLTP systems to support various business needs. This includes conceptual, logical, and physical data modeling. 84 months of experience using various SDLC methodologies (e.g., Agile, Waterfall, Iterative) and experience applying them in software development projects. 84 months of experience in systems analysis, including requirements gathering, process modeling, and system design. 84 months' experience in relational database management systems (RDBMS) (e.g. SQL Server, Oracle.) 84 months experience using SQL to query, manipulate, and analyze data for data analysis, reporting, and business intelligence, with a background in analytic functions and other advanced SQL techniques for data aggregation and transformation. 84 months experience in data governance principles and practices, to ensure data quality, traceability (data lineage), and data asset management. R sum Copy of Candidate Identification (i.e., Driver's License//Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Information Technology Industries Software Development Referrals increase your chances of interviewing at Jobs via Dice by 2x Sign in to set job alerts for “Database Architect” roles.
HBITS-07-14199-Database Architect-Expert
Data Systems Architect Stf - 1LMX / CloudPak
HBITS 07-14182 Systems Architect - Expert
Lead Database Architect (SQL Server / Oracle)
Albany, NY $130,000.00-$150,000.00 1 month ago Managed Services - Solution Architect - Data Platforms & Integrations - Senior Manager
Albany, NY $124,000.00-$280,000.00 1 week ago Troy, NY $144,000.00-$329,100.00 6 days ago Albany, NY $144,000.00-$329,100.00 6 days ago Managed Services - Test Data Management (TDM) Architect - Manager
Albany, NY $99,000.00-$232,000.00 2 weeks ago Albany, NY $80,000.00-$130,000.00 1 year ago Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)
Albany, NY $182,700.00-$263,900.00 2 days ago Discovery Database Administrator (DBA) (Top Secret Clearance Required)
Albany, NY $142,100.00-$192,850.00 2 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr