Education
-
1999 - 2002
University of Tehran
Master of Urban Development, City/Urban, Community and Regional Planning
Grade: 16.73 of 20
-
1992 - 1996
Azad University-South Tehran
Bachelor of Science (BS) on Surveying Engineering, Civil Engineering
Grade: 14.69 of 20
Experience
-
2022 - Present
Department of Transport and Planning
ePlan Specialist Project Officer
-
2016 - 2022
Department of Transport and Planning
System Engineer / Oracle DBA
– Provided BAU and engineering tasks as an Oracle/PostgreSQL DBA such as capacity & storage management, backup/recovery, performance tuning, security, high availability.
– Designed, developed, and implemented cadastral/GIS on Oracle11g/12c spatial database. (on premise & AWS cloud)
– Developed and maintained PostgreSQL 9.6.4 database.
– Migrated Oracle spatial to PostgreSQL/PostGIS
– Installed and configured Geoserver open source.
– Designed, developed, and implemented GIS layers as well as map styles
– Achieved solid experiences on XPATH, XQUERY, XML, XSD, JSON and HTML.
– Developed PL/SQL program units to transform coordinate systems and spatial bulk insert.
– Created subdivision plans and back-captured maps using LISCAD and AutoCAD Civil 3D.
– Created ePlan projects using LISCAD & Stringer ePlan utilities.
– Documented ePlan data storage on Oracle.
– Tested GIS/spatial web applications/database using HP ALM tool
– Provided technical support for surveying firms via phone /email
– Mentored, helped, and trained surveyors using face-to-face training sessions or preparing instructions -
2017 - Present
Swinburne University of Technology
Sessional Lecturer/Tutor
* Lectured GIS (Geographic Information Science) subject
* Tutored GIS lab using ArcGIS online and Australian local GIS tool about land & titling systems
* Designed and planned training contents and workshops
* Prepared training course material and tutorial for students - 2020 - 2022
-
2017 - 2018
University of Melbourne
Oracle/PostgreSQL Specialist
– Developed and maintained PostgreSQL 9.6.4 database
– Migrated Oracle spatial to PostgreSQL/PostGIS on 2D/3D Digital Cadastre
– Improved performance for bulk inserts on PostgreSQL
– Analysed database to find existing issues and provided solutions
– Prepared technical report as well as instruction manual -
2015 - 2016
Optus
Technical Support Consultant
– Provided technical support, raised and resolved issues on Comptel Fulfilment{LRM(OM,ASI),Project tracking(PT), Buos} to other teams at Optus
– Developed, modified and traced PL/SQL program units on Oracle11g database
– Wrote and tuned SQL ad-hoc queries on Oracle11g using Oracle TOAD
– Designed and implemented telecomm data networks including DSLAM, EOC, EOUEF, VPLS and VLAN
– Modified unix shell scripts on Linux using Perl
– Provided solution for character set issue between SQL Server 2008 & Oracle 11g
– Monitored DSLAMs with Huawei U2000 NMS
– Liaised with implementation and customer care teams to investigate and resolve standard and non-standard issues
– Implemented configuration on Comptel Fulfilment to configure Cisco internet routers automatically -
2015 - 2016
Freelancer
Oracle Instructor
Instructing Oracle Database Administration (version 6 to 12c) and associated tools and technologies including Data Warehouse, Security, Grid Infrastructure & RAC, Data Guard, Avanced Replication & Streams, Spatial, Application Server & WebLogic, Developer, Designer, Discoverer and Fusion Middleware.
-
2015 - 2015
City of Whittlesea
Computer Trainer
Teaching Computer Courses including Operating Systems, Network, Security and Troubleshooting
-
2015 - 2015
Rinnai Australia
Senior Oracle Consultant
– Provided plan and solution to upgrade Oracle database, Oracle Warehouse Builder,Oracle BI and Oracle JDE.
– Implemented test plan for whole upgrade project.
– Installed and upgraded Oracle database 11.1.0.7 to 11.2.0.4 on RHEL 5.11
– Installed and configured Oracle Warehouse Builder 11.2.0.4 including latest bundle patch.
– Upgraded OWB repository 11.1.0.7 to 11.2.0.4
– Provided solution to deploy mappings on OWB
– Configured network and connection settings on Oracle JDE E1 9.1
– Provided support to solve technical problems -
2006 - 2014
PBF Co.
Senior Oracle Specialist / Consultant / Data Architect
PBF is an enterprise Oracle services and solution provider with core competencies in consulting, managed services, development, education, database support and maintenance.
Working area in PBF is extensive and it services to diverse industries and organizations such as banking, financial, automotive, health insurance, auto parts suppliers, telecommunication, mobile, transportation, navigation, production, education, utilities,and other corporate. -
2002 - 2006
DPA Co.
Senior Oracle DBA / Developer
Data Processors Age(DPA) is an Oracle services provider and training center with core competencies in education, development, consulting, database support and maintenance.
The most important mission in DPA is training Oracle specialists.
DPA has been provided training, consultancy and support for enterprise organizations such as utilities(gas, electricity, water&sewage) , universities, telecommunications, airlines, retails, insurance and banks. -
2001 - 2002
Golestan Co.
Senior Spatial Database Administrator / GIS Project Manager
Golestan Software Engineering Co.(GOLSOFT) is a private software & EA services provider with strong background in GIS projects.
-
1995 - 2001
Cadastre
Cadastre Officer / Surveyor / GIS Developer / Oracle DBA
Cadastre is a governmental organization who is responsible for providing cadastral map and functional application software for using maps in country.
Cadastre uses GIS and GPS technologies with associated fundamental softwares for developing GIS applications and other applications for mechanization of State Organization for Registration of Deeds and Properties.