companyqodeworld logo

Lead SQL Server Operations DBA

qodeworldKarnataka, Karnataka, India
On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Unlock Your Potential

Generate Job-Optimized Resume

One Click And Our AI Optimizes Your Resume to Match The Job Description.

Is Your Resume Optimized For This Role?

Find Out If You're Highlighting The Right Skills And Fix What's Missing

Experience Level

Experience

Qualifications

The ideal candidate will possess:Extensive experience in database design and development, including:Database design using various objects such as Packages, Procedures, Functions, and Triggers. Proficiency in T-SQL procedures development, compilation, and debugging. Expertise in database troubleshooting, performance tuning, and logical/physical database modeling. Strong experience in database performance, maintenance, and management, including:Database management for backups, recovery, and maintenance. Export, import, and mass data loads management. Analysis and generation of table and index statistics. Monitoring and resolving data lock issues. Creating indexes to optimize dataset response times for sensitive reports. A solid understanding of security concepts and best practices for Microsoft SQL Server databases. Familiarity with version control tools like SVN or Git. Knowledge of programming or scripting languages such as C# and PowerShell.

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.

About qodeworld

qodeworld is a leading technology solutions provider committed to delivering innovative software solutions that empower businesses to achieve their goals. We pride ourselves on our collaborative work environment and our focus on professional development.

Similar jobs

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.