Database Engineer New - Galway
Database Engineer
Job Description:
We’re looking for a Database Engineer with expertise in SQL Server and exposure to .NET development environments to help us scale and optimize our data infrastructure. You'll play a key role in improving database performance, writing efficient stored procedures (TSQL), and collaborating with developers to ensure our applications run smoothly.Moreover, you will provide support and expertise to enhance and improve the data infrastructure to support growth of the application.
The role also offers the opportunity to contribute to cloud-based web application development, particularly database-driven applications using C#, .NET Core, and RESTful web services.
Our client is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle complex issues, and contribute to projects that shape the future of digital transformation
You will be working within and promoting the Company Values – Be Brave, Be Wise, Be Proud and Exceed.
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.
- Assist with some C#/.NET development tasks, particularly those related to database integration.
- 3+ years of experience managing and optimising SQL Server databases.
- 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.
- 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.