PartnerOne logo
PartnerOne

We are the leaders in Big Data management through hyper-automation, virtualized cloud tiering, metadata and AI

Senior SQL Server DBA

GeneralGeneralFull TimeRemoteSeniorTeam 201-500H1B No SponsorCompany SiteLinkedIn

Location

Egypt

Posted

1 day ago

Salary

0

Seniority

Senior

Bachelor Degree7 yrs expEnglishAzureMS SQL ServerSQL

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 Categories

Related Job Pages

More General Jobs

ContractRemoteTeam 1-10Since 2007H1B No Sponsor

• 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.

France
Julesetmoi logo

Wedding Planner, Independent

Julesetmoi

Fabrique de journées exceptionnelles.

General1 day ago
ContractRemoteTeam 1-10Since 2007H1B No Sponsor

• Sourcing and coordinating vendors. • On-site supervision and coordination at wedding venues. • Accompanying the couple to wedding preparation meetings.

France
Digital Lift logo

Polish Language Teacher

Digital Lift

Working with nonprofits to solve their biggest challenges through technology. Powered by monday.com.

General1 day ago
Full TimeRemoteTeam 51-200H1B No Sponsor

• 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.

Poland
Digital Lift logo

Fundraising Specialist

Digital Lift

Working with nonprofits to solve their biggest challenges through technology. Powered by monday.com.

General1 day ago
Full TimeRemoteTeam 51-200H1B No Sponsor

• 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.

Norway