Our client is seeking a Junior - Mid Database Developer and Administrator to look after their Microsoft SQL Server environments and keep them stable, secure and fast.
You will also build on them. This means writing stored procedures, queries and integrations, and working with the development team on the database side of their vending and payment platforms.
It suits someone early in their career who enjoys both building with data and keeping systems running. You will work with the R&D Manager, Business Development Manager and Managing Director.
DUTIES:
Database development
Write and optimise T-SQL stored procedures, functions, views and triggers.
Design and maintain tables, schemas and data models.
Build data integrations, imports and exports between systems.
Work with developers on new features and changes that touch the database.
Build reports and data extracts for internal teams and clients.
Database administration
Maintain and monitor SQL Server environments.
Manage indexing, backups, restores, replication and database security.
Tune queries and keep databases stable and highly available.
Support servers with patching and upgrades.
Support and recovery
Troubleshoot incidents and help find the root cause.
Run and test backup and disaster recovery procedures.
Automation and documentation
Write scripts to automate maintenance and reporting.
Use source control and follow change processes for database releases.
Keep technical documentation and procedures up to date.
REQUIREMENTS:
Minimum:
Diploma or degree in Information Technology, Computer Science, Information Systems or a related field.
1 to 4 years' experience in database development, database administration or software development.
Strong SQL with hands-on Microsoft SQL Server experience.
Experience writing stored procedures and complex queries.
Ideal:
Programming experience in C# / .NET or Python.
Exposure to SQL Server administration, backups and performance tuning.
Experience with APIs, integrations or SSIS.
Git or other source control.
Microsoft SQL Server or Azure Data certifications.
Experience with transactional, payments or high-availability systems.