Sr SQL Server Database AdministratorScientific Games • New York, New York, United States
Sr SQL Server Database Administrator
Scientific Games
- New York, New York, United States
- New York, New York, United States
Über
Position Summary Scientific Games LLC is looking for a self‑motivated, highly experienced Senior SQL Server Database Administrator to focus 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 other teams, preparing documentation 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.
Perform in‑depth analysis of performance, identify areas of improvement, and implement 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.
24×7 support of production databases.
Senior SQL Server DBA Skills & Qualifications
Knowledge of de‑facto standards and best practices in SQL Server.
Strong proficiency in SQL Server database management and administration, including large‑scale databases.
Hands‑on experience implementing and maintaining Always On Availability Groups is required; knowledge of additional replication models is 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 compared with 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.
Qualifications 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.
It would also be advantageous if you had any of the following experience
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 including close and distance vision, and ability to adjust focus while 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. 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.
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.
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.