SQL DBA - Fully Remote - £55k - £60K
Overview
An excellent opportunity has arisen with a market leading, data driven Saas company for an experienced, motivated, and autonomous SQL DBA with skills in T-SQL and AWS.
Role & responsibilities
• Manage AWS RDS SQL Server databases.
• Monitor system's health and performance via AWS Console and other tools.
• Analyse, solve, and correct performance issues in real time.
• Provide suggestions for solutions.
• Refine and automate regular processes, track issues, and document changes.
• Assist developers with query tuning and schema refinement.
• Rectify developers SQL code from the point of performance impact.
• Perform scheduled maintenance and support release deployment activities after hours.
• Run ad-hoc query from the management and support teams.
• Provide bug-hunting support on the SQL server. Change code (procedures, views, function, triggers) to correct a bug.
• Perform data-patching operation out of office hours.
• Create and Restore Native backup for AWS RDS.
Skills & experience
• 2+ years of MS SQL Server, including creation of stored procedure, views and functions.
• Database design.
• T-SQL programming.
• 1+ years of performance tuning.
• Index analysis.
• Profiler.
• Performance monitor.
• AWS console: RDS Databases.
• Performance insight.
• Knowledge of Data Pipeline and Glue (Desirable)
• Data warehousing.
Package:
• £50K - £60k basic salary
• Fully remote
• 25 days annual leave
