Database Architect (Data Migration & Data Modeling)

• 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.
• Experience in designing and implementing data models for OLTP systems to support various business needs. This includes conceptual logical and physical data modeling.
• Experience using various SDLC methodologies (e.g. Agile Waterfall Iterative) and experience applying them in software development projects.
• Experience in systems analysis including requirements gathering process modeling and system design.
• Experience in relational database management systems (RDBMS) (e.g. SQL Server Oracle.)
• 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.
• Experience in data governance principles and practices to ensure data quality traceability (data lineage) and data asset management.

Responsibilities:

• 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. 18. 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.