Overview:Leading AI-driven Global Supply Chain Solutions Software Product Company and one of Glassdoor’s “Best Places to Work”Seeking an astute individual that has a strong technical foundation with the additional ability to be hands-on with the broader engineering team as part of the development/deployment cycle, and deep knowledge of industry best practices, with the ability to implement them working with both the platform and the product teams.Scope:Design a database and ensure its stability, reliability, and performance. Optimize in-application SQL statements as necessary and establish best practices.Resolve database usage issues and come up with ideas and advice that can help avoid such problems in the future.Our current technical environment:Software: C++, Java, Springboot, Gradle, GIT, Hibernate, Rest API, OAuthApplication Architecture: Scalable, Resilient, event-driven, secure multi-tenant Microservices architectureCloud Architecture: MS Azure (ARM templates, AKS, HD insight, Application gateway, Virtue Networks, Event Hub, Azure AD)DevOps: CI/CD, JenkinsOS: Windows, LinuxFrameworks/Others: Kubernetes, Kafka, Elasticsearch, Spark, NOSQL, RDBMS, Springboot, Gradle GIT, IgniteDatabase: Oracle, MS SQL ServerWhat you’ll do:Design, code, debug, and performs development activities in accordance with designated standards and procedures.Drive architecture and designs to become simpler, more robust, and more efficient. Deliver these promises through self-healing, reliable services that require minimum manual intervention.Provide early visibility and mitigation of technical challenges throughout the journey.Provide support for products from conception to product delivery including problem-solving, defect maintenance, and support to customer servicesWhat we are looking for: 10-13 years of experience in SqlServer and SqlServer Reporting ServicesStrong proficiency with database design, including normalization, stored procedures, triggers, primary and foreign keys, and optimizing stored procedures, indexes, tables, views, and trigger code for production applicationsGood knowledge of SQL Server Integration Services.Take ownership of performance and capacity monitoring aspects of the DBStrong experience writing Complex Queries, Subqueries, Co-related Sub query, CTE, Views, Functions, and Stored Procedures using T-SQL.Good knowledge of performance optimization of SQL proceduresSkilled at optimizing significant, complicated SQL statements and stored proceduresFamiliar with tools that can aid with profiling server resource usage and optimizing itKnowledge of best practices when dealing with relational databasesCapable of configuring popular database engines and orchestrating clusters as necessaryStrong technical expertise in Troubleshooting and Performance tuning.Exceptional ability to quickly master new concepts and applicationsOur ValuesIf you want to know the heart of a company, take a look at their values. Ours unite us. They are what drive our success – and the success of our customers. Does your heart beat like ours? Find out here: Core ValuesDiversity, Inclusion, Value & Equality (DIVE) is our strategy for fostering an inclusive environment we can be proud of. Check out Blue Yonder's inaugural Diversity Report which outlines our commitment to change, and our video celebrating the differences in all of us in the words of some of our associates from around the world.All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
View Original Job Posting