Job Summary:
A skilled Database Engineer is required to help scale and optimize our data infrastructure.
Key Responsibilities:
* Maintain, optimise, and scale SQL Server databases to support high-performance transactional applications.
* Write, debug, and fine-tune complex stored procedures, functions, and queries.
* Work closely with .NET developers to optimise database interactions and improve system efficiency.
* Implement indexing strategies, deadlock investigations, and suggest and design database improvements around partitioning, sharding and high availability.
* Improve database security, backup strategies, and monitoring solutions.
Requirements:
* 3+ years of experience managing and optimising SQL Server databases.
* Degree in Software Engineering, Computer Science or related discipline.
* Strong skills in query optimisation, indexing, and performance tuning.
* Experience writing and maintaining stored procedures, triggers, and views using TSQL.
* Experience with C#/.NET Core for database-driven applications.
* Familiarity with ASP.NET, MVC, and RESTful web services.
* Knowledge of database security best practices and disaster recovery strategies.
* Ability to contribute to scalable database design as the company grows.
Desirable Qualifications:
* Experience working with large-scale datasets or high-transaction environments.
* Familiarity with cloud-based databases (Azure SQL, AWS RDS, etc.).
* Experience with both OLTP and OLAP databases.
* Experience with NoSQL databases, for instance, COSMOS.
* Exposure to JavaScript frameworks (jQuery, React, etc.).
* Experience working in Agile environments.
* Knowledge of DevOps processes and tools.
* Experience with automated unit and acceptance testing.