SQL/Server DBA Consultant

Rogaland  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

For our customer we are looking for a SQL Server DBA Consultant for a contract role based in Stavanger, Norway.

General Description for a SQL Server DBA Consultant:

Responsibilities:-
- Helping team members in case of Issues/Technical Problems
- Handling tickets/requests
- Troubleshooting technical issues
- Responsible for successful completion of Installation, configuration and migration
- Ensure maximum uptime according to the SLA
- Responsible for building/maintaining a test environment
- Improves and maintains customer and employee satisfaction
- Implementing new technologies and design changes
- Implementing Backup/Restoration Strategy for 24x7 operation support
- Applying patches/upgrades to maintain security level

Technical Requirements

- Good understanding of MS SQL Architecture, Filegroups, Partitioning, Schemas, Snapshots,C38Memory etc.
- Installation and Configuration of SQL Server Pre-requisites.
- SQL Server Database 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 Planning 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

Other Skills/Experience

- Worked on Production systems
- Experience with Database Migration, Installation, Upgrades and Patching
- Datacenter understanding
- Knowledge of Other RDBMS
- Experience in't SQL and worked on ER Diagrams.
- Working Knowledge on Clusterware
- Knowledge on SOX testing and Reporting

Certification requirements

- MCTS/MCTIP

All applicants must be eligible (EU Passport/Work Permit holders) and willing to work onsite in Norway.

Start date
ASAP
Duration
3 months +
(extension possible)
From
Miracle Partners
Published at
11.04.2012
Project ID:
346749
Contract type
Freelance
To apply to this project you must log in.
Register