At a Glance
- Tasks: Manage and optimise Microsoft SQL databases to enhance performance and reliability.
- Company: Join an innovative company transforming the retail sector and customer experience.
- Benefits: Enjoy a dynamic work environment with opportunities for growth and development.
- Why this job: Make a real impact in a tech-driven organisation focused on continuous improvement.
- Qualifications: 3+ years in SQL roles, experience with large production systems, and database security practices.
- Other info: Opportunity for out-of-hours support and involvement in exciting product launches.
The predicted salary is between 36000 - 60000 Β£ per year.
Are you looking to settle and join an innovative company? If you are keen to make a real impact in a business intent on changing the face of the retail sector (and thus the end customer experience), then this could be the perfect opportunity for you!
The selected SQL DBA will have the following responsibilities:
- Maintenance, support and administration of live Microsoft SQL database environments
- Proactive monitoring & continuous improvement of systems to ensure availability, resilience & performance of databases plus associated applications & interfaces
- Modification & manipulation of large volume live transactional data for company & customer use within databases
- Investigation & resolution of database and/or associated environmental issues
- Out of hours on call escalation point for critical database related incidents
- Provide database design/query optimisation/solution support & reasoned advice
- Implementation and deployment of database changes
- Ensure all database servers continue to adhere to PCI-DSS, GDPR & data retention policies
Required skills and knowledge:
- Minimum of 3 yearsβ experience in a SQL centric role (SQL Server 2005 onwards)
- Using SQL Server Availability Groups or Log Shipping or Database Mirroring
- Experience of working on large volume live production systems
- Performance tuning
- High availability
- Database configuration and management
- Backups
- Applying database security practices
- Exposure to a technology led organization
- Private equity or plc exposure
- Product launch experience
Experience with the following would be an advantage:
- Competent with Windows operating system and high-level server/storage infrastructure.
- Experience using SSAS/SSRS/SSIS
- Experience writing PowerShell scripts
- Administering a Data Warehouse
- DR/Business Continuity
- Experience using MySQL or Postgres
Send us your CV or get in touch for further details on this exciting new opportunity!
SQL DBA employer: Endeavour Recruitment Solutions
Contact Detail:
Endeavour Recruitment Solutions Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land SQL DBA
β¨Tip Number 1
Familiarise yourself with the latest SQL Server features and best practices. Being up-to-date with advancements like Availability Groups or Log Shipping can give you an edge during discussions with us.
β¨Tip Number 2
Showcase your experience with performance tuning and high availability in your conversations. We value candidates who can demonstrate their ability to optimise database performance and ensure system resilience.
β¨Tip Number 3
Prepare to discuss your experience with large volume live production systems. We want to hear about specific challenges you've faced and how you resolved them, as this will highlight your problem-solving skills.
β¨Tip Number 4
If you have experience with PowerShell scripting or administering a Data Warehouse, be ready to talk about it. These skills are advantageous and can set you apart from other candidates in our selection process.
We think you need these skills to ace SQL DBA
Some tips for your application π«‘
Tailor Your CV: Make sure your CV highlights your experience in SQL-centric roles, particularly with Microsoft SQL Server. Emphasise your skills in performance tuning, database configuration, and management to align with the job requirements.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for the retail sector and how your skills can contribute to improving customer experience. Mention specific experiences related to database maintenance and support that demonstrate your capability.
Highlight Relevant Experience: In your application, focus on your experience with SQL Server Availability Groups, Log Shipping, or Database Mirroring. Provide examples of how you've handled large volume live production systems and any relevant performance tuning you've performed.
Showcase Continuous Improvement Mindset: Demonstrate your proactive approach to monitoring and improving database systems. Include examples of how you've resolved database issues or implemented changes that enhanced system resilience and performance.
How to prepare for a job interview at Endeavour Recruitment Solutions
β¨Showcase Your SQL Expertise
Be prepared to discuss your experience with SQL Server, particularly versions from 2005 onwards. Highlight specific projects where you've implemented solutions or optimised performance, as this will demonstrate your hands-on knowledge and problem-solving skills.
β¨Understand the Companyβs Vision
Research the companyβs goals in transforming the retail sector. Be ready to articulate how your role as a SQL DBA can contribute to enhancing customer experience and operational efficiency, showing that you align with their mission.
β¨Prepare for Technical Questions
Expect questions on database management, performance tuning, and high availability strategies. Brush up on concepts like SQL Server Availability Groups, Log Shipping, and Database Mirroring, as these are crucial for the role.
β¨Demonstrate Problem-Solving Skills
Be ready to discuss past incidents where you resolved database issues or improved system performance. Use the STAR method (Situation, Task, Action, Result) to structure your answers, showcasing your analytical thinking and proactive approach.