Lead Database Architect (SQL Server / Oracle)

Trigyn's direct government client has an immediate need for a Lead Database Architect in Albany, NY.

Description:
? 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 Qualification:
? 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.
? Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

? 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.

For Immediate Response call , or send your resume to

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.