Database Administrator

TOPSYS IT; Austin (TX); Hybrid; USD 100,000 - 140,000; Full time

Job summary

TOPSYS IT in Austin, TX seeks a data warehousing professional to design and optimize data warehouses, data marts, and ETL processes. The role requires hands-on work with Informatica or IBM DataStage and strong SQL across Oracle/ Teradata/ SQL Server environments.

You’ll implement reporting solutions using BO, Cognos, Hyperion or MicroStrategy and ensure high-performance data architectures. Local candidates within 50 miles of Austin preferred; 3 days onsite and 2 days remote.

Qualifications

• Data warehousing and data mart design and implementation.
• Hands-on ETL experience with Informatica or IBM DataStage or similar tools.
• Experience with Oracle, Teradata, SQL Server or similar databases.
• Knowledge of reporting tools like Business Objects, Cognos, Hyperion, MicroStrategy.
• Strong SQL, data dictionary concepts and database design.
• Experience in database performance tuning and benchmarking.

Skills

Data Warehousing

Data Marts

SQL

Data Dictionary

Database Design

Database Performance Tuning

Tools

Informatica

IBM DataStage

Oracle

Teradata

SQL Server

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

Work Schedule: 3 days onsite (Wednesday, Thursday & Friday) + 2 days remote

Local Candidates Only: Must currently reside in Texas and live within a 50-mile radius of Austin. No out-of-state candidates or relocation plans.

• Data Warehousing & Data Marts
• Informatica / IBM DataStage or similar ETL tools
• Oracle, Teradata, SQL Server, or similar databases
• Business Objects, Cognos, Hyperion, MicroStrategy, or similar reporting tools
• SQL, Data Dictionary & Database Design
• Database Performance Tuning & Benchmarking