Database Administrator - Austin, United States - Texas Department of Aging & Disability Services

Texas Department of Aging & Disability Services Austin, United States

2 weeks ago

Description

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 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 of database policies, data replication and backup to secondary sites like disaster recovery environments, procedures for the integrity, availability, and confidentiality of the sensitive and business-critical databases.

This position requires hands-on experience as an administrator of relational databases like SQL Server or Oracle as well as experience in the management and administration of NoSQL databases like MongoDB in a cloud environment strongly preferred.

This position is expected to address high demand and may be required to participate in on-call rotation, as needed, with the expectation to complete all projects in a timely manner.

This position provides daily supervision and oversight to other DBA resources. This position reports to the Director of Operations.

This position is % telework in the state of Texas and is for U.S. Citizens or residents only.

Essential Job Functions:

Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

Evaluates users' requests for new data elements and systems and incorporates into the existing shared data environment. Coordinates use of data to ensure data integrity and control redundancy. Loads databases and reorganizes as needed. Performs data modeling and prototyping. (30%)

Installs and uses Data Modeling tools like Erwin, SQL developer data modeler, etc.
Develops logical and physical Data Models and Entity Relationship Diagrams.
Implements database objects in an Oracle RDBMS.
Advanced data modeler with experience in Design, creation, and maintenance data models representing production databases.
Generates scripts to be in the database using data modeler tools.
Incorporates changes to data model design.
Writes source to target mapping instructions as needed to support ETL development.
Develops stored procedures, database triggers and complex PL/SQL packages where needed.
Performs requirement analysis and provide data mapping guidance to application and development teams.
PL/SQL skills.

Analyzes, designs, and implements databases. Determines and implements database search strategies. Determines database storage requirements. Develops and maintains data dictionary ensuring uniformity of definitions and sets standards for use of data dictionary. Establishes and controls necessary database security. (30%)

Evaluates the database server Hardware.
Installs database and grid software.
Plans database for logical structure, overall database design and backup, restore strategy.
Database performance analysis.
Implements ASM for database storage or filesystembased database strategy.
Follows database naming conventions per guidelines.
If needed, implements Oracle advanced security and Oracle database Vault.
Database security solutions to ensure data privacy, protect against insider threats, and enable regulatory compliance.
Implement oracle identity management to secure critical applications and sensitive data, lower operational costs, and comply with regulatory requirements.
Directs the design, analysis and development of backup and recovery systems by working with the customer for support and implementation of more complex databases and environments. Serves as primary contact for vendors and system architects to represent customer requirements. Creates documentation for backup and recovery. Defines database validation requirements to ensure database integrity.
Develops a plan and directs implementation of database security infrastructure that coincides with policy requirements; makes recommendations for security best practices.

Designs, codes, and modifies complex computer programs, subroutines, triggers, stored procedures, objects, classes, and scripts to maintain reporting systems.

Performs necessary testing of assigned programs, including the generation of test data, writing test scripts/execution sequences, examining test results, debugging detected errors, etc.

Uses current software development methods/techniques and established development standards (which include programming standards, documentation standards and testing standards) to ensure the quality and maintainability of reports/applications.

Participates in code walk-throughs to ensure compliance with development standards and system/business requirements. (20%)

Works with trainers, technical support staff, network specialists and contract staff to perform modifications and/or updates to existing systems or to implement new systems.

Identifies, investigates, and resolves production problems. This may include analyzing problems, coding, testing, implementing, and training of other technical staff and/or customers. (15%)

Other duties as assigned. (5%)

Knowledge Skills Abilities:

Knowledge of database structures and theories, current database technologies, and data analysis techniques.
Knowledge of the principles, practices, and techniques of computer programming and systems design.
Knowledge of computer operations, systems, and procedures.
Knowledge of data processing flowcharting techniques.
Knowledge of Software Development lifecycle.

Skill in developing, maintaining, and troubleshooting data transformations or ETL (Extract Transform and Load), preferably using tools such as Azure Data Factory (ADF) or SQL Server Integration Services (SSIS), Informatica PowerMart, Data Integrator, or others.

Skill with the investigation and resolution of problems using strong analytical techniques, innovative approaches, and taking initiative in preventing problems.

Skill in technical analysis and design, including database design and planning.
Skill in effectively communicating information, both orally and in writing, with individuals and groups with varying technical backgrounds.
Skill in team building and providing oversight and performance management of others.

Ability to organize and plan identified tasks to meet goals and complete multiple assignments without compromising accuracy in a fast-paced environment.

