Avya Inventrax Pvt Ltd
Database Developer
- Compensation
- Not disclosed
- Location
- Visakhapatnam
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 2+ years
- Category
- Software engineering
- Posted
Skills
Must have
- 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 .
Nice to have
- 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
- Experience working in domains like retail, supply chain, Warehouse , healthcare, or e-commerce
Full description
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