Top 2 Oracle developer Jobs in Springfield, Il

Senior Platform Developer
Krasan Consulting Services Inc —Springfield, IL
- $70 - $75 an hour
- Full-time
- Remote
- SQL
- Senior level
Quick Apply

Check out these similar jobs

Based on your search for oracle developer jobs.

Senior Platform Developer
Krasan Consulting Services Inc —Springfield, IL
Documentation-first presentations, walkthroughs, and review materials translating complex technical findings into clear, actionable insights for technical and…
$70 - $75 an hour
Quick Apply
Senior Platform Developer/Engineer
Krasan Consulting Services Inc —Springfield, IL
Adhere to structured development lifecycles, including requirements analysis, design documentation, development, testing, deployment, and post-implementation…
$70 - $75 an hour
Quick Apply

Show more similar jobs

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

Java Developer (Oracle PL/SQL)
Sonsoft Inc —Westerville, OH
Database tuning and performance improvement experience. Excellent experience in Oracle PL/ SQL. Good Experience in Java With Oracle PL/SQL.
Quick Apply
Java Developer (Oracle PL/SQL)
Sonsoft Inc —Westerville, OH
Database tuning and performance improvement experience. Excellent experience in Oracle PL/ SQL. Good Experience in Java With Oracle PL/SQL.
Quick Apply

Show more jobs in cities nearby

I want to receive the latest job alert for oracle developer in springfield, il

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

oracle developer jobs near springfield, il

Senior Developer jobs in Springfield, IL

Senior Developer jobs in Remote

Senior Developer jobs in Georgetown, KY

Senior Data Analyst jobs in Boston, MA

Senior Aerospace jobs in Burbank, CA

Senior Developer jobs in Albuquerque, NM

Web Developer jobs in New Jersey

Senior Developer jobs in Washington, DC

Atria Senior Living jobs in Ardsley, NY

Senior Platform Developer

Krasan Consulting Services Inc -
Springfield, IL

Quick Apply

Job Details

Full-time
$70 - $75 an hour

Qualifications

Performance tuning

Full Job Description

Job Title: Senior Platform Developer

Work Location: Remote

Project Name: Gaming Regulatory System (Discovery Phase)

Employment Type: Full-Time

Duration: 6 Months (Each role)

Role Overview

The Senior Platform Developer will be responsible for designing, analyzing, and optimizing enterprise-grade data models and database architectures that support transactional systems, analytical platforms, and reporting environments. This role requires deep expertise in relational and dimensional modeling, advanced SQL-based data analysis, and database performance optimization across multiple RDBMS platforms. The position will work closely with application architects, data engineers, business analysts, and governance teams to ensure data structures are scalable, performant, and aligned with business and regulatory requirements.

Primary Responsibilities

Data Modeling & Architecture

Design and develop conceptual, logical, and physical data models for both greenfield initiatives and legacy system modernization efforts, ensuring alignment with business processes and technical architecture standards.

Create and maintain Entity-Relationship Diagrams (ERDs) using industry-standard tools such as Erwin and Power Designer, including reverse engineering of existing databases to document undocumented or inherited data structures.

Define entity attributes, primary and foreign keys, relationships, normalization standards, constraints, and referential integrity rules to ensure consistency and data accuracy across systems.

Relational & Dimensional Database Design

Architect robust relational database schemas for enterprise platforms including Microsoft SQL Server, Oracle, and MySQL, supporting high-volume transactional workloads.

Design dimensional data models using star and snowflake schemas to enable efficient analytics, reporting, and business intelligence solutions.

Partner with reporting and analytics teams to ensure data models meet performance, usability, and extensibility requirements.

Data Profiling, Quality & Lineage Analysis

Conduct comprehensive data profiling and data quality assessments by writing complex ANSI SQL queries to analyze data distributions, detect anomalies, identify data integrity issues, and validate business rules.

