HBITS 07-14209 Database Architect - Expert

Job Description

Project / Program
DEC - Pesticide Reporting Law using Outsystems DMNDDEC - Environmental Bond Act (EBA) Information System Phase 3 DMNDDEC: Special Licenses System (SLS) Modernization DMNDDEC Laboratory Info Mgt System - RFP DMND0004541

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

Day to Day Tasks
1. Develop and execute complex queries and procedures.
2. Manage and maintain scripts and code in source control repository.
3. Interact with the development team and business users to understand business process flow and business rules.
4. Document data models data migration and data quality requirements and solutions.
5. Guide and coordinate cross-functional teams (developers DBAs business analysts) to ensure successful project execution.
6. Monitor project progress identify and resolve roadblocks and escalate issues as needed.
7. Write complex SQL queries stored procedures and functions to retrieve manipulate and analyze data.
8. Utilize analytic functions and other advanced SQL techniques for data aggregation and transformation.
9. Optimize SQL queries for performance.
10. Use SQL to extract data for data analysis reporting and business intelligence.
11. Develop and maintain reports and dashboards to track key performance indicators (KPIs).
12. Analyze existing systems and data flows to identify areas for improvement.
13. Communicate technical concepts to both technical and nontechnical audiences.
14. Provide technical guidance and mentorship to junior team members.
15. Document data flows system integrations and data governance processes.
16. Provide knowledge transfer to other data management team members.
17. 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.

Mandatory Qualifications
Database Architect - 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.

Expert - 84 Months: 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.

Requested Qualifications
- 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.