Senior Data Modeler – (OLTP & SQL Server)
New
J
JobgetherIT Security
Based in IndiaFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 8–10 years of overall experience in database development, including at least 3 years of hands-on experience in data modeling or database design.
- Required Skills
- SQLMicrosoft SQL ServerData modeling
Requirements
- 8–10 years of overall experience in database development.
- At least 3 years of hands-on experience in data modeling or database design.
- Strong practical expertise with Microsoft SQL Server and T-SQL.
- Strong understanding of OLTP architectures and transactional database environments.
- Experience creating logical and physical data models for enterprise or commercial applications.
- Strong knowledge of ER modeling, normalization and 3NF, primary and foreign keys, cardinality, constraints, referential integrity, and indexing strategies.
- Ability to translate complex business requirements into effective database structures.
- Strong communication and collaboration skills.
- Strong analytical and problem-solving skills.
- Experience with Azure SQL or AWS RDS is a plus.
- Experience in healthcare, pharmaceutical, or life sciences environments is a plus.
- Familiarity with AI-assisted tools for engineering productivity is a plus.
Responsibilities
- Design conceptual, logical, and physical data models for enterprise OLTP applications, ensuring structures are scalable, maintainable, and aligned with application requirements.
- Translate business requirements into well-defined entities, attributes, relationships, cardinalities, and business rules that accurately represent business processes.
- Develop ER models and detailed database designs covering tables, primary keys, foreign keys, constraints, indexes, and other relational components.
- Apply normalization principles, including 3NF, to create efficient relational structures while maintaining appropriate data integrity and minimizing unnecessary duplication.
- Work closely with Architects, Developers, Business Analysts, Product Managers, and other stakeholders to ensure database designs support functional and technical requirements.
- Review and optimize existing database structures to improve data integrity, scalability, maintainability, and performance as applications and business needs evolve.
- Support database enhancements, new application features, and changes to transactional systems by evaluating their impact on existing data models and structures.
- Document database architectures, design decisions, assumptions, dependencies, business rules, and relevant technical considerations.
- Use AI-assisted tools such as ChatGPT, Claude, or GitHub Copilot where appropriate to improve SQL development, documentation, troubleshooting, and analysis.
View Full Description & ApplyYou'll be redirected to the employer's site
