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

Title: Database Engineer
Reports To: Technical Manager
Notice Period :- 30 to 45 Days
Location :- Gurugram
Salary :- 30 to 40 % Hike on current CTC.
Interview :- Virtual.

Job Overview:
The Database Team at SCA works with Client Data starting from collection phase, validation phase up to final integration of this data with our system. The database team
also works very closely with the development team to provide all the database related support in product development including writing complex SPs, managing Database schema and providing support to the reporting team (Tableau) as well. The database team works directly on client data and also in a product development environment where they provide expert support for all data related activities including migration, integration, and high-level validation. Our typical client projects/product development cycle lasts 6 to 12 weeks. The team often has specialists from different disciplines with defined deliverables from the respective areas. The database professional works on facilitating multiple activities including initial data receipt from client, uploading the data
into system, performing data validation and supporting development team with SPs or other Database objects.

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