Job Title:
Software Engineer - MS SQL Server

Job Description:
We are looking for talent that wants to be a part of the transformative journey with us at Bristlecone (https://www.bristlecone.com)

ABOUT US:
Bristlecone is the leading provider of AI-powered application transformation services for the connected supply chain. We empower our customers with speed, visibility, automation, and resiliency – to thrive on change.

Our transformative solutions in Digital Logistics, Cognitive Manufacturing, Autonomous Planning, Smart Procurement and Digitalization are positioned around key industry pillars and delivered through a comprehensive portfolio of services spanning digital strategy, design and build, and implementation across a range of technology platforms.

Bristlecone is ranked among the top ten leaders in supply chain services by Gartner. We are headquartered in San Jose, California, with locations across North America, Europe and Asia, and over 2,500 consultants. Bristlecone is part of the $19.4 billion Mahindra Group.

ROLE: Software Engineer - MS SQL Server

ROLE DESCRIPTION

Designing database tables and structures.

Good understanding of SQL Server and TSQL programming.

Good knowledge in creating views, functions and stored procedures.

Writing optimized SQL queries for integration with other applications.

Good knowledge about performance tuning concepts.

Good in logical thinking when solving complex business challenges.

Basic knowledge about SQL Administration like DB backup, restore, rebuild index, SQL job creation etc.

Good to have SSIS experience.

Good Knowledge under solving the DB Security like SQL Injection attacks.

Knowledge on Python scripting, PostGreSQL would be an added advantage.

Writing TSQL Code Static and Dynamic Stored Procedures with XML Datatype is must.

Help to write and optimize in application SQL statements.

Ensure performance, security, and availability of databases.

Experience with some of the modern relational databases

Capable of troubleshooting common database issues

Proficient understanding of code versioning tools such as Git

Familiar with tools that can aid with profiling server resource usage and optimizing it.

Provide statistical analysis to develop, test, and optimize databases to their full potential.

Collaborate with app architects leads for data modelling.

Debugging existing applications written in SQL, do bug fix, enhancement.

Analyze SQL queries for stability, reliability, and performance.

Conduct training programs and knowledge transfer sessions to junior developers when needed.

Recommend improvements to provide optimum reporting solutions.

Support ongoing strategic projects, account targeting, and delivery workstreams with customer data insights.

Strong analytical, technical skills to be able to address complex issues.

Able to review defects on a regular basis and perform root cause analysis.

Conducts data delivery unit tests and code reviews.

Basic knowledge on AWS concepts RDS databases, S3 Bucket added advantage.

SOFT SKILLS

Excellent communication skills, verbal as well as written

Positive attitude with flexibility and maturity to work in a challenging client environment

Ability to drive project responsibilities in a dynamic and proactive manner

Ability to showcase three Mahindra RISE Pillars e.g. Accepting No Limits, Driving Positive Change and Alternative Thinking

EQUAL OPPORTUNITY EMPLOYER

Bristlecone is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

Information Security Responsibilities:

• Understand and adhere to Information Security policies, guidelines and procedure, practice them for protection of organizational data and Information System.
• Take part in information security training and act while handling information.
• Report all suspected security and policy breach to Infosec team or appropriate authority(CISO).
• Understand and adhere to the additional information security responsibilities as part of the assigned job role.