
SQL Developer + DWH
at US management consulting firm headquartered in Evanston,

Similar jobs
We are looking for a skilled and motivated developer to build software using languages and technologies of the .NET framework. You will create applications from scratch, configure existing systems and provide user support.
In this role, you should be able to write functional code with a sharp eye for spotting defects. You should be a team player and excellent communicator. If you are also passionate about the .NET framework and software design/architecture, we’d like to meet you.
Experienced in C# programming language, .Net, and .Net MVC
At least 5 years of experience in developing modern web applications
Experienced in Web Services, Web API, REST and SOAP architectures
Experienced in ORM
Acquainted with Version Control Systems as (Git)
Experienced in HTML5, CSS3, Bootstrap, Javascript, Jquery, JSON, AngularJS and prevalent in Responsive Web Design
Knowledge of Relational Databases (MsSQL)
Can create qualified, testable and well-documented code
Good communication skills in English
Knowledge of JavaScript MV-VM/MVC frameworks including Angular/React.
.NET, ASP.NET Core MVC, Entity Framework, ASP.NET Web API, JSON, JQuery,
At Monarch, we’re leading the digital transformation of farming. Monarch Tractor augments both muscle and mind with fully loaded hardware, software, and service machinery that will spur future generations of farming technologies.
With our farmer-first mentality, we are building a smart tractor that will enhance (not replace) the existing farm ecosystem, alleviate labor availability, and cost issues, and provide an avenue for competitive organic and beyond farming by providing mechanical solutions to replace harmful chemical solutions. Despite all the cutting-edge technology we will incorporate, our tractor will still plow, till, and haul better than any other tractor in its class. We have all the necessary ingredients to develop, build and scale the Monarch Tractor and digitally transform farming around the world. For more details visit
www.monarchtractor.com
Monarch Tractor Electric Tractor
Monarch Tractor is the maker of the world’s first fully electric, driver-optional tractor making sustainable farming economically superior.
www.monarchtractor.com
Requirements and skills:
· 3+ Years of software development experience
· Strong in data structures and algorithms
· Solid understanding of Linux development environment and systems
· Expert level knowledge of Python along with frameworks some application framework
· Prior experience with WebRTC and video streaming protocols like RTMP, RTP and payloads
· Prior experience of h264, h265, vp8, vp9 and av1 encoders and decoders
· Prior experience with GStreamer pipelines
· Knowledge of C++ and proxy servers such as NGNIX is an added advantage
· Proficient in writing unit test cases using the Pytest framework.
· Expert level knowledge of SQL databases like MySQL
· Understanding of microservices architecture
· Knowledge of AWS cloud services like EC2, S3, Lambda etc.
Experience in Frameworks: Laravel
Must have good analytical and problem solving skills.
Good Knowledge of OOPS, PHP, MVC frameworks.
Write error free code and follow coding standards. Able to perform Code Review job.
Work closely with QA person to assist in the testing process.
Perform R&D tasks if assigned and communicate with the Designer and UI team.
Build reusable code and libraries for future use.
Able to work closely with the team and meet the tight deadlines where necessary.
Strong Communication Skills.
Summary/Objective:
We are looking for high performing developers who will get to develop an awesome product which the end user must love and trust. You will be responsible for building, scaling and maintaining the multiple modules, encompassing - external integration, API management, building business and operation processes, designing and defining micro services, designing multi-input/output state machines. You will work closely with business, product and UI teams and build products that would maximise business impact and customer delight. We are looking for people who love to challenge and contribute to new way of thinking. We value entrepreneurship skills, rolling up sleeves, resolving issues and raising up the bar. We love people who are excellent with delivery and execution and have a design thinking approach. You should be comfortable learning in a fast-paced environment and applying it at work. A quick overview of our stack:Python, MySQL, NoSQL, Memcache, Bigquery Microservices Responsibilities
• Write clear and effective API documentation.
• Write codes to integrate applications being used by various stakeholders
• Write and review test cases to QA pass your own code.
• Write/review test cases for code and process coverage
• Review code for both oneself and team members
• Reviewing designs, code, and processes from a system security standpoint
• Defining and building micro-services
• Building systems with positive business impact
• Tracking module health, usage, behaviour tracking, measure and improve code and processes Requirements
• An engineer with at least 1-7 years of working experience in web services, preferably in Python
• Must have penchant for good API design.
• Must be a Stickler for good clear and secure coding
• Must have built and released APIs in production
• Experience in working with RDBMS and No SQL databases
• Must have designed thoughtful, extensible data models
• Knowledge of identifying, defining and building micro-services
• Working knowledge of GCS, AWS, Azure or any other cloud provider
• Aggressive problem diagnosis and creative problem-solving skills
• Communication skills, to speak to developers across the world. Good To Have
• Focus on constant improvement of developer experience
• Building or Working knowledge of CI/CD
• Basic know-how of front-end technologies like AngularJS/React
• Have worked on additional languages like Javascript/Ruby
Thanks
The ideal candidate would be a person having a strong technical know-how of Drupal application development & CMS concepts, backed with an equally strong hands-on experience. He / She should be fluent with the design concepts using Drupal 8 and above(Must) as well as be well versed with the best practices in the development, testing & deployment phases.
Experience : 5 – 9 years
Contract duration : 6 months
Major Accountability
• Demonstrate expertise in authoring & customizing Drupal modules as well as have experience in working with views, panels and features.
• Carry-out impact analysis & estimation for given set of requirements.
• Develop code by adhering to the Drupal, security and accessibility standards.
• Act as liaison with the client for troubleshooting: investigate, analyze, and solve software problems.
• Work self-directed and independently.
Essential Skills & Experience
• Have overall 4-8 years of IT experience on Drupal 8 platforms.
• Have expertise in developing complex websites based on Drupal 8 platforms and framework-based web applications.
• Have expertise in LAMP environment.
• Have working knowledge of web servers like Apache, Nginx etc.
• Have strong experience with source/version control systems.
• Have excellent communication, analytical & presentation skills.
Education
• Minimum education: B.E., BTech, MCA
• Languages: English written & spoken
- LAMP Stack
- Laravel Framework
- HTML Framework
- Bootstrap
- Javascript Framework
- Ionic Framework - Capacitor for making hybrid mobile app
- E-Commerce frameworks
- SQL
- Payment Gateway
Skills:
- Familiarity with PHP and popular CMSs such as WordPress, Joomla
- Good working knowledge of Database concepts
- High-quality & optimized code
- Strong knowledge of JSON & the REST API is an added advantage
Requirements:
- Minimum 1 to 3 years of experience
- Good communication
- Willingness to learn new technology
- Analytical skills
- Team player
- Quick & Independent-learner
- Problem-solving skills
You will get to design, architect and develop complex enterprise software and SaaS web applications leveraging modern web stack.
Roles & Responsibilities
Design & build highly scalable, high performance, responsive web applications.
Take full ownership and responsibility for building, shipping, and maintaining core product features, end to end. Help out in building the backend & front-end infrastructure.
Translation of requirements, designs and wireframes into high quality code. Collaborate closely with designers, engineers, founders and product managers.
Mentor team members and review their work.
You will enjoy this role if you...
Are a geek with a desire to stay ahead of the curve.
Like building beautiful well-architected software products with millions of users.
Work collaboratively as part of a close-knit team of geeks, architects and leads.
Desired Skills & Experience:
2 - 6 years of production experience with modern web frameworks - Ruby on Rails, Phoenix/Elixir and/or Django/Python.
Should have sound experience in developing scalable / distributed SaaS apps
Should have good knowledge and work experience in REST API implementations, JSON format handling, caching, sessions, multi-threading, etc.
Should be comfortable with database schema design and leveraging SQL & NoSQL (PostgreSQL, MySQL, Redis, Elasticsearch, DynamoDB)
Experience developing, consuming and transforming internal and 3rd party API's (REST and GraphQL)
Experience with code quality and reusability practices (CI/CD for back-end & front-end repos)
Solid foundation in data structures, algorithms, distributed systems, design patterns.
Strong understanding of software engineering best practices, including unit testing, code reviews, design documentation, debugging, troubleshooting, and agile development
Communication: You like discussing a plan upfront, welcome collaboration, and are an excellent verbal and written communicator.
Bachelor’s degree in Computer Science or equivalent experience.
Bonus points if you have...
Exposure to front-end technologies like React/Redux, Javascript/Typescript etc.
Cloud native development on AWS or GCP
Experience with implementation of container technologies like Docker, Kubernetes. Knowledge of continuous integration, continuous delivery and enterprise DevOps concepts.
(NOTE-we are lookking for those ho can join immediatley or within 15-20days of notice period)
Job Description:
Passionate about making an impact, have a high level of energy and resilient when met with challenges. In addition, you will possess the below:
• Owns, implements and delivers key modules, and when necessary develops quick working prototypes
• Ensures that code developed is easy to test, easy to understand, extensible
• Ensures unit tests, integration tests are written for all modules implemented
• Ensures on time, quality delivery
• Does component /module/ sub- system design with Micro services
• Good to know NoSQL database, MongoDB
• Store user identities and authenticating requests using JWT
• Experience in deploying application to the cloud with Docker, docker compose and Kubernetes
• Good exposure in handling commands, events, handlers and other design patterns
• Delve into unit- and integration-testing the distributed system
• Experience in developing mobile apps (Android and iOS)
• CI/CD pipeline experience (Jenkins, CircleCI, or other)
• Supports in project estimation, planning
• Performs the role of a Specialist by ensuring the consistency and efficient integration of the separate modules of software that meets the product specification.
• Manages technical communication with partners and stakeholders
• Up-to-date with the latest trends, techniques, and technologies in cloud computing
• Strong team player
• Agile development, Scrum, Scaled Agile Framework (SAFe)
• Ability to engage with multi-site teams in a multi BU environment
• Excellent abstraction and analytical skills
• Excellent communication and documentation skills
• Ability to stay focused on the target in an ambiguous situation.
• Proactive and self-driven
Key Requirements:
• 8+ years professional experience in commercial or web-scale system software development and delivery Strong analytical skills
• 5+ years Experience in building micro services using .NET core, MVC core, JavaScript, XML
• Awareness – Python, Django, PHP, Angular, CSS
• 2+ year hands-on Azure experience.
• Experience in handling messages through distributed system
• Date store - SQL Server, MySQL, PostgreSQL, Redis etc
• In-depth hands on technology experience in the following areas:
o Strong in Object Oriented Programming concepts
o Experience in developing software using C# .NET, Cloud (Azure), SQL Server, CI/CD pipeline
o Experience in Test driven development using NUnit, mocking framework
o Database - SQL server, ORM and PostgreSQL, Redis
o Mobile application development and architecture aware
o Client/server - Networking, multithreading
o Deployment - Docker, Kubernetes
o Understanding of Cloud concepts, cloud deployments
o In depth understanding of ASP.net, MVC, IIS, security, Web API
o Working knowledge of Azure
o Exposure to Agile Scrum way of working, pair programming
o .NET Core, Web API, WPF, MVVM
o REST, JSON, JSON Schema
o Client / server, networking,
o Internet services, Windows Services, Security
o Any unit test framework (Nunit,MSTest), Mocking Framework (Moq,RhinoMock), TDD, Git , Jira
• 5+ years experience in Architecting solutions in software industry
• Experience architecting large scale web applications/products is a MUST
• Experience with technologies like .Net technologies, ASP.net Core, PHP, Angular, MySQL, Node.js, Python, Django, PostgreSQL & other new- edge technologies
• Experience with architecting, developing, and deploying on Azure Cloud platform is a must
• SaaS experience preferred in-depth working experience
• Must have experience in scalability, reliability, performance optimization, developing and deploying API based applications.
• In depth knowledge in DB Schema Design, Data Structures and trade- offs involved in writing queries
• Vast experience in integrating with external APIs and SDKs
Education
Bachelor or Masters Education in electronics, computer, software engineering or other relevant discipline.
The Database Developer will perform day-to-day database management, maintenance and troubleshooting by providing Tier 1 and Tier 2 support for diverse platforms including, but not limited to, MS SQL, Azure SQL, MySQL,
PostgreSQL and Amazon Redshift.
They are responsible for maintaining functional/technical support documentation
and operational documentation as well as reporting on performance metrics associated with job activity and platform
stability.
Must adhere to SLAs pertaining to data movement and provide evidence and supporting documentation for incidents that violate those SLAs.
Other responsibilities include API development and integrations via Azure
Functions, C# or Python.
Essential Duties and Responsibilities
• Advanced problem-solving skills
• Excellent communication skills
• Advanced T-SQL scripting skills
• Query optimization and performance tuning familiarity with traces, execution plans and server
logs
• SSIS package development and support
• PowerShell scripting
• Report visualization via SSRS, Power BI and/or Jupityr Nootbook
• Maintain functional/technical support documentation
• Maintain operational documentation specific to automated jobs and job steps
• Develop, implement and support user defined stored procedures, functions and (indexed) views
• Monitor database activities and provide Tier 1 and Tier 2 production support
• Provide functional and technical support to ensure performance, operation and stability of
database systems
• Manage data ingress and egress
• Track issue and/or project deliverables in Jira
• Assist in RDBMS patching, upgrades and enhancements
• Prepare database reports for managers as needed
• API integrations and development
Background/Experience
• Bachelor or advanced degree in computer science
• Microsoft SQL Server 2016 or higher
• Working knowledge of MySQL, PostgreSQL and/or Amazon Redshift
• C# and/or Python
Supervisory/Budget Responsibility
• No Supervisory Responsibility/No Budget Responsibility
Level of Authority to Make Decisions
The Database Developers expedite issue resolution pursuant to the functional/technical documentation available.
Issue escalation is at their discretion and should result in additional functional/technical documentation for future
reference.
However, individual problem solving, decision making and performance tuning will constitute 75% of their time.
Our client is a decade-old software development company, that offers its clients a wide range of customized web, mobile, and eCommerce tools and software. They are known to use advanced languages and platforms used to build reliable, secure, and scalable solutions for their business clients as well as individual customers. Their disruptive craftsmanship and strategy help in high-performance growth and allows customers to transform digitally and competitively.
Their products are being used by most of the banks and NBFCs in India, apart from clients from other industries. The founder is an IIM and MDI alumni and has experience of more than 13 years in business and strategic roles in MNCs. The company has been accredited by the government as a premier IT company, committed to quality and driven by customer success.
- Understanding and implementing security and data protection
- Managing both front-end and back-end web development requirements from a consumer.
- Taking full responsibility for task/ project execution
- Handling Payment Gateway integration and ecommerce development concepts
- Prioritizing own work and respect deadlines
What you need to have:
- Excellent skills in PHP Laravel
- Strong object-oriented programming skills
- General knowledge of both front-end and back-end web development from a consumer.
- Databases (more than one is desirable) MySQL, PostGRE, MongoDB
- Experience in Payment Gateway integration and ecommerce development concepts
- Should know about child theme and its structure.
- Proficient in CSS3/ HTML5
- Should know about source version control like git or svn etc.
- Familiar with AWS & Linux command line will be added advantage.
- Must be a team player with good communications
- Ability to solve problems quickly and efficiently
- Great aptitude and attitude towards learning
- Ability to prioritize own work and respect deadlines






![[x]cube LABS](/_next/image?url=https%3A%2F%2Fcdnv2.cutshort.io%2Fcompany-static%2F639877aa0ad87e002533a1c5%2Fuser_uploaded_data%2Flogos%2Fx_whiteB_eeCk0gqs.png&w=256&q=75)

