What Database Architects do at SCA ?
The Data Architect will have an end-to-end vision of all SCA's solutions for Supply Chain cost analysis and optimization products, and to see how a logical design will translate into one or more physical Databases, and how the Data will flow through the successive Stages involved.
The Data Architect will need to be able to address issues of Data Migration(Validation, Clean-up and Mapping), and will need to understand the importance of Data Dictionaries.
• Develop and document database architectures. Create and enforce database development standards.
• Develop data models for applications, metadata tables, views or related database structures.
• Develop load-balancing processes to eliminate down time for backup processes.
• Develop or maintain archived procedures, procedural codes, or queries for applications.
• Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
• Develops and delivers long-term strategic goals for data architecture vision and standards by collaborating with Solution architects, Software architects, design analysts, and others.
• Demonstrate database technical functionality, such as performance, security and reliability.
• Design data transfer mechanisms like ETL and improve data cleansing, data quality issues as they arise
• Establishes methods and procedures for tracking data quality, completeness, redundancy, and improvement
• Define technical dependencies and dependency management strategy, and align solutions with enterprise architecture strategy
• Defining functional design and technical design for data management and integration
• Creates short-term tactical solutions to achieve long-term objectives and an overall data management roadmap
• Selects and implements the appropriate tools, software, applications, and systems to support data technology goals
• Provides coaching and mentoring to all members of the department
What skills do we expect from Database Architect at SCA :
• Minimum of 5-8 years in Database design and development.
• Demonstrated ability to design and develop complex database load and maintenance processes
• 4+ years Hands-on experience designing RDBMS databases for web applications
• 2+ years of experience with star schema and dimensional data modeling.

About SCA Technologies
About
Company video


Connect with the team
Similar jobs


Engineering Head / Tech Lead (React + Node.js)
About MrPropTek
MrPropTek is building the future of real estate technology. We're looking for a hands-on Engineering Head / Tech Lead to drive our tech strategy and lead the development of scalable web applications across frontend and backend using React and Node.js.
Responsibilities
- Lead and mentor a team of full-stack developers
- Architect and build scalable, high-performance applications
- Drive end-to-end development using React (frontend) and Node.js (backend)
- Collaborate with product, design, and business teams to align on priorities
- Enforce code quality, best practices, and agile processes
- Oversee deployment, performance, and security of systems
Requirements
- 7+ years in software development; 3+ years in a tech lead or engineering management role
- Deep expertise in React.js, Node.js, JavaScript/TypeScript
- Experience with REST APIs, cloud platforms (AWS/GCP), and databases (SQL/NoSQL)
- Strong leadership, communication, and decision-making skills
- Startup or fast-paced team experience preferred
Job Location- Mohali, Delhi/ NCR
Job Type: Full-time



You’ll be joining a small team working at the forefront of new technology, solving the challenges that impact both the front-end and back-end architecture, and ultimately, delivering amazing global user experiences.
Responsibilities
• Work across the full stack, building highly scalable distributed solutions that enable positive user experiences and measurable business growth
• Ideate and develop new product features in collaboration with domain experts in healthcare and genomics
• Develop state-of-the-art enterprise standard front-end and backend services
• Develop cloud platform services based on a container orchestration platform
• Continuously embrace automation for repetitive tasks
• Ensure application performance, uptime, and scale, maintaining high standards of code quality by using clean coding principles and solid design patterns
• Build robust tech modules that are Unit Testable, Automating recurring tasks and processes
• Engage effectively with team members and collaborate to upskill and unblock each other
Other Skills
• Innovation and thought leadership
• UI - UX design skills
• Interest in learning new tools, languages, workflows, and philosophies to grow
• Communication
Who are we?
HaystackAnalytics is a company working in deep technology of genomics, computing, and data science for creating the first-of-its-kind clinical reporting engine in healthcare. We are a new but well-funded company with a tremendous amount of pedigree in the team (IIT Founders, IIT & IIM core team). Some of the technologies we have created are a global first in infectious disease and chronic diagnostics. As a product company creating a huge amount of IP, our Technology and R&D team are
our crown jewels. With the early success of our products in India, we are now expanding to take our products to international shores


Design, develop and maintain web-based services and applications using .Net Core/ASP.Net, C#, REST Web API, MS SQL Server, Entity Framework, and Dapper. Developing highly optimized cross-browser and responsive web applications using HTML5, and CSS. Manage the full technical life-cycle of web applications during each development phase including functional & technical design, implementation, testing, deployment and maintenance. Developing high standard Web Applications based on functional requirements, UI/UX requirements, business logic and Web APIs. Designing database tables, views, stored procedures, and functions to store and retrieve data most efficiently from SQL database. Writing bug-free code with the highest coding standard. Developing high-performance, highly secure and highly scalable Web Application. Perform unit testing, troubleshooting, debugging and code reviews for robustness, including edge cases, usability, and reliability of the software. Manage source code check-in, checkout, and merging code. Taking accountability and the ability to work under pressure
Hands-on experience o of using Angular with version 7 or later o in consuming complex nested API. o in using state management (e.g. NGRX, RXJS). o in using caching. o of using component library framework integration (e.g. Angular Material). o in integrating with REST web services from the application. Knowing JSON is a must. o with Git compatible source control and working with a CI/CD pipeline. Experience on AWS services will be added advantage. Good experience in Standard Project Development Life Cycle. Experience on Devextreme tools will be added advantage. Ability/ready to work on advanced technologies like Node JS is an added advantage. Knowledge / Experience of agile development methodologies. Very good logical skills and problem-solving ability. Quick learner and a good team player. Should be able to work independently and with the team.

