MS SQL Server

Job Description:

• Role MS SQL Server Database Administrator
• Level JL3
• Locations Bangalore BLR Chennai CHN Pune PUNE
• Job Summary
• We are looking for a skilled MS SQL Server Database Administrator DBA to manage maintain optimize and support mission critical SQL Server database environments
• The ideal candidate should have hands on experience in database administration performance tuning backup and recovery high availability and production support in enterprise environments

Key Responsibilities:

• Key Responsibilities
• Administer monitor and maintain Microsoft SQL Server databases across development test and production environments
• Perform database installation configuration upgrades patching and migrations
• Implement and manage backup recovery and disaster recovery procedures
• Monitor database health performance and availability and proactively address issues
• Optimize database performance through query tuning indexing and resource management
• Configure and manage High Availability HA and Disaster Recovery DR solutions such as
• Always On Availability Groups
• Database Mirroring
• Log Shipping
• Replication
• Failover Clustering
• Manage database security user access roles permissions and compliance requirements
• Troubleshoot database related incidents and provide L2 L3 support
• Support application teams during deployments releases and database changes
• Automate routine administrative tasks using PowerShell T SQL or SQL Agent Jobs
• Create and maintain operational documentation SOPs and knowledge articles

Technical Requirements:

• Required Skills
• Strong hands on experience in Microsoft SQL Server Administration
• Experience with SQL Server 2016 2019 2022 environments
• Expertise in
• Database Installation Configuration
• Backup Recovery
• Database Performance Tuning
• Query Optimization
• Index Management
• High Availability Disaster Recovery
• Security Management
• Capacity Planning
• Strong knowledge of T SQL scripting and troubleshooting
• Experience with SQL Server Agent SSMS Profiler Extended Events and Performance Monitoring tools
• Knowledge of Windows Server administration fundamentals
• Experience in incident problem and change management processes
• Preferred Skills
• Exposure to Azure SQL Database Azure Managed Instance or cloud database platforms
• Experience with database monitoring tools such as Redgate SolarWinds DPA SentryOne or similar solutions
• Knowledge of PowerShell scripting and automation
• Understanding of DevOps and CI CD database deployment practices
• ITIL Foundation certification preferred

Additional Responsibilities:

• Experience
• 2 4 years of relevant experience in MS SQL Server Database Administration
• Experience supporting production database environments with high availability requirements
• Educational Qualification
• Bachelor s Degree in Computer Science Information Technology Engineering or related field
• Soft Skills
• Strong analytical and troubleshooting abilities
• Good communication and stakeholder management skills
• Ability to work in a fast paced production support environment
• Strong ownership and customer centric mindset
• Ability to work in shifts and participate in on call support when required
• Primary Skill Technology Database Administration MS SQL Server
• Job Level JL3
• Locations Bangalore BLR Chennai CHN Pune PUNE
• Experience Range 2 4 Years

Preferred Skills:

Technology->Cloud Platform->Databases on Azure->Azure Managed Instance for Apache Cassandra,Technology->Database->Microsoft SQL Server,Technology->DevOps->DevOps Architecture Consultancy,Technology->Mainframe Technologies->CICS