RESPEC is seeking an experienced Database Administrator 2 to support a critical data infrastructure engagement with a major Texas state health and human services agency in Austin. This is a high-impact role embedded within a large-scale data environment where your expertise in enterprise databases, data warehousing, and ETL processes will directly support the agency's ability to deliver data-driven programs and services to Texans statewide.You will serve as a key technical resource responsible for the full lifecycle of database administration — from performance tuning and security to data modeling, warehouse management, and end-user support. If you thrive in complex, enterprise-grade data environments and want your work to matter beyond the private sector, this is the opportunity for you.Core ResponsibilitiesAs the Database Administrator on this engagement, you will manage and maintain integrated database systems while ensuring data integrity, performance, and security across a complex enterprise environment. Day-to-day, this means monitoring database performance, recommending efficiency improvements, implementing security and recovery procedures, and executing the processes necessary to save, retrieve, and recover data from hardware or software failures.You will collaborate closely with programmers, analysts, and business stakeholders to assess the impact of database changes, coordinate data usage across systems, and incorporate new data elements into the shared data environment. You'll perform both logical and physical data modeling — designing relational and warehouse structures including Star Schemas, Snowflake Schemas, and highly normalized models — and translate business requirements into robust physical database designs.Beyond architecture and performance, you'll maintain the data dictionary to enforce uniformity of definitions and standards, create test database environments for application development teams, and assist with the installation and configuration of database management software. You will also support EIR Accessibility standards, ensuring that all user interfaces for database administration, data input, and reporting output comply with applicable accessibility guidelines, and providing direct user support when accessibility issues arise.
