Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

RESPEC is seeking an experienced Database Administrator 2 to support a major Texas state government health and human services initiative. This position will play a key role in maintaining, enhancing, and optimizing enterprise data warehouse environments, supporting business intelligence and reporting platforms, and ensuring the integrity, security, and performance of critical data systems.

Responsibilities

• Install, upgrade, and support enterprise database management software and related technologies.
• Support database migrations and validate system functionality following upgrades.
• Analyze, design, modify, and maintain database structures and environments.
• Develop and implement backup, recovery, and disaster recovery procedures.
• Monitor database performance and implement tuning and optimization improvements.
• Establish and maintain database security controls, user access, and compliance requirements.
• Perform logical and physical data modeling for enterprise applications and data warehouse environments.
• Design and maintain relational database models and physical database structures.
• Support data warehouse development, maintenance, and enhancement efforts.
• Evaluate and recommend database software and technology solutions.
• Create and maintain database documentation, standards, procedures, and data dictionaries.
• Assist with benchmarking, performance testing, and capacity planning activities.
• Collaborate with business and technical teams to support reporting, analytics, and decision-support initiatives.
• Provide technical guidance regarding data integration, data quality, and database architecture.
• Ensure accessibility standards are considered for database administration tools and reporting interfaces.

Requirements

• At least 5 years of experience in Database & Data Warehouse Technologies.
• Strong knowledge of database management systems (DBMS).
• Experience with data warehouse management and decision support systems.
• Experience with development, implementation, and maintenance of data warehouses and data marts.
• Experience with enterprise database platforms such as Oracle, SQL Server, Teradata, or similar technologies.
• Experience with database access tools used for application delivery.
• Experience with database performance monitoring and optimization.
• Experience with data warehouse population methodologies.
• Experience with data modeling techniques including Star Schema, Snowflake Schema, and highly normalized data models.
• Experience with data dictionary creation and maintenance.
• Experience with the full data warehouse implementation lifecycle, including business requirements gathering, logical data modeling, physical database design, data sourcing, data transformation, data loading, SQL development, and end-user reporting tools.
• Experience with GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar enterprise ETL platforms.
• Experience with analytical and reporting platforms such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar business intelligence tools.
• Experience with analysis, planning, and management reporting functions.
• Experience with benchmarking methodologies and performance measurement techniques.
• Exceptional analytical and problem-solving capabilities.
• Strong oral and written communication skills.
• Strong interpersonal and teamwork skills.
• Experience working effectively with both technical and non-technical stakeholders.
• Ability to manage multiple priorities in a complex enterprise environment.
• 5+ years of Oracle Database experience.
• 5+ years of SSRS (SQL Server Reporting Services) report development experience.
• 1+ year of M204 database experience.
• Previous experience supporting state government, healthcare, or large public-sector environments.
• Experience working within highly regulated and security-conscious organizations.
• Candidates must currently reside in Texas and be local to the Austin area.
• Candidates must be legally authorized to work in the United States.
• Candidates must be able to satisfy all client employment eligibility and security review requirements.
• Selected candidates must successfully complete a criminal background investigation.
• Selected candidates must successfully complete a pre-employment security review.
• Selected candidates must successfully complete employment eligibility verification requirements.
• Selected candidates must successfully complete client onboarding and compliance documentation.
• Additional onboarding requirements include execution of security, confidentiality, acceptable-use, and integrity agreements as required by the client.

Skills

• Database & Data Warehouse Technologies
• Database management systems (DBMS)
• Data warehouse management
• Decision support systems
• Data warehouses
• Data marts
• Oracle
• SQL Server
• Teradata
• Database access tools
• Database performance monitoring
• Database optimization
• Data Modeling
• Data warehouse population methodologies
• Star Schema
• Snowflake Schema
• Highly normalized data models
• Data dictionary
• SQL development
• End-user reporting tools
• ETL
• Informatica
• IBM WebSphere DataStage
• Business Objects
• Cognos
• Hyperion
• MicroStrategy
• Business intelligence
• Analysis
• Planning
• Management reporting
• Benchmarking
• Performance measurement
• Problem-solving
• Communication skills
• Interpersonal skills
• Teamwork
• SSRS (SQL Server Reporting Services)
• M204 database

Location

• Texas
• Austin area

Work Type

• Hybrid
• Remote
• Full-time

Experience Level

• Experienced
• 5+ years

About the Company

• RESPEC is 100% employee-owned.
• Since 1969, RESPEC has tackled complex challenges in energy transition, infrastructure resilience, digital transformation, and sustainability.
• At RESPEC, you’ll work alongside clients to take on critical problems.
• RESPEC brings deep technical knowledge, real-world experience, and a commitment to work that matters.
• This is an opportunity to support a high-impact public-sector initiative that serves millions of Texas residents while working with enterprise-scale databases, data warehouse technologies, and business intelligence platforms.
• The role offers meaningful technical challenges, collaboration with experienced professionals, and the chance to contribute to mission-critical government systems.

Equal Opportunity

• All your information will be kept confidential according to EEO guidelines.