SQL DBA - L3 Consultant

Bodhayana Consulting; Chennai District; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Bodhayana Consulting seeks a seasoned SQL DBA to manage and optimize SQL Server and Azure SQL environments. You will handle upgrades, backups, performance tuning, and DR planning while collaborating with developers on SSIS/SSRS/SSAS projects.

The role emphasizes security, compliance, and strong problem-solving in a hybrid cloud setup across on-prem and Azure options. Chennai-based opportunity in India.

Qualifications

• MS SQL DBA with L3 level experience.
• PostgreSQL L2 level experience.
• Administer, maintain, and optimize SQL Server databases (2008R2/2012/2014/2016/2019/2022) and Azure SQL environments.
• Perform database upgrades, migrations, backups, restores, and patching.
• Monitor performance and implement tuning strategies for high availability and scalability.
• Design and implement disaster recovery solutions using Always On, Log Shipping, SQL Replication and Geo-Replication.
• Automate routine tasks using PowerShell, T-SQL, and Azure automation tools.
• Collaborate with development teams to support SSIS, SSRS, and SQL-based applications.
• Ensure database security, compliance, and access control across environments.
• Troubleshoot complex issues related to connectivity, performance, and data integrity.
• Participate in capacity planning and infrastructure reviews.
• Document procedures, configurations, and best practices.
• Experience with Azure services: Azure SQL Managed Instance, Azure PAAS DBs.
• Proficiency in performance tuning, query optimization, and indexing strategies.
• Hands-on experience with backup/restore strategies and disaster recovery planning.
• Familiarity with cloud migration tools and hybrid environments.
• Scripting skills in PowerShell and T-SQL.
• Knowledge of SSIS, SSRS, and SSAS.
• Excellent problem-solving and communication skills.
• Understanding of data governance and compliance frameworks.

Responsibilities

• MS SQL DBA L3 level responsibilities for enterprise SQL Server and Azure SQL environments.
• Managing upgrades, migrations, backups, restores, and patching across versions.
• Monitoring performance and applying tuning for HA and scalability.
• Designing disaster recovery using Always On, Log Shipping, Replication, Geo-Replication.
• Automating tasks with PowerShell, T-SQL, and Azure automation.
• Supporting SSIS/SSRS/SQL-based applications with Dev teams.
• Ensuring security, compliance, and access control across environments.
• Troubleshooting connectivity, performance, and data integrity issues.
• Participating in capacity planning and infra reviews.
• Documenting procedures, configurations, and best practices.
• Experience with Azure SQL Managed Instance and PAAS DBs.
• Indexing strategies and query optimization.
• Backup/restore strategies and DR planning.
• Familiarity with cloud migration tools and hybrid environments.
• Scripting in PowerShell and T-SQL.
• Knowledge of SSIS/SSRS/SSAS.
• Strong problem-solving and communication skills.
• Understanding data governance frameworks.

Skills

MS SQL DBA

Performance tuning

Data integrity

Security & compliance

Problem solving

Tools

SQL Server

Azure SQL

PowerShell

T-SQL

SSIS

SSRS

SSAS

Azure automation

Job description

Key Responsibilities:

• MS SQL DBA L3 level experience
• Postgre SQL L2 Level experiences
• Administer, maintain, and optimize SQL Server databases (2008R2/2012/2014/2016/2019/2022) and Azure SQL environments
• Perform database upgrades, migrations, backups, restores, and patching
• Monitor performance and implement tuning strategies for high availability and scalability
• Design and implement disaster recovery solutions using Always On, Log Shipping, SQL Replication and Geo-Replication
• Automate routine tasks using PowerShell, T-SQL, and Azure automation tools
• Collaborate with development teams to support SSIS, SSRS, and SQL-based applications
• Ensure database security, compliance, and access control across environments
• Troubleshoot complex issues related to connectivity, performance, and data integrity
• Participate in capacity planning and infrastructure reviews
• Document procedures, configurations, and best practices
• Experience with Azure services: Azure SQL Managed Instance, Azure PAAS DBs
• Proficiency in performance tuning, query optimization, and indexing strategies
• Hands-on experience with backup/restore strategies and disaster recovery planning
• Familiarity with cloud migration tools and hybrid environments
• Scripting skills in PowerShell and T-SQL
• Knowledge of SSIS, SSRS, and SSAS
• Excellent problem-solving and communication skills
• Understanding of data governance and compliance frameworks