Description

You will design, build, and manage relational databases, data warehouses, and multi-dimensional databases on-site in Madison, WI.

Responsibilities

• Design and implement relational databases, SQL schemas, and stored procedures.
• Develop strategies for data acquisition, archive recovery, and database implementation.
• Execute database conversions and migrations to replace outdated technology.
• Clean and maintain databases by removing, archiving, or deleting data.
• Perform systems analysis to support database modernization and enhancements.

Required Skills

• 7+ years of experience in database architecture and design.
• Expert proficiency in Oracle SQL and Oracle SQL Developer.
• Advanced experience with Oracle PL/SQL, including stored procedures and standalone scripts.
• Proven ability to research, design, implement, code, and test spatial and tabular data.
• Experience with database conversion and migration processes.
• Ability to validate and cleanse data anomalies.
• Strong verbal and written communication skills for technical documentation and meetings.

Preferred Skills

• Knowledge of Java.
• Experience with spatial data and systems.

Key Skills

Education

Any gradudate