SQL DBA Engineer
Job Summary
Atosis 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 54000 employees serving over 4500 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 Groupis a global leader in digital transformation with c. 56000 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 ServerR2 .
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 DMVs 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-.If you have any questions please contact our recruitment partnerMeyeppan M on LinkedIn
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.
Required Experience:
IC
About Company
Atos is a global leader in digital transformation with over 110,000 employees in 73 countries and annual revenue of over € 11 billion. European number one in Cloud, Cybersecurity and High-Performance Computing, the Group provides end-to-end Orchestrated Hybrid Cloud, Big Data, Busines ... View more