About the job
qodeworld is seeking a Lead SQL Server Operations DBA to join the team in Karnataka, India. This position requires a seasoned database administrator with a minimum of five years managing SQL Server environments, ready to take on a leadership role.
Key Responsibilities
- Install and configure Microsoft SQL Server instances, focusing on versions 2022, 2019, and 2016. Set up AlwaysOn availability groups and failover clustering.
- Design databases and create T-SQL solutions to address business requirements.
- Manage backup and recovery strategies, maintain database security and integrity, and oversee physical data storage design.
- Configure and manage SQL Server security settings in line with best practices.
- Advise on system designs that align with Microsoft SQL Server standards.
- Lead disaster recovery planning and execution.
- Create, update, and optimize SQL Server Agent jobs and maintenance plans.
- Monitor ongoing maintenance tasks and troubleshoot issues promptly.
- Analyze and tune complex SQL queries for improved performance.
- Supervise database migrations and server upgrades.
- Develop, maintain, and optimize SSIS packages for ETL processes.
- Prepare data for visualization and support Business Intelligence analysis.
- Integrate SQL Server with other enterprise applications.
Requirements
- At least 5 years of experience in SQL Server administration and operations.
- In-depth knowledge of Microsoft SQL Server 2022, 2019, and 2016.
- Proven skills in database design, T-SQL development, and performance tuning.
- Hands-on experience with AlwaysOn availability groups, failover clustering, and SSIS for ETL processes.
This role is based in Karnataka, India.

