Database Administrator – Data Warehouse & BI (Hybrid)

Confidential Jobs; Austin (TX); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Confidential Jobs in Austin, TX seeks an experienced Database Administrator with data warehousing expertise. You will design, implement, and maintain enterprise databases, data warehouses, and data marts.

You will model data using Star and Snowflake schemas, write complex SQL, and tune performance. You will also manage backup/DR, security procedures, and data governance, while supporting ETL processes with Informatica or DataStage and BI tools like Power BI, Business Objects, Cognos, Hyperion,

Qualifications

• 5+ years experience in database administration and data warehousing.
• Experience with enterprise databases (Oracle, SQL Server).
• Proficient with data modeling (star/snowflake).
• Strong SQL skills and performance tuning.

Responsibilities

• Design, develop, implement, maintain, and administer enterprise database systems.
• Develop and maintain data warehouses and data marts.
• Model data using Star/Snowflake/normalized schemas.
• Develop DB objects: tables, views, procedures, queries.
• Perform SQL development, optimization, and tuning.
• Monitor DB performance, resources, and storage.
• Implement backup, recovery, DR, and security procedures.
• Support DB installations, upgrades, migrations, and reorganizations.
• Ensure data integrity and consistent definitions.
• Maintain the data dictionary and collaborate with teams.
• Utilize GUI-based ETL tools and BI platforms.

Skills

Database Admin

Data Warehousing

Data Marts

Star Schema

Snowflake Schema

SQL

Data Modeling

Oracle

SQL Server

BI Tools

Data Dictionary

Performance Tuning

Backup & DR

ETL Tools

Tools

Informatica

IBM WebSphere DataStage

Power BI

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

Confidential Jobs in Austin, TX seeks an experienced Database Administrator with data warehousing expertise. You will design, implement, and maintain enterprise databases, data warehouses, and data marts.

You will model data using Star and Snowflake schemas, write complex SQL, and tune performance. You will also manage backup/DR, security procedures, and data governance, while supporting ETL processes with Informatica or DataStage and BI tools like Power BI, Business Objects, Cognos, Hyperion,