Data Warehouse DBA — Hybrid (Austin)

Genius Road, LLC; Austin (TX); Hybrid; USD 90,000 - 140,000; Full time

Job summary

Genius Road, LLC in Austin, Texas is seeking an experienced Database Administrator to support the design, implementation, maintenance, security, and performance of enterprise database and data warehouse environments.

This role requires collaborating with technical and business teams to ensure data integrity, availability, and accessibility, with a focus on SQL, data warehousing, and reporting tools. The position is hybrid (3 days onsite) in Austin and is limited to local candidates.

Qualifications

• 5+ years in database administration, management, and data warehousing with strong SQL and development experience.
• Expertise with database management systems, data warehouses, marts, and decision support tools.
• Experience developing and maintaining data warehouses and data marts.
• Data modeling techniques include Star Schema, Snowflake Schema, and normalized models.
• Experience with enterprise databases such as Teradata, Oracle, SQL Server.

Responsibilities

• Design, develop, implement, and maintain enterprise databases and data warehouse environments.
• Create and modify database programs, scripts, procedures, and SQL queries.
• Translate business and technical requirements into effective database solutions.
• Monitor database performance, resource utilization, availability, and processing efficiency.
• Perform performance tuning and recommend improvements.
• Develop logical and physical data models and relational database designs.
• Evaluate and implement requests for new data elements and systems while maintaining data integrity and minimizing redundancy.
• Load, reorganize, and maintain databases as needed.
• Maintain data dictionaries, database standards, and technical documentation.
• Implement database security, backup, recovery, and disaster recovery procedures.
• Create and maintain test database environments.
• Support database software installation, configuration, and implementation.
• Provide technical assistance to users requesting data or information.
• Support database benchmarking, threshold testing, and capacity planning.
• Ensure database administration and reporting interfaces meet applicable accessibility standards.
• Collaborate effectively with database, application, reporting, infrastructure, and business teams.
• Maintain accurate technical documentation and operational procedures.
• Stay current with database technologies, data warehousing practices, security standards, and industry best practices.

Skills

SQL proficiency

Data warehousing

Performance tuning

Data modeling

Security best practices

Collaboration

Tools

Teradata

Oracle

SQL Server

Informatica

IBM DataStage

Power BI

Job description

Genius Road, LLC in Austin, Texas is seeking an experienced Database Administrator to support the design, implementation, maintenance, security, and performance of enterprise database and data warehouse environments.

This role requires collaborating with technical and business teams to ensure data integrity, availability, and accessibility, with a focus on SQL, data warehousing, and reporting tools. The position is hybrid (3 days onsite) in Austin and is limited to local candidates.