23 Aug
|
Adecco
|
Chennai
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
📌 SQL Database Administrator (Chennai)
🏢 Adecco
📍 Chennai