Beschreibung
SQL Server DBA/SQL Server/SQL Server administration/DBA/SQL Server Admin
Role: SQL Server DBA
Location: Zurich, Switzerland
Job Type: Contract
Duration: 6 months
Job Description:
SQL Server Application Admin
- Understanding of Database Architecture Concepts Awareness on Application DBA Basics
- Ability to understand Basic DB Administration
- Ability to understand DB Administration Tools
- Working Knowledge of database specific data movement tools
- Strong knowledge in Database Architecture
- Able to Implement Application DBA Skills (Like Application/Development Support Admin)
- Working knowledge on DB Administration using Tools ( SQL Server Enterprise Manager)
- Ability to understand Database Upgrade
- Ability to understand Database Migration Process
- Expertise in using Database Tuning and Monitoring tools for performance improvements
- Knowledge of Database Replication
- Able to work on Database Upgrade
- Able to work on Database Migrations
- Ability to use Data Migration Tools for implementing Database Migrations.
T-SQL Programming
- Ability to understand and implement Declaring Variables, Building Blocks, Control Structures, Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions, Creating Database Triggers and Transaction Management.
- Adv Database Programming: Ability to understand and implement Dynamic SQL Usage, Programming with locks and isolations and Working with Temporary Tables
- Advanced Transact-SQL constructs, Business logic with stored procedures, Creating user-defined functions(UDF), Formulating triggers, Integrating XML with Transact-SQL, Transactions in T-SQL, Transferring data to and from SQL Server. Tools Level 1Usage
- Ability to Tune T-SQL Applications for Performance, Advanced Query concepts, Adv Stored Procedure Programming, DTS Programming Understanding of Database Migration Process
- Ability to work on Database Upgrade using T-SQL
- Ability to work on Database Migrations using T-SQL Exposure to Data Migration Tools
DB Modeling
RDBMS
- Exposure to Basic Relational Database Concepts
- Ability to understand basics of DB Design, Logical modelling, Normalization & De-Normalization Techniques
- Working knowledge of DB Design/Modeling techniques(Logical and Physical DB modelling)
- Adv knowledge of Logical & Physical modelling Knowledge of one Modeling Tool (LikeERWin, ER Studio, Visio, Power Designer, SELECT etc) Implementation Experience of Logical & Physical Database Modeling for Small/Medium Application Databases.