Analyze data relationships across multiple source systems to establish authoritative sources of truth and clearly defined ownership.

Document data lineage, metadata, and source-to-target mappings to support governance, auditability, and downstream system integration.

Database Performance & Optimization

Optimize database performance through strategic index design, query tuning, and metadata management across heterogeneous database platforms.

Diagnose and resolve database design and performance issues by reviewing execution plans, storage strategies, and schema configurations.

Recommend and implement architectural enhancements and operational improvements to support scalability, reliability, and long-term maintainability.

Key Deliverables

Current-State Data Architecture Documentation
Comprehensive “as-is” documentation of legacy database environments, including schemas, table structures, relationships, constraints, indexes, and embedded business logic across SQL Server, Oracle, and MySQL platforms.

Enterprise Data Models
Conceptual, logical, and physical data models aligned to 3NF and dimensional modeling standards, developed using enterprise modeling tools and validated against existing source systems.

Data Lineage & Dependency Artifacts
End-to-end data lineage diagrams and dependency mappings illustrating data flows, integrations, upstream/downstream impacts, and system touchpoints.

Data Profiling & Quality Assessment Reports
Detailed SQL-driven profiling reports documenting data volumes, distributions, anomalies, referential integrity issues, and data quality risks, with clear remediation recommendations.

Legacy System Analysis & Risk Assessments
Technical assessment documents identifying structural limitations, performance bottlenecks, design gaps, and modernization risks within legacy relational databases.

SQL Analysis & Validation Artifacts
Reusable ANSI SQL scripts and analysis outputs supporting reconciliation, validation, performance evaluation, and architectural decision-making.

Future-State Architecture Inputs
Well-defined technical inputs for solution and enterprise architects, including migration considerations, modernization constraints, and design assumptions.

Architectural Decision Records (ADR) Contributions
Clear, evidence-based documentation supporting architectural decisions, trade-offs, and long-term platform roadmap planning.

Stakeholder Review & Knowledge Transfer Materials
Documentation-first presentations, walkthroughs, and review materials translating complex technical findings into clear, actionable insights for technical and non-technical stakeholders.

Key Responsibilities

Act as the SQL / Oracle Subject Matter Expert (SME), providing authoritative technical analysis across complex legacy relational database environments.

Perform comprehensive legacy system analysis, including reverse-engineering database schemas, relationships, constraints, indexes, and embedded business logic across SQL Server, Oracle, and MySQL platforms.

Develop and maintain high-fidelity documentation of current-state (“as-is”) data architectures, including data models, lineage, dependencies, and integration touchpoints.

Create and validate conceptual, logical, and physical data models in alignment with 3NF and dimensional modeling standards using enterprise modeling tools.

Author and analyze advanced ANSI SQL to support data profiling, validation, reconciliation, lineage assessment, and performance evaluation.

Assess data quality, structural integrity, and performance characteristics of legacy databases, document risks, gaps, and optimization opportunities with clear technical recommendations.

Partner with solution and enterprise architects to support future-state data architecture planning, modernization assessments, and migration strategies.

Translate detailed legacy-state findings into actionable inputs for architectural decision records (ADRs) and long-term platform roadmaps.

Communicate complex technical findings clearly and concisely to cross-functional stakeholders through documentation-first deliverables, workshops, and reviews.

Operate in a documentation-first, analysis-driven role with minimal to no hands-on application development, focusing on technical advisory and architectural enablement.

Preferred Qualifications

Experience supporting large-scale government or regulated enterprise systems.

Familiarity with data governance, metadata management, and compliance frameworks.

Strong documentation skills with the ability to translate complex technical concepts into clear, consumable artifacts for technical and business stakeholders.

Quick Apply

Refine Your Search

oracle developer jobs in springfield, il

Senior Platform Developer

Check out these similar jobs

Explore jobs in cities nearby

I want to receive the latest job alert for oracle developer in springfield, il

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected