MS SQL DBA Senior Software Engineer

About Sopra Steria
Sopra Steria, a major Tech player in Europe with 50,000 employees in nearly 30 countries, is recognised for its consulting, digital services and solutions. It helps its clients drive their digital transformation and obtain tangible and sustainable benefits. The Group provides end-to-end solutions to make large companies and organisations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a collaborative approach. Sopra Steria places people at the heart of everything it does and is committed to putting digital to work for its clients in order to build a positive future for all. In 2024, the Group generated revenues of €5.8 billion.
The world is how we shape it.

Key Responsibilities:

Database Monitoring & Maintenance

Monitor SQL Server performance (CPU, memory, I/O).

Review failed jobs, long-running queries, and system alerts.

Perform routine health checks using tools like SSMS and Foglight.

Backup & Restore

Ensure regular backups are completed and verified.

Perform basic restore operations as needed.

User Access & Security

Manage user accounts, logins, and permissions.

Support compliance with data security policies.

Routine Maintenance

Rebuild/reorganize indexes and update statistics.

Clean up logs and old data.

Deployment Support

Assist in applying database changes or running scripts.

Document changes and use PowerShell as needed.

Developer Support

Help write/debug SQL queries.

Assist in testing/troubleshooting in dev/UAT environments.

Knowledge & Documentation:

Understand basic database design (normalization, keys, relationships).

Automate recurring tasks with T-SQL or PowerShell.

Maintain documentation and support audit requirements.

Tools & Technologies:

SQL Server Management Studio (SSMS)

Foglight (or similar monitoring tools)

PowerShell (basic scripting)

Ticketing tools (e.g., Jira, ServiceNow)

Total Experience Expected: 02-04 years

B.Tech

The candidate should be willing to participate in on-call support, which typically occurs outside of regular office hours. They must also be open to traveling on-site if required.

At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.

All of our positions are open to people with disabilities.