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
