SQL Server DBA role requires a service oriented mentality, high sense of ownership of the problems and requests assigned. Exposure to different versions of SQL Server.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication
Expert experience in implementing operational automation.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Excellent communication and client-facing skills/experience
Experience of working in SLA based support
Working in shifts is a critical requirement which could be on rotation based on a roster. There will be need to work on weekends too since its a 24x7 operation, which would be roster based.
Should have good knowledge of SQL Server Agent, SQL Jobs.
High sense of ownership
Iris Software is a professional software services organization offering high-quality... solutions to businesses. It services the information technology requirements of companies ranging from the Fortune 100 to medium-sized firms by utilizing specialized domain knowledge, best-of-breed technologies, rapidly deployable proprietary frameworks/solutions and flexible engagement models. Read full description