We are looking for a Full-time contractor or employee for a Oracle Database Architect.
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
CANDIDATE SKILLS AND QUALIFICATIONS(Required):
- Experience in database administration, data analysis, research or architecture work in Oracle database.
- Research, define and document proper governance and stewardship practices, engaging various business groups and technologies.
- Proven experience with data security, master data management, meta data management and support for creation of data dictionaries, data lineage flows and other documentation.
- Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytical models, and data visualization.
- Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
- Experience with identifying and documenting data sources, risks and data controls and ability to translate privacy and information security policies into operational procedures.
- Enterprise data warehouse and storage design experience on both on-premise and cloud platforms.
- Exposure to data classification, clustering, deduplication methodologies.
- Experience in master data management, metadata, reference data, data warehousing, and business intelligence principles and processes, including technical architecture.
- Knowledge of enterprise information management processes and methodologies, relational database management systems, and business intelligence/analytics tools, frameworks and infrastructure.
- Knowledge of database software and technologies, cloud technologies and engineered systems and enterprise software products, including Microsoft Azure AWS and Oracle.
- Excellent verbal and written communication skills; ability to tailor communication to audiences of all levels of technical knowledge.
- Skill in monitoring projects, and establishing measurement and tracking for project tasks.
- Ability to analyze, evaluate, and summarize data and information for accuracy and conformance to standards.
- Ability to document policies, procedures, and processes.
- Ability to exercise sound judgement, critical thinking and analytical skills.
- Ability to establish and maintain effective working relationships at all levels of the organization.
Skills(Preferred):
- Knowledge of the Texas Project Delivery Framework.
- 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.