£400 Per day
Undetermined
Onsite
London, UK
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