Senior Platform Developer

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 Power Designer
• 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, Power Designer, 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