<>Database Administrator 2 (Data Warehouse & Reporting) – M204 Database Experience Required<>Location : Austin, Texas (Hybrid)<>Client : State of Texas<>Experience Required : Minimum 15+ Years<>Work Arrangement : Hybrid Position
- 3 Days Remote
- Mandatory Onsite: Mondays & Tuesdays in Austin, TX
Local Candidate Requirement
- Texas Candidates Only
- Valid Texas Driver''s License Required
- Candidates must currently reside in Texas
- Candidates must be local to Austin or within commuting distance
- Candidates currently located outside Texas and planning to relocate will NOT be considered
Position Overview
The State of Texas is seeking an experienced Database Administrator 2 (Data Warehouse & Reporting) with strong expertise in M204 (Model 204) databases, Data Warehousing, Reporting, and Enterprise Database Technologies.
The ideal candidate will possess extensive experience designing, implementing, maintaining, and supporting enterprise data warehouse environments, reporting platforms, and database solutions while working with both technical and business stakeholders.
Required Skills & Experience
Database Administration & Data Warehousing
- Strong knowledge of Database Management Systems (DBMS)
- Extensive experience with Data Warehouse development, implementation, and maintenance
- Experience developing and supporting Data Marts
- Strong understanding of Decision Support Systems
- Expertise in Data Dictionary development and maintenance
- Experience using database access tools for application delivery
Data Warehouse Architecture & Modeling
- Experience with Data Warehouse implementation lifecycle
- Business requirements gathering and analysis
- Logical and physical database design
- Data sourcing and transformation
- Data loading and integration
- Structured Query Language (SQL)
Data Modeling
- Star Schema design
- Snowflake Schema design
- Highly normalized data models
- Data population strategies and methodologies
ETL Tools
Experience with GUI-based ETL platforms such as:
- Informatica
- IBM WebSphere DataStage
- Similar enterprise ETL tools
Enterprise Database Platforms
Hands-on experience with:
- Oracle Database
- SQL Server
- Teradata
- Other enterprise-class database technologies
Reporting & Analytics Tools
Experience with:
- Business Objects
- Cognos
- Hyperion
- MicroStrategy
- Similar reporting and business intelligence platforms
Additional Required Skills
- Oracle Database Administration experience
- SSRS Report Creation and Development
- M204 (Model 204) Database Experience
- Benchmarking methodologies and performance analysis
- Strong analytical and problem-solving abilities
- Excellent verbal and written communication skills
- Ability to work with both technical and non-technical stakeholders
- Proven ability to manage multiple priorities and deliverables
- Strong teamwork, collaboration, and interpersonal skills
Preferred Qualifications
- Prior experience supporting large-scale government or public-sector environments
- Experience with enterprise reporting and business intelligence initiatives
- Experience supporting mission-critical data warehouse platforms
Never miss an opportunity! Create an alert based on the job you applied for.
