2 MSSQL Database Consultants Stavanger (Norway) Job in Stavanger (Norway)

- Good understanding of MS SQL Architecture, Filegroups, Partitioning, Schemas, Snapshots,C38Memory etc.

- Installation and Configuration of SQL Server Pre-requisites.

- SQL Server Datbase Basic Administration and Latest Features.

- SQL Server user account management

- Test and Apply Patches and Service Packs

- Migrate Databases.

- Database Resource Management and Task Scheduling.

- Capacity Planing in terms of Growth of Database.

- Experience in basic Performance Tuning and Monitoring.

- Availability Management for Databases.

- Handling of daily issues (Blockings, Long running transaction, Deadlocks etc)

- Good understanding of Transact SQL.

- Automating SQL Server tasks (SQL Jobs, Windows scripts, etc.)

- Troubleshoot issues related to TempDb ,Transaction Log and System Databases

- Instance/Database monitoring/C39configuring DB Mail/SQL Mail and Alerts Operators

- Good knowledge of Index Management Statistics

- Basic Knowledge of SSIS, SSRS.

- Knowledge and troubleshooting Issues related to HA(Replication,Logshipping,Mirroring,Clustering)

- Scheduling Database Backups,taking Full and Transaction Log Backups.

- Implementing SQL Server Database Security Policy,Auditing