DBA (SQL Server) - HA/DR & Performance Focus

Octdaily; Karachi Division; On-site; PKR 1,800,000 - 3,000,000; Full time

Job summary

Octdaily is seeking a mid-level Database Administrator in Karachi to manage production databases with 4+ years of hands-on experience in MS SQL Server, MySQL, and MongoDB. You will handle installation, configuration, backups, recovery, and high-availability setups in a production environment.

The role covers performance tuning, monitoring, incident RCA, and automation using T-SQL and PowerShell/Bash, with a focus on security, reliability, and documentation across development, UAT, and production

Qualifications

• 4+ years of hands-on Database Administration experience.
• Strong practical experience with MS SQL Server in production environments.
• Experience with Always On Availability Groups, HA/DR, and clustering concepts.
• Knowledge of backup, restore, and disaster-recovery strategies.
• Familiarity with security, encryption, auditing, and access management.
• Troubleshooting and performance-tuning skills including indexing and query optimization.
• Experience managing SQL Server Agent jobs, alerts, and maintenance plans.
• Ability to work independently in a production/support environment.

Responsibilities

• Installation, configuration, upgrading, patching, and maintenance of MS SQL Server.
• Manage SQL Server logins, users, roles, permissions, security, and access control.
• Configure, monitor, and troubleshoot Always On Availability Groups and HA/DR environments.
• Design, implement, and validate database backup, restore, and recovery strategies.
• Perform database recovery, point-in-time recovery, and disaster-recovery activities.
• Monitor and troubleshoot database performance, blocking, deadlocks, connectivity, and resource issues.
• Perform query optimization, execution-plan analysis, indexing, and performance tuning.
• Manage SQL Server Agent jobs, alerts, maintenance plans, DB health checks, and scheduled tasks.
• Implement and maintain database security, TDE, encryption, auditing, and data masking.
• Support database deployments across Development, UAT, and Production environments.
• Perform database health checks, capacity monitoring, space management, and proactive maintenance.
• Troubleshoot production incidents and perform RCA.
• Develop and maintain DBA scripts for monitoring, maintenance, troubleshooting, and automation.
• Provide production support and participate in critical incident resolution.
• Perform basic administration, troubleshooting, backup/recovery, and performance monitoring for MySQL and MongoDB.
• Maintain technical documentation, operational procedures, and database standards.

Skills

MS SQL Server

MySQL

MongoDB

Always On Availability Groups

Backup & DR strategies

Performance tuning

T-SQL

PowerShell/Bash scripting

Production support

Incident RCA

Tools

SQL Server Agent

PowerShell

Bash

Database monitoring tools

Job description

Octdaily is seeking a mid-level Database Administrator in Karachi to manage production databases with 4+ years of hands-on experience in MS SQL Server, MySQL, and MongoDB. You will handle installation, configuration, backups, recovery, and high-availability setups in a production environment.

The role covers performance tuning, monitoring, incident RCA, and automation using T-SQL and PowerShell/Bash, with a focus on security, reliability, and documentation across development, UAT, and production