Job ID: TX-2022C0065 (912090602)
Remote/Local Oracle DBA/Architect with governance, MDM, modeling, security, DW, cloud, clustering, BI, Azure/AWS experience
Location: Austin TX (DFPS)
Duration: 2-14 months
Positions: 3 (2)
Candidates currently residing outside of the State of Texas, will be required to relocate to Texas, if selected for this position and the offer is accepted.
In order to assist in quickly acclimating the contractor to DFPS/ITS, they will be required to attend a virtual onboarding session and to physically pick up agency issued equipment in Austin, TX on their first day of contract. There will be additional appointments and blocks of time that the contractor will need to attend during their first week of assignment.
Minimum Requirements:
YearsRequired/PreferredExperience
3RequiredExperience in database administration, data analysis, research or architecture work in Oracle database
3RequiredResearch, define and document proper governance and stewardship practices, engaging various business groups and technologies
3RequiredProven experience with data security, master data management, meta data management and support for creation of data dictionaries, data lineage flows and other documentation
3RequiredIdentify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytical models, and data visualization
3RequiredDefine and govern data modeling and design standards, tools, best practices, and related development for enterprise data models
3RequiredExperience with identifying and documenting data sources, risks and data controls and ability to translate privacy and information security policies into operational procedures
2RequiredEnterprise data warehouse and storage design experience on both on-premise and cloud platforms
2RequiredExposure to data classification, clustering, deduplication methodologies
2RequiredExperience in master data management, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture
2RequiredKnowledge of enterprise information management processes and methodologies, relational database management systems, and business intelligence/analytics tools, frameworks and infrastructure
2RequiredKnowledge of database software and technologies, cloud technologies and engineered systems and enterprise software products, including Microsoft Azure AWS and Oracle
2RequiredExcellent verbal and written communication skills; ability to tailor communication to audiences of all levels of technical knowledge
2RequiredSkill in monitoring projects, and establishing measurement and tracking for project tasks
2RequiredAbility to analyze, evaluate, and summarize data and information for accuracy and conformance to standards
2RequiredAbility to document policies, procedures, and processes
2RequiredAbility to exercise sound judgement, critical thinking and analytical skills
2RequiredAbility to establish and maintain effective working relationships at all levels of the organization
1PreferredKnowledge of the Texas Project Delivery Framework
1PreferredStrong 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.
Work involves the following:
· Establishes database and system requirements by analyzing and evaluating business operations, applications, and programming.
· Coordinates and gathers data model requirements, and assists with the analysis, design, modification, and maintenance of database structures, models and architectures.
· Supports data analytics and business intelligence systems and coordinates the implementation of database changes to support new and modified applications, ensuring that new designs conform to standards and guidelines.
· Recommends and develops standards, procedures, and guidelines on creating and maintaining data models and governed data, ensuring completeness and quality.
· Reviews changes to logical and physical data modeling, metadata, relational database models, and prepares physical data models from logical data models.
· Supports improved data quality by charting the reduction of data redundancy, fragmentation and elimination of unnecessary movement of data.
· Assists in selecting data management tools and developing the standards, usage guidelines, and procedures for using those tools to ensure the integrity of the database environment.
· Assists in performing root cause analyses related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems.
· Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment