SQL Server Analyst / Architect
Work location
St. Louis, MO
Onsite 5 days a week
2350 Market Street, St. Louis, MO
Local candidates
Work Status
GC / USC required
Summary
SQL Server Admin / Analyst / DBA / Architect / Data Modeler
Database schema design and ER diagram
logical and physical database models
SSRS - Desired
Submit filled out - to be reviewed
Database Analyst
Anticipated Start Date : October 13, 2025
Responsibilities :
- Design and maintain the logical and physical database models to support MSDCARS.
- Develop and manage the project's database schema design and ER diagram, ensuring clarity of definitions and relationships.
- Develop and implement Database schemas, tables, stored procedure and functions
- Ensure data integrity, consistency, and scalability within the application.
- Collaborate with the SQL Server Database Administrator to optimize query performance and identifying bottlenecks, troubleshooting database issues.
- Partner with business and technical stakeholders to align the data model with reporting and compliance requirements.
Required Skills :
5 years of experience as a Data Architect, Data Modeler, or equivalent.Strong expertise in SQL Server database modeling and database design.Hands-on experience in DDL, DML, DQL in SQL Server database.Knowledge of SSRS tool will be add-on.Knowledge of normalization, data integrity, and relational database best practices.Preferred Skills / Certifications :
Experience in compliance or government reporting environments a plusData management certifications (e.g., DAMA, CDMP) will be add-onmail- tanu01@kanakits.com