We are the leaders in Big Data management through hyper-automation, virtualized cloud tiering, metadata and AI
Senior SQL Server DBA
Location
Egypt
Posted
1 day ago
Salary
0
Seniority
Senior
Job Description
Senior SQL Server DBA
PartnerOne
• Architect, install, configure, and maintain Microsoft SQL Server instances (2019, 2025, Azure SQL Database) across complex, multi-server Windows environments. • Lead end-to-end application performance engineering: analyze execution plans, identify problematic queries, and work with development teams to implement lasting optimizations at the code and schema level. • Proactively monitor application and database performance using Extended Events, DMVs, Wait Statistics analysis, and third-party tooling; establish baselines and SLA-aligned alerting thresholds. • Design, implement, and test robust backup and recovery strategies; own RTO/RPO targets and validate them through regular recovery drills. • Architect and maintain HA/DR solutions including Always On Availability Groups and Log Shipping across production and DR environments. • Govern database security: design role-based access controls, auditing frameworks, and encryption strategies in line with least-privilege and regulatory requirements. • Own capacity planning and storage forecasting; collaborate with infrastructure teams to ensure database platforms scale ahead of demand. • Lead database change governance: review and approve schema migrations, deployment scripts, and ORM-generated queries before they reach production. • Drive automation of routine DBA tasks (index maintenance, integrity checks, job monitoring) through PowerShell and SQL Agent. • Manage SQL Server patching and upgrades through a formal change management process, including pre- and post-upgrade validation. • Mentor and provide technical guidance to junior and mid-level DBAs; contribute to team knowledge-base and runbook documentation. • Serve as the senior escalation point in the on-call rotation, leading the response and post-incident review for Severity 1 database outages.
Job Requirements
- 7+ years of hands-on SQL Server DBA experience in large-scale, mission-critical production environments.
- Expert-level proficiency with Microsoft SQL Server 2019 / 2025 on Windows Server 2019 / 2022.
- Advanced T-SQL skills: query optimization, execution plan analysis, index design, partitioning, and performance troubleshooting.
- Deep expertise in application performance tuning: collaborating with developers to resolve ORM anti-patterns, N+1 queries, lock contention, and blocking chains.
- Proven experience architecting and supporting Always On Availability Groups, WSFC, and DR failover in enterprise environments.
- Strong command of Wait Statistics, DMVs, Extended Events, and Query Store for root-cause performance diagnosis.
- Solid experience with point in time database restores, High-Availability failover, disaster recovery planning, and hands-on recovery testing.
- Windows Server administration and Active Directory / Kerberos authentication for SQL Server.
- Demonstrated ability to lead technical projects and mentor junior team members.
- Familiarity with ITIL change, incident, and problem management processes.
Related Guides
Related Categories
Related Job Pages
More General Jobs
Travel Planner – Organisateur de mariages à destination Indépendant
JulesetmoiFabrique de journées exceptionnelles.
• Rechercher et coordonner des prestataires de voyages. • Supervision et coordination sur les lieux de mariage à l'étranger. • Accompagnement des mariés sur les rendez-vous de préparation du mariage. • Participer à une formation d'initiation au métier de Wedding Planner pendant 3 jours.
• Sourcing and coordinating vendors. • On-site supervision and coordination at wedding venues. • Accompanying the couple to wedding preparation meetings.
Polish Language Teacher
Digital LiftWorking with nonprofits to solve their biggest challenges through technology. Powered by monday.com.
• Developing lesson plans and materials to teach basic language skills to students. • Conducting online or in-person language classes for students. • Evaluating students' progress and providing feedback to help them improve. • Collaborating with other volunteers and staff members to develop effective teaching strategies. • Providing support and guidance to students to help them achieve their language learning goals. • Participating in training sessions and workshops provided by TEEI to enhance your teaching skills.
Fundraising Specialist
Digital LiftWorking with nonprofits to solve their biggest challenges through technology. Powered by monday.com.
• Develop and implement fundraising strategies that align with TEEI's mission and goals. • Arrange meetings with partners and communicate regularly with them to maintain strong partnerships and explore potential collaborations. • Research and identify potential new partners, and develop strategies to build relationships with them. • Explore innovative and effective ways to generate funding for the NGO, including researching and identifying new fundraising strategies. • Track fundraising progress, analyze data, and report results to senior leadership. • Work closely with other departments, such as marketing and communications, to ensure fundraising efforts align with overall organizational goals.


