• Minimum Experience of 4 years.
• Fluency in SQL and database specific programming language (PL/SQL, T-SQL etc.)
• Ability to translate business requirements into system design and perform as per the needs.
• Ability to do Data Modelling (including ER & dimension modeling)
• Physical Schema design for given Database (indexing, constraints, partitioning, caching etc.)
• Ability to understand the business applications and transaction model including end-to-end flow from ‘system’ perspective.
• Ability to debug queries and identify bottlenecks and resolve them in an efficient manner.
• Firm understanding how ORM’s works and how it can be optimized to achieve optimal performance while still using ORM’s rich features.