Scientific Games
Database Administrator
Scientific Games, Middletown, Pennsylvania, United States, 17057
Scientific Games:
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.
Position Summary
Location: Middletown, PA - (*THIS POSITION IS 100% ONSITE*)
(Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.)
The Database Administrator is responsible for tasks such as development of best practices and repeatable procedures for deploying databases. They shall work on both standard maintenance support issues - 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. Ensures a smooth operation of SG database platforms, and on project specific work including new product releases, enhancements and upgrades of the product for existing and new features. Our team also builds and maintains large-scale and very high transaction SQL Server databases on Windows Server platforms works closely with our Infrastructure, Development, and testing teams, identifying issues while also suggesting and implementing corrective actions. A strong knowledge base and the ability to work cooperatively with other teams are necessary.
Scope: Remote primary and secondary data centers. Local operations, control and testing environments. Job Duties / Key Accountabilities:
Provision and configure SQL Server instances for both new and existing products. Ensure performance, security, and availability of databases. Implement, monitor, and maintain replication strategies. Analyse performance and implement improvements. Prepare documentation and specifications to support the system. Implement database procedures such as upgrade, backup, recovery, migration, etc. Profile server resource usage, optimize and adjust as necessary. Collaborate with other team members and stakeholders. Maintains DB jobs in production and across multiple domains and test environments. Updates multiple domains configuring alternate dates and times. Participate in 24x7x365 role of the Databases. Qualifications / Skills / Knowledge:
Required:
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. Working knowledge of Always On Availability Groups is required. Familiarity with setting up and maintaining failover cluster portion. Working knowledge of SQL Server Integration Services (SSIS) and ETL jobs. Proficient in writing and optimizing SQL/T-SQL statements. Working knowledge of SQL Server features such as partitioning, query store, maintenance plans, etc. Working knowledge of SQL Server encryption methods and practices. Solid understanding of VSphere a plus Experience with backup and recovery strategies. Ability to plan resource requirements from high level specifications. Monitoring and alerting via Database Mail. Working 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 Ability to develop and maintain positive working relationships. Ability to communicate with all levels of management. Must have average organizational and interpersonal skills. Ability to collect and maintain documentation in accordance with Company protocol. Desired:
Experience with SQL Server Reporting Services (SSRS). Experience with Tableau. Knowledge of popular database engines such as MySQL, Percona, or MariaDB. Windows Server Administration. Experience with PowerShell or other scripting languages Knowledge of Zabbix. Industry experience - Lottery or Gaming. Knowledge of additional replication models. Knowledge of cybersecurity a plus. Job Conditions:
Travel as needed. Ability to lift 30 lbs. Ability to sit, stand, bend, and stretch at a minimum of 50% of the time for any or all of the movements described. Qualifications
Education/Years of Experience/Certifications:
Bachelor's degree in computer sciences. 4+ years working with SQL Server or 8 years of SQL experience. Certified SQL Server DBA is a plus.
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.
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.
Position Summary
Location: Middletown, PA - (*THIS POSITION IS 100% ONSITE*)
(Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.)
The Database Administrator is responsible for tasks such as development of best practices and repeatable procedures for deploying databases. They shall work on both standard maintenance support issues - 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. Ensures a smooth operation of SG database platforms, and on project specific work including new product releases, enhancements and upgrades of the product for existing and new features. Our team also builds and maintains large-scale and very high transaction SQL Server databases on Windows Server platforms works closely with our Infrastructure, Development, and testing teams, identifying issues while also suggesting and implementing corrective actions. A strong knowledge base and the ability to work cooperatively with other teams are necessary.
Scope: Remote primary and secondary data centers. Local operations, control and testing environments. Job Duties / Key Accountabilities:
Provision and configure SQL Server instances for both new and existing products. Ensure performance, security, and availability of databases. Implement, monitor, and maintain replication strategies. Analyse performance and implement improvements. Prepare documentation and specifications to support the system. Implement database procedures such as upgrade, backup, recovery, migration, etc. Profile server resource usage, optimize and adjust as necessary. Collaborate with other team members and stakeholders. Maintains DB jobs in production and across multiple domains and test environments. Updates multiple domains configuring alternate dates and times. Participate in 24x7x365 role of the Databases. Qualifications / Skills / Knowledge:
Required:
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. Working knowledge of Always On Availability Groups is required. Familiarity with setting up and maintaining failover cluster portion. Working knowledge of SQL Server Integration Services (SSIS) and ETL jobs. Proficient in writing and optimizing SQL/T-SQL statements. Working knowledge of SQL Server features such as partitioning, query store, maintenance plans, etc. Working knowledge of SQL Server encryption methods and practices. Solid understanding of VSphere a plus Experience with backup and recovery strategies. Ability to plan resource requirements from high level specifications. Monitoring and alerting via Database Mail. Working 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 Ability to develop and maintain positive working relationships. Ability to communicate with all levels of management. Must have average organizational and interpersonal skills. Ability to collect and maintain documentation in accordance with Company protocol. Desired:
Experience with SQL Server Reporting Services (SSRS). Experience with Tableau. Knowledge of popular database engines such as MySQL, Percona, or MariaDB. Windows Server Administration. Experience with PowerShell or other scripting languages Knowledge of Zabbix. Industry experience - Lottery or Gaming. Knowledge of additional replication models. Knowledge of cybersecurity a plus. Job Conditions:
Travel as needed. Ability to lift 30 lbs. Ability to sit, stand, bend, and stretch at a minimum of 50% of the time for any or all of the movements described. Qualifications
Education/Years of Experience/Certifications:
Bachelor's degree in computer sciences. 4+ years working with SQL Server or 8 years of SQL experience. Certified SQL Server DBA is a plus.
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.