London Jobs |
Manchester Jobs |
Liverpool Jobs |
Nottingham Jobs |
Birmingham Jobs |
Cambridge Jobs |
Glasgow Jobs |
Bristol Jobs |
Wales Jobs |
London Jobs |
Manchester Jobs |
Liverpool Jobs |
Nottingham Jobs |
Birmingham Jobs |
Cambridge Jobs |
Glasgow Jobs |
Bristol Jobs |
Wales Jobs |
Oil & Gas Jobs |
Banking Jobs |
Construction Jobs |
Top Management Jobs |
IT - Software Jobs |
Medical Healthcare Jobs |
Purchase / Logistics Jobs |
Sales |
Ajax Jobs |
Designing Jobs |
ASP .NET Jobs |
Java Jobs |
MySQL Jobs |
Sap hr Jobs |
Software Testing Jobs |
Html Jobs |
Job Location | London |
Education | Not Mentioned |
Salary | Competitive salary |
Industry | Not Mentioned |
Functional Area | Not Mentioned |
Job Type | Permanent , full-time |
KEY Responsibilities:* Troubleshooting and resolving database performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues etc* 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* Knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication * Implementing operational automation where the need or opportunity arises * Ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints)* Proven documentation skills for processes and procedures* Install and configure new SQL Servers and apply security and stability patches across all environments.* Manage the security and disaster recovery aspects of a database.* Communicate regularly with technical, applications and operational staff to ensure database integrity and security* Carry out capacity planning* Control access permissions and privileges* Required to help with any additional tasks required by management* Support and administration of Snowflake databases in the Cloud (SaaS)Technical Skills and Experience:* Qualified to university equivalent * Experience managing MS SQL Databases * Microsoft Database Qualification* Web-specific technology expertise. For e-businesses, DBAs are required to have knowledge of Internet and Web technologies to enable databases to participate in Web-based applications. Examples of this type of technology include XML, .NET, Java Script,C#, TCP/IP, Web servers, and SSL. * Demonstrable use of working and writing in T-SQL * Related application and software/OS experience including any of the following: Microsoft Server technologies, SQL Databases, SSIS, SSRS, Analysis Server, failover Clustering, AlwaysOn Availability groups, Log Shipping and Replication, Powershell & IIS.* Desirable skills in AWS RDS, Azure and Business Intelligence. * Experience with Monitoring products such as Idera, Foglight, AppDynamics would be advantageous.* Any support/administration of Snowflake databases in the Cloud (SaaS) would be desirable.