What are the responsibilities and job description for the Database Architect 3 position at Smart IMS?
Texas Department of Family and Protective Services requires the services of 3 Database Architect 3 , hereafter referred to as Candidate(s), who meets the general qualifications of Database Architect 3, Data / Database Administration and the specifications outlined in this document for the Texas Department of Family and Protective Services .
All work products resulting from the project shall be considered "works made for hire" and are the property of the Texas Department of Family and Protective Services and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Texas Department of Family and Protective Services will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).
Work involves the following :
- Performs advanced (senior-level) data analysis and architecture work. Works under minimal supervision, with extensive latitude for the use of initiative and independent judgment. Employees at this level may be considered technical experts in the field and may :
o Select data management tools and develop standards, usage guidelines, and procedures for those tools.
o Identify appropriate data sourcing and extraction processes, and identify and nominate sources as systems of record for data usage in various applications.
o Perform root cause analyses related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems
o Determines database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems.
II. CANDIDATE SKILLS AND QUALIFICATIONS
Minimum Requirements :
Candidates that do not meet or exceed the minimum stated requirements (skills / experience) will be displayed to customers but may not be chosen for this opportunity. Years Required / Preferred Experience 12 Required Experience in master data management, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture 12 Required Experience in database administration, data analysis, research or architecture work in Oracle database 12 Required Proven experience with data security, master data management, meta data management and support for creation of data dictionaries, data lineage flows and other documentation 12 Required Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytical models, and data visualization 12 Required Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models 12 Required Experience with identifying and documenting data sources, risks and data controls and ability to translate privacy and information security policies into operational procedures 12 Required Engage with various business groups and technology to research, define and document proper governance and stewardship practices 8 Required Enterprise data warehouse and storage design experience on both on-premise and cloud platforms 8 Required Exposure to data classification, clustering, deduplication methodologies 8 Required Knowledge of enterprise information management processes and methodologies, relational database management systems, and business intelligence / analytics tools, frameworks and infrastructure 8 Required Knowledge of database software and technologies, cloud technologies and engineered systems and enterprise software products, including Microsoft Azure AWS and Oracle 8 Required Excellent verbal and written communication skills; ability to tailor communication to audiences of all levels of technical knowledge 8 Required Skill in monitoring projects, and establishing measurement and tracking for project tasks 8 Required Ability to analyze, evaluate, and summarize data and information for accuracy and conformance to standards 8 Required Ability to document policies, procedures, and processes 8 Required Ability to exercise sound judgement, critical thinking and analytical skills 8 Required Ability to establish and maintain effective working relationships at all levels of the organization 1 Preferred Knowledge of the Texas Project Delivery Framework 1 Preferred Strong working knowledge of the following DFPS systems / programs (including but not limited to) : IMPACT, PACES, ABCS, PEIRS, NEICE, e-Report, e-Travel, General Placement Search and Community Based Care.
III. TERMS OF SERVICE
Services are expected to start 09 / 11 / 2024 and are expected to complete by 08 / 31 / 2025 . Total estimated hours per Candidate shall not exceed 1936 hours. This service may be amended, renewed, and / or extended providing both parties agree to do so in writing.
Salary : $160
