About This Role
This role involves setting up and maintaining the core databases that power the company's systems. The Database Administrator will need deep knowledge of the data model to perform duties effectively, working closely with operations teams and developers to ensure high quality and performance.
Responsibilities
- Maintain, monitor, and support production and development databases and environments
- Monitor and troubleshoot database integrity issues, performance issues, blocking and deadlock issues, replication/log shipping issues, connectivity issues, and security issues
- Troubleshoot SQL Server related CPU, memory, I/O, disk space, and other resource contention
- Apply high availability through backups, restores, DBCC commands, clustering, availability groups, and replication
- Implement operational automation
- Install and configure new SQL Servers
- Apply latest patches and updates
- Plan system storage and partitioning
- Write, optimize, and maintain stored procedures
- Performance tune T-SQL queries based on best practices
- Ensure that databases are optimized from a performance perspective
- Manage index creation, storage, and integrity checks
- Work in partnership with development teams and provide technical expertise to attain highly optimized and innovative solutions
- Deploy database change scripts
- Support developers on the most efficient database designs (tables, data types, stored procedures, functions, etc.)
- Model data optimized for read/write workloads
- Provide on-call support
- Participate in root cause analysis for production incidents
Requirements
- 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
Benefits
About the Company
Betsson is a business with 1700 employees, 75% of whom are millennials, spread across 7 offices, with 900 based out of its Malta HQ.
