Senior Database Administrator

Corporate:

Light & Wonder’s corporate team is comprised of incredible talent that works across the enterprise, defying boundaries to provide essential services in an extraordinary manner to ensure the success of the organization and the well-being of employees.

Position Summary

• SQL Server Concepts like SQL Architecture, Indexes, T-SQL skills & DMV.
• Hands-on experience with SQL Server installations and patching.
• Perform scheduled maintenance and support release deployment activities.
• Database Maintenance/ Support tasks and lower-level monitoring using tools like profiler, DMV, Perfmon.
• Deep understanding of SQL Server performance analysis and tuning / capacity planning / query optimization.
• Hands-on experience with clustering, Always on / multi node clusters at the time of DR process.
• SQL Server Replication, Backup/ Restore, maintenance plans and DR strategies.
• Understanding of system tables, stored procedures, functions, triggers & SQL tuning.
• General troubleshooting like assisting end users with various issues related to connectivity, permissions, access, distributed queries issues, suggesting solutions, best practices etc.
• SQL Server Security, adept in creating and maintain complex User and permission management environment using AD groups, DB roles, SQL ids and Proxy accounts.
• Knowledge of Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices)