Database Administrator (Data Warehousing)

Location: Austin, TX; local candidates only. Hybrid schedule with 3 remote days and onsite work on Mondays and Tuesdays.

Company

hirify.global supports a database administration engagement for the Texas Health and Human Services Commission.

What you will do

• Install database software, support migrations to new data management system levels, and test reliability and functionality.
• Analyze, design, modify, and maintain database structures, relational models, data warehouses, and data marts.
• Implement backup, recovery, database security controls, user access levels, disaster recovery procedures, and data integrity standards.
• Monitor and tune database performance, perform benchmarking and threshold testing, and improve efficiency.
• Prepare database documentation, procedures, data definitions, and data dictionaries; support users with data access and accessibility issues.
• Evaluate database management software and provide technical assistance across application delivery, data sourcing, transformation, loading, and reporting.

Requirements

• 4–7 years of experience in database administration or a related field, including computer systems analysis or programming work.
• At least 5 years of experience with database management systems, data warehouse management, decision-support tools, data warehouse and data mart implementation, and data dictionary development.
• Experience with data warehouse population and modeling techniques, including Star Schema, Snowflake Schema, and highly normalized models.
• Experience with GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.
• Implementation experience with enterprise databases such as Teradata, Oracle, SQL Server, or similar technologies.
• Experience with analytical and reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar tools; experience with data access tools and SSRS is preferred.
• Experience with the full data warehouse implementation process, from business requirements and logical modeling through physical design, sourcing, transformation, loading, SQL, and end-user tools.
• Knowledge of database structures and theories, computer operations, systems and procedures, programming languages, systems design, benchmarking, and project control and cost estimating.
• Strong analytical, problem-solving, communication, teamwork, interpersonal, and relationship-management skills; ability to work with technical and non-technical groups and manage multiple responsibilities.
• Working knowledge of EIR accessibility standards and assistive technologies, including accessible database administration interfaces, data input, viewing, reporting, and user support.
• Ability to maintain critical infrastructure security and comply with laws and regulations related to national security and foreign ownership restrictions.

Nice to have

• Oracle Database experience.
• SSRS report creation.
• M204 database experience.

Culture & Benefits

• Hybrid working arrangement with three remote days and two required onsite days each week.
• Work involves coordination with programmers, analysts, coworkers, application teams, and database users.
• Position operates with limited supervision and considerable latitude for initiative and independent judgment.

Hiring process

• Three professional references are required, including each reference's name, company, and phone number with area code; title, email, and professional relationship are optional.
• Candidates are subject to a pre-employment security review to determine employment eligibility.