Data Modeler

Jero Technologies; Hyderabad, Chennai District, Bengaluru; On-site; INR 2,500,000 - 4,200,000; Full time

Job summary

Jero Technologies is seeking a seasoned database architect to design and optimize relational data models for enterprise applications in Hyderabad. The role requires deep expertise in OLTP schemas, cross-platform SQL development, and hands-on work with Oracle and PostgreSQL.

Candidates should demonstrate strong problem-solving, excellent communication, and capability to lead database migration and release processes in a fast-paced environment.

Qualifications

• 8+ years of experience in relational database design and 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.

Skills

Relational database design

Data modeling

OLTP schemas

SQL programming

Stored procedures

Views

Triggers

Packages

Normalization

Indexing

Transactions

Referential integrity

Performance tuning

Query optimization

Analytical skills

Communication skills

Tools

ERwin

ER/Studio

Oracle SQL Developer Data Modeler

Oracle

PostgreSQL

Job description

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.