13 April 2023
1) Experience in sql 2012 and above.
2) Ability to troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
3) Experience in trouble shooting resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
4) Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
5) Experience in Performance Tuning Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools 6) Backup, restore. DR, HA Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC
Desired Candidate Profile
Knowledge in any of Scripting languages (Poweshell,VBScript,WSH)
Exposer to tools like redgate, idera, Erwin, Mysql, postgress, AWS RDS,ETL,BCP
Experience in managing db security roles privileges
Sql server DBA certification MCDBA or MCITP(preferred), MCSA (SQL server)
24 X 7 Production Database on Call Support
Backup, restore. DR, HA Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC