Job Description :
Internal Job ID: APR009
Position: Database Administrator
Client:State Dept of TX
Location: Austin TX
Local Profiles Preferred

Requirement Details:

Duties:

Work with business to analyze and define existing legacy data architecture.
Write and execute queries and export jobs to extract proper data.
Work with technical project team to transform data for load to cloud database platform.
Analyze database dependencies and key elements.
Create and execute SQL queries and scripts for the extraction and transformation of data from MS Access legacy system.
Cleanse and normalize data for import.
Knowledge and experience with MS Access.
Create data reports.
Must follow agency database standards and guidelines

Requirements:
Years Skills/Experience
5Y SQL Server database administration
5Y MS Access database administration
5Y SQL scripting and queries
4Y Working experience with interaction and communication with both technical and business division personnel
3Y Experience with and working knowledge of highly complex application security requirements

Preferences:
Years Skills/Experience
3Y Proficient with the Microsoft Windows and Office products
3Y Public sector experience (Federal, State or Local Government

Client : State Dept Of TX