Ms Sql Database Administrator

MUST HAVE

• Must have strong technical knowledge in MSSQL 2014 & above Administration.
• Execution of backup/recovery procedures and DB refreshes.
• Should have handled database installations as MSSQL DBA.
• Creation and Maintenance of Database Instances
• Event, database performance and availability monitoring.
• Exposure to Logical and Physical database design and Implementation.
• Install, configuring, applying patches to MSSQL servers.
• Knowledge and experience in Replication, Log Shipping, Clustering, Always On in SQL 2005 above configure and basic troubleshooting.
• Backup monitoring, verification.
• Applying Database patches, upgrade and migration
• OS level activities related to database tasks.
• Log, scheduled Job Management through Control-M or similar products.
• Schema Object, Partition Management.
• Expertise in handling Database Maintenance related to Index and DBCC.
• Hands on expertise in Performance tuning.
• Development support/ debugging performance issues.
• Windows administration experience desired.
• Well averse with DB Scripting, SQL Profiler, Extended Events, Query Analyzer and Query Store and Intelligent query processing.
• Experience on ITIL/operations and production support

GOOD TO HAVE

• Good knowledge in MSBI
• Should have handled database installations as MSBI DBA.
• Experience in MSBI and its related components like SSAS/SSIS/SSRS and Power BI.
• Exposure to SSIS Packages, SSAS, SSRS and Power BI.
• Application DBA Exposure.
• PowerShell scripting