Senior Database Administrator - Data Warehouse & Power BI

Masterapp Labs; Austin (TX); Hybrid; USD 83,000 - 124,000; Part time

Job summary

Masterapp Labs is seeking a Database Administrator to manage production databases and ensure data integrity in a hybrid Austin environment. You will guide development and maintenance of data warehouses, BI reporting, and security procedures.

The role requires extensive experience with DBMS, data modeling, ETL tools, and enterprise DB platforms, plus strong communication and teamwork abilities.

Qualifications

• 5 years of experience with database management systems and data warehouse tools.
• Extensive experience in development, implementation and maintenance of data warehouses and data marts.
• Experience with data dictionary and building data dictionaries.
• Ability to use database access tools for application delivery.
• Strong analytical, planning and management reporting skills.
• Excellent oral and written communication and teamwork.
• Knowledge of data warehouse design: star and snowflake schemas.
• Experience with ETL tools such as Informatica or DataStage.
• Experience with enterprise databases (Teradata, Oracle, SQL Server).
• Experience with reporting tools (Business Objects, Cognos, Hyperion, MicroStrategy).
• Experience with data warehouse implementation from requirements to data loading and SQL.
• Preferred: PowerBI report creation.

Responsibilities

• Enters codes to create production database.
• Monitors database performance and memory usage.
• Directs programmers and analysts to modify DBMS.
• Reviews and corrects programs; answers user questions.
• Confer with coworkers on data changes and cost impacts.
• Tunes database performance for efficiency.
• Specializes in one or more DBMS types.
• Supports planning, development, and maintenance of integrated database systems.
• Ensures data integrity and controls redundancy across databases.
• Performs data modeling and creates physical data models.
• Implements database security and disaster recovery procedures.
• Assists in installing database software and designing databases.
• Benchmarking and threshold testing of databases.

Skills

DBMS knowledge

Data modeling

SQL proficiency

Analytical ability

Communication

Teamwork

Benchmarking

Data governance

Tools

Teradata

Oracle

SQL Server

Informatica

WebSphere DataStage

PowerBI

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

Masterapp Labs is seeking a Database Administrator to manage production databases and ensure data integrity in a hybrid Austin environment. You will guide development and maintenance of data warehouses, BI reporting, and security procedures.

The role requires extensive experience with DBMS, data modeling, ETL tools, and enterprise DB platforms, plus strong communication and teamwork abilities.