SQL Database Administrator

Adecco; Tamil Nadu; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Adecco is assisting a Canada-based client with a product-focused role to hire a SQL DBA in Chennai. The position requires 5–10 years of hands-on experience with SQL Server, Azure SQL, and performance tuning.

You will install, secure, and optimize databases across development, testing, and production environments, implement HA/DR, automate tasks with PowerShell, and collaborate with global teams to support business initiatives.

Qualifications

• 5–10 years of experience with Microsoft SQL Server
• Experience with Azure SQL databases
• Proficient in T-SQL, query optimization, indexing
• Experience in backups, DR, HA using Always On
• Security practices: TDE, auditing, and compliance

Responsibilities

• 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 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.
• Configure, monitor, troubleshoot, and optimize SQL Server Always on Availability Groups and clustering solutions.
• Develop, document, and implement backup and recovery strategies.
• Monitor database performance and optimize queries, indexing, and configurations.
• Implement and manage database security controls (TDE, CDC, auditing).
• Develop and enhance database monitoring solutions and automate routine tasks using PowerShell.
• Collaborate with CloudOps, Development, and Infrastructure teams; support global teams.

Skills

SQL Server

Azure SQL

PowerShell

Performance tuning

Security

Tools

SQL Server Management Studio

SSIS

Job description

Company : Client of Adecco -Canada Based MNC product company

Title: SQL DBA

Experience : 5-10 Years

Location: Chennai

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.

Collaboration

• Work closely with CloudOps, Development, and Infrastructure teams to support business initiatives.
• Collaborate effectively with global teams across North America, EMEA, and APAC