IT IS_AMS_Database_MS SQL Server

2 - 5 years

2 - 5 Lacs

Posted:1 day ago| Platform: Foundit logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

IT IS_AMS_Database_MS SQL Server

Roles and Responsibilities:

  • Database Administration:

    Perform routine database administration tasks for Microsoft SQL Server, including installation, configuration, patching, upgrades, and managing database instances.
  • Performance Monitoring & Tuning:

    Continuously monitor SQL Server database performance, identify bottlenecks, and implement optimization strategies such as query tuning, index optimization, and instance-level tuning.
  • Backup and Recovery:

    Design, implement, and manage robust backup, recovery, and disaster recovery solutions for SQL Server databases to ensure data integrity and business continuity.
  • High Availability:

    Implement and maintain high availability and disaster recovery solutions like AlwaysOn Availability Groups, SQL Server Failover Cluster Instances, and replication.
  • Database Security:

    Implement and enforce database security policies, manage user access, roles, and permissions, and ensure compliance with security standards.
  • Incident & Problem Management:

    Respond to database-related incidents, troubleshoot complex issues, perform root cause analysis, and implement permanent fixes in an AMS framework.
  • Change Management:

    Adhere to ITIL-based change management processes for all database modifications and deployments.
  • SQL Development Support:

    Provide support to application development teams for database-related issues, including query optimization, schema changes, and data fixes.
  • Automation:

    Develop and maintain scripts (e.g., PowerShell, T-SQL) for automating routine DBA tasks, database maintenance, and reporting.
  • Documentation:

    Create and maintain comprehensive documentation for database configurations, procedures, and troubleshooting guides.

Preferred Candidate Profile:

  • MS SQL Server Expertise:

    Strong hands-on experience in administering, configuring, and troubleshooting Microsoft SQL Server databases across various versions.
  • T-SQL Proficiency:

    Excellent proficiency in T-SQL for querying, scripting, and stored procedure development.
  • High Availability:

    Proven experience with SQL Server high availability features such as Alway sOn Availability Groups, clustering, and replication.
  • Performance Tuning:

    Strong ability to diagnose and resolve database performance issues.
  • Database Security:

    Good understanding of database security best practices and compliance requirements.
  • AMS / ITIL:

    Familiarity with Application Management Services (AMS) models and ITIL processes for incident, problem, and change management.
  • Problem-Solving:

    Excellent analytical and problem-solving skills with a methodical approach to complex database challenges.
  • Communication:

    Strong verbal and written communication skills to effectively collaborate with technical teams and stakeholders.
  • Education:

    Bachelor's degree in Computer Science, Information Technology, or a related technical field. Microsoft SQL Server certifications are a significant plus.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Teamware Solutions logo
Teamware Solutions

IT Services and IT Consulting

Chennai Tamilnadu

RecommendedJobs for You