Ability to work in a team environment as well as the ability to independently learn new technologies and concepts quickly.

Database Administrator

1 week ago

Dutech Systems Austin, United States

**Austin,TX**: · **DatePosted : 5/1/2024 8:57:52 AM **:JobNumber : DTS · 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 S ...
Vertica Database Administrator

2 weeks ago

Q1 Technologies Austin, United States

Minimum 10+ years experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud. · Expert Knowledge of Vertica Architecture - Vertica Enterprise and Vertica Eon.Expertise in installing/upgrade and maintaining 50+ Vertica environments. · 5+ yea ...
Vertica Database Administrator

2 weeks ago

Formac Austin, United States

Vertica DBA · Austin, TX / Sunnyvale, CA · Long TERM · Minimum 10+ years experience in Vertica and managing several multi-terabyte Vertica databases both on-prem and cloud. · Expert Knowledge of Vertica Architecture - Vertica Enterprise and Vertica Eon. · Expertise in installing/ ...
Database Administrator

3 days ago

COGENT DATA SOLUTIONS LLC Austin, United States

Hello Professionals, · Cogent Data Solutions LLC is hiring for a Database Administrator position with one of our direct clients. · Check out the details listed below. I look forward to hearing back from you. Have a great day · Client Name: Texas Health and Human Services Commissi ...
Database Administrator

2 weeks ago

IDR Healthcare Austin, United States

IDR 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 ...
Database Administrator

2 weeks ago

L.K. Jordan & Associates Austin, United States

Database 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 processes100% Remote Database Administrator, Databas ...
Database Administrator

2 weeks ago

Zilliant Austin, United States

Job Description · Job 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 highes ...
Database Administrator II

2 weeks ago

Texas Department of Aging & Disability Services Austin, United States

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 TIRN). AES is driven by its mis ...
Database Administrator III

3 weeks ago

Texas Department of Aging & Disability Services Austin, United States

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 i ...
Database Administrator 3

3 days ago

My3Tech Austin, United States

Hello, · Hope you are doing good. · Position: Database Administrator 3 · Location: US Remote · Duration: Long Term · Client: State of Texas · Job ID: HHSC · Job Description: · DESCRIPTION OF SERVICES · Texas Health and Human Services Commission requires the services of 1 Databas ...
Database Administrator IV

2 weeks ago

Texas Department of Aging & Disability Services Austin, United States

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 ...
Database Administrator 3

3 weeks ago

Smart IMS Austin, United States

Texas 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 f ...
Senior Database Administrator

9 hours ago

Auctane - Stamps Austin, United States

As a Senior Database Administrator (DBA) and member of the Engineering Operations team, this individual is responsible for the research and planning, development, implementation, utilization, monitoring, and administration of databases, primarily MS Database Administrator, Databa ...
Database Administrator 3

9 hours ago

My3Tech Inc Austin, United States

Hello, · Hope you are doing good. · Position: Database Administrator 3 · Location: US Remote · Duration: Long Term · Client: State of Texas · Job ID: HHSC · Job Description: · DESCRIPTION OF SERVICES · Texas Health and Human Services Commission requires the services of ...
Senior Database Administrator

3 weeks ago

Allied Consultants (Texas) Austin, United States

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 serv ...
Senior Database Administrator

1 week ago

pulteGroup Austin, United States Full time

This position can be located in Englewood, Colorado or the state of Texas. · JOB SUMMARY · The Senior Database Administrator (DBA) works with the Agile teams on the design, installation, and maintenance of our database environments for on-premise as well as Cloud system configu ...
Database Administrator

3 weeks ago

Rose International Austin, United States

Date Posted: 05/01/2024 · Hiring Organization: Rose International · Position Number: 463334 · Job Title: Database Administrator · Job Location: Austin, TX, USA, 78751 · Work Model: Hybrid · Shift: 8:00 AM to 5:00 PM · Employment Type: Temporary · Estimated Duration (In months): 2 ...
Postgres Database Administrator

3 weeks ago

Saxon Global Austin, United States

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 R ...
Database Administrator

3 weeks ago

Oscar Austin, United States

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 w ...
Database Administrator

3 weeks ago

Alliance IT Austin, United States

Position: Database Administrator · Location: Austin, TX · The role is for a Senior Database Administrator and will perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. · Assists the team in creating a ...

Database Administrator - Austin, United States - Texas Department of Aging & Disability Services

Description

Job Description: