Database Architect IV

Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense. Must be onsite the first week to get their computer. This role could be remote up to 5 days per week in Madison, Wisconsin.

DOT Database Architect IV

Job Description

Database Architect IV designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and database implementation. Cleans and maintains the database by removing / archiving / deleting data. Must be able to design, develop and manipulate database management systems, data warehouses and multi-dimensional databases. Requires a depth and breadth of database knowledge that will help with formal design of relational databases and provides insight into strategic data manipulation. This position will provide analysis and design of relational databases and systems analysis for support, modernization, and enhancements. Database Architect will design strategies, implement database SQL and stored procedures, and devise strategies to replace outdated technology and implement them.

Top Skills and years of experience: 7+ years of experience in the following:

• Proficient in Oracle PL/SQL, including stored procedures and standalone scripts.
• Designing and implementing database SQL and stored procedures.
• Expert in Oracle SQL and SQL Developer
• Strong proactive ability to research, recommend, design, implement, code, and test spatial and tabular data.
• Understand data system rules and proactively validate and cleanse anomalies under user guidance.
• Database conversion and migration.
• Communication skills, verbal and written, are required for user and technical meetings and documentation.
  
  

Nice to have skills:

• Strategic thinking and planning skills.
• Significant depth and breadth of database knowledge that will help with formal design of relational databases.
• Knowledge of spatial data & systems
• Knowledge of Java