Database Administrator - PostgreSQL - Scientific Games

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

*CANDIDATE SPONSORSHIP IS NOT AVALABLE FOR ROLE*

*CANDIDATE MUST RESIDE IN THE UNITED STATES, PREFERABLY RESIDING IN, EST/EASTERN TIME ZONE*

We are looking for an experienced talent who is a self-motivated, experienced PostgreSQL Database Administrator . This position will be 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 candidate will also build and maintain large-scale and very high transaction PostgreSQL databases in both public and private cloud installations. They will also work in tandem with the other teams, preparing documentations and specifications as required.

Job Duties / Key Accountabilities:

• Provision PostgreSQL instances, both in clustered and non-clustered configurations
• Ensure performance, security, and availability of databases.
• Implement, and maintain replication strategies.
• Analyze performance and implement improvements.
• Prepare documentations and specifications.
• Experience in database software management (patch and version management)
• Handle common database procedures, such as backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary.
• Collaborate with other team members and stakeholders.
• Write scripts to generate adhoc reports, perform data audits, etc using bash or Python.
• Excellent verbal and written communication skills
• 24/7 Support of production databases.

Qualifications

Required:

• Strong proficiency in PostgreSQL database management and optimization
• Experience managing large scale PostgreSQL databases.
• Understanding of PostgreSQL user access and authentication processes and controls.
• Experience with replication configuration in PostgreSQL
• Hands on experience with designing and implementing database replication strategies.
• Knowledge of de-facto standards and best practices in PostgreSQL
• Proficient in writing and optimizing SQL state