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.
● 4 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).



- Strong experience in PHP with deep understanding of Codeigniter, Laravel & other frameworks
- Working experience with SQL, table design, and entity relationships.
- Familiarity with relational databases mySQL or MS SQL Server
- Deep knowledge of how the web works (Servers, Sockets, HTTP, Rest API).
- Up-to-date knowledge of modern HTML5, CSS3/4, Bootstrap, JavaScript, JQueries.
- Developing APIs and RESTful services
- Version control systems like Git and GitHub ·
- Proficient in data structures and algorithms.
- Helping with the design and development of software
- Testing and debugging software to keep it optimized
- Writing clean code for the front and back end of the software
- Creating servers and databases for the back end of the software
- Ensuring cross-platform compatibility and optimization
- Testing and maintaining the responsive design of applications
Job Types: Full-time, Regular / Permanent
Salary: ₹40,000 - ₹80,000 per month
Schedule:
- Day shift
- Visakhapatnam, Andhra Pradesh: Reliably commute or planning to relocate before starting work (Required)
- Bachelor's (Preferred)
- PHP: 4 year (Preferred)
- total work: 4+ year (Preferred)
- software development: 4+ year (Preferred)
- PHP (Preferred)

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.

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

- Provide development and maintenance services for .NET application.
- Develop and implement best practices for .NET programming.
- Review codes and provide recommendations for improvements.
- Identify the key problems and develop a solution within business and technical context.
- Design, develop, test, review and document .NET application programs.
- Evaluate user requests to determine budget, time, feasibility and compatibility of the new or modified program.
- Analyze technical architecture and provide recommendations.
- Coordinate with users to analyze and propose application solutions to meet business needs.
- Participate in all stages of the software development life cycle including coding, designing and documentation.
- Develop support processes to integrate .NET applications into in-house and third party applications.
- Prepare and maintain system-level, program-level and user-level documentations.
- Act as a technical lead for development and integration of .NET applications.


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

Developing complex object oriented web/windows applications on the Microsoft platform using .Net technologies
Frontend Technologies: AngularJs, JQuery
Database Skills: Good knowledge in MS SQL programming skills,
Independent contributor with experience in developing high quality software within the timelines
Works collaboratively and professionally with other associates in cross functional teams to achieve goals
Apply a sense of urgency, commitment and focus on the right priorities in developing solutions in a timely fashion




