Database Developer

Role Overview:

We are seeking a talented and detail-oriented Database Developer with 2+ years of experience to design, develop, and maintain scalable database solutions. The ideal candidate should have a strong command over SQL and be experienced in writing efficient queries, stored procedures, and working with data models to support application and reporting needs.

Key Responsibilities:

• Write and optimize SQL queries, stored procedures, functions, views, and triggers
• Design and maintain normalized and denormalized data models
• Develop and maintain ERP Processes
• Analyze existing queries for performance improvements and suggest indexing strategies
• Work closely with application developers and analysts to understand data requirements
• Ensure data integrity and consistency across development, staging, and production environments
• Create and maintain technical documentation related to database structures, processes, and queries
• Generate and support custom reports and dashboards (using tools like Superset Etc)
• Participate in data migration and integration efforts between systems or platforms
• Work with large datasets and ensure optimal data processing and storage

Required Skills:

• Strong hands-on experience with SQL Server, MySQL, PostgreSQL.
• Proficiency in writing complex SQL queries, stored procedures, and data transformations
• Understanding of relational database concepts, data modeling, and indexing
• Knowledge of performance tuning techniques (joins, temp tables, query plans)
• Familiarity with ERP tools or scripting .

Preferred Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or related field
• MS SQL, good to have dot net.
• knowledge on WMS or MEW or manufacturing ERP experience.
• Knowledge of basic database security, transactions, and locking mechanisms
• Exposure to cloud-based databases
• Experience with version control (Git), Agile methodologies, or similar tools

Nice to Have:

• Experience working in domains like retail, supply chain, Warehouse , healthcare, or e-commerce

Send Resume to : sowmya.chintada@inventrax.com (or) janardhan.tanakala@inventrax.com