Senior Software Engineer

Senior Backend Developer, Database & Systems Optimization

Job Summary:

We are seeking a highly skilled Senior Backend Developer with strong database and performance tuning skills to join our engineering team. The ideal candidate will have a strong focus on optimizing database performance and troubleshooting complex issues in large-scale, hosted systems. This role is crucial for ensuring the stability, efficiency, and scalability of our software. You will be a key contributor, applying your skills in both development and deep analysis to maintain and improve our solutions.

What you'll be doing:

As a Senior Backend Developer, you will be responsible for the performance and stability of our enterprise solution. Your primary role will be to dive deep into our database architecture and distributed systems to identify, analyze, and resolve performance bottlenecks, while also contributing to ongoing feature development.

Key Responsibilities:

• Database Performance Tuning: Proactively identify and optimize slow-performing queries, fine-tune query plans, and implement advanced indexing strategies to ensure efficient data retrieval.
• Database Architecture: Design, implement, and manage effective database partitioning strategies to support large data volumes and ensure scalability.
• Resource Management: Configure, monitor, and adjust resource governor settings to maintain system stability and prevent resource contention in multi-tenant hosted environments.
• System Diagnostics: Set up and utilize extended event monitoring and other diagnostic tools to gain deep insights into database and system behavior.
• Advanced Troubleshooting: Investigate and resolve complex I/O, latch, and other resource contention issues that impact service performance and availability.
• Problem Resolution: Act as a subject matter expert for triaging and resolving critical customer-facing issues in our distributed systems, providing timely and effective solutions.
• Solution Development: Develop robust, scalable, and maintainable code in C# to address identified issues and enhance system capabilities.
• Collaboration and Mentorship: Serve as a technical resource for other engineers, sharing your expertise in database optimization and complex troubleshooting.

What you'll bring:

• A Bachelor's degree in Computer Science, a related field, or equivalent professional experience.
• A minimum of 5 years of hands-on experience with Microsoft SQL Server, with a proven track record of advanced performance tuning and optimization in a production environment.
• At least 2 years of professional software development experience in an object-oriented language, preferably C#.
• Expert-level knowledge of database internals, including partitioning, resource governance, and extended events.
• Demonstrable experience in diagnosing and resolving I/O and latch contention issues.
• Strong analytical and problem-solving skills for troubleshooting in complex, distributed systems.
• Excellent communication and collaboration skills, with the ability to articulate complex technical concepts clearly.
• A strong drive for continuous learning and improvement.

What will make you stand out:

• Experience with Windows Server administration and performance monitoring tools.
• Proficiency in PowerShell scripting for automation and administration.
• A strong foundation in DBA best practices for hosted environments.
• Familiarity with virtualization technologies (e.g., VMware, Hyper-V).
• Prior experience in a similar role supporting enterprise software for a global organization.