Database Administrator II / Data Warehouse DBA

We are seeking an experienced Database Administrator II to support enterprise database and data warehouse initiatives for a Texas state agency. The ideal candidate will have strong hands-on experience with enterprise databases, data warehousing, ETL, data modeling, SQL, and analytical/reporting platforms.

Key Responsibilities

• Support development, implementation, administration, and performance optimization of enterprise databases and data warehouses.
• Design and maintain logical and physical data models, including Star Schema, Snowflake Schema, and normalized models.
• Support data sourcing, transformation, loading, data marts, and data warehouse implementations.
• Monitor database performance, troubleshoot issues, and support backup, recovery, security, and disaster recovery processes.
• Develop and maintain data dictionaries and ensure data integrity and consistency.
• Work with technical and business teams to translate requirements into scalable database solutions.
• Support analytical and reporting environments and tools.

Required Qualifications

• 5+ years of database management and data warehousing experience.
• 5+ years developing and maintaining data warehouses/data marts.
• Strong experience with SQL and data modeling.
• Experience with Informatica, IBM DataStage, or similar ETL tools.
• Experience with enterprise databases such as Oracle, SQL Server, Teradata, or similar.
• Experience with reporting/analytics tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar.
• Strong analytical, troubleshooting, communication, and collaboration skills.

Preferred

• 5+ years of Oracle Database experience.
• Experience creating Power BI reports.

Location Requirement: Candidates must currently reside within 50 miles of Austin, Texas. This position requires onsite work Wednesday, Thursday, and Friday. Candidates currently outside Texas who plan to relocate cannot be considered.