Junior SQL DBA: Production Support & Backups

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

Job summary

Octdaily is seeking a Junior Database Administrator (DBA) with 2+ years of hands-on experience, primarily in MS SQL Server, and basic working knowledge of MySQL and MongoDB. You will perform routine database administration, backup and restore activities, and support senior DBAs in production environments.

You will assist with SQL Server installation, maintenance, monitoring, security, and documentation, contributing to deployments across Dev, UAT, and Production while ensuring high availability

Qualifications

• 2+ years of relevant DBA experience.
• Hands-on experience with MS SQL Server.
• Basic working knowledge of MySQL and MongoDB.
• Good understanding of SQL Server backup and restore.
• Familiarity with Always On Availability Groups and HA/DR concepts.
• Good communication and documentation skills.
• Willingness to work in a production/support environment and learn advanced DBA technologies.

Responsibilities

• Assist with SQL Server installation, configuration, and routine maintenance.
• Create and manage SQL Server logins, users, roles, and basic permissions.
• Perform regular database backups and restores.
• Monitor database health, disk space, CPU, memory, and database availability.
• Monitor SQL Server Agent jobs and troubleshoot failed jobs.
• Perform basic database maintenance activities.
• Monitor and troubleshoot basic blocking, connectivity, and performance issues.
• Assist with SQL Server Always On Availability Group monitoring and basic troubleshooting.
• Support database deployments across Dev, UAT, and Production environments.
• Perform basic index and query performance checks.
• Assist with database security and access management.
• Support database recovery and routine DR activities under senior DBA guidance.
• Perform basic administration and troubleshooting of MySQL and MongoDB.
• Monitor production databases and elevate critical issues to senior DBAs.
• Maintain database documentation, reports, and operational checklists.

Skills

MS SQL Server

Backup/Restore

Monitoring

Troubleshooting

Documentation

Communication

Tools

MySQL

MongoDB

Always On

SQL Server Agent

Job description

Octdaily is seeking a Junior Database Administrator (DBA) with 2+ years of hands-on experience, primarily in MS SQL Server, and basic working knowledge of MySQL and MongoDB. You will perform routine database administration, backup and restore activities, and support senior DBAs in production environments.

You will assist with SQL Server installation, maintenance, monitoring, security, and documentation, contributing to deployments across Dev, UAT, and Production while ensuring high availability