At a Glance
- Tasks: Support and manage Microsoft SQL Server for large-scale projects, ensuring optimal performance and security.
- Company: Join Atos, a global leader in digital transformation and cybersecurity.
- Benefits: Enjoy a competitive salary, private medical cover, and generous leave policies.
- Other info: Diversity and inclusion are at our core; we welcome all applicants.
- Why this job: Make an impact in a dynamic environment while working with cutting-edge technology.
- Qualifications: Experience with SQL Server and strong problem-solving skills are essential.
The predicted salary is between 72000 - 88000 £ per year.
Atos is the Atos Group brand dedicated to AI-powered, secure, end-to-end digital services.
Atos designs, develops, and operates critical digital environments that drive performance, resilience and sovereignty, helping public and private organizations worldwide retain control over their data and infrastructures, while meeting regulatory requirements.
With more than 54,000 employees serving over 4,500 clients across 54 countries, Atos helps modernize core IT systems, accelerate cloud and data transformation, strengthen cybersecurity, and deliver secure digital workplace environments to support its clients, its employees and society.
Atos also provides consulting and advisory services through its Atos Amplify brand.
A trusted partner in operating complex and mission-critical environments, Atos supports organizations across highly regulated and sovereign contexts.
About Atos Group
Atos Group is a global leader in digital transformation with c. 56,000 employees and annual revenue of c. €7.2 billion (at the go-forward perimeter), operating in 54 countries under two brands - Atos for services and Eviden for products and systems.
European number one in cybersecurity and a leader in cloud, Atos Group is committed to a secure and decarbonized future and provides tailored AI-powered, end-to-end solutions for all industries.
Atos Group is listed on Euronext Paris.
As a SQL Specialist you will be involved with large scale customer infrastructure transition and transformation projects relating to specific customer infrastructure systems and associated software, ensuring that the service provided to Atos customers meets the requirements set out in the project definition.
Responsibilities will include
- Microsoft SQL Server support, implementation and deployment
- Thoroughly investigate and resolve problems to a highly technical standard
- Plan and undertake changes to software/hardware as agreed with the customer
- Assess user requirements and formulate technical specifications that are cost effective and accurately meet the identified needs of the customer
- Install and test SQL Server software and associated products in conjunction with application providers to ensure that each element of a project performs to specification
- Contribute to the implementation of new and modified systems in conjunction with clients to achieve identified benefits
- Implement and maintain a standard methodology for the planning and installation of infrastructure
- Prepare and produce systems documentation in accordance with current Atos processes and standards
- Ensure that all development and maintenance work is undertaken in accordance with ITIL change management process Effectively monitor specific infrastructure services and identify improvements and preventative maintenance interventions.
BAU Support DBA
DBA will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modelling in support of multiple development teams.
The data warehouse supports an enterprise application suite of program management tools.
Must be capable of working independently and collaboratively.
Responsibilities
- Installing and configuring the SQL Server 2005, 2008, 2008R2, 2012,2014,2016,2017.
- Applying SQL Server patches and hot fixes.
- Verifying and resolving the SQL Server Blocking issues and finding and fixing the root cause.
- Resolving the Disk space issues and finding the root cause and permanent fixes.
- Expertise in Database backup, Recovery, Restoration and Disaster Recovery Plans.
- Restoring the Databases from Production to test environment and vice versa.
- User Management activities like adding the user and managing the permissions.
- Creating and scheduling the jobs and troubleshooting the failed jobs.
- Performance tuning activities like verifying the slow running queries and identifying missing indexes and usage of statistics.
- Usage of DBCC commands and DMV’s for troubleshooting.
- Executing the deploying the scripts in prod environment.
- Configuring, monitoring and troubleshooting the REPLICATION and DR activities
Essential / Minimum Criteria
- Previous Microsoft SQL Server project experience including infrastructure implementation and deployment
- Excellent understanding of SQL infrastructures (including 2008 - 2019)
- Well established experience in patching and upgrading SQL versions
- Preferably MCSE certified
- Minimum 3 years of parallel experience in setting up and maintaining production Microsoft SQL Server instances.
- Strong knowledge of SQL Database Performance Tuning
- Strong knowledge in installing/managing SQL failover clustering, configuring log shipping and mirroring
- Strong knowledge of database backup and recovery technologies, with experience of implementing and maintenance
- Good experience in replication set up and DTS/SSIS
- Configuration of database monitoring using SQL native or third-party software
- Experience of large scale infrastructure transition and transformation projects
- Installation and configuration of SQL Reporting Services, SQL Management Studio and other software /tools
- Set up database backup and perform database recovery when required
- DB Upgrade, DB migrations and patching of existing SQL databases
- Optimize SQL Database performance and guide application team to tune SQL queries
- Automation of database related activities
- Excellent communication skills
- Strong documentation skills
- Customer and delivery focused
Desirable Criteria
- Microsoft Certification
· Knowledge of Oracle, and DB2 LUW database technologies
· Knowledge of Windows Server configuration
Benefits
- Pension Scheme - contributions matched up to 10%
- Private medical cover
- Income Protection
- Life Assurance
- 25 days paid leave + National Holidays
- Flex benefits program
Please note eligibility for SC clearance is essential for this role.
As a Disability Confident employer, we encourage applications from all applicants, especially, differently abled applicants.
We aim to ensure that those who meet the minimum criteria for this position will be offered an interview.
We are committed and willing to making reasonable adjustments to the application and assessment process to accommodate your needs.
We are a care leaver friendly employer, if you require additional support with your application, please contact our recruiter or send an email to our dedicated mailbox
UK-Recruitment-Support@atos. net . If you have any questions, please contact our recruitment partner
Meyeppan M on Linked In
Here at Atos, diversity and inclusion are embedded in our DNA.
Read more about our commitment to a fair work environment for all.
Atos is a recognized leader in its industry across Environment, Social and Governance (ESG) criteria.
Find out more on our CSR commitment.
Choose your future. Choose Atos.
SQL DBA Engineer in Aberdeen employer: Atos
Atos is an exceptional employer that prioritises innovation and strategic leadership within the National Security, Safety and Energy sectors. With a strong commitment to employee growth, a collaborative work culture, and comprehensive benefits including a pension scheme and medical cover, Atos provides a rewarding environment for professionals looking to make a significant impact in their field. Located in the UK, this role offers unique opportunities to influence industry trends and drive technological advancements.
StudySmarter Expert Advice🤫
We think this is how you could land SQL DBA Engineer in Aberdeen
✨Tap into Local Tech Meetups
Get yourself to local tech meetups or database management conferences. It's a really great way to meet industry professionals and potentially uncover unadvertised full-time roles. When chatting with people, mention your skills and interests in database management; you never know who might be looking for someone just like you!
✨Contribute to Open Source Projects
Diving into open-source projects can not only sharpen your database skills but also get you noticed by employers. Many companies look for candidates who actively contribute to projects – it shows initiative and a real passion for the field. Plus, it's a perfect excuse to connect with other developers and expand your professional network.
✨Utilise Professional Bodies
Sign up for professional bodies related to database management, like the British Computer Society. They often host events and networking opportunities that can lead directly to job openings in the full-time market. Plus, it adds a nice touch to your professional profile!
✨Showcase Your Skills in a Public Portfolio
As you’re on the hunt for that full-time role, make sure to have a public portfolio that displays your best database projects. This can easily set you apart from the competition. And when you apply for roles, definitely mention it – it shows employers you mean business and are proud of your work!
We think you need these skills to ace SQL DBA Engineer in Aberdeen
Some tips for your application 🫡
Show off your database skills:When applying for a full-time role in database management, it’s super important to highlight your skills with specific database technologies like SQL, NoSQL, or any relevant data visualisation tools. We want to see how you've used these tools in real projects, so don't shy away from detailing your hands-on experience!
Tailor your CV for data:Make sure your CV is structured clearly, focusing on your previous experience in database management. Use specific metrics to demonstrate your impact, like how you improved data retrieval times or reduced errors. This isn't just about what you've done; it’s about what you’ve achieved with your skills!
Craft a compelling cover letter:In your cover letter, share what excites you about database management and how you can contribute to Atos. Mention any relevant projects where you tackled challenges or implemented new solutions. Let us know why you want to join our team and how your passion aligns with our goals.
Document your projects:If you've worked on interesting database projects—maybe during your studies or in previous roles—be sure to include those in your application. If you can, link to a portfolio or GitHub repo where we can see examples of your work. Having a tangible showcase of your skills will really make your application stand out!
How to prepare for a job interview at Atos
✨Brush Up on Database Tools
Make sure you're well-versed with popular database management systems like MySQL, PostgreSQL, or MongoDB. Incorporating real-world examples of how you've used these tools in past projects will show that you can put theory into practice, which is something Atos will definitely appreciate.
✨Know Your SQL Inside Out
Get ready for some technical questions focused on SQL queries and database design. We should anticipate coding challenges where you might need to optimise queries or design a database schema on the spot. Practising these problems will build our confidence to impress in the interview.
✨Demonstrate Problem-Solving Skills
Besides just technical know-how, be prepared to answer scenario-based questions that test your critical thinking and problem-solving abilities. Think about how you would approach data integrity issues or handle performance bottlenecks — Atos will want to see your analytical side!
✨Show Your Collaboration Spirit
Since this is a full-time role, it's crucial to highlight how you've collaborated with cross-functional teams or contributed to team projects in the past. Emphasising our interpersonal skills will demonstrate that you’re not just a tech wizard, but also a team player who fits well with Atos's culture.
