Senior Database Developer

Advansys · Cairo, Egypt · Posted 2026-01-14

Database Design: Architect and implement relational database models, schemas, and tables using industry best practices for normalization and performanceAdvanced Development: Write complex stored procedures, triggers, views, and user-defined functions to support application logicPerformance Tuning: Proactively identify and resolve performance bottlenecks through index optimization, query refactoring, and execution plan analysisETL & Integration: Design and maintain robust Data Integration/ETL processes using SSIS (SQL Server Integration Services) to consolidate data from disparate sourcesData Security: Implement and manage security protocols, including encryption, data masking, and granular access controls, to protect sensitive informationReporting & Analytics: Develop and optimize complex reports using SSRS (SQL Server Reporting Services) or Power BI to provide actionable business insightsRequirements1. Oracle DevelopmentProficiency in PL/SQLExperience with Oracle Forms & ReportsStrong understanding of Oracle database structures, stored procedures, and performance tuning2. Microsoft SQL ServerHands‑on experience with MS SQL ServerAbility to develop and optimize T‑SQL queries, triggers, and stored procedures3. Additional RequirementsStrong analytical and problem‑solving skillsAbility to work with cross‑functional teamsExperience in banking/financial systems is preferredBenefits50 Percent of the Salary in USD Social and Medical insurance Transportation and transportation allowance Internet package

Apply for this role