Database Architect
i-Link Solutions - Albany, New York, United States
Work at i-Link Solutions
Overview
- View job
Overview
Database Architect
role at
i-Link Solutions 3 days ago Be among the first 25 applicants Join to apply for the
Database Architect
role at
i-Link Solutions Get AI-powered advice on this job and more exclusive features. Agency: Information Technology Services (ITS)
Please call nysreqs@ilinksolutions.com
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. 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. 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.
Job Title: Database Architect - Expert
Task ID: HBITS-07-14209
Position Duration: 24 months
Client: State of NY
Agency: Information Technology Services (ITS)
Please call
(703) 466-0951 | (571) 351-1868
or email at
nysreqs@ilinksolutions.com
Description
18. Data Migration
Mandatory Qualification:
1. 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. 2. 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. 3. 84 months of experience using various SDLC methodologies (e.g., Agile, Waterfall, Iterative) and experience applying them in software development projects. 4. 84 months of experience in systems analysis, including requirements gathering, process modeling, and system design. 5. 84 months experience in relational database management systems (RDBMS) (e.g. SQL Server, Oracle.) 6. 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. 7. 84 months experience in data governance principles and practices, to ensure data quality, traceability (data lineage), and data asset management.
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. 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.
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Information Technology Referrals increase your chances of interviewing at i-Link Solutions by 2x Get notified about new Database Architect jobs in
Albany, NY . Database Architect (Data Migration & Data Modeling)
HBITS-07-14199-Database Architect-Expert
Database Architect (In-Person Interview)
Lead Database Architect (SQL Server / Oracle)
HBITS 07-14182 Systems Architect - Expert
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 1 week ago Albany, NY $144,000.00-$329,100.00 1 week ago Managed Services - Test Data Management (TDM) Architect - Manager
Albany, NY $99,000.00-$232,000.00 3 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 3 days ago Discovery Database Administrator (DBA) (Top Secret Clearance Required)
Albany, NY $142,100.00-$192,850.00 3 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