Advansys Esc 1Nasr City, Al Manteqah Al Oula, Egypt1d ago
Database Design: Architect and implement relational database models, schemas, and tables using industry best practices for normalization and performance.
Advanced Development: Write complex stored procedures, triggers, views, and user-defined functions to support application logic.
Performance Tuning: Proactively identify and resolve performance bottlenecks through index optimization, query refactoring, and execution plan analysis.
ETL & Integration: Design and maintain robust Data Integration/ETL processes using SSIS (SQL Server Integration Services) to consolidate data from disparate sources.
Data Security: Implement and manage security protocols, including encryption, data masking, and granular access controls, to protect sensitive information.
Reporting & Analytics: Develop and optimize complex reports using SSRS (SQL Server Reporting Services) or Power BI to provide actionable business insights.
Requirements
1. Oracle Development
Proficiency in PL/SQL
Experience with Oracle Forms & Reports
Strong understanding of Oracle database structures, stored procedures, and performance tuning
2. Microsoft SQL Server
Hands‑on experience with MS SQL Server
Ability to develop and optimize T‑SQL queries, triggers, and stored procedures
3. Additional Requirements
Strong analytical and problem‑solving skills
Ability to work with cross‑functional teams
Experience in banking/financial systems is preferred