🎁 Before you apply, rehearse this interview. Create your free WorkMundi account and get an Interview Training on HelpsYouSpeak — no cost, no card. I want my training →
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