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
Years Required/Preferred Experience
8 Required Azure/SQL Server DBA Experience in an IaaS/PaaS environment
8 Required Implementing and maintaining data security protocols for sensitive data & PII.
8 Required Azure/SQL Server monitoring and performance tuning
8 Required T/SQL, SQL, DML, DDL and DCL Experience
8 Required RDBMS admin/console tools such as TOAD or SSMS
5 Required Experience with Azure Data Factory and/or SSIS
5 Required Project leadership and implementation
5 Required Experience with data pipelines and ETL data structures
4 Required Bachelors or advanced degree in a closely related field
3 Required Experience with Azure PaaS using Azure Data Factory
5 Preferred Azure SQL Server installation, administration and maintenance
3 Preferred Knowledge 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.