Role: Software Design Engineer 1
Duration: 12 months Contract with possible extension
Location: Redmond, WA - Prefers candidates that can come into the office a few days a week, but is open to fully remote candidates as well (PST only)
This contractor will be a part of the MS SQL performance team working on on-prem and AzureSQL software, focused on ensuring performance is optimal and competitive.
They should be familiar with data structures and understand what makes a program optimal and performance oriented (they will not write code but should be able to understand the code and know which questions to ask to determine how it works).
The contractor should be very familiar with databases. They should understand structured query language (SQL), tables, indexes, kinds of logic, locks & spinlocks, etc. Some experience with hardware and processors is needed, the contractor will do low level testing and benchmarking for machines that will be added to Azure to ensure they work as intended.
The contractor doesn't need to know any specific coding language, but should have a strong understanding of coding logic and ideally be comfortable writing in at least one of the following: C#, Bash, C, C++, PowerShell, Python, etc. They should be able to read a function, understand what is does, and know how to change the function. This role will involve implementing automation in PowerShell.
The best candidate has great problem solving, communication, and presentation skills and is able to explain what they've found while testing. They should be vocal about what they understand and what they don't understand, and are willing to ask questions to learn more. The second-round interview will focus on their technical knowledge of SQL servers and tuning them.
Candidates should be prepared to expand on what is included in their resumes and rate their ability with the programming languages listed on their resume. The sponsor's team will ask candidates about their coding experience, to explain different data types, if they understand database-related info such as concurrency and which kinds of locking are best for certain scenarios, and ensure they know how their code works instead of just being able to write code.
Develops/executes performance tools and scripts. Collect and report the performance data to the performance team and other stakeholders. Analyze automated performance tool results and report results to the performance team. Be familiar with physical computer technologies and configuration as well as cloud-based technologies. Will work under the supervision of more senior Performance Engineers. General knowledge of personal and server-class computers, applications software, and operating systems required. Knowledge of PowerShell and other scripting languages a must. Database skills are highly desirable. Demonstrated investigative and problem-solving skills required. Familiarity with product lifecycle preferred. Must have the ability to use, at a basic level, word processing and spreadsheet applications. Must have the ability to learn new information quickly. A bachelor’s degree in computer science (Master’s a plus) is required.
Looking for candidates interested in pursuing a Software Database Engineer role in the future, as this role is essentially for a very junior SDE candidate that is willing to be trained on the job
The team covers a broad scope, producing daily builds of SQL server products – the role requires taking those builds through performance tests, measuring regressions, etc., then presenting findings in meetings (meetings may be held once a week or daily depending on project)
Hardware testing for azure – testing before putting into fleet, tuning back-end systems, and working closely with processing manufacturers
Azure environment testing – running new storage systems through its paces to find data and test the code base, hardware, and services
Develop automation processes for further performance testing and analysis on hardware, Azure, and SQL
Weekly calls with development teams – the candidate in this role may present during these meetings as well
The candidate will not be going through SQL source code individually, they will be identifying which module flagged an error and then developers will fix the source code
Task Breakdown:
- 20% meetings, (daily sync, several 1-1 trainings/discussions)
- 50% running tests
- Remainder is spent automating processes
Degrees/Certifications: Bachelor’s degree in computer science (master’s degree preferred)
1. SQL proficiency – knowledgeable about basic server and database interactions (the more they know about SQL databases the better) | 2+ years of experience
2. Strong understanding of coding logic - ideally be comfortable writing in at least one of the following: C#, Bash, C, C++, PowerShell, Python, etc | 2+ years of experience
3. Basic excel & PowerPoint skills | 2+ years of experience
Compensation:
This is the base hourly pay range that Aditi Consulting reasonably expects to pay someone for this position $36- $38/hr. (compensation may vary outside of this range depending on a number of factors, including but not limited to, a candidate’s qualifications, skills, competencies, experience, location and end client requirements).
Benefits and Ancillaries:
Medical, dental, vision, PTO benefits and ancillaries may be available for eligible Aditi Consulting employees and vary based on the plan options selected by the employee.
Email me for quick response: shinilv@aditiconsulting.com
"Aditi Consulting LLC uses AI technology to engage candidates during the sourcing process. AI technology is used to gather data only and does not replace human-based decision making in employment decisions"