2931 – Junior Database Administrator

Prosource.It; Aberdeen City; On-site; GBP 70,000 - 96,000; Full time

Job summary

prosource.it is seeking a hands-on Database Administrator to support and optimise a large enterprise SQL Server estate. You will investigate issues, maintain secure, high-performing environments and contribute to ongoing improvements with cross-functional teams.

The role involves on-site attendance in Aberdeen or London with flexible on-site options. You'll work across BAU operations and continuous improvement, ensuring reliability and scalable database performance.

Qualifications

• Practical experience administering Microsoft SQL Server environments.
• Strong SQL and T-SQL knowledge.
• Good understanding of core database administration principles.
• Experience with database backup, restore and recovery processes.
• SQL Server performance troubleshooting experience.
• Understanding of database security, user management and permissions.
• Strong problem-solving and troubleshooting skills.
• Good communication and documentation skills.
• Experience working within structured operational processes including incidents, changes and service requests.

Responsibilities

• Support the administration and maintenance of Microsoft SQL Server databases.
• Monitor database health, availability, performance and capacity.
• Investigate and resolve database incidents, service requests and operational issues.
• Perform backup, restore and recovery activities.
• Support database patching, upgrades and routine maintenance.
• Troubleshoot SQL performance issues, including long-running queries, blocking and resource utilisation.
• Manage database security, user access and permissions.
• Assist with database deployments and environment changes.
• Maintain technical documentation, operational procedures and support records.
• Identify opportunities to improve and automate repetitive DBA activities.
• Collaborate with application, infrastructure and data teams to resolve technical issues.
• Escalate complex issues appropriately while contributing to their resolution.

Skills

Microsoft SQL Server

SQL & T-SQL

DB administration

Backups & recovery

Performance troubleshooting

Security & permissions

Troubleshooting

Documentation

Incidents & changes

Tools

Azure SQL Database

Azure SQL Managed Instance

Always On / HA techs

Monitoring tools

PowerShell scripting

Azure DevOps / CI/CD

Job description

A growing data and technology team is looking for a Database Administrator to support the day-to-day operation, maintenance and continuous improvement of a large enterprise database estate. This role would suit someone with solid Microsoft SQL Server experience who enjoys hands-on database administration, troubleshooting technical issues, and working closely with application, infrastructure and data teams. You'll join an established database function where you'll help maintain a stable, secure and high-performing environment while contributing to ongoing improvement and optimisation initiatives.

Location: Aberdeen or London with regular weekly attendance ideally preferred, but flexibility allowing for ad hoc on-site attendance will be considered for the right candidate

Contract Type: Contract

Contractors: Competitive day rate available for suitable candidates

The Person

You'll be a hands-on database professional who enjoys investigating issues, improving processes and working collaboratively across technical teams. Equally comfortable supporting BAU operations and contributing to continuous improvement, you'll bring a proactive approach and a desire to help maintain a robust and reliable database estate.

What you'll do

• Support the administration and maintenance of Microsoft SQL Server databases
• Monitor database health, availability, performance and capacity
• Investigate and resolve database incidents, service requests and operational issues
• Perform backup, restore and recovery activities
• Support database patching, upgrades and routine maintenance
• Troubleshoot SQL performance issues, including long-running queries, blocking and resource utilisation
• Manage database security, user access and permissions
• Assist with database deployments and environment changes
• Maintain technical documentation, operational procedures and support records
• Identify opportunities to improve and automate repetitive DBA activities
• Collaborate with application, infrastructure and data teams to resolve technical issues
• Escalate complex issues appropriately while contributing to their resolution

What to bring

Essential

• Practical experience administering Microsoft SQL Server environments
• Strong SQL and T-SQL knowledge
• Good understanding of core database administration principles
• Experience with database backup, restore and recovery processes
• SQL Server performance troubleshooting experience
• Understanding of database security, user management and permissions
• Strong problem-solving and troubleshooting skills
• Good communication and documentation skills
• Experience working within structured operational processes including incidents, changes and service requests

Desirable

• Azure SQL Database and/or Azure SQL Managed Instance experience
• SQL Server Always On or other high-availability technologies
• Experience using database monitoring and performance management tools
• PowerShell or scripting/automation experience
• Azure DevOps or CI/CD pipeline exposure
• Microsoft Azure knowledge
• Experience working within enterprise data platform environments
• Oracle database exposure

Why prosource.it?

Technology is constantly evolving, and so are we.

Since our beginnings as a managed IT services provider, prosource.it has grown alongside the organisations we support, adapting to changing technologies and business needs. Today, we deliver a broad range of technology and business services that help clients plan, implement and embrace change successfully.

While technology is at the heart of what we do, we know that delivering lasting value takes more than technical expertise alone. By combining innovative thinking with practical experience and strong client partnerships, we help organisations realise the full potential of their technology investments. From adopting emerging technologies and delivering complex transformation programmes to improving day-to-day operations, we focus on achieving outcomes that make a measurable difference. As technology continues to evolve, we're committed to staying at the forefront of change, helping our clients embrace new opportunities and shape what's next.

We've built our reputation on being knowledgeable, approachable and easy to work with. Our people bring a wealth of skills and experience, united by a shared commitment to doing the right thing for our customers. With a culture built on teamwork, accountability and trust, our people are empowered to work in a way that makes a meaningful impact.

If you're looking for a role where you can make a difference, develop professionally and be part of a team that is helping organisations navigate an ever-changing technology landscape, we'd love to hear from you.