Lead MS SQL DBA
- Atos
- 9 - 14 years
- Pune
- 3 days ago
- Email to a friend
- Report this job
Job Description
Location: Bangalore, Pune, Mumbai & Chennai
Experience: 8+ years
Max CTC: 18 to 20 LPA
Notice period: Immediate to 30 Days
Job Description:
A Microsoft SQL Server DBA is responsible for overseeing database administration activities, ensuring high availability, performance, and security while guiding a team of DBAs. Heres a structured job description:
Job Title: MSSQL DBA
Key Responsibilities:
- Database Administration & Performance Tuning
- Oversee installation, configuration, and maintenance of SQL Server databases.
- Optimize database performance using indexing, query tuning, and partitioning.
- Monitor and troubleshoot database issues, ensuring minimal downtime.
- High Availability & Disaster Recovery
- Manage Always On Availability Groups, replication, and failover clustering.
- Develop and implement backup and recovery strategies using RMAN and log shipping.
- Ensure compliance with disaster recovery policies.
- Security & Compliance
- Implement Transparent Data Encryption (TDE) and Always Encrypted for data protection.
- Manage user roles, permissions, and authentication mechanisms.
- Conduct security audits and ensure compliance with industry standards.
- Team Leadership & Collaboration
- Lead and mentor a team of DBAs, providing technical guidance and training.
- Collaborate with developers, system administrators, and business stakeholders.
- Define best practices and standard operating procedures for database management.
- Automation & Monitoring
- Develop automation scripts for database maintenance using PowerShell and SQL Agent Jobs.
- Utilize SQL Server Profiler, Extended Events, and Query Store for monitoring.
- Implement proactive alerting and monitoring solutions.
Required Skills & Qualifications:
- Experience: 7+ years in SQL Server database administration, with 2+ years in a leadership role.
- Technical Expertise: Strong knowledge of SQL Server 2016/2019/2022, SSMS, T-SQL, and performance tuning.
- High Availability: Hands-on experience with Always On, failover clustering, and replication.
- Security & Compliance: Familiarity with GDPR, HIPAA, and PCI DSS compliance.
- Leadership: Proven ability to lead and mentor a team, manage projects, and collaborate across departments.
Preferred Certifications:
- Microsoft Certified: Azure Database Administrator Associate
- Microsoft Certified: SQL Server DBA
24x7 suppport
2. Patching & Upgrades
- Plan and execute SQL Server patching and service pack upgrades with minimal downtime.
- Perform pre-patch validation and post-patch testing to ensure system stability.
- Automate patch deployment using PowerShell and SQL Agent Jobs.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: IT & Information SecurityRole Category: IT Infrastructure ServicesRole: IT Infrastructure Services - OtherEmployement Type: Full timeContact Details:
Company: AtosLocation(s): Pune
Keyskills: MS SQL DBA High Availability Ms Sql Server Administration Performance Tuning
Similar positions
Atos
BOUNCE is an Indoor Action Adventure Park combining elements of the worlds most exciting freestyle activities. BOUNCE is spread over 40,000 sq. ft., made up more than 100 wall-to-wall Trampolines, Free jumping arena, X-park, Cliff jump, Slam Dunk, Big Bag, Zip Line, miniBounce zone and over 20 ex...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in