SQL Database Administrator

Adecco; Chennai District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Adecco is recruiting for a SQL DBA on behalf of a Canada-based MNC product company in Chennai. The role covers on-premises SQL Server administration, Azure SQL management, and strong focus on performance, security, and high availability across development, testing, and production environments.

You will implement backups, disaster recovery, optimization, and monitoring, and collaborate with CloudOps and global teams. PowerShell automation will be used to enhance operations and reliability.

Qualifications

• 5-10 years experience as SQL DBA.
• Experience administering on-premises SQL Server and Azure SQL.
• Familiarity with Always On, backups, DR, and security controls.

Responsibilities

• Install, configure, and maintain SQL Server databases across environments.
• Manage Azure SQL Databases and storage resources.
• Tune performance, optimize T-SQL queries, and indexing strategies.
• Implement backups, DR plans, and recovery procedures.
• Ensure security controls and compliance for databases.
• Monitor, automate, and streamline DB operations.
• Collaborate with cross-functional and global teams.

Skills

SQL Server

Azure SQL

Always On Availability Groups

Performance tuning

Backup & Disaster Recovery

T-SQL

PowerShell

Security & Compliance

Monitoring & Automation

Tools

Azure SQL Database

Job description

Company : Client of Adecco -Canada Based MNC product company

Title: SQL DBA

Experience : 5-10 Years

Key Responsibilities:

Database Administration & Implementation

• Install, configure, administer, and maintain on-premises Microsoft SQL Server databases across development, testing, and production environments.
• Configure, tune, and manage Azure SQL Databases and associated storage resources.
• Apply data modeling techniques to support integration, scalability, and performance requirements.
• Participate in database upgrades, migrations, and infrastructure improvement initiatives.
• Ensure high levels of database performance, availability, reliability, and security.

High Availability & Disaster Recovery

• Configure, monitor, troubleshoot, and optimize SQL Server Always on Availability Groups and clustering solutions.
• Develop, document, and implement backup and recovery strategies.
• Ensure disaster recovery readiness and data protection standards are maintained.

Performance Tuning & Optimization

• Monitor database performance and proactively identify bottlenecks and optimization opportunities.
• Analyze and optimize T‑SQL queries, indexing strategies, and database configurations.
• Review deployment scripts and provide recommendations to improve performance and reliability.
• Utilize native SQL Server and 3rd party monitoring and troubleshooting tools to optimize database performance.

Security & Compliance

• Implement and manage database security controls, including Transparent Data Encryption (TDE), Change Data Capture (CDC), and auditing capabilities.
• Manage user access, permissions, and database security policies.
• Support compliance with organizational security standards and best practices.

Monitoring & Automation

• Develop and enhance database monitoring solutions to improve visibility and operational efficiency.
• Automate routine database administration tasks using PowerShell and other appropriate tools.
• Continuously improve database operations, maintenance procedures, and documentation.
• Support capacity planning and resource utilization analysis.

Troubleshooting & Support

• Diagnose and resolve production database issues in support of service‑level objectives.
• Support application development teams with database design, query optimization, and troubleshooting.
• Perform scheduled maintenance and support release deployment activities as required.
• Follow and participate in Explorance development standards and guidelines.
• Work closely with CloudOps, Development, and Infrastructure teams to support business initiatives.
• Collaborate effectively with global teams across North America, EMEA, and APAC