Database Administrator 2 - TX

Nexiva Inc; Austin (TX); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Nexiva Inc. in Austin, TX seeks a seasoned Database Administrator 2 to support enterprise databases, data warehouses, data marts, reporting environments, and decision-support systems. The role emphasizes data modeling, performance tuning, security, backup and recovery, and collaboration with cross-functional teams.

Hybrid work arrangement combines three days onsite and two remote. You will manage star and snowflake schemas, ETL processes, and data dictionaries, while ensuring accessibility

Qualifications

• Five years of experience with database management systems.
• Five years of experience with data-warehouse management and decision-support tools.
• Five years of experience building data warehouses and data marts.
• Experience with Business Objects and enterprise data dictionaries.
• Experience with database access tools for application delivery.
• Experience with analysis, planning and management reporting.
• Experience with data-warehouse population and data-modeling techniques.
• Experience with star and snowflake schemas and highly normalized data models.
• Experience with GUI-based ETL tools (Informatica, IBM DataStage or similar).
• Experience with Oracle, SQL Server, Teradata or similar databases.
• Experience with BI/reporting tools such as Cognos, Hyperion, MicroStrategy.
• End-to-end data-warehouse implementation including modeling, loading, and performance tuning.
• Knowledge of database benchmarking and performance testing.

Responsibilities

• Administer, maintain, monitor, and optimize enterprise database environments.
• Support data warehouses and data marts development and maintenance.
• Perform data modeling (logical and physical).
• Design relational database structures and translate models into physical designs.
• Develop and maintain star and snowflake schemas and normalized models.
• Maintain data dictionaries and standards.
• Coordinate data usage to ensure integrity and consistency.
• Support ETL processes and data validation.
• Monitor performance and tune SQL and databases.
• Implement backup, recovery, and disaster plan procedures.
• Assist with database security and access controls.
• Create environments for development and testing.
• Review changes with developers and analysts.
• Analyze impact of changes on applications and costs.
• Develop and support reporting via enterprise tools.
• Provide user support for data access and reporting.

Skills

Database management

Data warehousing

Data modeling

ETL processes

SQL development

Analytical communication

Collaboration with stakeholders

Tools

Informatica

IBM WebSphere DataStage

Oracle

SQL Server

Teradata

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

Database Administrator 2

Location: Austin, Texas

Work Arrangement: Hybrid three days onsite and two days remote

Contract Term: November 2, 2026 August 31, 2027

Estimated Hours: Up to 2,000 hours

Submission Deadline: September 18, 2026, at 5:00 PM CT

Important Location Requirements

• Candidates must currently reside within a 50-mile radius of Austin, Texas.
• Candidates who live outside Texas and plan to relocate will not be considered.
• The selected candidate must work onsite Wednesday, Thursday, and Friday at:

Austin, TX 78751

• Monday and Tuesday may be worked remotely.
• The work arrangement is subject to change at HHSC's discretion.

Position Overview

an experienced Database Administrator to support enterprise databases, data warehouses, data marts, reporting environments, and decision-support systems.

The selected candidate will assist with database architecture, administration, implementation, performance monitoring, data modeling, ETL processes, security, backup and recovery, accessibility compliance, and production support. The position requires strong technical expertise, analytical ability, communication skills, and experience working with both technical and nontechnical stakeholders.

Key Responsibilities

• Administer, maintain, monitor, and optimize enterprise database environments.
• Support the development, implementation, and maintenance of data warehouses and data marts.
• Perform logical and physical data modeling.
• Design relational database structures and translate logical models into physical database designs.
• Develop and maintain star schemas, snowflake schemas, and normalized data models.
• Create, maintain, and enforce standards for enterprise data dictionaries.
• Evaluate requests for new data elements and incorporate approved changes into shared data environments.
• Coordinate data usage to maintain integrity, consistency, and controlled redundancy.
• Use database access tools to support application delivery and reporting requirements.
• Support ETL processes, including data sourcing, transformation, loading, and validation.
• Monitor database performance and perform SQL and database performance tuning.
• Benchmark databases and conduct threshold and performance testing.
• Determine database storage, indexing, and search requirements.
• Develop and execute backup, restoration, disaster recovery, and database recovery procedures.
• Assist with database security standards, access controls, and security monitoring.
• Create and maintain database environments for application development and testing.
• Install, configure, and evaluate database management software.
• Review database-related programs and coordinate required changes with developers and systems analysts.
• Analyze the impact of database changes on connected applications, systems, users, and operating costs.
• Develop and support analytical reports using enterprise reporting tools.
• Provide technical assistance to users experiencing data-access or reporting issues.
• Ensure database administration tools, reports, and data interfaces comply with Electronic and Information Resources accessibility standards.
• Support users when accessibility issues affect their ability to retrieve or review information.
• Collaborate with technical and business teams while managing multiple responsibilities.

Required Qualifications

Candidates must have at least five years of experience in each of the following areas:

• Database management systems.
• Data warehouse management and decision-support tools.
• Development, implementation, and maintenance of data warehouses and data marts.
• Business Objects and enterprise data-dictionary development.
• Database access tools used for application delivery.
• Analysis, planning, and management reporting.
• Data-warehouse population and data-modeling techniques.
• Star schemas, snowflake schemas, and highly normalized data models.
• GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or comparable platforms.
• Enterprise databases such as Oracle, SQL Server, Teradata, or comparable technologies.
• Analytical and reporting tools such as Business Objects, Cognos, Hyperion, MicroStrategy, or comparable platforms.
• End-to-end data-warehouse implementation, including:
  • Business requirements analysis
  • Logical data modeling
  • Physical database design
  • Data sourcing and transformation
  • Data loading
  • SQL development
  • End-user reporting tools
  • Database and SQL performance tuning
• Database benchmarking processes and technique