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


Looking for a passionate developer and team player who wants to learn, contribute and bring
fun & energy to the team. We are a friendly startup where we provide opportunities to explore
and learn a lot of things(new technology/tools etc.,) in building quality products using
best-in-class technology.
Responsibilities
● Design and develop new features using Full-stack development
(Java/Spring/React/Angular/Mysql) for a cloud(AWS/others) and mobile product
application in SOA/microservices architecture.
● Design awesome features and continuously improve them by exploring alternatives /
technologies to make design improvements.
● Performance testing with Gatling (Scala).
● Work with CI/CD pipeline and tools (Docker, Ansible) to improve build and
deployment process.
● Working with QA to ensure the quality and timing of new release deployments.
Skills/Experience
Good coding/problem solving skills and interest in learning new things will be the key.
Time /Training will be provided to learn new technologies/tools.
● 2 or more years of professional experience in building web/mobile applications using
Java or similar technologies (C#, Ruby, Python, Elixir, NodeJS).
● Experience in Spring Framework or similar frameworks.
● Experience in any DB (SQL/noSQL)
● Any experience in front-end development using React/Vue/Angular/similar
frameworks.
● Any experience with Java/similar testing frameworks (JUnit/Mocks etc).
KEY RESPONSIBILITIES
· Develop high-quality database solutions.
· Use T-SQL to develop and implement procedures and functions.
· Review and interpret ongoing business report requirements.
· Research required data.
· Build appropriate and useful reporting deliverables.
· Analyze existing SQL queries for performance improvements.
· Suggest new queries.
· Develop procedures and scripts for data migration.
· Provide timely scheduled management reporting.
· Investigate exceptions with regard to asset movements.
MUST-HAVES FOR THIS GIG
T-SQL, Stored Procedure, Functions, Triggers, XML Operations, JSON support on SQL 2016 and above SSIS, SSRS, CTE, EAV Data structure, Integration with NoSQL(MongoDB), SQL Server Indexes, Bulk Insert, BCP, CMD Shell ,Memory Optimization, Performance Tunning, Query Optimization, Database Designing, Table Joins, SQL Server Job agent
Backup and Maintenance plan ,Data Migration, Good Communication
NICE-TO-HAVES FOR THIS GIG:
- Working knowledge of mobile development activity.
- Working knowledge of web hosting solution on IIS7.
Experience working with an offshore –onsite development process

- 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
· 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 |

Selected candidate(s) will lead technology for the company by initially working alongside an outsourced software development team and later on being responsible for current and future software development.
Opportunity to earn ESOP / equity based on experience and performance. We're looking for candidates who are hungry to learn, can apply themselves to solve problems using techology and who are looking to make a meaningful impact with their energy and work. If this sounds like you, we'd like to hear from you.
****** Apply only if you know Angular, NODEJS, EXPRESS framework ******
Skills Required:
Problem-solving Approach
Programming Data Structures
Logic & Design concepts
Object Oriented Programming concepts
Familiarity with databases
NodeJS and its framework.

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

Aviso is the AI Compass that guides Sales and Go-to-Market teams to close more deals, accelerate revenue growth, and find their True North.
We are a global company with offices in Redwood City, San Francisco, Hyderabad, and Bangalore. Our customers are innovative leaders in their market. We are proud to count Dell, Honeywell, MongoDB, Glassdoor, Splunk, FireEye, and RingCentral as our customers, helping them drive revenue, achieve goals faster, and win in bold new frontiers.
Aviso is backed by Storm Ventures, Shasta Ventures, Scale Venture Partners and leading Silicon Valley technology investors
What you will be doing:
● Aviso is in the process of building a highly scalable, and highly performant upgrade to its industry-leading AI product. This requires a complete rethink of the base architecture of how data is stored and accessed using persistent Databases like MongoDB, PostgreSQL and Redshift.
● As part of this far reaching engineering goal, This role will be primarily responsible for the design and development of said re-architecture, working with all other parts of the Engineering organization.
Details below:
○ You will be responsible for designing the most optimal data schema architecture
to handle billions of rows of information, accessible in real-time, both for the
purposes of enabling our Machine Learning team, as well as other engineering
teams presenting complex analytical functionality directly to customers.
○ You will be responsible for designing the most optimal physical database
architecture to scale reliably with business growth, while optimizing cost.
● You will be working with our platform team to create the Service Oriented Architecture needed to create a highly redundant, fail-safe and responsive end customer facing service.
○ Needed is a solid working experience and understanding of the AWS
environment, including VPC, EC2, EBS, S3, RDS, SQS, Cloud Formation, NAT
Gateways, Lambda will be needed in order to achieve this.
● You will also own the definition and implementation of enterprise grade security using their skillsets around LDAP integration, security policies, and auditing in a Linux/AWS environment
● Additionally, You will be responsible for designing the Continuous Integration and
Continuous Delivery (CI/CD) platforms to enable all of engineering to deliver code faster with better quality.
○ In this, they will be working daily with the QA and engineering teams to enable
unit tests and automation tests to increase code test coverage.
○ Using their experience and great understanding of DevOps automation -
Orchestration/Configuration Management and CI/CD tools (Puppet, Chef,
Jenkins, etc.), they will identify the right set of CI/CD tools needed to make this a
success.
What you bring:
● Minimum 10-15 year experience in database architecture and management
● A Degree in Computer Science from a top University or equivalent
● Strong and relevant experience building and maintaining a high performance, high volume SaaS solution.
● Industry leading experience in managing petabyte scale databases.
● Solid working experience and good understanding of the AWS environment, including VPC, EC2, EBS, S3, RDS, SQS, Cloud Formation, NAT Gateways, Lambda and Redshift.
● Great understanding of DevOps automation - Orchestration/Configuration Management and CI/CD tools (Puppet, Chef, Jenkins, etc.) is required.
● Experience implementing role based security, including LDAP integration, security policies, and auditing in a Linux/Hadoop/AWS environment. We expect hands on experience with monitoring tools such as AWS CloudWatch, Nagios or Datadog.
● Networking : Working knowledge of TCP/IP networking, SMTP, HTTP, load-balancers (ELB, HAProxy) and high availability architecture.
● Strong experience in continuous integration, builds automation, configuration
management, code repository, performance engineering, application monitoring, system monitoring, management and deployment automation.
● Strong knowledge of Unix systems engineering with experience in Ubuntu or Red Hat Linux.
● Programming: Experience programming with Python, Unix scripts
Aviso offers
● Dynamic, diverse, inclusive startup environment driven by transparency and velocity
● Bright, open, sunny working environment and collaborative office space
● Convenient office locations in Redwood City, Hyderabad and Bangalore tech hubs
● Competitive salaries and company equity, and a focus on developing world class talent operations
● Comprehensive health insurance available (medical) for you and your family
● Unlimited leaves with manager approval and a 3 month paid sabbatical after 3 years of service
● CEO moonshots projects with cash awards every quarter
● Upskilling and learning support including via paid conferences, online courses, and certifications
● Every month Rupees 2,500 will be credited to Sudexo meal card




