15 Nov
|
Crowe
|
Ahmedabad
We are looking for an experienced Database Administrator (DBA) with strong hands-on expertise in Microsoft SQL Server to manage, support, monitor, and optimize enterprise-grade applications. The ideal candidate should have strong experience in SQL Server Administration, Performance Tuning, Query Optimization, Stored Procedures, Indexing, Database Monitoring, Backup & Recovery, High Availability, and Production Support. Experience supporting .
NET / ADO.
NET applications with SQL Server stored procedure-based architecture is required. Exposure to PostgreSQL will be an added advantage.
Key Responsibilities
- Install, configure, administer, monitor, and maintain Microsoft SQL Server environments.
- Manage Development, UAT, Staging, and Production databases.
- Perform database migrations, upgrades, patching, backup, recovery, and capacity planning.
- Analyze and optimize SQL queries, Stored Procedures, Functions, Views, and Triggers.
- Perform execution plan analysis, query tuning, and SQL performance troubleshooting.
- Design and maintain Clustered, Non-Clustered, Composite, and Covering Indexes.
- Troubleshoot deadlocks, blocking, locking, long-running queries, high CPU, memory bottlenecks, and disk I/O issues.
- Monitor database performance using SQL Server Profiler, Query Store, Extended Events, DMVs, Activity Monitor, and PerfMon.
- Conduct database health checks and perform Root Cause Analysis (RCA) for performance issues.
- Design and maintain database backup, recovery, High Availability (HA), and Disaster Recovery (DR) strategies.
- Support enterprise applications built using .
NET, ADO.
NET, and SQL Server Stored Procedures.
- Provide L2/L3 production support for database-related incidents.
- Support deployments and production releases.
- Work closely with developers, architects, infrastructure, and application support teams. Mandatory Skills
- 5+ years of hands-on Microsoft SQL Server DBA experience
- SQL Server 2019 / 2022
- Strong T-SQL knowledge
- Performance Tuning & Query Optimization
- Stored Procedure Optimization
- Execution Plan Analysis
- Indexing & Statistics
- SQL Server Agent Jobs
- Backup & Recovery
- Database Security
- Database Monitoring
- Troubleshooting Deadlocks, Blocking & Locking
- High CPU / Memory / Disk I/O troubleshooting
- Database Health Checks & Capacity Planning
- Experience supporting high-volume, enterprise transactional applications
- Understanding of ADO.
NET and database interaction mechanisms
- L2/L3 Production Support Preferred / Added Advantage
- PostgreSQL Administration & Performance Tuning
- SQL Server to PostgreSQL migration exposure
- Always On Availability Groups
- Replication, Log Shipping & Database Mirroring
- Database Auditing & Security Management
- IIS-hosted .
NET application exposure
- Experience in Banking, Financial Services, FinTech, AML, Compliance, ERP, CRM, or similar enterprise domains
- Microsoft SQL Server certifications Qualification Bachelors Degree in Computer Science, Information Technology, Engineering, or a related discipline. Desired Skills
- Strong analytical and problem-solving abilities
- Excellent database troubleshooting skills
- Positive communication and stakeholder management
- Ability to independently handle critical production incidents
- Good documentation and reporting skills
📌 Database Administrator (Ahmedabad)
🏢 Crowe
📍 Ahmedabad