Qualifications | Must be professional with the following modules:
01. Installing and Configuring Microsoft SQL Server
02. Managing Databases and Files
03. Partitioned Tables Management
04. Indexes Management & Tuning
05. Constraints Planning
06. Performance Planning & Management
07. Backup/Restoring Management
A. File/File Group backup
B. Full/Differential backup
C. Transaction Log backup
D. Online Restore Operations
E. Recovering Data from Database Snapshots
F. System Databases backup/restoring
08. Managing Security
09. Monitoring SQL Server
10. Transferring Data
11. Automating Administrative Tasks
A. Configuring SQL Server Agent
B. Creating Jobs and Operators
C. Creating Alerts
D. Managing Multiple Servers
E. Managing SQL Server Agent Security
12. Implementing Replication
13. Maintaining High Availability
A. Log Shipping
B. Database Mirroring
C. Server Clustering
14. Troubleshooting and Performance Tuning
15. DCL Statements
16. DDL Statements
17. DBCC Commands
18. Collation & Data formatting management
Must be also professional with the following modules:
1. Windows Server clustering.
2. Windows Server mirroring.
Must be good with the following modules:
1. DQL Statements
2. DML Statements
3. Triggers [DML/DDL]
4. Views
5. Stored Procedures
6. Must be aware with the Windows administrating generally.
Oracle, MySQL or both are plus. |
0 comments :
Post a Comment