- LocationChennai,Bengaluru / Bangalore,Hyderabad
Location - Pune, Mumbai, Bangalore, Chennai & Hyderabad.
NP - Immediate to 15 days.
Skills Required -
Database Design and Modeling:
Proficient in creating Entity-Relationship Diagrams (ERDs) and understanding relationships between different data entities.
Experience with various data modeling tools like ER/Studio, Oracle Designer, or IBM InfoSphere Data Architect.
Database Management Systems (DBMS):
In-depth knowledge of DBMS such as MySQL, Oracle, SQL Server, PostgreSQL, or NoSQL databases like MongoDB, Cassandra.
Data Analysis:
Ability to analyze application requirements and translate them into database structures.
Strong analytical skills to identify and resolve data-related issues.
Best Practices in Database Design:
Understanding of normalization and denormalization processes.
Knowledge of indexing strategies, partitioning, and optimization techniques.
SQL and Scripting:
Proficiency in SQL for database querying, creating, and managing schemas.
Experience with scripting languages for database automation tasks.
Technical and Documentation Skills:
Strong technical writing skills to document database designs, schemas, and processes.
Ability to communicate complex data concepts to technical and non-technical stakeholders.
Problem-Solving:
Strong problem-solving skills to address and fix database-related issues.
Role Responsibilities
Design and Implementation:
Design robust and scalable database models to support various order-related applications.
Implement best database practices to ensure data integrity, security, and performance.
Entity-Relationship Diagrams:
Create detailed ERDs to visualize data relationships and structure.
Collaborate with application developers to align the database design with application requirements.
Database Optimization:
Optimize database performance through proper indexing, query optimization, and data partitioning.
Monitor and improve database performance and efficiency.
Recommendation and Evaluation:
Evaluate different database models and recommend the most suitable one based on the application requirements.
Stay updated with the latest database technologies and trends to make informed recommendations.
Collaboration and Communication:
Work closely with software engineers, data analysts, and other stakeholders to gather requirements and ensure seamless integration of the database with applications.
Communicate design decisions and trade-offs to project stakeholders.