Sr SQL Server Database Administrator
About the role
Scientific Games is seeking a self-motivated, highly experienced Senior SQL Server Database Administrator to support their Tableau-based BI solution and other SQL Server databases. This role involves provisioning and configuring SQL Server instances, ensuring database performance, security, and availability, managing replication strategies, and handling various database procedures.
Responsibilities
- Provision and configure SQL Server instances for new and existing products.
- Ensure performance, security, and availability of databases.
- Plan, implement, and maintain replication strategies.
- In-depth analysis of performance, identification of areas of improvement, and implementation planning.
- Prepare documentation, procedures, and specifications.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Profile server resource usage, optimize and tweak as necessary.
- Collaborate with other team members and stakeholders.
- Mentor junior team members.
- 24x7 Support of Production DB’s
Skills and Qualifications
- Knowledge of de-facto standards and best practices in SQL Server.
- Strong proficiency in SQL Server database management and administration, especially with large scale SQL Server databases.
- Hands-on experience implementing and maintaining Always On Availability Groups.
- Hands-on experience implementing and maintaining SQL Server encryption models.
- Experience with SQL Server Integration Services (SSIS) and ETL jobs.
- Knowledge of SQL Server features such as partitioning, query store, Column Store indexing, etc.
- Proficient in writing and optimizing SQL/T-SQL queries and jobs.
- Experience with backup and recovery strategies.
- Able to plan resource requirements from high level specifications.
- Monitoring and alerting solutions.
- Knowledge of limitations in SQL Server and workarounds in contrast to other popular relational databases.
- Strong technical problem-solving skills and working knowledge of common protocols such as SFTP, SMTP, DNS, and HTTP/S.
- Able to work under pressure and multi-task.
- Pro-active, dedicated, committed, and responsible.
- Excellent verbal and written communication skills.
Education
- Bachelor’s degree in Computer Sciences with 10+ years administering and maintaining SQL Server OR
- Master’s degree with 8+ years’ experience.
- Certified SQL Server DBA is a plus.
Years of Related Experience
- 5 to 8 years
Additional Experience
- Knowledge and experience with Tableau.
- Code versioning tools such as Git/GitLab.
- Other popular database engines such as MySQL, Percona, MariaDB.
- Windows Server Administration.
- Scripting – PowerShell, Python, and shell scripting.
- Zabbix.
- Industry experience - either in iLottery or iGaming.
Physical Requirements
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit, stand, walk, bend, use hands, operate a computer, and have specific vision abilities to include close and distance vision, and ability to adjust focus working with computer and business equipment.
Work Conditions
Scientific Games, LLC and its affiliates (collectively, “SG”) are engaged in highly regulated gaming and lottery businesses. As a result, certain SG employees may, among other things, be required to obtain a gaming or other license(s), undergo background investigations or security checks, or meet certain standards dictated by law, regulation or contracts. In order to ensure SG complies with its regulatory and contractual commitments, as a condition to hiring and continuing to employ its employees, SG requires all of its employees to meet those requirements that are necessary to fulfill their individual roles.