Database Administrator II / Data Warehouse DBA

About the role

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.

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 Qualifications

• 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.