SQL DBA Engineer - Data Warehouse & Performance

Atos; United Kingdom; On-site; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Pension Scheme - matched up to 10%

Private medical cover

Income Protection

Life Assurance

25 days paid leave + holidays

Flex benefits program

Job summary

Atos is seeking an experienced SQL Specialist/DBA to support SQL Server environments, ensure operational readiness, and perform data modelling for enterprise projects. You will work on database security, health, and performance for a large-scale data warehouse and coordinate with multiple development teams.

The role requires hands-on experience with SQL Server versions 2005-2019, clustering, log shipping, SSIS, SSRS, and strong problem-solving skills. Eligibility for SC clearance applies.

Qualifications

• 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
• 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

Responsibilities

• Installing and configuring the SQL Server versions across environments.
• Applying SQL Server patches and hot fixes.
• Verifying and resolving SQL Server blocking issues and root-cause analysis.
• Resolving disk space issues and implementing permanent fixes.
• Expertise in database backup, recovery, restoration and DR planning.
• Restoring databases between production and test environments.
• User management and permissions control.
• Creating and scheduling jobs; troubleshooting failed jobs.
• Performance tuning: slow queries, indexing, and statistics.
• Using DBCC commands and DMVs for troubleshooting.
• Deploying scripts in production environments.
• Configuring, monitoring and troubleshooting replication and DR activities

Skills

SQL Server

Performance Tuning

Replication setup

SSIS/DTS

Backup and Recovery

Failover Clustering

Patching Upgrades

Communication skills

Documentation skills

Customer focus

Education

MCSE certification

Tools

SQL Server Management Studio

SQL Server Reporting Services

DTS/SSIS

Oracle

DB2 LUW

Job description

Atos is seeking an experienced SQL Specialist/DBA to support SQL Server environments, ensure operational readiness, and perform data modelling for enterprise projects. You will work on database security, health, and performance for a large-scale data warehouse and coordinate with multiple development teams.

The role requires hands-on experience with SQL Server versions 2005-2019, clustering, log shipping, SSIS, SSRS, and strong problem-solving skills. Eligibility for SC clearance applies.