Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and optimise databases, troubleshoot issues, and collaborate with engineering teams.
- Company: Public Sector organisation in Glasgow with a focus on innovation.
- Benefits: Competitive daily rate, hybrid work model, and potential contract extensions.
- Why this job: Join a dynamic team and make a real impact on database management.
- Qualifications: 5+ years of DBA experience, strong SQL skills, and AWS knowledge.
- Other info: Opportunity for career growth in a supportive environment.
The predicted salary is between 50000 - 80000 £ per year.
ASA Recruitment’s client, a Public Sector organisation in Glasgow, are currently looking to recruit a DBA on a hybrid basis, for an initial 6 month contract (with potential extensions) on a rate of up to £572/day outside of IR35 (based on experience).
Responsibilities
- Work closely with engineering teams and stakeholders to design schemas.
- Monitor, diagnose and remediate query performance issues.
- Peer-review operational SQL and propose and implement improved operational mechanisms – e.g. where SQL can be parameterised and moved to a Stored Procedure.
- Monitor, diagnose and remediate database related issues.
- Work closely with business users and information systems development stakeholders to provide database specifications in reference to storage, capacity and planning.
- DBA maintenance using replication techniques, availability and disaster recovery.
- Perform upgrades, migration and patching.
- Monitor database performance and troubleshoot issues such as job failures and index fragmentation.
- Maintain database security including creation of users and groups.
- Perform quality assurance of data solutions provided by external suppliers.
- Set standards for database administration, ensuring that procedures exist and are followed.
- Plan for backup and recovery of database information, ensuring backup is carried out as per plans, planning and managing exercises to prove recovery procedures.
- Ensure that recovery plans are tested regularly.
- Implement recovery procedures when necessary.
- Manage database resources, including allocation of system storage.
- Plan for future storage requirements, and prepare cases for additional resources.
- Ensure that database problems are investigated, diagnosed and resolved, referring to database users, other staff and suppliers as necessary.
- Bring existing operational SQL under SCM source control, managing its acceptance through the engineering pipeline.
- Support engineering and release colleagues in ensuring changes are successfully deployed to live, acting as point of contact on releases with database facing changes.
- Carry out full impact analysis of new software releases and recommend upgrade plans.
- Review upgrades and fixes available from system software suppliers and identify those which merit action.
- Design and develop user code to enhance or customise system software to satisfy business objectives and tailor system software to ensure maximum efficiency.
- Prepare software implementation procedures with fall back contingency plans.
- Ensure that new versions of system software are properly installed and thoroughly tested.
Essential Experience
- 5 yrs + experience of InnoDB in MySQL or MariaDB.
- Working knowledge of AWS data storage solutions, e.g. Aurora, RDS, DynamoDB.
- 5 yrs + experience of performance management and tuning, with regards to database schemas, indexes and SQL queries.
- Demonstrable experience of creating and reviewing SQL as part of a SCM-backed development lifecycle.
- Demonstrable experience of database, table, index, constraints schema creation and lifecycle.
- Demonstrable experience of creating Stored Procedures and Functions.
- Experience of working with wider engineering function to design and suggest improvements to new or existing services.
SQL Server DBA in Glasgow employer: ASA Recruitment
Contact Detail:
ASA Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Server DBA in Glasgow
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage with online communities. You never know who might have the inside scoop on a DBA role that’s perfect for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your database projects, performance tuning successes, and any cool SQL queries you've crafted. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common DBA scenarios. Think about how you’d handle performance issues or database migrations. Practising these responses will help you feel more confident when it’s time to shine.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities waiting for talented DBAs like you. Plus, it’s a great way to ensure your application gets the attention it deserves.
We think you need these skills to ace SQL Server DBA in Glasgow
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the SQL Server DBA role. Highlight your experience with InnoDB, AWS data storage solutions, and performance management. We want to see how your skills match what we're looking for!
Showcase Your Experience: In your application, don’t just list your responsibilities; showcase your achievements! Talk about specific projects where you improved database performance or implemented successful recovery plans. This helps us see the impact you've made.
Be Clear and Concise: When writing your application, keep it clear and concise. Use bullet points for easy reading and make sure to get straight to the point. We appreciate straightforward communication that highlights your key skills and experiences.
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it makes the whole process smoother for everyone involved.
How to prepare for a job interview at ASA Recruitment
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills, especially around performance management and tuning. Be ready to discuss your experience with InnoDB in MySQL or MariaDB, and have examples of how you've improved query performance or designed schemas.
✨Familiarise Yourself with AWS Solutions
Since the role involves working with AWS data storage solutions like Aurora and RDS, it’s crucial to understand these technologies. Prepare to talk about any hands-on experience you have with these services and how they can be leveraged for database management.
✨Prepare for Technical Questions
Expect technical questions that dive deep into your DBA experience. Think about scenarios where you've had to troubleshoot database issues or implement recovery procedures. Having specific examples will show your problem-solving skills and expertise.
✨Showcase Your Collaboration Skills
This role requires working closely with engineering teams and stakeholders. Be ready to discuss how you've collaborated in the past, particularly in designing schemas or implementing operational improvements. Highlight your communication skills and ability to work as part of a team.
