Database Engineer SCA Technologies

About SCA Technologies

SCA Technologies has provided category sourcing and cost management solutions that assist industry leaders in maximising profits by managing market, supply, and demand volatility more effectively. Professionals in supply chain, procurement, finance, and corporate social responsibility use the unique cross-functional approach of the SCA Planner suite to make better decisions for billions of dollars in annual category spending. Customers can finally address the difficult challenges of volatile commodity prices, extensive supply chain networks, and corporate social responsibility tradeoffs with our patented technology. Our innovative cloud-based solutions increase visibility and response time, resulting in a 3-5% annual reduction in the average cost of goods sold. SCA Technologies has offices all over the world, including Chicago and New Delhi, India, in addition to its headquarters in Pittsburgh. Consistent growth has been enabled by our company's continued success. SCA Technologies is a debt-free, self-funded organisation.

Job Description

Responsibilities
• Work for a sustained duration (2- 3 months) on large scale business
problems involving software modules in the area of cost, operations and
supply chain.
• Design, write, test, and debug database stored procedures and complex
queries to extract, calculate or manipulate information using SQL-Server
2017/2019 database.
• Assist in migration and integration of data and DB Objects from
legacy systems to new applications and new technologies.
• Working in a team environment to process and analyze large data sets
• Use tools such as Excel to manage, process and aggregate sales, product,
manufacturing and financial related data
• Bring in new and fresh ideas into the team and work towards getting the team
to meet industry standards
• Take responsibility for the accuracy and quality of the work performed and
takes ownership of all assigned projects
• Work with middle-tier developers to integrate back-end database code with
business applications.

Skills
• Minimum 2 years of experience in working with large data sets
preferably in ERP/ MRP manufacturing and/or distribution environment
• Must have worked on business domain side, with data management as the
key area of work
• Good to have experience in ETL practices and procedures
• BE/BTech/MCA from a reputed institute, with Computer
Science/Mechanical/ Mathematics/Chemical as preferable
engineering background
• Should be able to relate to the business needs driven by data sensitivity
in real world scenarios
Technical Skills
• Expert in Designing, writing, testing, and debugging database stored
procedures, functions, triggers and complex queries to extract, calculate or
manipulate information using SQL- Server 2017/2019 database (MUST)
• Expert in migration and integration of data and DB Objects from legacy
systems to new applications and new technologies.
• Experience with optimizing data queries for improving performance
• Should be able to implement the best practices in writing and maintaining SQL code.
• Demonstrated experience in understanding the impact of data
alteration on business side
• Demonstrated experience in conducting analytics with SQL and Excel
• Should be able to perform detailed impact analysis of implementing anything new on the
existing application.
• Should be able to use SQL tools like SQL Profiler/Extended Events/Activity Monitor
• Should be able to create and schedule SQL Agent Jobs.

Soft Skills
• Excellent communication skills
• Good Team Player
• Take responsibility for the accuracy and quality of the work performed
and takes ownership of all assigned projects
• Able to work onsite if the situation demands
• Ability to be a quick learner who can work independently
• Work effectively with minimum supervision
• Work closely with other teams of application developers, system
administrators and Client facing team
Location- Gurgaon