SQL Server Database Administrator
Responsibilities and Duties
- Day to Day administration ensuring that the database platforms are fully supported at all times
- Conduct database performance, capacity and security management
- Maintaining a high level of availability of services, and minimising the risk of exposure to system downtime, through continual monitoring of key systems
- Defining and improving database coding standards
- Maintaining ER diagrams describing the application data model
- Improving monitoring of production databases to include metrics such as CPU, memory usage and IOPS
- Provide dashboards to management to illustrate monitored metrics
- Analysing systems proactively to identify problems and trends, proposing technical solutions, and recommending changes to optimise system performance and usability
- Act in an advisory and consultancy capacity for the Dev team
- Identify obsolescent technologies and formulate upgrade plan
- Ensure database structure, quality, standards and best practices are met
- Conducting incident management, including post-incident reviews
- Work closely with the development and project management teams to design and deliver key projects
- Follow emerging technologies
Skills & Education
Essential
- Expert level experience in database tools such as Microsoft SQL Server 2016 and MySQL
- Extensive experience in database development and support
- Strong proficiency in MySQL or SQL Server database management
- Excellent Transact-SQL skills
- Practical experience in query performance tuning including indexing and statistics
- Significant knowledge of High Availability and SQL replication
- In-Depth understanding and practical experience of Always on Availability Groups
- Database monitoring tools and techniques
- Experience administering SQL Server Reporting Services
- Experienced in Disaster Recovery techniques and solutions (Backup and Recovery)
- Excellent communication skills with management, development teams, vendors and systems administrators
Desirable
- Insight of SQL Integration Services and Analysis Services
- Experience of Microsoft PowerBI
- Experience of tools such as MySQL and NoSQL databases
- Experience of Database Design, Development & Data Architecture
- Experience with Microsoft SSIS and SSRS
- Knowledge of Cloud technologies (Microsoft Azure)
- Experience working within ITIL framework (Incident Management, Problem Management, Change Control)
- Exposure working within a DevOps environment
What We’re Offering
- Competitive basic salary (dependent on experience)
- 30-32 days holiday per year (inclusive of bank holidays) - dependent on experience
- Extra day off for your birthday
- Bupa Health Insurance – full cover
- Income Protection
- Pension
- Enhanced Family Friendly Rights (such as Maternity, Paternity and Family Leave)
- Full ongoing training will be provided with lots of opportunities for progression
- A hardworking but fun and lively atmosphere with opportunities to develop within the business
- Employee recognition scheme
