- 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
Benefits
-50 Percent of the Salary in USD
- Social and Medical insurance
- Transportation and transportation allowance
- Internet package
What We Do
A dynamic solution provider, passionate about building smart, modular, comprehensive, and sustainable solutions for today’s world of business. We resolve problems, improve operations and enhance customer experience through technology as we help our clients find better, smarter ways to perform business and modernize the way they work. Since our establishment in 2014, our 400+ Skilled engineers have been strongly committed to our 100+ enterprise Customers’ satisfaction by helping them overcome their challenges and supporting their journey towards a more agile business in more than 14 Countries. Our offices are across the globe in USA, UK, UAE, KSA and Egypt. Advansys ESC is part of INTRO Group, which was founded in 1980 and currently employs more than 2,500 skilled calibers. The group encompasses a wide range of companies in several sectors, including oil and gas, construction, pharmaceutical, engineering, and trading and commercial representation. We are specialized in a wide array of premium services including Business Automation, Low-code Development, Cloud Services, Industrial Digitization, Warehouse Automation and Strategic Outsourcing. For more info: [email protected]
.png){kind=logo}
