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