Krasan Consulting Services ยท 1 week ago
Senior Platform Developer
Springfield, IL
Full-time
Onsite
Senior LevelKrasan Consulting Services is seeking a Senior Platform Developer who will lead the design, analysis, and optimization of enterprise-grade data models and database architectures. The role involves collaborating with various teams to ensure scalable and compliant data structures that meet regulatory and business needs.
Information TechnologyIT ManagementManagement Consulting
Hiring Manager
Jyothsna Gayathri
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
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
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
Optimize database performance through: Index design, 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 DDL scripts for schema and table creation
Stored procedures, views, functions, and triggers
Indexing strategies aligned with workload patterns
Data profiling and quality assessment reports
Data lineage diagrams and metadata documentation
Source-to-target mapping specifications
Database performance tuning reports
Index and query optimization scripts
Capacity planning and scalability analysis
Qualification
Required
Strong expertise in data modeling methodologies (3NF, dimensional modeling)
Advanced proficiency in ANSI SQL
Hands-on experience with SQL Server
Hands-on experience with Oracle
Hands-on experience with MySQL
Extensive experience with Erwin, PowerDesigner, or similar tools
Proven ability to analyze, optimize, and troubleshoot complex database environments
Preferred
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
Company
Krasan Consulting Services
Krasan Consulting Services is a technology management consulting firm and solutions integrator.
Founded in 2019
51-200 employees
H1B Sponsorship
Krasan Consulting Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (42)
2024 (21)
2023 (4)
Funding
Current Stage
Growth StageLeadership Team
Rick Pugh
Chief Operations Officer
Company data provided by crunchbase