Database Engineer

Full–time
About SCA

Since 1999, SCA Technologies has provided sourcing optimization and cost management solutions that help industry leaders maximize profits by better managing commodity, supply and demand volatility. Our fresh, cross-functional approach provides improved visibility and streamlines processes for planning, tracking and optimizing direct materials costs and prices, through our cloud-based, proprietary technology, SCA Planner™.

Headquartered in Pittsburgh, SCA Technologies has offices in Chicago, Gurgaon and Hyderabad. Sustaining successes with some of the biggest restaurant brands in the world has enabled our company to grow steadily.

Title: Database Engineer

Reports To: Technical Manager

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