4Bell Technology

Staffing & Recruiting

Senior Data Modeler(R-1912)

3,000,000.00-3,500,000.00/A

Any Degree

IT (Information Technology)

Full-time

Bangalore/Bengaluru,Chennai

17-Sep-2026

Data modeling Oracle and PostgreSQL SQL ERwin / ER Studio Logical Model & Physical Model OLTP Stored Procedures

Job Description

Key Responsibilities

  • Design conceptual, logical, and physical data models based on business and functional requirements.
  • Develop scalable and efficient relational database schemas with a strong focus on data integrity, normalization, and performance.
  • Create and maintain ER diagrams, data dictionaries, data mappings, and database design documentation.
  • Collaborate with Business Analysts, Architects, Developers, and QA teams to understand data requirements and translate them into robust database designs.
  • Develop and maintain SQL scripts, stored procedures, functions, views, triggers, packages, and other database objects.
  • Implement database enhancements, schema modifications, and structural changes as application requirements evolve.
  • Analyze and optimize SQL queries, indexes, and execution plans to improve database performance.
  • Ensure database security, data integrity, backup, recovery, and compliance with organizational standards.
  • Review database designs and SQL code to ensure adherence to best practices.
  • Troubleshoot database-related issues and provide timely production support.
  • Work closely with development teams during application releases and deployments.
  • Maintain database versioning and documentation for all schema changes.

Required Skills

  • 8+ years of experience in relational database design and data modeling.
  • Strong expertise in conceptual, logical, and physical data modeling.
  • Extensive experience designing OLTP database schemas.
  • Strong hands-on experience with Oracle and/or PostgreSQL databases.
  • Excellent SQL programming skills.
  • Experience developing stored procedures, functions, views, triggers, and packages.
  • Strong understanding of database normalization, indexing, constraints, transactions, and referential integrity.
  • Hands-on experience with database performance tuning and query optimization.
  • Experience using data modeling tools such as ERwin, ER/Studio, Oracle SQL Developer Data Modeler, or equivalent.
  • Familiarity with database migration, schema versioning, and release management.
  • Excellent analytical, problem-solving, and communication skills.