Data Modeling:
Create conceptual, logical, and physical data models for SQL Server and
PostgreSQL.
Database Optimization:
Implement partitioning, indexing, and sharding for scalability.
Integration:
Work with the Big Data Engineer to integrate relational databases with data
lakes.
Support Power BI workflows by creating optimized queries and views.
Skills
Advanced SQL skills, experience with ER/Studio, and expertise in ETL
pipelines.
Proficiency in SQL Server, PostgreSQL, and database performance tuning.
5+ years in database administration and data modeling.