SQL Server Engineer

Job Description

SQL EngineerJoin the Access Family and see how we make software ideas become a reality!Our core value of Love work, Love life has been central to our success and so were looking for people to join us who share our passion for making things better every day, to help us become a UK top 10 Software company.Are you ready for the challengeAbout you: First and foremost, you are a MS SQL T-SQL expert with a complete knowledge of this technology. You are a proactive, thorough, and independent while also comfortable closely collaborating with a wider team. Highly motivated to deliver will designed, well optimised,secure, and highly available data solutions to an application or set of services. An excellent communicator and team player, with a genuine desire to help collegues and customers/users. A keen and fast learner who enjoys leaning new technologies, tools, andskills. Hardworking, tenacious and determined. Very adaptable, and able to cope with a fast paced working environment. Day-to-day, you will:• Review, profile, diagnose and maintain large scale complex MSSQL / T-SQL databases. • Be an expert resource in T-SQL.• Support a development team in ensuring best data architecture, design, and implementation practises are followed when implementing new features or services.• Profile and analyse existing data stores and recommend improvements and optimisations to leaders.• Take lead or sole ownership of performance optimisations within the database, or lower application layers (data layer, ORM).• Define, own, and maintain data level performance KPIs and metrics.• Log trawling and troubleshooting production data issues using APMs, monitoring tools, application logs, etc.• Write, or support others in writing, complex scripts or procedures to maintain, delete, restructure, or otherwise manipulate data in large scale production environments.• Advise on and champion application data security.• Assist developers, DBAs, and DevOps engineers in some production data management; maintaining schema, indexes, cross estate consistency, etc.• Support QA Engineers in testing at the data level. • Be involved in supporting or participating in application software delivery using SCRUM or KanBan methodologies.• Executing automation pipelines in MS Azure.• Documenting data architecture, design, models, best practices.• Report to an Engineering Manager and work closely with Engineering leads & principles.• Support P1 incident managers in solving critical productions issues if required. As a well-rounded SQL Engineer, your Skills and Experiences likely include: • Good understanding of Execution Plans.• Knowledge of using Extended Events and interpretation of results.• Good understanding of Indexes and indexing strategies.• Advanced knowledge of TSQL including:oStored Procedures / Views / FunctionsoCTEsoWindow functions• Knowledge of Query Store and use in performance monitoring.• Technical stack:oMS SQL Server / T-SQL - Expert Level. oAPMs: AppDynamics, NewRelic, SolarWinds, Redgate SQL Monitor.oMS Azure DevOps - at least basic familiarity.oMS Azure cloud hosting and native application technologies - advanced or expert knowledge of MS Azure storage (SQL, Blob, Table).oMySQL - Advanced.oAtlassian Confluence.oAzure Repos/GIT.• Having a working knowledge of full stack software development. Although you will specialise in the data level it is vital you know and be able to advise on how to design and implement strong software up the stack to ensure no detrimental effects on data storeswhen used at scale. • Capable of configuring popular database engines and orchestrating clusters as necessary• Closely collaborating with a Product Engineering Development team consisting of Product Managers, BA/Product Owners, and QA Engineers.• Experience working in a wider community of Data Engineers, DBAs, Data Architects, and Architects.• Strong communicator (written and verbal). Good interpersonal skills. Update to manage stakeholders at every level.• Have a foundational knowledge of software deployment and distribution on networks and cloud platforms. • Some DevOps skills and experience welcome.• Expert at examining RML traces to identify issues and optimisations.• Social care industry knowledge ideal by not required.• Able to cope with a fast paced working environment.• Knowledge in Mobile apps and data store highly beneficial. • Production DBA experience beneficial.• Experience in diagnosing and solving production issues under pressure.What does Access offer youWe are a growing software company and we deliver on what we say we do! We take the development of our people very seriously! We will work with you to carve out your success plan and an opportunity to accelerate your career and make a real difference.• Healthy, friendly, and inclusive culture• Work-life balance• Hybrid/Remote working• Flexible working hours• Competitive salary package• Great Holiday Package (starting from 25)• Charity day - day off paid by the company for volunteering activities• Private Healthcare & Life Insurance• Referral Bonus• Big Break - all-inclusive holiday paid by the company• Other benefitsLove Work. Love Life. Be You.