Back-end Engineer Lead - SQL & C#
C# related details:
Key Technologies: C#, NUnit, SQL, RESTful APIs
Technical Skills:
- Strong experience in C# and object-oriented programming.
- Expertise in NUnit for unit testing
- Proficient in writing unit tests, including mocking dependencies and handling edge cases.
- Good knowledge of SQL for back-end services interacting with databases.
- Solid understanding of RESTful web services and integrating them with back-end persistence stores.
- Familiarity with version control systems, such as Git.
- Ability to assess output from static code analysis tools. Proven experience recognizing code smells. Experience writing unit tests to cover complex logic and potential failure points.
- Experience with Scrum & Agile methodologies. Experience leading teams of at least five engineers. Experience with coaching and mentoring less-experienced engineers.
Interpersonal / Consultative Soft Skills
- Excellent written and verbal communication
- Proactive, self-starter mindset; ability to recognize problems as opportunities
- Proven record of accomplishment of turning strategy into action (bias for action)
- Capable of juggling multiple, competing priorities
- Expertise with audience adaptation, adjusting technical jargon to the audience
Role & Responsibilities:
- Identifying bugs in back-end services and APIs using C#.
- Write thorough unit tests using NUnit to ensure code quality and reliability.
- Implement and enforce testing best practices, including the use of mocks and stubs to isolate code for testing.
- Assess the existing codebase to identify high-risk areas and ensure adequate test coverage for critical business logic.
- Collaborate with cross-functional teams to define, design, and ship new features.
- Ensure that code is robust, scalable, and integrates smoothly with SQL databases and SOAP web services.
- Troubleshoot and debug issues in production environments, ensuring minimal disruption to service delivery.
Contribute to continuous integration and deployment pipelines, ensuring that all unit tests are executed automatically.
SQL related description:
Key Technologies: SQL, tSQLt, Stored Procedures, Triggers
Skills:
- Proficient in SQL and relational database management systems (RDBMS).
- Strong experience in writing and maintaining stored procedures, triggers, and complex SQL queries.
- Expertise in unit testing database code using tSQLt, with a focus on high test coverage for stored procedures and triggers.
- Familiarity with database design, normalization, indexing, and query optimization.
- Experience in debugging and optimizing SQL code to ensure high performance.
- Knowledge of version control systems and integrating database tests into continuous integration pipelines.
Role & Responsibilities:
- Design, implement, and maintain SQL databases with a focus on stored procedures, triggers, and complex business logic.
- Write and maintain unit tests for database code using tSQLt, ensuring high coverage for stored procedures and triggers.
- Collaborate with application developers to ensure efficient interaction between the application and the database layer.
- Assess existing database code to identify high-risk areas and implement unit tests to mitigate risks and improve stability.
- Optimize database performance by tuning stored procedures, triggers, and SQL queries.
- Troubleshoot and resolve database-related issues, ensuring data integrity and high availability.
- Implement and maintain CI/CD pipelines for database changes, integrating tSQLt tests into the workflow to support continuous testing and deployment.
- Experience with Scrum & Agile methodologies. Experience leading teams of at least five engineers. Experience with coaching and mentoring less-experienced engineers.
Nice to Have:
- Experience with BDD
- Familiarity with the testing pyramid
