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

📌 SQL Database Administrator (Chennai)
🏢 Adecco
📍 Chennai