Database Administrator IV

4 weeks ago

Austin, United States Texas Department of Aging & Disability Services Full time
Job Description:
The Database Administrator IV performs advanced (senior level) database administration and application development functions for the Data Management team within Information and Data Management, Office of Data, Analytics and Performance (DAP). The DBA IV will be responsible for overseeing and coordinating support of various DAP controlled data assets including SQL Server and Oracle systems. They will work to ensure reliable performance and functionality and will work with other members of the DM team to perform development and testing within these assets. DBA IV will also review and provide feedback on larger DAP data asset architecture and data modeling. They will also be responsible for developing and updating standard operating procedures and guidelines for the work done within these data assets. The DBA IV will conduct analysis of data sets, perform data needs assessment, data acquisition, cleaning, standardization, extraction, transformation, and loading into database systems. The DBA IV will design, code, evaluate and implement changes to the data sets as driven by the needs of DAP and HHSC. They will be responsible for managing these data assets and working to increase efficiency by automating routine tasks. Mentors ADDM team members and DAP staff in the use of compiled datasets. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment. Essential Job Functions:
EJF#1: Consults and coordinates with HHSC IT, Texas Shared Technology Services, and data trading partner technical staff in order to maintain and troubleshoot computer applications and data management processes. Collaborates with business analysts to understand data requirements and translate them into technical specifications to integrate into current data warehouse models. Develops and maintains data quality and data governance processes to ensure accuracy, consistency, and integrity of data in the warehouse.

EJF #2: Initiates and coordinates projects to refresh and upgrade database software and server operating systems. Maintains and updates server and database configuration to maintain connectivity between HHSC systems and data trading partners. Resolves functional and performance issues by conducting performance tuning and optimization of data warehouse processes and queries to improve overall system efficiency. Collaborates with ATOS and other database system management vendors to ensure proper configuration, backup, and recovery of the data warehouse.

EJF#3: Consults and coordinates with DAP and other HHSC staff to identify business needs related to database systems. References data in various HHS and other systems and transform research and reporting requirements into ADDM/DAP data systems. Acquires, extracts, cleans, transforms, and loads needed datasets into ADDM/DAP database systems and writes complex SQL queries and stored procedures to extract and manipulate data for reporting and analysis purposes. Mentors DAP staff in the use of data systems.

EJF#4: Consults and coordinates with ADDM, DAP and other HHSC staff to identify potential areas for increased efficiencies using automation. Designs, develops, codes, evaluates, implements, and documents computer applications and procedures to implement those efficiencies. Conducts data profiling and data analysis to identify data quality issues and recommend improvements.

EJF#5: Prepares and reviews a variety of written, oral, and graphical deliverables containing analyses of Health and Human Services data to detect data trends and anomalies, optimize health outcomes. Provides DAP and data management leadership information necessary to make informed decisions on streamlining workflows and processes, modification of existing data models, and recommendations on the enhancement of database system architecture. Develops and maintains data quality and data governance processes to ensure accuracy, consistency, and integrity of data in the warehouse.

EJF#6: Trains DAP staff on QAI Datamart applications and systems. Identifies areas for learning and development and participates in training programs available to HHSC and DAP staff members. Identifies and incorporates innovative solutions to streamline workflows and processes. Knowledge Skills Abilities:
Knowledge of the process of computer application development.
Knowledge of Oracle 19c on the Linux platform
Knowledge of data warehouse architecture of Star and Snowflake schemas used in relational, dimensional, and multi-dimensional data modeling.
Knowledge of scripting language to import and extract database information in a Linux batch environment – preferably PERL.
Knowledge of scientific research methods, statistical techniques, mathematics, geographical concepts, and their application to data analytics.
Knowledge of the various Texas Health and Human Service (HHS) programs.
Knowledge of patient level health and demographic data (e.g., Census, Vital, Medicaid, and CHIP data including eligibility, enrollment, medical claims, and encounters).
Knowledge of the principals, practices and techniques of database design and development, database structures and theories and current database technologies.
Knowledge of medical records systems or clinical coding practices.
Knowledge of Internet and World Wide Web.
Knowledge of computer programming principles, spreadsheet macros, and database design.
Skill in developing computer applications using high level interpreted languages such as Perl.
Skill in using SAS, SPSS, SQL, R, ACCESS, Business Objects, or other statistical and database management software.
Skill in using EXCEL or other spreadsheet software.
Skill in graphical, tabular, and geographical presentation of data.
Skill in verbal and written communications.
Skill in database management with Oracle, SQL Server, or similar large database systems.

