SQL Database Administrator Job in NexionPro
- Kpr sugar apperals
- 4 to 10 Yrs
- Other Haryana
- 2 months ago
- Email to a friend
- Report this job
Job Description
- Job Title: SQL Database Administrator (DBA + Engineer) Location: Gurugram (Hybrid - Onsite) Experience Range: 4-10 years Client Interview: Yes Company: Mphasis and Permanent with it. About Company-Mhasis Limited is an Indian multinational information technology services and consulting company based in Bangalore. The company provides infrastructure technology and applications outsourcing services, as well as architecture guidance, application development and integration, and application management services. It serves financial services, telecom, logistics, and technology industries. Job Description:We are looking for a highly skilled SQL Database Administrator (DBA + Engineer) to manage and optimize SQL Server environments. The ideal candidate should have expertise in SQL query writing, performance tuning, high availability (HADR), replication, and disaster recovery strategies. This role requires hands-on experience in database administration, troubleshooting, and query optimization. Key Responsibilities: SQL Server Administration: Managing SQL Server databases, including installation, configuration, and maintenance. Handling database patching and upgrades. Ensuring high availability and disaster recovery (HADR) configurations. SQL Query Writing & Scripting: Developing and optimizing SQL queries and stored procedures. Troubleshooting query performance issues. Performance Tuning & Optimization: Monitoring and resolving performance issues. Optimizing indexing, execution plans, and query performance. Handling temporary database space issues and backup strategies. High Availability & Disaster Recovery (HADR): Implementing and managing Always On Availability Groups. Failover framework management. Developing recovery strategies for accidental data deletion. Replication & Data Synchronization: Managing and troubleshooting SQL Server replication (transactional, merge, snapshot). Diagnosing replication lags and data synchronization issues. AWS & Cloud Database Management (Good to Have): Understanding of clustered vs. non-clustered indexing strategies. Working knowledge of SQL Server on AWS or cloud environments. Required Skills & Expertise: Database Administration: SQL Server management, patching, backups, and disaster recovery. SQL Query Optimization: Strong SQL scripting, query performance tuning, and troubleshooting. HADR & Replication: Experience with Always On Availability Groups, failover strategies, and replication management. Performance Troubleshooting: Ability to diagnose and resolve slow query execution, index inefficiencies, and resource bottlenecks. Scenario-based Problem Solving: Expertise in debugging real-time database performance issues. Cloud Database Exposure (Preferred): Experience with AWS RDS, Azure SQL, or similar cloud-based SQL environments. Interview Topics to Assess Candidates: High Availability & Disaster Recovery (HADR): Always On Architecture, failover strategies, recovery from accidental deletion. SQL Server Optimization & Tuning: Handling temporary database space issues, backup frequency, slow query execution scenarios. Replication: Types of replications, diagnosing and resolving replication lag issues. AWS/Cloud Indexing: Clustered vs. Non-Clustered Index strategies. Job Type: Full-time Schedule: Day shift Education: Bachelor's (Required) Experience: Total IT: 4 years (Required) SQL: 3 years (Required) Work Location: In person,
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: Not Specified
Functional Area: Not Specified
Role/Responsibilies: SQL Database Administrator Job in NexionPro at
Contact Details:
Company: NexionProLocation(s): Other Haryana
+ View Contact
Keyskills: SQL Server Administration
Fraud Alert to job seekers!
₹ Not Specified
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in