Database Administrator IV
2 weeks ago
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
1 month ago
Austin, United States Texas Department of Aging & Disability Services Full timeJob 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
4 weeks ago
Austin, United States L.K. Jordan & Associates Full timeDatabase Administrator wanted in the Austin area! Are you a tech-savvy problem-solver with a keen eye for detail? We're seeking a dynamic individual to join our team and revolutionize our lead intake, tracking, and communication processes!100% Remote Database Administrator, Database, Administrator, Technology, Staffing
-
Database Administrator
2 weeks ago
Austin, United States Infojini Full timeEnters codes to create production data base. Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to data base management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine...
-
Database Administrator
2 weeks ago
Austin, United States IDR Healthcare Full timeIDR is seeking a Database Administrator to join one of our top clients in the public sector industry. If you are looking for an opportunity to join a large organization and work within an ever-growing team-oriented culture, please apply today! Position Overview/Responsibilities for the Database Administrator: Enters codes to create production data base....
-
Database Administrator
4 weeks ago
Austin, United States LightEdge Solutions Full timeThis 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;...
-
Database Administrator
2 weeks ago
Austin, United States LightEdge Solutions Full timeThis 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;...
-
Database Administrator
2 weeks ago
Austin, United States Health & Human Services Comm Full timeThe DBA works on activities including but not limited to database tuning, indexing, customization, data migrations/conversions, installations, troubleshooting, upgrades, patching, user management, security of data at rest and in motion, disaster recovery, clustering for high availability and load balancing, data backup, purging and archiving, implementation...
-
Database Administrator
2 months ago
Austin, United States Dutech Systems Full time**Austin,TX**: **DatePosted : 5/1/2024 8:57:52 AM **:JobNumber : DTS101766147 JobType : W2 Skills: Database Experience, Oracle, Microsoft SQL, Database Design, Database Structures, Analysis, Software Development Life Cycle. **SALARY RANGE: 120K TO 130K Per Annum** **CANDIDATE SKILLS AND QUALIFICATIONS** **10 years**: Database experience. **8 years**:...
-
Administrative Asst Iv
3 weeks ago
Austin, United States Health & Human Services Comm Full timeAdministrative Asst IV- This position will also perform other administrative work in the Claims Management Division (CMD). Work will depend on the unit’s business needs and may include scheduling meetings; purchasing and invoice processing; inventory management; preparing reports, forms, spreadsheets; and maintaining SharePoint sites.**Essential Job...
-
Administrative Assistant Iv
2 weeks ago
Austin, United States Texas Department of Criminal Justice Full timeJob PostingClick on the Job Posting Number for a more detailed job description. POSTED: 06-06-2024 CLOSES: 06-17-2024 JOB POSTING NO: 064217PP14 PAYROLL TITLE: ADMIN ASST IV EXTENDED TITLE: Assistant to Director of Staff Development SALARY: GR. A15 - ($3143.50 / Monthly) VACANCY LOCATION: Austin, TX UNIT/DEPT: Board of Pardons and Paroles PAYROLL...
-
Database Administrator 3
4 weeks ago
Austin, United States Smart IMS Full timeTexas Health and Human Services Commission requires the services of 1 Database Administrator 3, hereafter referred to as Candidate(s), who meets the general qualifications of Database Administrator 3, Data/Database Administration and the specifications outlined in this document for the Texas Health and Human Services Commission. All work products resulting...
-
Database Administrator 3
2 weeks ago
Austin, United States Indotronix International Corporation Full timeThe contractor role is for a Senior Database Administrator (Database Administrator III) and will perform 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 successful candidate will work with Full-stack...
-
Database Administrator 3
2 weeks ago
Austin, United States Indotronix International Corporation Full timeThe contractor role is for a Senior Database Administrator (Database Administrator III) and will perform 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 successful candidate will work with Full-stack...
-
Database Administrator 3
4 days ago
Austin, United States LanceSoft Full timeEnter Job Description... Enters codes to create production data base. Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to data base management system. Reviews and corrects programs. Answers user questions. Confers with...
-
Database Administrator 3
2 weeks ago
Austin, United States Prolim Global Full timeJob DescriptionJob DescriptionPROLIM (www.prolim.com) is currently seeking Database Administrator 3 for one of our top Client for Location- 701 W 51st St Austin, TX 78751 Remote - within the state of TexasQualified candidates can directly send your updated resume and contact info via email: jayaprakash.hiremath@prolim.comJob description:Enters codes to...
-
Database Administrator 3
2 weeks ago
Austin, United States Prolim Global Full timeJob DescriptionJob DescriptionPROLIM (www.prolim.com) is currently seeking Database Administrator 3 for one of our top Client for Location- 701 W 51st St Austin, TX 78751 Remote - within the state of TexasQualified candidates can directly send your updated resume and contact info via email: jayaprakash.hiremath@prolim.comJob description:Enters codes to...
-
Database Developer
2 weeks ago
Austin, United States TEXAS EDUCATION AGENCY Full time**Database Developer (Programmer IV)** **(**00041327**)** **Organization**: TEXAS EDUCATION AGENCY **Primary Location**: Texas-Austin **Work Locations**: Texas Education Agency 1701 NORTH CONGRESS AVENUE Austin 78701 **Job**: Computer and Mathematical **Employee Status**: Regular **Schedule**: Full-time **Standard Hours Per Week**: 40.00 **State Job...
-
Database Administrator
1 week ago
Austin, United States Zilliant Full timeZilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction.? If youre ready to make an impact at a growing company that values the time, input, and...
-
Database Administrator
3 weeks ago
Austin, United States Zilliant Full timeJob DescriptionJob DescriptionZilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction. If you’re ready to make an impact at a growing...
-
Database Administrator
2 weeks ago
Austin, United States Zilliant Full timeJob DescriptionJob DescriptionZilliant powers intelligent B2B commerce with our industry-leading price optimization and sales guidance software. Our data science, cloud-native software, and passion for customer success deliver the highest ROI, fastest time to value, and highest customer satisfaction. If you’re ready to make an impact at a growing...
