Search jobs > Madison, WI > Database architect

Database Architect IV

RIT Solutions, Inc.
Madison, WI, United States
Full-time

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
  • 9 days ago
Related jobs
Promoted
RIT Solutions, Inc.
Madison, Wisconsin

Database Architect IV designs and builds relational databases. Database Architect will design strategies, implement database SQL and stored procedures, and devise strategies to replace outdated technology and implement them. Develops strategies for data acquisitions, archive recovery, and database i...

Promoted
Church Mutual Insurance Company, S.I.
Madison, Wisconsin

Senior Underwriting Data Analyst. Develop advanced data and reporting solutions utilizing intelligence applications to provide dashboards, data marts, query tools, and ad hoc reporting. Retrieve and manipulate data from multiple data sources using current tools and software, such as SAS EG, SAS VA, ...

Promoted
Ledgent Technology
WI, United States

SQL Developer, SQL Programming, SQL Database, SQL Development. The SQL Developer is responsible for designing, implementing, and maintaining database solutions to facilitate efficient data management within the organization. SQL Developer or in a similar role. They will utilize their expertise in SQ...

Promoted
Element6Talent
Madison, Wisconsin

Data Management and Quality: data mapping, data profiling, data catalog, relational data modeling, master data management, data governance. Demonstrate competence, experience, knowledge, understanding, and advocacy of data management concepts, data warehousing, data integration, BI, and analytics. D...

Promoted
Navitus Health Solutions LLC
Madison, Wisconsin

Data Engineer designs, develops, and maintains Navitus’ data architecture, ensuring that data is correctly mapped, accessible, available, and secure. Data Engineer to our Information Technology Data department. Develop data mapping and transformation strategies to ensure data consistency and c...

Promoted
SRS Consulting Inc
WI, United States

Troubleshoot and resolve database-related issues, including performance bottlenecks, data inconsistencies, and software bugs. Required Skills · 9+ Years of experience in handling NoSQL database. DataStax architecture and hands-on administration experience · The DataStax administrator role involves s...

Promoted
FTI
WI, United States

Supports data management, data modeling, data warehousing, and master data management initiatives. Creates strategic plans for improving data integration, data quality, and data delivery. Contributes to data governance, data standards, and data literacy initiatives. Experience: 8+ years overall expe...

Promoted
CliftonLarsonAllen
Madison, Wisconsin

Strong proficiency in SQL Server development tools, including SQL Server Management Studio, Azure Data Studio, and Azure SQL Database. We are seeking a skilled SQL/ETL Developer to join our team. As a SQL/ETL Developer, you will be responsible for designing, implementing, and maintaining our ETL pip...

Promoted
Horace Mann Educators
Madison, Wisconsin

The Business Systems Analyst- Experienced will serve as a liaison between the business and technology groups to assist in the identification and execution of IT solutions to support business goals. Business Systems Analyst-Experienced. Assist the business and IT to define and document the business c...

Promoted
Ladders
Madison, Wisconsin

Develop advanced data and reporting solutions utilizing intelligence applications to provide dashboards, data marts, query tools, and ad hoc reporting. Retrieve and manipulate data from multiple data sources using current tools and software, such as SAS EG, SAS VA, Excel, and Tableau. Document corpo...