Lead SQL Server Application Administrator

CH  ‐ Vor Ort
Dieses Projekt ist archiviert und leider nicht (mehr) aktiv.
Sie finden vakante Projekte hier in unserer Projektbörse.

Schlagworte

Beschreibung

Lead SQL Server Application Administrator

Required Skills 

  • 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.

SQL Server T-SQL Programming - Database Programming Basics: 
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 understandand implement Dynamic SQL Usage, Programming with locks and isolations andWorking with Temporary Tables 

Adv Database Programming: 
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 

Adv Database Programming: 
Ability to Tune T-SQL Applications forPerformance, Advanced Query concepts, Adv Stored Procedure Programming, DTSProgramming, Understanding of Database Migration Process,Understanding of Database Upgrade, Ability to work on Database Upgrade using T-SQL, Ability towork on Database Migrations using T-SQL, Exposure to Data Migration, Tools Exposure to Multi DB - Multi Platform Migration.

DB Modeling- RDBMS - Exposure to Basic Relational Database Concepts - basic types of databases, data integrity, the relational model,etc 

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) 

Ability to understand Conceptual Model 

Acknowledge of Logical   Physical modelling 

Knowledge of one Modeling Tool (Like ERWin, ER Studio, Visio, Power Designer, SELECT etc) 

Implementation Experience of Logical  

Physical Database Modeling for Small/Medium Application Databases.


Essential Skills

SQL Server T-SQL Programming -

Database Programming Basics: 
Ability to understand and implement Declaring Variables, Building Blocks, Control Structures, Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions, Creating Database Triggersand Transaction Management. 

Adv Database Programming:
Ability to understandand implement Dynamic SQL Usage, Programming with locks and isolations andWorking with Temporary Tables 

Adv Database Programming: 
Advanced Transact-SQLconstructs, Business logic with stored procedures, Creating user-definedfunctions(UDF), Formulating triggers, Integrating XML with Transact-SQL,Transactions in T-SQL, Transferring data to and from SQL Server. 

Tools Level 1Usage  Adv Database Programming:  Ability to Tune T-SQL Applications forPerformance, Advanced Query concepts, Adv Stored Procedure Programming, DTSProgramming 

Understanding of Database Migration Process 

Understanding of Database Upgrade: Ability to work on Database Upgrade using T-SQL 

Ability to work on Database Migrations using T-SQL 

Exposure to Data Migration Tools

Exposure to Multi DB - Multi Platform Migration

Start
ab sofort
Dauer
6 months +
(Verlängerung möglich)
Von
GIOS Technology Limited
Eingestellt
24.05.2013
Projekt-ID:
541521
Vertragsart
Freiberuflich
Um sich auf dieses Projekt zu bewerben müssen Sie sich einloggen.
Registrieren