Database Administrator

Database Administrator (DBA)

Location: Mohali, Punjab

Shift: 4 pm-1 am

Experience:5+years

Database Administrator (DBA)

high availability

database administration, T-SQL development, backup/recovery strategies, and monitoring/troubleshooting

Key Responsibilities

Database Administration & Maintenance

• Manage and maintain

  MS SQL Server

  ,

  MySQL

  , and

  Azure SQL Managed Instance

  environments (production, UAT, and development).
• Install, configure, patch, and upgrade database servers and tools.
• Implement and manage

  database backup and recovery

  strategies (native backups, BCP, export/import utilities, and automated backup jobs).
• Ensure databases are

  highly available

  ,

  secure

  , and

  performant

  .
• Regularly perform

  health checks

  ,

  index optimization

  ,

  statistics updates

  , and

  space management

  .

Performance Monitoring & Troubleshooting

• Monitor database performance using tools such as

  SQL Profiler

  ,

  Azure Monitor

  ,

  SSMS Performance Dashboard

  ,

  SolarWinds

  ,

  Redgate SQL Monitor

  ,

  Nagios

  , or similar.
• Identify and resolve

  performance bottlenecks

  ,

  blocking/deadlock issues

  , and

  slow-running queries

  .
• Perform

  root cause analysis (RCA)

  for database outages or performance issues and implement preventive measures.

Development & Query Optimization

• Write and optimize

  T-SQL queries

  ,

  stored procedures

  ,

  functions

  ,

  views

  , and

  triggers

  .
• Collaborate with developers to ensure efficient database design and query performance tuning.
• Support deployment of scripts and changes across environments following best practices.

Security & Compliance

• Manage

  database users, roles, and permissions

  in alignment with company security policies.
• Ensure

  data encryption

  ,

  auditing

  , and

  compliance

  with regulatory standards (e.g., GDPR, HIPAA if applicable).

Automation & Documentation

• Automate routine DBA tasks (e.g., backups, monitoring, alerts, and maintenance plans).
• Maintain up-to-date documentation for all databases, configurations, procedures, and change logs.
• Support disaster recovery planning and testing.

Required Skills & Experience

• 5+ years

  of experience as a Database Administrator managing

  SQL Server

  and

  MySQL

  environments.
• Strong expertise in:

• T-SQL

  (queries, stored procedures, triggers, views)

• Database backup/restore

  (native, maintenance plans, BCP, logical/physical)

• Performance tuning and query optimization

• SQL Agent Jobs and automation

• Working knowledge of

  Azure SQL Managed Instance

  or other cloud-based database services.
• Experience with

  monitoring and alerting tools

  (Redgate, SolarWinds DPA, Azure Monitor, etc.).
• Strong understanding of

  replication, mirroring, Always On Availability Groups

  , and

  log shipping

  .
• Familiarity with

  MySQL administration

  , including replication and backup utilities.
• Ability to

  diagnose and troubleshoot

  complex database and performance issues.

Preferred Qualifications

• Microsoft Certified:

  Azure Database Administrator Associate

  or

  SQL Server Database Administrator

  .
• Experience with

  PowerShell

  or

  Python scripting

  for automation.
• Familiarity with

  DevOps

  tools and

  CI/CD pipelines

  for database deployments.
• Knowledge of

  Linux/Windows Server administration

  related to DB operations.