Job Description
Job Description :
Understanding core database concepts
Table Operations
Data storage in table
Data definition concepts
Data manipulation concept
Transaction control management concepts
Constraints operations in table
Understanding normalization
Joins operations in table
Data types and usage
Types of table in SQL Server and usage
Practical's and Objective Questions practice
Database Objects:
Views conceptual understanding
Types of views and their operations
Indexes operations
Procedure and Functions
Other database objects in SQL Server(intro)
Practical's and Objective Questions practice
Database Administration :
Database security User operations
Create, maintain, and drop users
Configure row level security
Configure dynamic masking
User and login concepts
Schema usage and operations
Roles understanding and usage :
In-built role activities
User-defined role activities
Backup and Restore :
Backup type and usage concepts
Configure backup strategy
Alert for failed operations
Backup automation
Ways to take backup
Ways to restore database
Page recovery
Point in time recovery
Restore file groups
Plan for automate and test restore
Scenario Activities
Practical's and Objective Questions practice
Configure data access and auditing
Encryption :
Encryption concepts and ideas to implement
Practical exposure in encryption
Cell level
Backup
Always
Configure TDE
Configure connection encryption
Troubleshoot
Practical's and Objective Questions practice
Auditing :
Conceptual fundamental and usage
Configure auditing
SQL Server auditing
Query log auditing
Analyse audit logs and reports
Practical's and Objective Questions practice
Manage and monitor instances:
Monitor concepts and Activities
Monitor SQL Server instance
Monitor database
Monitor Queries
Manage Indexes
Manage statistics
Practical's and Objective Questions practice
High availability and Disaster recovery
Configure and monitor log shipping
Implement AlwaysOn availability groups
Implement failover cluster instances
Difference between Logshipping, Mirroring and replication
Practical's and Objective Questions practice
Activities implement in Azure:
Deploy Microsoft Azure SQL Server
SQL server installation plan and strategies
SQL server instance management
Backup database strategies
Analyse tools in Azure
Database and instance configurations:
Configure secure access
Configure performance settings
Manage SQL Server instance
Manage SQL Server storage
Database maintenance operations
Employement Category:
Employement Type: Full time
Industry: IT
Functional Area: IT
Role Category: Software Engineer
Role/Responsibilies: MS Sql Server DBA
Contact Details:
Company: Teamlease Digital
Location(s): Bengaluru