Sr SQL Server Database Administrator
sglottery · US ·
- Seniority
- Senior
- Category
- Devops
sglottery · US ·
Scientific Games is the global leader in lottery games, sports betting and technology, and the partner of choice for government lotteries. From cutting-edge backend systems to exciting entertainment experiences and trailblazing retail and digital solutions, we elevate play every day. We push game designs to the next level and are pioneers in data analytics and iLottery. Built on a foundation of trusted partnerships, Scientific Games combines relentless innovation, legendary performance, and unwavering security to responsibly propel the global lottery industry ever forward.
Scientific Games LLC is looking for a self-motivated, highly experienced Senior SQL Server Database Administrator to be focused on our Tableau based BI solution as well as other SQL Server Databases. The DBA is responsible for tasks such as development of best practices and repeatable procedures for deploying databases, day-to-day operational activities including break/fix, capacity management, backup and recovery, database replication setup/management and ongoing database change reviews. The team also builds and maintains large-scale and very high transaction SQL Server databases on Windows Server platforms. You will also work in tandem with the other teams, preparing documentations and specifications as required.
Senior SQL Server DBA Responsibilities
Provision and configure SQL Server instances for both 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
Senior SQL Server DBA Skills and Qualifications
Knowledge of de-facto standards and best practices in SQL Server
Strong proficiency in SQL Server database management and administration including with large scale SQL Server databases.
Hands on experience implementing and maintaining Always On Availability Groups is required. Knowledge of additional replication models in a plus.
Hands on experience implementing and maintaining SQL Server encryption models including TDE, Always Encrypt, SSL connections, etc.
Experience working 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.
Ability 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
Years of experience 5 to 8 years
It would also be advantageous if you had any of the following 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 are all good
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. As a prerequisite to employment with SG (to the extent permitted by law), you shall be asked to consent to SG conducting a due diligence/background investigation on you.
This job description should not be interpreted as all-inclusive; it is intended to identify major responsibilities and requirements of the job. The employee in this position may be requested to perform other job-related tasks and responsibilities than those stated above.
SG is an Equal Opportunity Employer and does not discriminate against applicants due to race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class. If you’d like more information about your equal employment opportunity rights as an applicant under the law, please click here for EEOC Poster.