Senior Platform Developer

Krasan Consulting Services; Springfield (IL); On-site; USD 100,000 - 130,000; Full time

Job summary

A consulting firm is seeking a Senior Platform Developer to lead the design and optimization of data models for transactional systems. The role demands advanced proficiency in SQL, experience with various databases, and the ability to develop comprehensive data solutions. The ideal candidate will collaborate with architects, engineers, and analysts to ensure data structures support compliance and business needs. This full-time position emphasizes innovative data management practices in a dynamic IT environment.

Qualifications

• Advanced proficiency in ANSI SQL essential.
• Hands-on experience with relational database systems required.
• Extensive experience with data modeling tools like Erwin is a plus.

Responsibilities

• Lead the design and optimization of data models for transactional systems.
• Create and maintain ERDs for new initiatives and legacy systems.
• Ensure data integrity and compliance with architectural standards.

Skills

Advanced proficiency in ANSI SQL

Hands-on experience with SQL Server

Hands-on experience with Oracle

Hands-on experience with MySQL

Experience with Erwin, PowerDesigner, or similar tools

Ability to analyze, optimize, and troubleshoot complex database environments

Job description

Senior Platform Developer – Krasan Consulting Services

Role Overview

The Senior Platform Developer will lead the design, analysis, and optimization of enterprise‑grade data models and database architectures supporting transactional systems, analytics platforms, and regulatory reporting environments. This role requires deep expertise in relational and dimensional modeling, advanced SQL analysis, and database performance optimization across multiple RDBMS platforms.

Collaborate closely with application architects, data engineers, business analysts, and data governance teams to ensure scalable, performant, and compliant data structures aligned with regulatory and business needs.

Key Responsibilities

• Design and develop conceptual, logical, and physical data models for new initiatives and legacy system modernization
• Create and maintain Entity‑Relationship Diagrams (ERDs) using tools such as Erwin or PowerDesigner
• Reverse‑engineer existing databases to document undocumented or inherited data structures
• Define entities, attributes, keys, relationships, constraints, and normalization standards
• Ensure data consistency, integrity, and alignment with architectural standards

Relational & Dimensional Database Design

• Architect relational database schemas for high-volume transactional systems using:
• Microsoft SQL Server
• Oracle
• MySQL
• Design dimensional models (Star & Snowflake schemas) to support analytics and BI reporting
• Partner with analytics and reporting teams to optimize performance, usability, and extensibility

Data Profiling, Quality & Lineage

• Perform data profiling and data quality analysis using advanced ANSI SQL
• Identify anomalies, integrity issues, and validate business rules across datasets
• Analyze relationships across multiple source systems to establish systems of record
• Document data lineage, metadata, and source‑to‑target mappings to support governance and audits

Database Performance & Optimization

• Optimize database performance through:
• Query tuning
• Execution plan analysis
• Diagnose and resolve database design and performance issues
• Recommend architectural improvements to support scalability, reliability, and long‑term maintainability
• Conceptual, logical, and physical data models with complete ERDs
• Reverse‑engineered models of legacy systems with modernization documentation

Database Implementation Assets

• Database DDL scripts for schema and table creation
• Stored procedures, views, functions, and triggers
• Indexing strategies aligned with workload patterns

Data Quality & Governance Documentation

• Data profiling and quality assessment reports
• Data lineage diagrams and metadata documentation
• Source‑to‑target mapping specifications

Performance & Scalability Outputs

• Database performance tuning reports
• Index and query optimization scripts
• Capacity planning and scalability analysis

Required Skills & Expertise

• Advanced proficiency in ANSI SQL
• Hands‑on experience with:
• SQL Server
• Oracle
• MySQL
• Extensive experience with Erwin, PowerDesigner, or similar tools
• Proven ability to analyze, optimize, and troubleshoot complex database environments

Preferred Qualifications

• Experience supporting government or regulated enterprise systems
• Familiarity with data governance, metadata management, and compliance frameworks
• Strong documentation and communication skills for both technical and business audiences

Position Details

• Seniority level: Mid‑Senior level
• Employment type: Full‑time
• Job function: Information Technology
• Industry: IT Services and IT Consulting