Job Type: [Full-Time] Department: IT Department Location: Onsite - Nasr City Job Summary: The Database Administrator Specialist will be responsible for the design, implementation, and maintenance of database systems across SQL Server environments. This role involves optimizing database performance, ensuring data integrity, and implementing security measures to protect our data assets. Key Responsibilities: Database Management: Administer and maintain databases in SQL Server and NoSQL Server. Perform regular database backups, restores, and disaster recovery operations. Monitor database performance and optimize queries, indexes, and schemas to improve efficiency. Database Design and Implementation: Design and implement database structures and schemas to support business requirements. Develop and maintain database scripts for data migration, import/export, and automation. Ensure database design adheres to industry best practices and compliance standards. Security and Compliance: Implement and manage database security measures to protect sensitive data. Perform regular security audits and vulnerability assessments on database systems. Ensure compliance with data protection regulations and industry standards. Performance Tuning and Optimization: Monitor and analyze database performance metrics and resolve performance issues. Optimize database configurations, queries, and indexing strategies for improved performance. Implement and manage database caching and replication strategies. Incident Response and Troubleshooting: Respond to and resolve database-related incidents and issues in a timely manner. Troubleshoot and resolve database performance and connectivity problems. Provide support for application development teams in resolving database-related issues. Documentation and Reporting: Create and maintain comprehensive documentation for database configurations, procedures, and policies. Generate and review database performance reports and analytics. Provide regular updates to stakeholders on database performance, issues, and resolutions. Collaboration and Support: Collaborate with IT and development teams to support database integration and application development. Provide training and support to team members on database-related tools and technologies. Stay current with database technologies and industry trends to recommend improvements.