Inta People
Location
Swansea | United Kingdom
Job description
Salary: Please contact us
Employment: Permanent
Are you a Database Administrator looking to work with big data with the flexibility of 2 days per month in the office? We’re helping a Swansea based company scale up the Technology Service Department with a SQL DBA to provide database support across the estate delivering an efficient and reliable environment.
About the company:
This role is mainly remote with visits to the Swansea office 2 days per month. We cannot consider applications outside of the UK.
The culture in this office is second to none, the team are super collaborative and it feels like more of a community.
They’re a data driven company and are moving to big data environments.
If job security is a priority, this company could be a good fit. They’re an established company of over 30 years.
About the role:
Day to day, you will be developing, implementing, maintaining and supporting database systems as they move to Big Data Environments.
As new systems are brought in-house, you will choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies.
You will consistently monitor the SQL environment and ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives.
When performance issues arise, the DBA will determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
The DBA will install and configure new SQL Servers as well as automate routine/non-routine DBA tasks and contribute to driving efficiency gains within your area.
The experience required:
Experience in database development and support in MS SQL Server environments.
Strong experience in Database Administration in SQL Server (2008 - 2019)
MongoDB
Any experience in the following is a bonus:
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Experience performing DR tests.
Expert experience in implementing operational automation.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
Solid acquaintance with windows server, security delegation, SPNs, storage components.
About the benefits:
25 days holiday, plus 8 public holidays
12% Bonus
Company pension scheme
Annual pay reviews
Development opportunities and additional training
What next?
‘Apply Now’ to be considered or contact Kim for a confidential chat on [email protected]
Get in touch:
[email protected]Job tags
Salary
