IT Infrastructure Engineer (SQL DB)

Overview

Min 2 years in IT Infrastructure in the field of IT Domain or support

Work Location: Bengaluru

Education: BE / B.Tech / MCA or Any UG / PG in Computer Science.

Language: Good communication in English & Kannada.

Skills Required:

SQL DBA Skills:

• SQL Server Management: Installation, configuration, and management of MS SQL Server (2022).
• Database Backup and Recovery: Performing regular database backups (full, differential, and transaction log), and restoring databases in different environments.
• T-SQL: Writing and optimizing complex queries, stored procedures, triggers, and functions.
• Performance Tuning: Analyzing execution plans, indexing strategies, and query performance to optimize SQL queries and improve system efficiency.
• Database Security: Managing SQL Server security roles, user permissions, and auditing.
• Replication and High Availability: Setting up and maintaining database replication, log shipping, and Always On Availability Groups.
• Monitoring and Troubleshooting: Using tools like SQL Server Management Studio (SSMS), SQL Profiler, and Performance Monitor for performance troubleshooting and proactive system monitoring.
• Scripting and Automation: Automating repetitive tasks using PowerShell and SQL Agent Jobs.
• Reporting and Documentation: Creating database documentation, reports, and maintaining logs for auditing purposes.

Windows Skills:

• Windows OS Management
• User and Group Management
• Networking and Connectivity
• Security Management
• System Performance Monitoring and Troubleshooting
• Backup and Disaster Recovery
• Virtualization and Hyper-V
• Server and Remote Management
• Disaster Recovery and High Availability
• Software Deployment and Patch Management
• Documentation and Reporting

Job Types: Full-time, Permanent

Pay: ₹250,000.00 - ₹400,000.00 per year

Benefits:

• Health insurance
• Leave encashment
• Life insurance
• Provident Fund

Schedule:

• Day shift

Application Question(s):

• How many years of experience you have in SQL server administration?
• How many years of experience you have in Windows server?
• How many years of experience you have in Backup & Restore in SQL DB?
• Are you ready to work at client location (onsite)?

Work Location: In person

Application Deadline: 03/04/2025