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