The future is our choice At Atos, as the global leader in secure and decarbonized digital, our purpose is to help design the future of the information space. Together we bring the diversity of our people s skills and backgrounds to make the right choices with our clients, for our company and for our own futures.
Job Title: SQL Database Admin
Location: Bangalore/Chennai/Pune
Shift : 24X7 Rotational
Job Type: Hybrid
Job Description:
Knowledge of Failover clustering, SQL server AlwaysOn Groups, SQL server mirroring, SAN replication, and other high availability technologies
Ensure all database servers are backed up in a way that meets the business s Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business Recovery Time Objectives (RTO)
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
Configure SQL Server monitoring utilities to minimize false alarms.
As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies.
Install and configure new SQL Servers
Deploy database change scripts provided by third party vendors.
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
Document the company s database environment.
MSSQL DBA Job Requirements:
Experience on Microsoft SQL Server 2008,2012, 2014,2016,2017,2019,2022.
Production Support Activities (Installation, Upgradation and Troubleshooting).
T-SQL Scripts for Administration and Monitoring tasks.
Microsoft Clustering services (MSCS) knowledge- Install/Configure/support.
Relevant knowledge of the operating system (2008, 2012,2016,2019) as far as MS-SQL databases is concerned.
High Availability (Log shipping, Replication and Mirroring) - Always ON
User creation & maintenance, database log space monitoring and maintenance.
Good knowledge on Always on and high availability
Strong fundamentals of SQL.
Strong in SQL Architecture, Backup & Restore process.
Configuring CDC replication.
Configuring TDE in always on servers.
Knowledge on ITIL process.
Good communication, should be able to clarify issues with customer
Learn more about us At Atos, we embrace diversity as the ultimate engine of ingenuity for our clients, and we constantly strive to create a culture where people feel supported and encouraged. Read more about our commitment here .
Whether it is fighting climate change, promoting digital inclusion, or ensuring trust in data management tech for good sits at the core of our identity. With numerous global recognitions for our ESG practices, we are committed to building a better future for all by harnessing the power of technology. Learn more here
Q2.3. Golden Rules of account 4.what is Derivatives and types of derivatives 5.what is investment banking 6.what is hedge fund management 7.wha... read more
Q3.Tell me about yourself? Tell difference Between pointer and reference. Tell difference between truncate and delete. Project-related question... read more