-
Administration and monitoring of MS SQL-based database services deployed in distributed environments
-
Providing 2nd line support to database management
-
Updating technical documentation and operating procedures
-
Troubleshooting and resolving database issues across complex, large-scale systems
-
Deploying databases and managing Always-On availability deployments
-
Extracting, transforming, and loading data using MS SQL scripting, ETL tools, and cloud services
-
Planning capacity and availability of databases, tuning and optimizing performance
-
Implementing changes according to ICT change management procedures
-
Database incident management and escalation handling
-
Monitoring database health using tools such as SQL Profiler, Execution Plans, Dynamic Management Views (DMVs), and DBPlus Performance Monitor
-
Reporting on activities and operational metrics