Database Developer-Post Gres,Post GIS

Job Description

1. Must haveexperience ofworking inatleast 1major e-Governanceproject.2. Minimum 4years ofexperience indevelopmentof PostGISprogrammingor usingpostgres.3. Workexperiencemust spanover 2 turnkeyprojects as aDBD1. Workingexperience forgovernmentclients would beadded advantage2. Knowledge ofBusinessintelligence tools3. Experience ofquerying / dataretrieving usingmultipledatabase type4. Exposure todatabaseadministrationlobs5. Schedulingtasks, jobs, datamigration1. Design, deploy && maintain datatable structures, stored procedures,reports, and queries optimization.2. Database configuration, migration&& performance monitoring as well asbackup && data recovery.3. Writing efficient stored procedurefor other developers working on theBusiness Access Layer / ServiceLayer4. Configuration and Designing ofReporting Services Reports.5. Conduct research and makerecommendations on databaseproducts, services, protocols, andstandardsin support of procurement anddevelopment efforts.6. Coordinate and work with othertechnical staff to develop relationaldatabases and secondary databasesidentify inefficiencies in currentdatabases and investigate solutions.7. Develop, implement, and maintainchange control and testing processesfor modifications to databases.8. Ensure all database systems meetbusiness and performancerequirements.9. Diagnose and resolve databaseaccess and performance issues.10. Plan and coordinate datamigrations between systems.11. Develop, implement, andmaintain change control and testingprocesses for modifications todatabases. Ensure all databasesystems meet business andperformance requirements.12. Produce ad-hoc queries anddevelop reports to support businessneeds.13. Creation and maintenance oftechnical documentation.Page 56 of 60Development and maintenance ofData warehouse.14. implementation of datadashboards to display data in variousformats.15. Writing PostGres Jobs inPostGres-PostGIS16. Writing PostGres Jobs

Keyskills :
geoserverpostgisdatabase developmentmysqlpostgresdatabase developerdatabase developer-gis