Database Administrator
Maintains and tunes the SQL Server and PostgreSQL databases behind Betsson's iGaming systems: monitoring, backups and high availability, performance tuning of T-SQL, deploying schema changes, and advising developers, plus on-call production incident support. Works across Linux/Windows Server and AWS cloud databases.
- Compensation
- Not disclosed
- Location
- Malta
- Work setup
- Onsite
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Devops
- Posted
Skills
Must have
- Good experience administering SQL Server databases, at least 3 years
- Good experience administering PostgreSQL databases, at least 3 years
- High proficiency in coding and performance analysis of SQL queries
- Strong experience with Linux and Windows Server administration
- Familiarity with cloud databases (AWS)
- Exposure to data observability concepts
- Experience with monitoring and alerting tools
Nice to have
- Experience with MySQL
- Experience with Snowflake
Full description
The Database Administrator is responsible for setting up and maintaining the databases which are at the core of our Systems. You will have a deep knowledge of the data model used to be able to effectively perform the duties and work closely together with both operations teams and developers to ensure the highest quality and performance.
A taster of what you will be involved with:
Database Administration:
- Maintain, monitor and support production and development of databases and environments;
- Monitoring and troubleshooting database integrity issues, performance issues, blocking and deadlock issues, replication/log shipping issues, connectivity issues, security issues etc.;
- Troubleshooting SQL Server related CPU, memory, I/O, diskspace and other resource contention;
- Apply high availability through backups, restores, DBCC commands, clustering, availability groups, replication;
- Implement operational automation;
- Install and configure new SQL Servers;
- Apply latest patches and updates;
- Planning System storage and partitioning
Database Development:
- Write, optimize and maintain stored procedures;
- Performance tuning of T-SQL queries based on best practices;
- Ensure that the databases are optimized from a performance perspective;
- Index management, creation, storage, and integrity checks;
- Working in partnership with development teams and providing technical expertise to attain highly optimized and innovative solutions;
- Deploy database change scripts;
- Support developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc);
- Modelling of data optimized for read\write workloads.
Tech Support:
- Provide on call support;
- Participate in root cause analysis for production incidents.
What we are looking for:
Must have:
- Good experience with Administration of SQL Server Databases at least 3 years
- Good experience with Administration of PostgreSQL Databases at least 3 years
- High proficiency in coding and performance analysis of SQL queries
- Strong experience with Linux and Windows Server Administration
- Familiarity with Cloud Databases (AWS)
- Exposure to data observability concepts
- Experience with monitoring and Alerts tools
Nice to have:
- Experience with MySQL
- Experience with Snowflake