Delivering robust database solutions and IT infrastructure management with over 8 years of professional experience in the Saudi Arabian Defense sector.
Professional Overview
Oracle PL/SQL Development
Over 3 years of specialized experience in Oracle PL/SQL development, focusing on robust database design, maintenance, and optimization. Proven track record in developing and enhancing complex SQL queries and database objects for mission-critical applications.
IT Systems Engineering
8 years of experience as an IT Systems Engineer, currently managing infrastructure for the Royal Saudi Air Defense Forces across 16 branches (300 employees/branch). This includes maintaining 16 separate Oracle databases and ensuring seamless operations with Oracle Forms and Reports 6i.
Holistic Security & Solutions
Comprehensive background in domain administration and security, enabling the implementation of robust protection measures while ensuring efficient IT operations. This unique combination delivers end-to-end solutions for both technical and operational challenges.
Key Metrics & Accomplishments
Branches & Offices
Managing IT infrastructure and database operations across distinct locations throughout Saudi Arabia.
Databases Maintained
Maintaining separate database instances for each branch, ensuring data integrity and availability.
Employees Served
Supporting the technology needs of over 4,800 military and civilian personnel.
Reports & Forms Identified
Total number of reports and forms identified for migration from legacy systems.
Successfully Migrated
Reports and forms already successfully converted to modern formats.
Years Experience
Combined professional experience across database development and IT systems.
Current Professional Role
SQL Developer (Oracle PL/SQL) | Reports & Forms Development
Ministry of Defense - Royal Saudi Air Defense Forces - Headquarters, Riyadh
February 2023 - Present
In my current role at the Royal Saudi Air Defense Forces headquarters in Ri
yadh, I serve as an IT Support Specialist with a focus on domain administration. This position combines my database expertise with broader IT infrastructure management responsibilities, allowing me to maintain critical systems that support military operations.
Active Directory Management
Administering users, groups, and permissions across a complex organizational structure, ensuring appropriate access controls while maintaining security standards.
Authentication Troubleshooting
Diagnosing and resolving authentication and access issues, minimizing downtime and ensuring continuous system availability for critical military operations.
Security Policy Implementation
Implementing and enforcing security policies across all 16 branches, protecting sensitive military information in compliance with defense protocols.
Previous Experience: IT Systems Engineer
Ministry of Defense - Royal Saudi Air Defense Forces, Jeddah
June 2017 - February 2023
During my tenure as an IT Systems Engineer in Jeddah, I was responsible for the comprehensive management of the IT infrastructure supporting military operations. This role required expertise across multiple domains, from database development to network administration.
Infrastructure Design & Maintenance
Designed, implemented, and maintained comprehensive IT infrastructure, ensuring reliability and performance for mission-critical applications.
Oracle Development
Developed and maintained complex Oracle Reports and Forms, creating efficient database solutions for military operations.
SQL Query Optimization
Designed and optimized complex SQL queries, improving system performance and data retrieval capabilities.
Previous Experience: IT Support Specialist (Domain Administration)
Nahil Computing Company, Riyadh
April 2017 - June 2017
At Nahil Computing Company in Riyadh, I specialized in Oracle PL/SQL development, focusing on creating efficient database solutions for clients. Though my tenure was brief, it provided valuable experience in commercial software development that complemented my subsequent roles in the defense sector.
Oracle Forms & Reports
Designed, developed, and maintained complex Oracle Reports and Forms, delivering intuitive user interfaces and comprehensive reporting capabilities.
SQL Query Development
Created and optimized complex SQL queries, ensuring efficient data retrieval and manipulation while maintaining performance standards.
Database Programming
Developed stored procedures, functions, triggers, and packages that enhanced database functionality and automated critical business processes.
Technical Skills: Database Expertise
With specialized training and hands-on experience in Oracle technologies, I've developed comprehensive database skills that enable me to design, implement, and optimize complex database solutions. My expertise in Oracle PL/SQL development forms the cornerstone of my technical capabilities.
Oracle PL/SQL Development
Expert-level programming skills in Oracle's procedural extension to SQL, creating efficient and scalable database solutions.
Oracle Forms and Reports 6i
Extensive experience with Oracle's legacy application development tool, maintaining and enhancing critical business applications.
Oracle Database Administration
Proficient in database administration tasks including installation, configuration, security, and performance tuning.
Technical Skills: Systems & Networks
Windows Server Administration
Expert management of Windows Server environments, including installation, configuration, maintenance, and troubleshooting of server infrastructure supporting critical military operations.
Active Directory Management
Comprehensive administration of Active Directory services, implementing and maintaining directory structures, group policies, and security principals across complex organizational hierarchies.
Domain Administration
Expert configuration and management of domain environments, ensuring secure and efficient authentication, authorization, and resource access for thousands of users across multiple locations.
Network Configuration
Skilled implementation and maintenance of network infrastructure, including routing, switching, and security configurations that support reliable communications across military facilities.
Technical Skills: Cybersecurity
In today's threat landscape, security expertise is essential for protecting critical military information systems. My cybersecurity skills complement my database and systems capabilities, allowing me to implement comprehensive protection across all layers of the IT infrastructure.
As I pursue my Master's in Cybersecurity, I continue to expand my knowledge in this vital field, applying the latest security principles and practices to protect sensitive information and critical systems.
CompTIA Security+ Certified
Validated expertise in core security concepts, including risk management, cryptography, identity management, and network security.
Cybersecurity Analysis
Skilled in identifying security threats, vulnerabilities, and risks to systems and data, with experience implementing appropriate countermeasures.
Penetration Testing
Proficient in conducting security assessments to identify vulnerabilities before they can be exploited by adversaries.
Incident Response
Experienced in developing and implementing procedures for effective response to security incidents, minimizing impact and recovery time.
Technical Skills: Data Analysis
Beyond database development, my skills extend to data analysis and visualization, enabling me to transform raw data into actionable insights. These capabilities are essential for decision support in military operations and administrative functions.
CompTIA Data+ Certified
Validated expertise in data concepts and environments, data mining, manipulation, visualization, and governance, ensuring high-quality data management practices.
Data Engineering
Proficient in designing and implementing data pipelines and architectures that facilitate efficient data collection, storage, and retrieval for analytical purposes.
Data Analytics
Skilled in applying statistical methods and analytical techniques to extract meaningful insights from complex datasets, supporting evidence-based decision making.
Report Development
Expert in creating comprehensive, intuitive reports that effectively communicate data findings to stakeholders at all levels of the organization.
Professional Certifications
Continuous professional development is a cornerstone of my career philosophy. I've earned over 15 professional certifications that validate my expertise across multiple domains, from database development to cybersecurity and network administration.
These certifications represent my commitment to maintaining current knowledge and skills in rapidly evolving technology fields. They provide a solid foundation for addressing complex technical challenges in mission-critical environments.
My certification portfolio demonstrates breadth and depth of knowledge, combining specialized database expertise with broader IT infrastructure and security capabilities. This holistic approach enables me to understand and address technical challenges from multiple perspectives.
SCE Professional Accreditation
Saudi Council of Engineers - Valid until March 2025
CompTIA Security+
Core security certification validating essential cybersecurity skills
CompTIA Data+
Certification in data analysis and management principles
CCNA
Cisco Certified Network Associate
Additional Professional Certifications
Oracle SQL Specialization
Oracle SQL Specialization from LearnQuest, validating expert-level SQL development skills
IBM Cybersecurity
Cybersecurity Analyst specialization from IBM, covering threat intelligence and incident response
Data Engineering
Data Engineering Fundamentals certification covering data pipeline design and implementation
Penetration Testing
Specialized training in penetration testing methodologies and incident response procedures
These certifications demonstrate my commitment to professional excellence and continuous learning. By maintaining current credentials across multiple technology domains, I ensure that my skills remain relevant and adaptable to emerging challenges in the rapidly evolving IT landscape.
Educational Background: Postgraduate Diploma in Cybersecurity
Majmaah University - Deanship of Admissions and Registration
Second Semester 1446/1447 (Current)
I am currently pursuing a Master's degree in Cybersecurity at Majmaah University, building on my professional experience to develop advanced theoretical knowledge and practical skills in this critical field. This program will enhance my ability to protect critical information systems against sophisticated threats.
First Semester
- DSC 511 - Principles of Information Security
- DSC 512 - Network and Communications Security
Second Semester
- Operating Systems Security
- Fundamentals of Cryptography
- Information Security Management
Third Semester
- Secure Software Development
- Ethical Hacking
- Digital Crimes
Educational Background: Bachelor's Degree
Core Curriculum
- Computer Architecture
- Operating Systems
- Data Structures & Algorithms
- Digital Electronics
- Software Engineering
Specialization Areas
- Database Systems
- Computer Networks
- Network Security
- Embedded Systems
- Systems Programming
Bachelor of Computer Engineering
Taif University
2010 - 2015
My undergraduate education in Computer Engineering at Taif University provided a strong foundation in both hardware and software aspects of computing systems. The program combined theoretical knowledge with practical applications, preparing me for a successful career in IT.
With a specialized focus on networks and databases, my studies aligned perfectly with my professional interests, allowing me to develop expertise in areas that would become central to my career. The comprehensive curriculum covered fundamental engineering principles while providing depth in specialized computing domains.
Current Project: Report and Form Migration
Oracle Forms and Reports Conversion Project
One of my primary responsibilities is leading the migration of Oracle Forms and Reports from legacy systems to modern formats. This extensive project involves converting 1,614 reports and forms to Excel and PDF formats, ensuring continuity of operations while enabling improved accessibility and functionality.
Overall Completion
1,137 of 1,614 reports and forms successfully migrated to modern formats
Excel Reports
412 of 639 reports converted to Excel format, enabling enhanced data manipulation
PDF Reports
725 of 975 Oracle decision reports converted to PDF format for easy distribution
Migration Project Details by Category
The migration project encompasses various report categories, each serving different operational needs within the Royal Saudi Air Defense Forces. Employee reports, which include personnel records and management information, represent the largest category of Excel migrations with 168 of 251 reports (67%) already completed.
Accounting reports, essential for financial management and budgeting, have a 60% completion rate with 147 of 245 reports successfully migrated. Contract reports, which document agreements with vendors and service providers, show strong progress at 66% completion (72 of 109 reports).
Operations and maintenance reports have the highest completion rate at 74%, with 25 of 34 reports successfully converted to modern formats. This prioritization reflects the critical importance of these reports to ongoing military operations.
Project: Reports and Forms Conversion Tool
PL/SQL/Forms Export Tool
I've developed a specialized tool that exports reports (.RDF/.REP) and forms (.FMB/.FMX) to Excel and PDF formats. This custom solution addresses the specific needs of our organization, enabling efficient migration from legacy systems while preserving functionality and data integrity.
Excel Reports Progress
412 of 639 reports successfully converted
PDF Reports Progress
725 of 975 reports successfully converted
Key Features
- Automated extraction of report and form structures
- Preservation of formatting and calculations
- Batch processing capabilities for efficient migration
- Validation routines to ensure data integrity
- Detailed logging and error handling
- Support for complex Oracle Forms objects
This tool has significantly accelerated our migration efforts, reducing the time required for each conversion while maintaining consistency and quality across all outputs. The automation capabilities have allowed us to process large batches of reports efficiently, contributing to our strong completion percentages.
Project: Intelligent Migration Assistant
Advanced Forms Analysis and Code Generation
To further enhance our migration capabilities, I've developed an Intelligent Migration Assistant that analyzes Oracle Forms 6i files and generates comprehensive documentation and optimized code. This innovative solution combines traditional database expertise with modern code analysis techniques to streamline the migration process.
Forms 6i Analysis
Extracts blocks, fields, LOVs, and triggers from Forms 6i files, providing a complete inventory of form components for migration planning.
Multi-Format Output
Generates JSON structures, Excel spreadsheets, and PDF documentation to support different aspects of the migration process.
PL/SQL Optimization
Automatically suggests PL/SQL code improvements, enhancing performance and maintainability in the migrated systems.
SQLCoder Integration
Incorporates SQLCoder for code suggestions and corrections, leveraging advanced code analysis to improve migration quality.
Projects and Achievements
Featured Projects: Ministry of Defense Datathon Hackathon
DATA TRANSFER Project
An advanced project for data transfer and integration between different systems. It addresses the lack of a dedicated data integration platform for the armed forces, supporting informed decision-making within the Ministry of Defense.
Goal: Create a Level 4 data system supporting data quality issue detection, automated processing, and predictive analytics.
- Data Management
- Data Processing
- Predictive Analysis
Eagle Eye - AI Assistant
A sophisticated intelligent assistant for data analysis and management. It utilizes AI technologies to enhance data quality and provide advanced analytical insights, streamlining complex data operations.
Features: Intelligent data analysis, automated error handling, interactive report generation, and a smart conversational interface.
- AI/ML
- NLP
- Data Analysis
Hackathon Recognition
Received a Certificate of Appreciation from the Ministry of Defense for outstanding participation in the Datathon Hackathon. This recognition highlights my contribution to innovating advanced technical solutions for data management and integration.
Date: November 2024
Achievement: Developed innovative data integration solutions.
Project: Hijri Date Validation System
Comprehensive Islamic Calendar Solution
In response to the specific needs of our Saudi Arabian military organization, I developed a sophisticated Hijri date validation system that supports multiple input formats while ensuring accuracy according to the Umm al-Qura calendar, the official calendar of Saudi Arabia.
This system addresses the challenges of working with Islamic calendar dates in database applications, providing consistent validation and standardization across all forms and reports. The solution is now actively used throughout our systems, enhancing data integrity for date-sensitive operations.
Multiple Input Format Support
- Supports 22+ different date input formats
- Handles various separator characters
- Processes both numeric and text month formats
- Accommodates different year representations
Comprehensive Validation
- Verifies day/month/year validity
- Conforms to Umm al-Qura calendar standards
- Prevents impossible date combinations
- Handles leap years correctly
Standardized Output
- Returns unified date format
- Enables consistent date storage
- Facilitates accurate date comparisons
- Supports proper chronological ordering
Project: SQLCoder Integration with Oracle 12c
AI-Enhanced Database Development Environment
Leveraging modern AI technologies to enhance traditional database development, I've implemented a SQLCoder integration with our Oracle 12c environment. This innovative project combines the power of artificial intelligence with established database practices to improve code quality and development efficiency.
Zip File Analysis
Processes .zip files containing SQL code, extracting and preparing them for analysis and optimization.
Local SQLCoder Processing
Utilizes Ollama to run SQLCoder locally without internet connectivity, ensuring security for sensitive military applications.
Oracle 12c Integration
Connects directly to Oracle 12c database (DEVSYS@o12cehd), enabling real-time validation and testing of generated code.
Flask API Implementation
Provides a user-friendly interface for query analysis, index suggestion, and other database optimization functions.
This solution operates entirely within our secure network environment, requiring no external connections or data sharing. By combining AI-powered code suggestions with traditional database expertise, we're able to improve development efficiency while maintaining the highest security standards required for military applications.
Project: Offline Oracle Development Tool
Secure Development Environment
Security requirements in military environments often necessitate working in air-gapped networks without internet connectivity. To address this challenge, I developed an offline Oracle development tool that provides advanced coding assistance without requiring external connections.
This solution enables developers to benefit from modern code analysis and suggestion capabilities while maintaining the strict security protocols required for handling sensitive military information. The tool integrates directly with our existing Oracle Forms 6i and SQL*Plus environments, providing seamless support for ongoing development activities.
Local SQLCoder Environment
Utilizes Ollama to run SQLCoder locally, providing intelligent code suggestions and analysis without internet connectivity.
Direct SQL*Plus / Forms 6i Integration
Works seamlessly with existing Oracle development tools, enhancing their capabilities without requiring workflow changes.
Local Code Inspection & Development
Enables comprehensive code analysis and development entirely within the secure local environment, maintaining security compliance.
Project: Screen and Report Conversion Analytics
Technical Migration Tracking System
To effectively manage our large-scale migration effort, I've implemented a comprehensive tracking system that monitors progress across all report and form categories. This analytical approach allows us to prioritize critical components, allocate resources efficiently, and maintain clear visibility into project status.
Form File Analysis
Systematically analyzes .FMB files from FASF5004 to FASF5007, identifying all components requiring migration and documenting their specifications.
Component Extraction
Extracts blocks, fields, LOVs, and triggers from legacy forms, creating a comprehensive inventory of elements for migration planning.
Documentation Generation
Automatically generates JSON files and PDF documentation, creating a searchable knowledge base to support the migration process.
Progress Tracking
Maintains detailed metrics on conversion progress, with current completion rates of 64.5% for Excel reports (412/639) and 74.4% for PDF reports (725/975).
Project: Professional Portfolio Development
Interactive HTML Portfolio
To effectively communicate my professional qualifications and technical expertise, I developed an interactive HTML portfolio that showcases my experience, skills, and certifications. This modern, responsive design presents my professional background in an engaging format suitable for sharing with potential employers and colleagues.
The portfolio features dynamic CSS effects that enhance the user experience while maintaining a professional aesthetic appropriate for technical and military contexts. This project demonstrates not only my technical abilities but also my attention to detail and professional presentation skills.
Modern Responsive Design
Implements a clean, professional interface that adapts seamlessly to different screen sizes and devices.
Comprehensive Content
Presents detailed information about my experience, skills, certifications, and projects in a well-organized format.
Interactive Elements
Incorporates subtle animations and interactive components that enhance engagement without compromising professionalism.
Interview-Ready
Prepared specifically for professional networking and interview opportunities with organizations like Shory and FirstTech.
Project: Procedural Guide and Awareness Campaign
Comprehensive Documentation and Training Materials
Recognizing the importance of clear procedures and user awareness in maintaining effective IT operations, I developed a detailed procedural guide and awareness campaign targeting both end users and department managers. This extensive presentation (60+ slides) provides comprehensive guidance on critical IT processes and security practices.
Equipment Request Procedures
Detailed step-by-step instructions for requesting IT equipment, including approval workflows, specification guidelines, and delivery processes. This standardized approach ensures efficient resource allocation while maintaining proper documentation.
Oracle Access Permissions
Clear guidelines for requesting and managing Oracle database access permissions, ensuring appropriate security controls while enabling necessary operational access. Includes role-based access models and approval requirements.
Ministry of Defense Email
Comprehensive instructions for email system usage, including security practices, attachment handling, and official communication protocols specific to military environments.
Issue Reporting Channels
Structured approach for reporting technical issues and security incidents, with clear escalation paths and response expectations. This framework ensures timely resolution of problems while maintaining proper security protocols.
Project: Hijri Date Documentation
Comprehensive Islamic Calendar Solution
Working in Saudi Arabia requires handling dates in both the Gregorian calendar and the Hijri (Islamic) calendar. To address the challenges of working with multiple date formats, I developed detailed documentation and implementation guidelines for handling Hijri dates in our systems.
This comprehensive approach ensures consistent date handling across all applications and reports, while respecting the cultural and practical importance of the Islamic calendar in Saudi organizations. The solution accommodates various input formats while maintaining data integrity and proper chronological ordering.
Multiple Input Format Support
The system accepts more than 10 different Hijri date formats, accommodating various user preferences and data import sources. This flexibility improves user experience while maintaining data consistency.
Umm al-Qura Calendar Validation
All dates are validated against the official Umm al-Qura calendar used in Saudi Arabia, ensuring accuracy for government and military applications that require precise Hijri dates.
Date Component Verification
The system verifies day/month/year components individually and in combination, preventing impossible dates while accommodating the unique structure of the lunar-based Hijri calendar.
Standardized Output Format
After validation, all dates are converted to a standard format for storage and processing, enabling consistent reporting and accurate date calculations across systems.
Ongoing Projects and Future Initiatives
Beyond my current projects, I'm actively developing several initiatives that will further enhance our technological capabilities and operational efficiency. These ongoing efforts demonstrate my commitment to continuous improvement and innovation in support of our organizational mission.
Complete Oracle Forms Conversion
Working to complete the conversion of all remaining Oracle Forms reports to Excel/PDF formats, targeting 100% completion within the next six months. This will eliminate dependency on legacy systems while maintaining all critical functionality.
Flask GUI Tool Development
Developing enhanced graphical user interfaces within our Flask framework to improve usability for technical and non-technical users. These tools will streamline database operations and reporting while reducing training requirements.
Comprehensive Documentation
Creating detailed Word/Excel documentation for all processes and systems, ensuring knowledge transfer and operational continuity. This documentation will serve as both a reference resource and a training tool for new team members.
Government Platform Integration
Working on integration with the "Etimad" platform and other government entities, enhancing interoperability with national systems and services. This will streamline administrative processes and improve data sharing capabilities.
Key Career Achievements
Large-Scale Management
Successfully managing IT services for more than 4,800 employees across 16 branches and offices, maintaining 16 separate database instances with consistent performance and reliability. This large-scale operation requires comprehensive planning, meticulous execution, and effective resource allocation to ensure continuous service availability.
System Development
Extensive hands-on experience with Oracle Forms and Reports 6i, developing and maintaining critical applications that support daily military operations. My deep understanding of this technology has enabled efficient system enhancements and problem resolution, ensuring operational continuity while planning for future migration.
Migration Projects
Converting 1,137 reports and forms from a total of 1,614 (68.9% complete), transitioning from legacy systems to modern formats while preserving functionality and improving accessibility. This complex migration project requires technical expertise, careful planning, and systematic execution to maintain operational capabilities throughout the transition.
Security & Compliance
Implementing comprehensive security policies across the organization, protecting sensitive military information while ensuring appropriate access for authorized personnel. My cybersecurity expertise enables effective threat mitigation and compliance with defense security standards, creating a secure operating environment for critical systems.
Infrastructure Management
Designing and maintaining complex IT infrastructure systems that support mission-critical operations across multiple locations, ensuring reliability and performance in demanding military environments.
Continuous Professional Development
Earning and maintaining more than 15 professional certifications across multiple technology domains, demonstrating commitment to excellence and current knowledge in rapidly evolving fields.
AI Integration
Successfully integrating SQLCoder with Oracle systems to enhance development capabilities, improving code quality and efficiency while maintaining security in air-gapped environments.
Why I'm the Right Candidate
Combining Technical Expertise with Organizational Value
My unique combination of database development skills, systems engineering experience, and cybersecurity knowledge enables me to deliver comprehensive solutions that address both technical and operational challenges. With over 9 years of professional experience in the Saudi defense sector, I understand the specific requirements and constraints of mission-critical military systems.
Technical Strengths
- Extensive practical experience in Oracle PL/SQL
- Deep understanding of database management
- Experience in large-scale environments
- Multiple current professional certifications
- Cybersecurity expertise with formal education
Added Value
- Performance and efficiency optimization
- Innovative technical solutions
- Experience with growth and expansion
- Team collaboration and knowledge sharing
- Commitment to continuous improvement
- Military-specific operational knowledge
Technical Skills Summary
Database Development
- Oracle PL/SQL
- Forms & Reports 6i
- Database Design
- Query Optimization
- Stored Procedures
Systems Administration
- Windows Server
- Active Directory
- Domain Management
- IT Infrastructure
- System Integration
Cybersecurity
- CompTIA Security+
- Threat Analysis
- Penetration Testing
- Security Compliance
- Incident Response
Networking
- CCNA Certified
- Network Configuration
- Troubleshooting
- Security Implementation
- Performance Optimization
Data Analysis
- CompTIA Data+
- Data Engineering
- Report Development
- Business Intelligence
- Data Visualization
This comprehensive skill set enables me to address complex technical challenges from multiple perspectives, delivering integrated solutions that enhance both technical performance and operational capabilities. My continuous professional development ensures that these skills remain current and relevant in the rapidly evolving technology landscape.
Contact Information
Engineer Ziyad Al-Sufyani
Oracle PL/SQL Developer & IT Systems Engineer
Professional Details
Current Position: SQL Developer (Oracle PL/SQL) | Reports & Forms Development
Organization: Ministry of Defense - Royal Saudi Air Defense Forces
Location: Headquarters, Riyadh, Saudi Arabia
Professional Accreditation: Saudi Council of Engineers (SCE) - Valid until March 2025
Contact Information
Email: ZYIAD_92@HOTMAIL.COM
Phone: +966-546000987
Location: Riyadh, Kingdom of Saudi Arabia
Ziyad Al-Sufyani: Expert Oracle PL/SQL Developer & IT Systems Engineer