Short Description:
The Senior Database Architect is responsible for designing, developing, and implementing application infrastructure for the Ohio Human Services Data Warehouse to meet the Ohio Housing Finance Agency's objectives and requirements.
Complete Description:
This position will start as part-time, 3 days per week, and will ramp up to full-time after approximately 2-6 weeks.
Resumes are due to the manager on Monday the 14th with interviews that week as well.
The HEARTH Act codifies in law the Continuum of Care planning process and certain data collection requirements and requires HUD to ensure operation of and consistent participation by recipients and sub-recipients of programs authorized by Title IV of the McKinney- Vento Act in HMIS. The purpose of HMIS is to record and store client-level information about the numbers, characteristics and needs of persons who use homeless housing and supportive services and about persons who receive assistance for persons at risk of homelessness over time, to produce an unduplicated count of homeless persons for each Continuum of Care; to understand the extent and nature of homelessness locally, regionally and nationally; and to understand patterns of service use and measure the effectiveness of programs.
HUD envisions that by implementing an HMIS system within each Continuum of Care, homeless individuals, agency directors and program managers, as well as public policy makers will all benefit. The OHSDW project intends to leverage the core continuum-level systems to provide a richer, fuller picture of the homeless population and the services they receive, better enabling agencies to collaborate across continuum and jurisdictional boundaries, and allowing public policy makers to address homelessness issues on a statewide basis.
This position will start as part-time, 3 days per week, and will ramp up to full-time after approximately 2-6 weeks.
The Senior Database Architect is responsible for designing, developing, and implementing infrastructure to provide highly-complex, reliable, and scalable databases to meet the organization’s objectives and requirements. Database Architects are 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 are able to 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 organization. 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.
SDA1
Years of Relevant Experience:
8 plus years of database experience
Preferred Education:
4 year college degree in computer science or related field with advanced study preferred.
Role Description:
•Possesses extensive knowledge of one or more database systems, and is capable of hands-on work in all phases of database design and management.
•Designs, develops, and implements infrastructure to provide highly-complex, reliable, and scalable database to meet the organization's objectives and requirements.
•Analyzes organization's business requirements for database design, and implements changes to database as required.
•Performs systems analysis on database, and resolves performance, capacity, and replication issues as necessary.
•Provides detailed design and specification documentation, including flowcharts, for all aspects of the database.
•Works with database analysts to develop methodologies, report views, queries, and table replications
•Ensures that all the data is in the proper format.
•Participates in the identification, prioritization, and development of technical initiatives and strategies.
•Develops and maintains database standards and naming conventions.
•Keeps up-to-date on emerging database architectures, technologies, and methodologies, and attends training classes as necessary.
Skills:
Skill
Required / Desired
Amount
of Experience
Expert in Data Warehouse design and construction, ETL (extract-tranform-load), performance tuning, and front-end tools
Required
8
Years
Expert in Data Warehouse design techniques to support business intelligence (BI)
Required
8
Years
Expert in SQL Server 2012 Enterprise Edition with knowledge of its Data Warehousing features
Required
8
Years
Experience in analyzing integrity of Data Warehouse data and developing means to correct problems
Required
8
Years
Skilled in configuring the hardware and network infrastructure necessary to support a Data Warehouse
Required
6
Years
Responsible for structuring and maintaining the Data Dictionary for the Data Warehouse
Required
6
Years
Understands Data Warehouse physical platform and multi-tier architecture
Required
6
Years
Understands Data Warehouse technology and can perform as a Data Modeler or Database Administrator
Required
8
Years
Understands data acquisition tools and processes
Required
8
Years
Skilled in project management activities including time management, risk assessment, maintaining project scope, and communication of status to client
Required
6
Years
Excellent team player able to work with cross functional teams
Required
8
Years
Excellent spoken and written communication as well as receptive listening skills, with ability to present complex ideas in a clear, concise fashion to
Required
8
Years
Ability to work with domain experts from multiple external agencies and coordinate efforts among them
Required
8
Years
Familiar with the leading data warehouse/data mart data models such as star schema or snowflake schema
Required
8
Years
Experience in supporting programs to aid homeless populations or other charities
Nice to have
2
Years
Experience in developing web-based applications in Microsoft Visual Studio .NET
Desired
4
Years
Skilled in creating and deploying SQL Server Reporting Services (SSRS) reports
Required
5
Years
Understands and is able to resolve application interface problems
Desired
4
Years