Software Engineer - MS SQL Server
We are looking for talent that wants to be a part of the transformative journey with us at Bristlecone (https://www.bristlecone.com)
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.
Software Engineer - MS SQL Server
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.
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.