Ability to analyze and solve problems.
Ability to design, develop, code, test, implement, maintain, and document computer applications.
Ability to manage, manipulate, and analyze complex databases.
Ability to Extract, transform, and load (ETL) data from various sources into the data warehouse using tools like Informatica, PERL, and Linux shell scripts.
Ability to oversee and/or supervise the work of others.
Ability to plan, organize, and conduct data analytic projects.
Ability to work in a team and to communicate effectively.
Ability to develop and interpret statistical data charts, maps, and tables.
Ability to interpret and publish data analytic findings.
Ability to exercise independent judgment and show initiative.
Ability to maintain detailed and organized documentation of data analytic projects.
Ability to train staff in the use of data systems.

  • Database Administrator

    2 weeks ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: The Database Administrator (Database Administrator IV) position performs advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. Assists the team in creating and maintaining logical and physical data models. The DBA works on activities including but not limited to...

  • Database Administrator

    2 days ago

    Austin, United States LightEdge Solutions Full time

    This position serves as a member of the Database Services Group that provides database administration for our internal and customers' database systems that include Oracle, SQL Server, MySQL, and others in both stand-alone and high/availability configurations. Responsibilities: Manages database system uptime, data backups & restores, operational tasks;...

  • Senior Database Administrator

    1 week ago

    Austin, United States beBee S US Full time

    Overview Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Senior Database Administrator to be a key resource on a technical services team. Allied Consultants offers its family of consultants excellent rates, a...

  • Senior Database Administrator

    5 days ago

    Austin, United States Allied Consultants (Texas) Full time

    Overview: Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Senior Database Administrator to be a key resource on a technical services team. Allied Consultants offers its family of consultants excellent rates, a...

  • Administrative Assistant IV

    3 weeks ago

    Austin, United States Blue Star Partners LLC Full time

    Job DescriptionJob DescriptionJob Title: Administrative Assistant IVLocation: Austin, TX – 100% Onsite – Local candidates onlyPeriod: 04/22/2024 to 04/21/2025 – Potential to convert for right candidate.Hours/Week: 40 hours Rate: $35-$40/hour (Hours over 40 will be paid at Time and a Half)Contract Type: W-2Scope of Services:The Administrative Assistant...

  • Admin Asst Iv-executive Administration

    7 days ago

    Austin, United States Texas Department of Criminal Justice Full time

    POSTED: 05-13-2024 CLOSES: 05-22-2024 JOB POSTING NO: 051259PP01 PAYROLL TITLE: ADMIN ASST IV EXTENDED TITLE: Executive Administration SALARY: GR. A15 - ($3143.50 / Monthly) VACANCY LOCATION: Austin, TX UNIT/DEPT: Parole Executive Administration PAYROLL JOB#: 717179 - Longevity Pay - Regular Service Retirement - Telephonic Interviews Will Not Be...

  • PostgreSQL database administrator

    14 hours ago

    Austin, United States IRIS Software, Inc. Full time

    Iris is looking for a PostgreSQL database administratorRole: PostgreSQL database administratorLocation: Austin , TXHybrid : 3 days office , 2 days work from homeDuration: Long Term ContractClient : BankingJob Description:10+ years of experience of overall.Must have strong experience working as PostgreSQL database administratormust have good experience in...

  • PostgreSQL database administrator

    24 hours ago

    Austin, United States Iris Software Inc. Full time

    Iris is looking for a PostgreSQL database administratorRole: PostgreSQL database administratorLocation: Austin , TX or South Lake, TX (you can choose any location)Work Model : all 5 days onsiteDuration: Long Term ContractClient : BankingJob Description:10+ years of experience of overall.Must have strong experience working as PostgreSQL database...

  • PostgreSQL database administrator

    1 day ago

    Austin, United States Iris Software Inc. Full time

    Iris is looking for a PostgreSQL database administratorRole: PostgreSQL database administratorLocation: Austin , TX or South Lake, TX (you can choose any location)Work Model : all 5 days onsiteDuration: Long Term ContractClient : BankingJob Description:10+ years of experience of overall.Must have strong experience working as PostgreSQL database...

  • PostgreSQL database administrator

    15 hours ago

    Austin, United States Iris Software Inc. Full time

    Iris is looking for a PostgreSQL database administratorRole: PostgreSQL database administratorLocation: Austin , TX or South Lake, TX (you can choose any location)Work Model : all 5 days onsiteDuration: Long Term ContractClient : BankingJob Description:10+ years of experience of overall.Must have strong experience working as PostgreSQL database...

  • Database Administrator 2

    7 days ago

    Austin, United States LanceSoft Full time

    Level Description 4-7 years of experience in the field or in a related area. Familiar with standard concepts, practices, and procedures within a particular field. Relies on limited experience and judgment to plan and accomplish goals. A certain degree of creativity and latitude is required. Works under limited supervision with considerable latitude for the...

  • Database Administrator II

    3 days ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: The Texas Health and Human Services Commission (HHSC) seeks highly qualified candidates to fill the Database Administrator II position within the Access and Eligibility Services (AES), 2-1-1 Texas Information and Referral Network (2-1-1 TIRN). AES is driven by its mission to connect Texans to people, services and supports by helping...

  • Senior Database Administrator

    3 weeks ago

    Austin, Texas, United States Allied Consultants, Inc. Full time

    Overview: Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Senior Database Administrator to be a key resource on a technical services team.   Allied Consultants offers its family of consultants excellent...

  • Database Administrator III

    3 weeks ago

    Austin, United States Texas Department of Aging & Disability Services Full time

    Job Description: Designs, develops, enhances, maintains, and supports the databases underlying IT systems utilized by HHSC program areas. Maintains and monitors integrated database systems. Develops and maintains complex models and logical database designs. Provides expertise in and participates in the development and implementation of database...

  • Postgres Database Administrator

    7 days ago

    Austin, United States Saxon Global Full time

    Database Administrator with good experience in PostgresSQL and Python . Python At least 1 year Is Required AWS At least 1 year Is Required Google Cloud Platform (GCP) At least 1 year Is Required PostgreSQL At least 1 year Is Required MemSQL No At least 1 year Is Required Linux No At least 1 year Is Required

  • Administrative Assistant Iv

    3 days ago

    Austin, United States Texas Department of Criminal Justice Full time

    Job PostingClick on the Job Posting Number for a more detailed job description. POSTED: 05-16-2024 CLOSES: 05-28-2024 JOB POSTING NO: 064218PP14 PAYROLL TITLE: ADMIN ASST IV EXTENDED TITLE: Board Administration SALARY: GR. A15 - ($3143.50 / Monthly) VACANCY LOCATION: Austin, TX UNIT/DEPT: Board of Pardons and Paroles PAYROLL JOB#: 720382 *Longevity...

  • Oracle/People Soft Database Administrator

    1 month ago

    Austin, United States Terbium Technologies Full time

    Required Experience 5 to 8 years Proven experience with effective database administration using Oracle 11g/ 12c RDBMS in an enterprise-class environment. Proven understanding of the Avamar and/or Networker backup solutions or similar with vendor administered media management. Demonstrates experience in the effective database management of PeopleSoft 9.2...

  • Oracle/People Soft Database Administrator

    1 month ago

    Austin, Texas, United States Terbium Technologies Full time

    Required Experience 5 to 8 years Proven experience with effective database administration using Oracle 11g/ 12c RDBMS in an enterprise-class environment. Proven understanding of the Avamar and/or Networker backup solutions or similar with vendor administered media management. Demonstrates experience in the effective database management of PeopleSoft 9.2...

  • Database Administrator

    1 month ago

    Austin, United States Oscar Full time

    We are seeking a skilled and experienced Database Administrator to join our team. The ideal candidate will have a strong background in database management systems, along with expertise in software development life cycle principles and practices. As a Database Administrator, you will be responsible for analyzing, designing, planning, and performing database...

  • Database Administrator

    1 month ago

    Austin, United States Oscar Full time

    We are seeking a skilled and experienced Database Administrator to join our team. The ideal candidate will have a strong background in database management systems, along with expertise in software development life cycle principles and practices. As a Database Administrator, you will be responsible for analyzing, designing, planning, and performing database...