Crowe logo

Database Administrator

Crowe

5 - 7 years

Ahmedabad

Posted:6 days ago

Job Description

Database Administrator (DBA)

SQL Server Administration, Performance Tuning, Query Optimization, Stored Procedures, Indexing, Database Monitoring, Backup & Recovery, High Availability, and Production Support

.NET / ADO.NET applications

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

Desired Skills

  • Strong analytical and problem-solving abilities
  • Excellent database troubleshooting skills
  • Good communication and stakeholder management
  • Ability to independently handle critical production incidents
  • Good documentation and reporting skills

Skills Required

Shipping SQL DBMS Database administration Replication Log shipping Administration

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

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.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Crowe logo
Crowe

RecommendedJobs for You

Genesys International logo

Database Administrator

Genesys International

Ahmedabad

Kreate Technologies logo

Database Administrator

Kreate Technologies

Mangaluru

MakeMyTrip logo

Gurugram

Orbit Techsol India logo

Database Administrator

Orbit Techsol India

Dehradun

Arohana Tech Solutions Private Limited logo

Database Administrator

Arohana Tech Solutions Private Limited

Chennai

Arohana Tech Solutions Private Limited logo

Database Administrator

Arohana Tech Solutions Private Limited

Delhi

Data Eminence logo

India