PostgreSQL Database Administrator

Overview

We are looking for an experienced talent who is a self-motivated, experienced Postgre

SQL 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 Postgre

SQL databases in both public and private cloud installations. They will also work in tandem with the other teams, preparing documentations and specifications as required.

• Provision Postgre
  
  SQL 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.

• Strong proficiency in Postgre
  
  SQL database management and optimization
• Experience managing large scale Postgre
  
  SQL databases.
• Understanding of Postgre
  
  SQL 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 Postgre
  
  SQL features, such as pgagent or pgbouncer.
• Ability to plan resource requirements from high level specifications.
• Knowledge of limitations in Postgre
  
  SQL 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.

• Experience managing MySQL or SQL Server.
• Ubuntu System Administration.
• Experience with Redis.
• Experience with Zabbix.
• Experience with Rabbit
  
  MQ.
• Industry experience - either in iLottery or iGaming.

• Bachelor’s degree in computer sciences with 5+ years’ experience with Postgre
  
  SQL.
• Master’s degree with 3+ years’ experience.