DBA/SQL Developer

This job has now expired please search on the home page to find live IT Jobs.

DBA/SQL DeveloperSalary - 45kMy client is currently looking for a DBA/SQL Developer to join their talented and successful in house development team where you will get the opportunity to work on a varied range of projects across all aspects of the business. You will be reporting to the Senior DBA Developer with direct access to the CTO and Head of SQL and NAV development.My client also offers many great benefits such as Pension and the opportunity to further progress your career. My client really understands the importance of work life balance which is why they also offer a range of flexible working arrangements which include WFH / Flexible working.Skills & Qualifications-At least 5 years' experience with MS SQL Server.-A good understanding of relational database principles and guidelines.-Extensive SQL query development experience.-Database administration - reliability, performance tuning and optimisation, backup, high availability (replication, mirroring, log shipping, always on) and DR solutions.-SSIS development & implementation experience.-Experience of participating in full life cycle development.-Background in high transaction environments and implementation of scalable architectures.-Experience or knowledge of an agile environment that practices scrum methodologies.-Familiarity with SQL Redgate tools: SQL Compare and Data Compare, SQL Monitor, SQL Source Control.-Github version control.-Experience of designing and implementing AWS/Azure Cloud databases and high availability solutions - desirable.-Experience of managing Always-n Availability groups.-Experience with ORM generated SQL code.Role & Responsibilities-Coding and improving existing SQL Server T-SQL queries.-Helping to develop efficient database designs (tables, datatypes, stored procedures, functions, etc.).-Carry out index maintenance, choosing when to add or remove indexes.-Tuning T-SQL queries to improve performance. Using profiler traces, extended events and other tools to SQL code, comparing SQL plans, etc.-DBA duties, ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives.-Use DMV queries or other tools to help diagnose server reliability and performance.-Develop, deploy and maintain SSIS packages.-Ensure that new database code meets company standards for readability, reliability, and performance.-Implementing and monitoring transactional replication, mirroring and log shipping.Interviews are happening as we speak so don't delay in applying. To apply for this role please send an up to date CV to Jessica Elliott [email protected] or give me a call on 02033199595