MS SQL Database Administrator

MS SQL Database Administrator

Posted 2 weeks ago by Job Board - Jobserve on JobServe

£400 Per day
Undetermined
Onsite
London, UK
p>Rate: 400 per day insideIR35

Duration: 6 months

Work Location: Hybrid, London.

Job Summary:

A highly motivated and results-oriented MS SQL Database Administrator, who can independently lead and be responsible for a variety of tasks related to the administration, maintenance, and optimization of Microsoft SQL Server databases hosted at on-prem/cloud. The person should be a team player to closely work with other IT team members/stakeholders, ensuring smooth operation and performance of the database systems and technology landscape for futureproofing.

Responsibilities:

Good understanding of database architecture, design, and expertise in MS SQL Server administration, configuration, and maintenance.

Good experience in Performance Tuning and Optimization (PTO) of query, database and server, using native monitoring and troubleshooting tools.

Experience with backups, restoration, and recovery models.

Knowledge of Analysis services, cubes, data-warehousing.

Good Experience on reporting services packages implementation, configuration, and troubleshooting.

Experience on SSIS packages implementation, configuration, and troubleshooting.

Sound experience on High Availability (HA) [clustering, AlwaysOn, mirroring) and Disaster Recovery (DR) options for SQL Server.

Experience of Database auditing and security.

Experience of database migration, upgradation, and patching.

Driving the cloud Solutioning on Azure/AWS for large complex implementation

Plan Storage and Capacity Management and create logical models and build physical models

Create and maintain database documentation and assist with the development and implementation of new database systems and strong understanding of Microsoft SQL Server, including My-SQL

Experience with database administration tools and utilities

Good to have:

Microsoft Certified: Azure Database Administrator Associate

Microsoft Certified: SQL Server Database Administrator Associated

Configuring and Administering Security/Policies/Resource Governing/Azure Key Vault.

MCTS, MCITP, and/or MVP certifications