SQL Server Database Administrator
Posted
Summary
A mid-level (3–4 years) SQL Server Database Administrator at the company's head office in Giza, Egypt, responsible for installing, maintaining, and optimizing Microsoft SQL Server databases — covering performance tuning, backups and disaster recovery, security and user management, monitoring, and documentation while supporting development and infrastructure teams.
Job Information
Job Title: SQL Server Database Administrator
Department: Database Administration
Division: Information Technology
Reporting To: Head of Database Administration
Location: Head Office
Job Summary
We are looking for a SQL Server Database Administrator with 3–4 years of experience to manage, maintain, and optimize Microsoft SQL Server databases. The ideal candidate will ensure database availability, security, performance, and reliability while supporting business applications and collaborating with development and infrastructure teams.
Key Responsibilities
Database Administration
- Install, configure, administer, and maintain Microsoft SQL Server databases.
- Monitor database health, availability, and performance.
- Perform database upgrades, patching, and migrations.
- Create and maintain databases, tables, indexes, and other database objects.
Performance & Optimization
- Monitor and optimize database performance.
- Analyze execution plans and optimize queries and indexing.
- Troubleshoot and resolve database performance issues.
Backup & Recovery
- Perform scheduled database backups and monitor backup jobs.
- Maintain and test backup and recovery procedures.
- Prepare daily backup status reports and ensure data recoverability.
Security
- Manage database users, roles, and permissions.
- Implement database security best practices, including authentication, encryption, and access control.
- Apply security updates and patches to maintain compliance.
Monitoring & Troubleshooting
- Monitor SQL Server environments for errors, failures, and capacity issues.
- Investigate and resolve database-related incidents.
- Support production environments and minimize downtime.
Documentation & Collaboration
- Maintain documentation for database configurations, procedures, and standards.
- Work closely with developers, system administrators, and infrastructure teams to support applications and deployments.
- Follow organizational IT policies, security standards, and operational procedures.
Requirements
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 3–4 years of hands-on experience as a SQL Server Database Administrator.
Technical Skills
- Strong experience with Microsoft SQL Server Administration.
- Solid knowledge of SQL, T-SQL, database design, and data modeling.
- Experience with backup, restore, disaster recovery, and database maintenance.
- Good understanding of performance tuning, indexing, and query optimization.
- Experience with SQL Server security, user management, and permissions.
- Familiarity with database monitoring and troubleshooting tools.
- Knowledge of SQL Server Always On Availability Groups, Replication, or Clustering is a plus.
- Experience with ETL processes or data migration is an advantage.
Soft Skills
- Strong analytical and problem-solving skills.
- Good communication and teamwork abilities.
- Ability to prioritize tasks and manage multiple responsibilities.
- Attention to detail and commitment to maintaining high system availability.
Preferred Certifications
- Microsoft SQL Server certifications (preferred but not mandatory).