Database Administrator 2

VSG Business Solutions LLC; Austin (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Texas Health and Human Services Commission seeks an experienced Database Administrator 2 to support database administration, data warehousing, development, performance tuning, security, recovery, and reporting environments.

The candidate will maintain and support enterprise database systems, ensure data integrity, assist with design/implementation, and provide technical support to application development and business teams.

Qualifications

• 5+ years in database management systems and data warehousing.
• Experience with BI/reporting tools and data modeling.
• Proficient in SQL development and data governance concepts.
• Experience with enterprise DBs (Teradata/Oracle/SQL Server) and ETL tools.

Responsibilities

• Design, develop, implement, and monitor enterprise DB systems.
• Maintain production databases and related programs.
• Monitor performance, memory usage, and system efficiency.
• Perform performance tuning and implement improvements.
• Collaborate with developers and business users on DB impacts.
• Support ETL processes, data sourcing, transformation, and loading.
• Develop and maintain data warehouses/data marts and schemas.
• Ensure data integrity, security, backup, and disaster recovery.
• Create test environments and assist with installation and configuration.

Skills

Database administration

Data warehousing

Performance tuning

SQL development

Data modeling

ETL processes

Security and recovery

BI reporting

Data governance

Tools

Informatica

IBM WebSphere DataStage

Power BI

Oracle Database

Teradata

SQL Server

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

NEED PASSPORT, DL, VISA COPY

WEBCAM INTERVIEW

Position Overview

Texas Health and Human Services Commission (THHSC) is seeking an experienced Database Administrator 2 to support database administration, data warehousing, database development, performance tuning, security, recovery, and reporting environments.

The candidate will be responsible for maintaining and supporting enterprise database systems, ensuring data integrity and performance, assisting with database design and implementation, and providing technical support to application development and business teams.

Key Responsibilities

• Design, develop, implement, maintain, and monitor enterprise database systems.
• Create and maintain production databases and related database programs.
• Monitor database performance, memory usage, record distribution, and system efficiency.
• Perform database performance tuning and recommend improvements.
• Analyze and implement database changes based on business and application requirements.
• Work closely with programmers, analysts, developers, and business users to understand database impacts.
• Provide technical assistance and answer user questions related to databases and data access.
• Support the planning, development, maintenance, and monitoring of integrated database environments.
• Perform logical and physical data modeling.
• Design relational database models and develop physical data models from logical models.
• Develop and maintain data warehouses and data marts.
• Work with Star Schema, Snowflake Schema, and highly normalized data models.
• Ensure data integrity, minimize data redundancy, and manage database population and reorganization.
• Maintain the data dictionary and ensure consistency of data definitions and standards.
• Develop and maintain database security, backup, recovery, and disaster recovery procedures.
• Execute database backup, restore, recovery, and retrieval procedures following established standards.
• Create and maintain test database environments for application development teams.
• Assist with database software installation, configuration, and implementation.
• Assist with database security standards, disaster recovery procedures, benchmarking, and threshold testing.
• Evaluate database management software and assist with database technology selection.
• Support ETL processes, data sourcing, transformation, and data loading.
• Develop and use SQL for data extraction, transformation, and analysis.
• Work with reporting and analytical tools to support business and decision-making requirements.
• Provide support for database-related accessibility requirements and ensure database user interfaces and reports comply with applicable EIR accessibility standards.
• Work effectively with both technical and non-technical teams while managing multiple priorities.

Required Qualifications and Experience

• 5+ years of experience working with database management systems.
• Strong knowledge of database management systems, data warehousing, and decision-support tools.
• 5+ years of experience developing, implementing, and maintaining data warehouses and data marts.
• 5+ years of experience with Business Objects or similar business intelligence/reporting tools.
• Experience building and maintaining data dictionaries.
• Strong experience using database access tools for application delivery.
• Strong understanding of analysis, planning, and management reporting functions.
• 5+ years of experience with data warehousing, data population, and data modeling techniques.
• Strong knowledge of Star Schema, Snowflake Schema, and normalized data models.
• Experience with GUI-based ETL tools such as Informatica, IBM WebSphere DataStage, or similar technologies.
• Experience implementing enterprise-class 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 across the complete data warehouse implementation lifecycle, including:
  • o Business requirements gathering
  • o Logical data modeling
  • o Physical database design
  • o Data sourcing
  • o Data transformation
  • o Data loading
  • o SQL development
  • o End-user reporting and analytical tools
  • o Database and SQL performance optimization
• Strong understanding of database benchmarking processes and techniques.
• Excellent analytical and problem-solving skills.
• Strong oral and written communication skills.
• Strong teamwork and interpersonal skills.
• Ability to work effectively with technical and non-technical stakeholders.
• Ability to manage multiple responsibilities and priorities.
• High level of analytical ability to solve complex and unusual technical problems.

Preferred Qualifications

• Experience with Oracle Database.
• Experience creating reports and dashboards using Power BI.
• Experience with enterprise data warehouse environments.
• Experience with database performance tuning and optimization.
• Experience with database security, backup, recovery, and disaster recovery.

Knowledge and Skills

• Database structures and theories.
• Database management systems and current database technologies.
• Data warehousing and data modeling.
• Computer programming and systems design.
• SQL and database programming.
• Computer operations, systems, and procedures.
• Data processing and flowcharting techniques.
• Project control and cost-estimation concepts.
• Database performance monitoring and optimization.
• Database security and recovery procedures.
• Accessibility standards and assistive technologies.

Soft Skills

• Excellent communication and interpersonal skills.
• Strong analytical and critical-thinking abilities.
• Ability to work independently as well as within a team.
• Ability to communicate effectively with technical and business stakeholders.
• Strong problem-solving skills.
• Ability to handle complex and challenging database issues.
• Ability to manage multiple projects and priorities.
• Strong collaboration and stakeholder management skills.

Additional Requirements

The selected candidate may be required to successfully complete a criminal background check as permitted under Texas law.

All work products created as part of the project will be considered works made for hire and will be the property of the Texas Health and Human Services Commission.

Candidates should be prepared to participate in interviews and technical discussions as part of the selection process.