Database Administrator 2
About The Position
The Texas Health and Human Services Commission (HHSC) is seeking three experienced Database Administrator 2 professionals to support enterprise database administration, data warehouse operations, performance optimization, data modelling, security administration, and database infrastructure maintenance. The selected candidates will be responsible for supporting critical database systems, ensuring data integrity, implementing security controls, managing database performance, and assisting with enterprise data warehouse initiatives. This position requires strong experience with relational databases, ETL technologies, reporting platforms, and data warehouse architectures. Candidates must possess strong analytical, communication, and problem-solving skills and be comfortable working with both technical and business stakeholders.
Requirements
- Strong knowledge of database management systems, data warehouse management, and decision support tools.
- Extensive experience developing, implementing, and maintaining data warehouses and data marts.
- Experience creating and maintaining enterprise data dictionaries.
- Experience using database access tools for application delivery.
- Knowledge of data warehouse population methodologies and data modeling techniques.
- Experience designing: Star Schemas, Snowflake Schemas, Highly Normalized Data Models
- Strong understanding of logical and physical database design.
- Experience with GUI-based ETL tools such as: Informatica, IBM WebSphere DataStage, Similar enterprise ETL platforms
- Experience implementing and supporting enterprise-class databases such as: Oracle, SQL Server, Teradata, Comparable database technologies
- Experience with enterprise reporting and analytics tools including: Business Objects, Cognos, Hyperion, MicroStrategy, Similar reporting platforms
- Strong SQL development skills.
- Experience with data sourcing, transformation, and loading processes.
- Understanding of database optimization and performance tuning techniques.
- Excellent analytical and problem-solving abilities.
- Strong verbal and written communication skills.
- Excellent teamwork and interpersonal skills.
- Ability to work effectively with technical and non-technical stakeholders.
- Proven ability to manage multiple priorities simultaneously.
- Experience with benchmarking processes and performance evaluation techniques.
- Oracle Database Administration experience.
- SSRS (SQL Server Reporting Services) report development experience.
- M204 database experience.
- Experience supporting large-scale enterprise data warehouse environments.
- Knowledge of accessibility standards (EIR Accessibility) and assistive technologies.
- Minimum 5 years of experience in database administration, data warehousing, database design, ETL development, or related database technologies.
- Experience supporting enterprise database environments.
- Experience implementing database security, backup, and recovery solutions.
- Strong understanding of database architecture and performance optimization.
Responsibilities
- Support installation, configuration, upgrades, and migration of database management systems.
- Analyse, design, implement, and maintain database structures and environments.
- Develop and maintain logical and physical data models.
- Design and implement database backup, recovery, and disaster recovery procedures.
- Establish database security controls, permissions, and user access management.
- Monitor database performance and implement performance tuning strategies.
- Assist with database software evaluations and recommendations.
- Create and maintain database documentation, standards, procedures, and data dictionaries.
- Support enterprise data warehouse development and maintenance efforts.
- Implement and manage data integration and data loading processes.
- Coordinate database changes and assess impacts across applications and systems.
- Ensure data integrity and minimize redundancy across enterprise systems.
- Create and manage test database environments.
- Assist with benchmarking, threshold testing, and database optimization.
- Support compliance with security, accessibility, and regulatory requirements.
- Provide technical support to business users and development teams.
- Participate in database security reviews and disaster recovery planning.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
