Database Administrator - PostgreSQLScientific Games • New York, New York, United States
Cette offre d'emploi n'est plus disponible
Database Administrator - PostgreSQL
Scientific Games
- New York, New York, United States
- New York, New York, United States
À propos
Position Summary
CANDIDATE SPONSORSHIP IS NOT AVAILABLE 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 documentation 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 documentation 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
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 statements.
Knowledge of PostgreSQL features, such as pgagent or pgbouncer.
Ability to plan resource requirements from high level specifications.
Knowledge of limitations in PostgreSQL and their workarounds in contrast to other popular relational databases.
Experience administering Debian or Ubuntu Linux.
Able to work under pressure and multi‑task.
Pro‑active, dedicated, committed and responsible.
Desired
Experience managing MySQL or SQL Server.
Ubuntu System Administration.
Experience with Redis.
Experience with Zabbix.
Experience with RabbitMQ.
Industry experience - either in iLottery or iGaming.
Education
Bachelor’s degree in computer sciences with 5+ years’ experience with PostgreSQL.
Master’s degree with 3+ years’ experience.
Certified PostgreSQL DBA is a plus.
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
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre a été publiée par l’un de nos partenaires. Vous pouvez consulter l’offre originale ici.