SQL Server DBA

1 x SQL Server DBA is needed for a contract in Valencia, Spain.

You will provide on-going administration and support for the SQL Server systems within an international ICT support company, functioning as part of a team based in multiple geographical locations. This is an English speaking role and has the potential to be long term. If you have relevant SQL Server DBA experience and are interested in working in an amazing city like Valencia please apply.

SQL Server DBA duties include:

* Installation, configuration and support of SQL Server infrastructures.
* Follow-up on problem management cases including problem detection, logging, categorization, investigation, diagnosis and complete resolution plans.
* Installation and configuration of new SQL Server infrastructures.
* Creation and configuration of databases, users and SQL Agent jobs.
* Configuration and support of SQL disaster recovery synchronizations.
* On-going patching and upgrades of SQL Server instances.
* Migrations of SQL Server environments and consolidation of SQL Server infrastructures.
* Capacity planning and reporting on SQL storage requirements.
* Feasibility assessment, implementation, deployment and support of SQL Server services in Microsoft Public Cloud Azure.
* Documentation of operating processes, procedures and installations.
* Identification of key areas for improvements in system performance, processes, and deployments.
* Stand-by services during weekends, official holidays and outside business hours as required.

Your skills should include:

* Microsoft SQL Server 2008, 2008 R2, 2012 and 2014
* High availability solutions including SQL Server AlwaysOn technology, Failover Clustering (FCI), Availability Groups (AVG).
* Disaster recovery technologies including database mirroring and transaction log shipping.
* SQL Server Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS), and Master Data Services.
* SQL Server Replication technology including snapshot, merge and transactional replications.
* SQL Server backups and database recovery procedures including the ability to recover from failed processes and engine crashes.
* Storage technologies, disk arrays, SAN, data storage virtualization technologies (RAID levels, virtual fiber Switches).
* T-SQL Scripting, Windows PowerShell Scripting and SQL Server troubleshooting skills.
* SQL Server performance monitoring, tuning, query optimization, data segregation, SQL Server Distributed Replay, Activity and Resource Monitor, SQL Profiler.
* SQL Server database encryption.
* SQL Server security (users, logins, roles).
* Network communication protocols, including the ability to analyze network issues.
* Service Management tools (ticketing systems) and
* ITIL & PRINCE2 knowledge.
* Microsoft System Centre Operations Manager (SCOM).
* Windows Operating Systems (Windows Server 2008, 2008R2, 2012, 2012R2).
* Microsoft certifications are highly desirable.

Again this is an English speaking role with long term potential. Please contact Quanta with your CV to apply.