Database Administrator

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