Senior GIS Oracle DBA
(Atheeb Intergraph Saudi Company)-Jeddah Municipality)
Total years of experience :15 years, 5 Months
• Set-up, management, and monitoring of ArcSDE Geodatabase.
• Perform technical and administrative functions of ArcSDE Enterprise Geodatabase
Analyze datasets.
Geodatabase Compression.
Managing Locks.
Managing Versions.
Updating Statistics.
Manage and Develop Workflows within Versioning.
Maintaining Geodatabase Updates (Creating GDB objects, Managing Subtypes and domains, Loading Data, Maintaining Metadata, and Updating Enterprise Data Models)
• Oracle database administration:
Managing users and Profiles.
Managing Physical Database Structures (Data files, Tables, Indexes).
Setting Backup and Recovery Policies.
Auditing GDB objects.
Monitoring Geodatabase Performance and Connections.
Performance tuning of Oracle database and ArcSDE services.
• Designing and reviewing new Geodatabase according to GIS Data Model standards.
• Managing procedures for the Geodatabase and data Model updates.
• Supporting and training users to use the new ESRI data Model of Jeddah Municipality.
• Converting data from many formats like Geomedia, Shape files and CAD to ESRI GIS Formats.
• Analyzing user needs and assessment for applications like Crises and Emergency& Municipal Geo-Observation.
• Preparing UML Models for GIS Applications (Crises and Emergency).
• Many tasks of Base Map production and extracting needed data using Spatial Analysis.
• QAQC of delivered data from (Map Production project) using Topology rules and Data Reviewer Extension.
o Reporting and Understanding As-Is System of municipal work.
o Documenting and reporting Interviews and Analyzing Questionnaires.
o Analyzing User needs and Assessments for Municipal daily work.
o Preparing UML Models for Municipal Applications (Shop Permits, Municipal Investments, Approved plans, Building Permits, Parcel grants, Transport Activity, Road Maintenance, Street Naming and Building Numbering, Municipal project management).
o Identifying the GIS themes layers needed for Geodatabase.
o Designing (Conceptual & physical Design) and modeling Enterprise geodatabase for GMRA.
o Entity Relationship Modeling and Functional Specification Documents Preparing.
o GIS System Design for GMRA GIS center.
o Analyzing the five GIS system components for two Municipalities.
o Preparing BOQ for GIS system H.W and S.W.
o Preparing Reports for Geodatabase Modeling and designing.
o Preparing reports for GIS data migration to Enterprise geodatabase and BaseMap production.
o Design user interface for GIS applications.
o Preparing presentations for stakeholders about Work progression and Geodatabase Modeling.
o Onsite technical support for the geographical information system.
o Documenting and reporting GIS applications incidents and problems.
o Supporting and guiding the system end users.
Database Administration.
o Monitoring Database performance.
o Monitoring and controlling SDE Services.
o Monitoring the application server performance.
o Supporting the data replication process.
o Helping in backup and recovery process.
1. ArcGIS I & ArcGIS II. 2. Building Geodatabase. 3. Survey analyst. 4. Multi User Geodatabase (Arcsde workgroup & Enterprise). 5. ArcGIS Server Enterprise Configuration and Tuning for Oracle. 6. Introduction to ArcGIS Server. 7. ArcGIS Server Administration using .net frame work 3.5.
Data modeling (DFD,ERD,UML) Systems analysis and design Computer security fundamentals. Red-Hat Linux 5 operating system. Computer networks & connectivity - Oracle Certified Professional Developer: Oracle Database 10g: SQL Fundamentals I&II. Oracle Database 10g: Program with PL/SQL. Oracle Forms builder 10g: Build Internet Applications. - Oracle Certified Professional Administration: Oracle Database 10g: Administration Workshop I (under linux). Oracle Database 10g: Administration Workshop II (under linux). - Advanced Courses: Oracle 10g: Discoverer Administrator. Managing Oracle under Linux. Oracle Database 10g: Advanced PL/SQL. Oracle Reports Developer 10g: Build Reports. Oracle Database 10g: Develop Applications using HTML.
Planning your own development. Communication skills. Presentation skills. Technical & business writing Working in team Problem solving and decision making Customer services Sales fundamentals Marketing essentials. Feasibility study B. English Language: General English (pre intermediate level from - AMID EAST). Business English (pre intermediate level from - AMID EAST). Technical Report Writing (pre intermediate level from - AMID EAST