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.