Note: This is a remote position, but have to be office the first day once selected .

The Senior Database Architect is responsible for the analysis, design, development, and implementation of the data architecture in support of the agency mission. The Senior Database Architect will architect the analytical data systems including data warehouse(s), data lake(s), and data mart(s) as best meet the agency requirements. The Senior Database Architect is familiar with a variety of the database technologies, concepts, methodologies, practices, and procedures and rely on experience and judgment to plan and accomplish goals. Database Architects perform a variety of complicated tasks with minimal or no direct supervision. They assist in defining system and application architecture and provide vision, problem anticipation, and problem-solving ability to the agency. They consult with the client to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization.

Role Description:

1. Possesses extensive knowledge of one or more database systems and is capable of hands-on work in all phases of database design and management.
2. Three (3) years of experience working with Microsoft SQL Server.
3. Four (4) years of experience in designing data model and architecture to support high performance, high availability data analytic functions for relational (structured), unstructured, and spatial data sets.
4. Determines data structural requirements by analyzing client operations, applications, programming, reporting, analytics and informatics; reviewing objectives with clients; and evaluating systems.
5. Develops reliable and scalable database solutions through designing and implementing proposed system
6. Defines database physical structure, functional capabilities, security, back-up, and recovery specifications.
7. Produces data flow diagrams and flowcharts; applying optimum access techniques; coordinating installation actions; and documents actions.
8. Participates in the identification, prioritization, and development of technical initiatives and strategies.
9. Works with database analysts to develop methodologies, report views, queries, analytical cubes, and table replications
10. Performs systems analysis on database, and resolves performance, capacity, and replication issues as necessary.
11. Ensures that all data is in the proper format.
12. Develops and maintains database standards and naming conventions.
13. Keeps up to date on emerging database architectures, technologies, and methodologies, and attends training classes as necessary.
14. Understands and knows best practices regarding application of different analytical data solutions such as data warehouse, data lakes, or data marts from the ground up in support of an organization initiative.