Job/Position DescriptionThe 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 100% telework in the state of Texas and is for U.S. Citizens or residents only. Essential Job FunctionsAttends 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 filesystem-based 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 th https://jobshrportal.hhsc.state.tx.us/ENG/CareerPortal/job_profile.cfm?szOrderID=605246 Copy the URL in the preceding sentence to an Internet Explorer browser to apply to the job directly through the Texas Health and Human Services Career Portal.