View all jobs

Database Architect 2 - Texas Department of Insurance - Austin, TX

Austin, TX · Information Technology
Database Architect 2 - Texas Department of Insurance - Austin, TX

A database architect is being solicited by TDI to create comprehensive documentation mapping application to database for agency applications utilizing Oracle 12c databases. Primary focus will be on creating entity relationship diagrams (ERDs), data dictionaries, and intuitive documentation using screen shots and other presentation methods to describe how an application maps to the database, at the column-level. Additionally, database views may be created for use in Tableau or Microsoft Power BI to assist with the agency’ reporting needs. This work will extend to at least one application, Independent Dispute Resolution, but may also include other applications as contract time and funding allow.
Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will not be considered for this opportunity and the resume will not be submitted to the customer.
Years Required/Preferred Experience
4 Required Creating data dictionaries, containing application and database metadata
4 Required Creating database views
4 Required Creating documentation to map application data entry to database fields
4 Required Creating Entity Relationship Diagrams (ERDs) using ERwin or TOAD software
4 Required Working in Oracle 12c databases, via table-level administration and writing custom Oracle SQL queries
2 Preferred Working in Tableau Desktop and Tableau Server
2 Preferred Creating data sources using Oracle Views
2 Preferred Working in Microsoft Power BI

To be considered for this position, please send the following to Zandra at Pedigo Staffing Services, zandra@pedigostaffing.com
  • Resume in MS Word .doc or .docx format
  • Current & Expected Salary 
  • Date available to start
Share This Job
Powered by