This job has expired.
Sparkfish
Expired

Developer - C# and SQL Server

$55 - $65/hourRemote (On-site)

Location restricted
This job is restricted to tax residents of , but we detected your IP as outside of the country. Please only apply if you are a tax resident.

We are looking for someone who enjoys being involved in multiple layers of the application stack. If you had to choose, you’d rather be coding. But ... your experience has led you to realize that SQL Server performance and maintenance is key. So, you’ve mastered what you need to know to keep the SQL side of things humming along.

We’re seeking a hands-on, dedicated C# and SQL developer who is driven to push their technical skills and knowledge; someone who is not looking for a typical desk job. The closer you are to being a full-stack developer, the better. We also need you to have cloud platform experience, preferably with Azure. We don't expect that you are the master of all things Azure, SQL or C#; however, we need you to have the desire and confidence to figure it out, mostly by your lonesome.

We work with different clients who serve a variety of industries, so one month you might be helping to migrate a company’s systems to the cloud, the next month you might be developing a data warehouse, and still the next month you may be developing a web application. There is a ton of opportunity for a variety of innovative projects!

We're a small company, but we've landed gigs serving some big brands. In general, our company is on two tracks. We run a consulting company that helps other companies solve their problems, whatever those might be. And, we are building a war chest to self-fund a series of startups. If you like a startup environment, then this might be a good fit.

Please send your resume and ask questions. Feedback will be provided within a day or two.
Benefits

  • Work from anywhere in the US, with additional perks for those in Dallas
  • Flexible paid vacation, nice health benefit packages
  • High-powered development laptops, large external monitors, standup desks
  • Work with other really good people

Skills Needed

  • Strong C# proficiency and moderate-to-advanced SQL skills
  • Experience managing SQL Servers (backups, restores, performance tuning, SQL agent jobs)
  • Experience with an exercise from an online class on MongoDB that you didn’t quite complete
  • Experience deploying code to at least one cloud provider, preferably with Azure
  • Experience working with and developing a REST API architecture
  • Some level of “full-stack” experience including JS, CSS, HTML (with the emphasis on JS)
  • Source control, git, GitHub, Azure DevOps
  • Exposure to unit testing, test-driven development
  • Knowledge of development using Agile and Kanban methodologies
  • Ability to read peoples’ emotions (aka Emotional IQ, if you want to get fancy)

Keywords: dotnet core, node.js, azure, git, github, visual studio, rest api, web api, mongodb, sql, sql toolbelt, trello, slack, dapper
Requirements
Must be a good person. Humble, yet confident in your abilities, and able to work through both merge conflicts and people conflicts.)

Interview Questions
Answer as many of these as you like and post them in a gist on Github to share your responses with me to review … this really saves everyone a LOT of time:

  • What are examples of the types of projects you have deployed to Azure?
  • How do you classify your senior-ness as a developer? What are your development strengths?
  • Have you ever had a chance to use TDD? Have you found it to be helpful? If so, when does it work best for you?
  • Have you been given the opportunity to use tools like ReSharper? What did you like about it?
  • What about Red Gate's SQL Toolbelt or similar? If you’ve been given the opportunity to use it, did you find it valuable?
  • Can you explain what DevOps and/or continuous integration is, and some of the benefits?
  • Are you technology agnostic? Or are you pretty strict when it comes to things like Mac vs Windows, or AWS vs Azure?
  • What sort of administration tasks have you performed on SQL Server? What versions were you managing?
  • What are some of the differences you have found between Azure SQL and a traditional installation of SQL Server?
  • After you’ve added the obvious indexes to a table, what tools do you think of using to try to sort out why a query is not running as fast as you think it should?
  • [ADVANCED] If you’ve had a chance to be exposed to CTEs, how would you describe situations where they can be handy?
  • [ADVANCED] So, SQL “window functions” are pretty much on the advanced side of SQL writing, so don’t freak out if you’ve never heard or used them before. Can you attempt to explain a scenario when window functions can be used to solve a problem?
  • How much duress would be needed to pressure you to write a PowerShell script? (I ask because I personally refuse to write in PS, but sometimes it apparently is needed when managing a SQL Server.)
  • What’s the big idea with NoSQL? When is it a good idea to use that versus a traditional RDBMS?
  • You may have heard of ACID (or perhaps just “transactions”). But can you explain what BASE sorta kinda means? It’s a nerdy topic with its own theorem, so feel free to look this up and explain it in your own words.
  • Have you ever had a chance to use SQLite? What are some of the advantages over SQL Server? Or, maybe when is this a bad idea?
  • Python has gained a lot of ground due to the surge in data science. But, we are also finding it useful for easier-to-manage admin scripts and ETL processes compared to the horrid affair that is SSIS. Are you now or will you ever have interest in becoming a pythonista?
  • What problems does MongoDB solve as compared to SQL Server? If you are building out an API back-end, which of these 2 approaches offers a simpler coding path to interact with the DB?
  • Pick from one of these NP-hard questions and give your best-guess response: (A) How do you tell a customer they are wrong without offending them? Or (B) You just went 100 hours over budget ... How do you recover the relationship with your customer (and your boss)?
  • Do you have any interest in being exposed to data science projects? Statistically speaking, 95% of respondents say yes to this question, so if you are going to say yes, maybe tell me what interests you in this topic.
  • How comfortable are you in working on a project that involves touching some CSS and HTML?
  • Can you explain GPG, SSL or public/private key encryption?
  • Have you had the occasion to undergo any training on "secure coding" practices?
  • How enthusiastic would you be if we asked to pay you to take some training courses on Udemy?
  • Which of these platforms / languages / concepts / frameworks do you have experience with (so far)?

Node Typescript Angular React Vue Spark Hadoop SQL Excel Python Pandas R Linux Mac Windows Jasmine Docker Kubernetes .NET C# NUnit Go PostgreSQL MySQL SQL Server SQLite bash PowerShell MongoDB Azure AWS Google Cloud Platform SQLCLR SQL Cursors CTEs SQL Window Functions Table Valued Parameters Ola Hallengren SSIS SSRS Power BI ETL Encryption AutoMapper SQLite

Job Types: Full-time, Contract

Pay: $55.00 - $65.00 per hour

Schedule:

  • 8 hour shift

Other C# contracts

Remote
0
USD
/hr

0 outside IR35 C# contracts