Job Summary:

We are looking for a highly skilled MS SQL DBA + Developer (L3) who is independent, proactive, and capable of guiding stakeholders in projects. The ideal candidate should be well-versed in database optimization, performance tuning, automation, security, and monitoring while adhering to best practices.

Key Responsibilities:

• Optimization: Optimize SQL queries and overall database performance while guiding development teams on best practices for indexing, archiving, and script optimization. Provide recommendations for query and DBA-level optimizations to enhance execution time.

• Performance Tuning: Fine-tune database performance through appropriate parameter settings, including DOP, Parallelism, Log Shipping, and Shrinking. Identify and resolve performance bottlenecks at the database level.

• Reporting: Generate and publish daily database health reports, providing insights on database growth, critical logs, and backup history.

• Automation: Automate DBA-related tasks to reduce human errors and implement scripts and tools to streamline database operations.

• Maintenance: Track and manage database maintenance activities to ensure smooth functioning and timely backups.

• Security Management: Strengthen database security configurations by performing timely security patching and managing user accounts. Protect databases from vulnerabilities and unauthorized access.

• Monitoring & Proactive Issue Resolution: Actively monitor production databases using both reactive and proactive techniques. Develop monitoring reports and automation tools to detect issues before they impact operations, preventing unexpected downtimes by addressing potential risks in advance.

Qualifications and Skills:

• Bachelor’s or Master’s degree in Computer Science, IT, or a related field.
• 9-11 years of experience in MS SQL DBA and Developer.
• Expertise in SQL optimization, indexing strategies, and query performance tuning.
• Strong knowledge of database security best practices.
• Hands-on experience with Log Shipping, Backup Strategies, and High Availability Solutions.
• Proficiency in automating DBA tasks and database maintenance.
• Excellent problem-solving skills and ability to work independently.
• Strong communication skills for collaborating with stakeholders and cross-functional teams.