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



Job Description:
Responsibilities:
· Participate in the entire application lifecycle, focusing on coding and debugging
· Ability to design and document the product features, codes.
· Self-driven and ability to take up ownership of things
· Write clean code to develop functional applications, automation scripts, test cases
· Troubleshoot and debug applications
· Collaborate with developers, cross-functional teams to identify issue, new features and come up with solutions
· Gather and address technical and design requirements
· Provide training and support to internal teams
· Build reusable code and libraries for future use
· Ability to sync with other developers, designers to identify issues, new features and improvements
Requirements and skills:
· Solid understanding of linux development environment and systems
· Expert level knowledge of Python along with frameworks like Django, flask
· Proficient in writing unit test cases using Pytest framework.
· Expert level knowledge of SQL databases like MySQL and PostgreSQL
· Good knowledge of design principles and databases
· Knowledge of front technologies like Typescript, ReactJs
· Knowledge of Caching techniques using Memcached and Redis
· Experience of using queueing service line Kafka
· Solid understanding of microservices architecture
· Knowledge of AWS cloud services
· Expert in serverless technologies like lambda along with API gateway
· Knowledge of Git, Jira, CI/CD pipelines and containerization like docker
· Knowledge of logging and monitoring tools like Grafana or Newrelic

Role & Responsibilities:
- Individuals are responsible for all traditional development activities analysis, design, coding, testing, and documentation.
- Add new features to existing Windows and Web-based applications in Visual Studio 2019. Interacting with the internal team.
- Transform business and design needs into innovative products.
- Drive all projects to completion within deadlines.
- Perform thorough testing to find issues ahead of time.
- Engineering software needs a more precise analysis & coding skillset
- Enhance skillset by working with fortune 500 clients
- Interacting with the internal team.
Qualifications:
- B.E in computer science or related fields.
- Hands-on development experience with web & database technologies (MS SQL).
- Excellent programming & communication skills Strong problem-solving, judgmental, and decision-making skills.
- Ability to work at the tactical and strategic levels of IT initiatives.
- Impressive hands-on experience in .Net technologies. Impressive hands-on experience and knowledge with C#, SQL, JSON, XML, Win Forms & MVC, Angular, JavaScript, jQuery, HTML/CSS.
- Self-Motivated, flexible & Innovative.


Sr .Net Developer/ SQL Server (4 + Years)
We are a Business process Management Solutions & Services Company based out of Bangalore, looking for dynamic and self-motivated .Net/sql Server Developer, who can play a significant role in NeoLotex own flagship BPM Products.
Deliverables
• Add new features to the different applications in the product suit
• Troubleshoot and provide resolution to production issues. Reproduce, document and resolve product defects
• Provide well-thought out and reliable direction, both in technical and non-technical terms to the team members
• Take ownership of customer issues, including troubleshooting, identification of root cause and issue resolution
• Create clear and concise Knowledge documents and ensure maintenance of the same
• Understand requirement through discussions with Client/Business Team, or by studying / analyzing the Function Specification Document (FSD), and converting the requirements in to technical implementations using technical documentation and unit test cases
• White box testing (unit test) manual and automated
• Utilize established development tools, guidelines, and conventions including ASP.NET, ASP.NET Core, SQL Server, JavaScript, JQuery, React JS and .NET Core, Web API
• Database design and development (Microsoft SQL Server). Analyze existing SQL queries for performance improvements
Core Competencies
• A sense of ownership and pride in his/her performance and its impact on the company’s success
• Understanding of Software Development Life Cycle
• Technical Skills to work with C#,.NET, .NET Core (Windows and Linux), ASP.NET Core MVC, ASP.NET Web Forms, Win Forms, Windows Services, Service Workers, WCF/Web API, JavaScript & JQuery, React JS, Stored Procedures, HTML, CSS, IIS
• Should have sound knowledge of .NET and .NET Cores frameworks
• Should have good experience with MS SQL Server
• Job Scheduling in Windows, Linux and SQL Server
• Ability to write APIs using WCF and .NET Core
• Experience with micro services or service Oriented Architectures
• Exposure to AWS or Azure deployment
• Familiar with various design and architectural patterns
• Experienced with writing clean, readable, and easily maintainable code
• Good oral and written communication skills
• Other required soft skills to work in a team
Qualification
• Any bachelor degree
• 4+ years of Relevant experience
Other Details
• 5 days working – Monday to Friday
• Office Time – 9 30am to 6 30pm
• Work Mode – Work from office
• Preferably looking for immediate joiner

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)

- Experience in .Net Core, MVC framework, WebAPI
- Deep understanding of programming principles and OOPS concepts.
- Strong Coding Discipline
- Comprehensive knowledge on Good Practices, Coding guidelines, General Programming Paradigms
- Excellent verbal communication skills and good interpersonal skills.
- Good experience in Error handling & debugging techniques
- Strong Logical, analytical & problem solving skills
- Ability to build well maintained libraries & tools based on the business needs
- Experience in mentoring the teams and helping them
- Azure / AWS DevOps knowledge is desirable but not a must.

2. Maintain and customise existing android and iOS apps
3. Develop new products

Job Description :
*4+ years of software design and development experience.
*Programming experience building .net web applications in .net core/.net 6
*Must have strong knowledge in any Database.
*AWS and Azure experience will be an added advantage.
*The candidate must have developed a browser-based application and used web services and APIs.
*Good communication skills (both verbal and written)
*Able to prioritize and deliver project activities on time
*Good understanding of client requirements.




We’re looking for an experienced (2+ years) full stack developer to build web applications and API's, who will be responsible in handling various B2B clients, developing new API's working with business and product teams and, building data pipelines and storage systems for large amounts of data.
Your responsibilities will include:
• Build a framework for handling large volumes of data.
• Scaling API's with lowest response times.
• Onboarding client data in a B2B tech integration.
• Cross-team communication and translating into products.
• Develop and deploy new features to facilitate related procedures and tools if necessary
• Write “clean”, well-designed code
• Contribute in all phases of the development lifecycle
• Passion for best design and coding practices and a desire to develop new bold ideas.
• Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality
• Follow industry best practices
Job Skills
• Good python scripting and hands-on experience with Django framework
• Experience managing full stack, multi-language, multi-framework software development
• Back-end: Proficient in developing APIs across different platforms of web application servers. Experience in web server technologies in Django/Python is necessary.
• Database: Able to understand RDBMS schema and develop software to access data via SQL queries or DB mapper. Familiarity with SQL/NoSQL (MySQL, MongoDB) databases and their declarative query languages
• Front-End: Good understanding of front-end technologies, such as Object Oriented JavaScript, HTML5, and CSS3. Should have knowledge of Angular JS, Bootstrap, Express JS, Node JS etc.
• Understanding of MVC design patterns and other industry standard design patterns.
• Understanding fundamental design principles behind a scalable application
• Excellent analytical, problem-solving skills and programming skills
• Demonstrated ability to define and drive adoption of software development best practices, standards, processes, methodologies
• Strong communication skills, both verbal and written, and the ability to listen effectively
• Proficient understanding of code versioning tools, such as Git


You must possess good communication skills, .net and C# development skills, Server connectivity.
The person should have the capability to design solutions and can handle projects or lead projects individually if senior is not available.
A great opportunity to work grow and visit different countries waiting for you.

