Hands-on experience in Microsoft SQL Server is a must - Creating all key database objects (Tables, Views, Foreign Key Relationships, Triggers, Stored Procedures scripting and User Defined Functions)
Primary responsibilities of this role includes owning, tracking and resolving database related incidents andrequests within provided SLAs, reviewing service related reports (e.g.: database backups, maintenance,monitoring) on a daily basis to ensure service related issues are identified and resolved within establishedSLAs, responding to database related alerts and escalations and working with database engineering to comeup with strategic solutions to recurring problems.
Establish database performance baselines and conduct workload testing, including replication, backup and recovery, log shipping, scalability and partitioning.
Database Performance & Optimization: Write, review, and optimize SQL queries; identify long-running or resource-intensive queries and work with engineering teams to resolve them.
Responsible in managing database backup, recovery, data archiving, performance tuning, capacity forecast, database health monitoring and applying database patches
Establish database performance baselines and conduct workload testing, including replication, backup and recovery, log shipping, scalability and partitioning.