0 years

3 - 4 Lacs

Posted:3 days ago| Platform: GlassDoor logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Job Description - SQL Developer

Role Overview:
Responsible for designing, developing, and maintaining SQL databases, stored procedures, triggers, and data pipelines that power the ERP and BI systems. Ensures data integrity, performance optimization, and seamless integration across manufacturing modules.

Reporting To:
ERP Manager

Team Reporting:
None (works closely with BI Developer and ERP development team)

KRA – Key Result Areas

✔ Database Design & Development
✔ Data Integration for ERP & BI✔ Performance Optimization✔ Data Security & Backup Management✔ Query Automation & Support

Work Schedule : General Shift

Activity Calendar – Micro-Level Tasks

Daily Activities

  • Monitor database health and query performance.
  • Execute and verify scheduled data backups.
  • Troubleshoot ERP-related data issues.

Weekly Activities

  • Review and optimize slow queries.
  • Validate data integrity across modules.

Fortnightly Activities

  • Update stored procedures and triggers as per ERP changes.
  • Conduct performance benchmarking.

Monthly Activities

  • Implement indexing strategies for large tables.
  • Share performance improvement report with ERP Manager.

Quarterly Activities

  • Perform database capacity planning.
  • Test disaster recovery and failover mechanisms.

Annual Activities

  • Upgrade database version and optimize schema.
  • Review overall database architecture and suggest improvements.

Operational Responsibilities

  • Maintain all ERP-related databases.
  • Write efficient SQL queries and procedures.
  • Ensure proper user access control and security measures.

Strategic Responsibilities

  • Develop data automation scripts to reduce manual intervention.
  • Recommend improvements for scalability and high availability.
  • Support BI and analytics team with optimized data structures.

Competencies & Skills

Functional:

  • Proficiency in SQL Server
  • Strong understanding of data modelling and normalization.
  • Experience with ERP database structures and manufacturing data.

Behavioural:

  • Strong analytical and problem-solving skills.
  • Ability to work under pressure with deadlines.
  • Good communication for cross-functional collaboration.

Job Types: Full-time, Permanent

Pay: ₹30,000.00 - ₹35,000.00 per month

Benefits:

  • Commuter assistance
  • Food provided
  • Provident Fund

Work Location: In person

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

hyderabad, telangana, india

nagercoil, all india

noida, uttar pradesh, india