Description

<< Back to all jobs

Database Administrator 3

[Austin, TX, 78751] |   2022-10-13 09:05:31

Apply Now

Share Job 

Job Code : HHSC-529310148C

Database Administrator 3

Austin, TX 78751 (Remote within Texas)

6 month Contract with possibility to extension

The Database Administrator III performs advanced (senior-level) database administration work for the HEART (HHS Enterprise Administrative Reporting and Tracking) and CFO (Chief Financial Officer Financial System Support) application modernization projects. The HEART system is used to track client complaints and inquiries made to HHSC programs and to report statistical data to the Legislative Budget Board (LBB). The CFO-FSS system is a customized, web-based, agency application for HHSC managers to view their monthly budget reports on-line. Work involves providing direction and guidance in database administration operations and planning; migration of on-premises Oracle relational database to Azure SQL Server database; identity and access management for database roles and principles. Evaluates and reviews database performance monitoring and implements efficiency improvements. Recommends and implements database security standards and controls, and user access levels; providing for the efficient and effective storage, retrieval, customization, and archiving of data to ensure integrated database systems; planning, developing, and implementing database policies and procedures; and maintaining and verifying data integrity. May supervise the work of others. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

 

Candidate Skills and Qualifications:

YearsRequired/PreferredExperience
8RequiredProven experience in Database Administration / Database Design & Development using Azure/SQL Server databases in an IaaS/PaaS environment. Proficient in data migration and conversion from on-premises Oracle to Microsoft Azure SQL Server.
8RequiredPerforms highly complex data management functions at an enterprise level; integrates, upgrades, and manages database environments; plans, organizes, tests and executes migration of databases from development to production environments.
8RequiredExperience must include developing stored procedures/triggers/scripts/SQL and optimizing/tuning SQL in enterprise-class production and development/test environments.
8RequiredImplementing and maintaining data security protocols;configuring database authorization & authentication using platform and database tools;configures object-level permissions;implements data masking;implements compliance controls for sensitive data/PII
8RequiredExperience configuring and monitoring activity and performance for AzureSQL at the infrastructure, server, service, and database levels
8RequiredExperience configuring and monitoring activity and performance– including QueryStore; resolving production and operational problems; monitoring utilization and managing available database resources; all the above in order to optimize and tune performance.
8RequiredConfigure storage resources; configure compute resources for scaling; analyzes data resource and server capacity and forecasts growth requirements; recommends server, hardware and software upgrades and enhancements to meet long-term needs.
8RequiredProvides enterprise-level short and long-term planning advice on technical enterprise database and systems management and utilization issues.
8RequiredExperience with T/SQL, SQL, DML, DDL and DCL – to debug and resolve issues.
8RequiredExperience with RDBMS admin/console tools such as TOAD, SSMS and/or SQL Developer.
5RequiredExperience documenting data migration processes, CI/CD process, ETL pipelines, day-to-day operations.
5RequiredConfiguring data integration and batch processing solutions in Azure Data Factory and/or SSIS; monitoring data ingestion processes and performance; review query plans and identify problem areas in execution plans.
5RequiredDemonstrated experience leading and evaluating the implementation of project requests to ensure efficient use of server/database resources. Further, in terms of logical design so as not to create inefficiencies, and unreasonable demands on computing res
5RequiredDemonstrated experience leading efficiency improvements and implementation of database administration policies and procedures.
3RequiredDemonstrates experience in data and systems architect duties; experience in migrating data from spreadsheets and from Oracle through SQL Server Migration Assistant (SSMA) and other platforms to Azure PaaS using Azure Data Factory
3RequiredDemonstrates and promotes the effective sharing and utilization of common data across applications and departments/business units.
3RequiredValidate database build requirements, leverage automation tools to complete requirements.
4PreferredBachelors or advanced degree in computer science, computer information systems, management information systems, or a closely related field.
3PreferredAgile methodology.

Warm Regards,

Sai Tharun

Technical Recruiter

My3 Tech Inc,

1601 N Harrison Ave, STE # 2B, Pierre, SD 57501

Direct: 605-674-2099 | Board: 605-220-5981 Ext-132

E Mail: Tharun.v@my3tech.com |

Education

Any Graduate