Sr. Database Administrator

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 Sr. 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 e