Database Developer - Riyadh - Onsite

Role Overview

Key Responsibilities

• Manage, optimize, and support both production databases (SQL Server and Oracle)
• Lead the stored procedure to Entity Framework migration alongside the development team design the
• migration strategy, own the database side of the transition
• Design, implement, and regularly test backup and disaster recovery plans for both DB engines recovery
• procedures must be documented and drilled
• Monitor database performance continuously using AppDynamic and native tooling; identify and resolve
• bottlenecks before they cause SLA breaches
• Build and maintain cross-system data integration flows between the Correspondence System (SQL Server)
• and the Archiving System (Oracle)
• Implement and maintain database-level security controls: access control, encryption at rest, row-level
• security, audit logging
• Support developers with query writing, execution plan analysis, and index design throughout development
• waves
• Produce and maintain database documentation in Arabic: schemas, ERDs, data dictionaries, backup
• procedures, and recovery runbooks

Minimum Qualifications

• Fluent Arabic Speaker is a Must.
• Bachelor's degree in computer science, Information Systems, or equivalent
• Demonstrated professional experience with both Microsoft SQL Server and Oracle Database in production
• environments
• Experience with database performance tuning, backup/recovery design, and production incident response
• Experience with ORM systems Entity Framework Core or equivalent preferred

Required Technical Skills

• Microsoft SQL Server T-SQL (complex queries, stored procedures, views, triggers, jobs), SQL Server Agent,
• SSMS, replication awareness
• Oracle Database PL/SQL (procedures, functions, packages), Oracle SQL Developer or Toad, performance

tools (AWR, ADDM, EXPLAIN PLAN)

• Backup and recovery SQL Server native backup strategies, SQL Server Always On Availability Groups
• awareness, point-in-time recovery
• Backup and recovery Oracle RMAN backup configuration, Data Guard awareness, recovery drills
• Entity Framework Core ORM design, code-first migrations, guidance for developers on EF best practices
• during SP migration
• Database performance tuning execution plan analysis, index design and review, query rewrites, statistics
• management for both SQL Server and Oracle
• AppDynamic (or equivalent APM) database query monitoring, slow query identification, alert
• configuration
• Data integration cross-database data flows between SQL Server and Oracle; ETL basics; integration query
• design
• Database security column-level and transparent data encryption, row-level security, audit trail
• configuration at DB layer, access control matrix
• SSMS and Oracle SQL Developer primary daily tooling
• Familiarity with both Windows Server and Linux environments for DB hosting (either may be in use on-site)
• Basic scripting (PowerShell or shell) for database maintenance automation beneficial

Key Soft Skills

• Systematic and methodical database changes in a zero-downtime production environment require
• extreme care; rushes nothing
• Detailed documentation discipline every schema change, index addition, backup configuration change,
• and recovery test result documented in Arabic
• Proactive performance monitoring identifies degrading query performance or backup failures before they
• cause incidents, not after
• Collaborative mindset closely partners with developers during the EF migration; the DB developer and
• developers must operate as a single team, not silos
• Clear communication of database risks to the Technical Lead understands which issues need immediate
• escalation