Job ID: TX-52917007 (914491106)
Azure SQL Server Admin/DBA with IaaS/PaaS, PII data, tuning, T/SQL, DML/DDL/DCL, TOAD/SSMS, SSIS, Data Factory, ETL, data pipelines and agile experience
Location: Austin TX (HHSC)
Duration: 9 months
Minimum Requirements:
YearsRequired/PreferredExperience
8RequiredAzure/SQL Server DBA Experience in an IaaS/PaaS environment
8RequiredImplementing and maintaining data security protocols for sensitive data & PII.
8RequiredAzure/SQL Server monitoring and performance tuning
8RequiredT/SQL, SQL, DML, DDL and DCL Experience
8RequiredRDBMS admin/console tools such as TOAD or SSMS
5RequiredExperience with Azure Data Factory and/or SSIS
5RequiredProject leadership and implementation
5RequiredExperience with data pipelines and ETL data structures
4RequiredBachelors or advanced degree in a closely related field
3RequiredExperience with Azure PaaS using Azure Data Factory
5PreferredAzure SQL Server installation, administration and maintenance
3PreferredKnowledge of Agile methodology.
This position will perform advanced database administration tasks for databases used by the applications with complex data models, workflows and reports. Assist the team in planning, creating, maintenance and monitoring logical and physical data models.
This position will work on activities including but not limited to database tuning, indexing, data modeling, prototyping, customization, 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 will need hands on experience as a developer of relational databases in SQL server as well as experience in the management and administration of SQL databases.
Has working knowledge of EIR Accessibility standards and assistive technologies.
Ensures that user interfaces for database administration and inputting, viewing, outputting data (via reports) are compliant with accessibility standards. Provides support to users in obtaining data / information when EIR Accessibility issues arise.