Responsibilities
• Participate in requirements analysis
• Collaborate with internal teams to produce software design and architecture
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code Requirements
• At least 5 years of experience with .NET
• Experience with ASP.NET
• MS SQL knowledge
• JavaScript experience
Nice to have
• .NET Core experience
• Entity Framework Core knowledge
• Experience with Angular • Experience with AWS (or Azure, GCP)
• Knowldege of CI/CD (GitLab, TeamCity, TFS Release)
· Software Development and leading supporting development team, status reporting to Project Manager · Should be able to review the code of the team members, should be actively involved in impact analysis · Must take ownership of tasks assigned to self and team · Create and maintain proper documents related to development work · Collaborate with other team to create quicker issue resolution to achieve high customer satisfaction · Manage Source code repositories and internal and external deployment and patches · Clear understanding of requirement from functional team · Coding applications using best practices, documentation. · Involvement in analysis, design, coding, SIT, UAT and support · Should be a self-learner, able to work independently and manage tasks in hand |
BCA/BSC/MCA/MSC/BE or any other graduate with good academic background |
3-9 years in software development |
Web : Angular4+, HTML, JavaScript, CSS, Ajax Frameworks : Spring Boot, Hibernate/JPA, Spring Cloud Micro services Programming: Typescript, Java/J2EE 1.8, Oracle PL SQL IDE Tools : Eclipse, SpringSuit, Visual Studio Code, InteliJ Web servers : Apache Tomcat/JBoss/Wildfly/Weblogic/Maven or any additional web server Source Control – Good knowledge on SVN/Git Databases : Oracle - Strong in Oracle PL / SQL WebServices : SOAP, Restful, WSDL, ETL tools like Talent
|
Good Communication Skills (Verbal & Written) Good Team Player Should be Self-Starter |


Skill set: ASP.Net, Web, MySQL, C+, HTML, ASP.Net Angular(good to have),
Job Description as mentioned below: ·
MS SQL; Database design,
Stored Procedure, Functions,
Views, triggers, and advanced queries ·
C# version 4 or higher. ·
Visual Studio 2013 or later. ·
ASP.NET web forms knowledge ·
Advanced JQuery/JavaScript ·
Ability to understand the existing applications and work on enhancements · Ability to understand requirements quickly · Documentation skills , Requirement Analysis ·
Good Communication skills

As Lead Software Engineer, we are looking for a person who loves to engineer design specs into usable interactions. Responsibilities will include translation of the UI/UX design wireframes to actual code that will produce visual elements of the application. You will work with the development team to understand and bridge the gap between graphical design and technical implementation, taking an active role and defining how the application looks as well as how it works.
This is an innovative role and requires a candidate who is extremely motivated, dedicated, and passionate about development. It's a high growth opportunity to be part of a fast-growing startup!
Key Responsibilities :
- Build scalable web applications using MERN Stack
- Convert visual designs to UI elements with an acute eye for detail and design fidelity
- Make web applications responsive and cross-browser compatible
- Optimize application performance and reduce page loading speed
- Collaborate with various teams to develop new features
- Ability to work under pressure and deliver projects with tight deadlines
- Implement unit tests and integration tests to drive development efficiency.
Requirements :
- 3 years of work experience comprising of Backend(preferably NodeJS), Frontend (React/Angular) and Software Design/Architecture
- 2+ years experience building Production grade applications on ReactJS or Angular - STRICT REQUIREMENT
- Expertise in building UI components in a reusable manner.
- Knowledge of messaging services like Apache Kafka, RabbitMQ
- Experience in integrating REST APIs and developing data processing pipelines
- Experience in distributed web services development and chaining
- Understanding of cloud services like AWS and GCP
- Experience with DevOps technologies such as Docker, Kubernetes, Jenkins, CI/CD, etc
- Experience in working with Mapping Library like Google Maps, Mapbox or Leaflet is a plus.
Salary - 4-6.5 lpa


- Proficient in Python 2 / 3 and have built products before (managing the entire DevOps cycle) - proficient in Python Data Structures
- Good understanding of Open Source Visualisation Tools like D3.JS, Matplotlib etc.
- Good understanding of Functional APIs and Data Ingestion viz. Pandas’ dataframe from SQL DB and Excel (CSV) & Flat files of (primarily) structured data - no data cleansing
- Growth mindset - eagerness to learn and grow in the role
- Qualifications: B.Tech / BE / Graduate Engineer in any stream (preferred Mech / Industrial Engineer)
- Compensation : At par with industry (with stock options / grants to be vested over 3 years)


