05

DatabaseDeveloper(PostGRESPOSTGIS)

B.E. /B.Techor PG inIT/CSorequivalent

3

6

1. Must haveexperience ofworking inatleast 1major e-Governanceproject.

2. Minimum 4years ofexperience indevelopmentof PostGISprogrammingor usingpostgres.

3. Workexperiencemust spanover2turnkeyprojects as aDBD

1. Workingexperience forgovernmentclients would beaddedadvantage

2. Knowledge ofBusinessintelligencetools

3. Experience ofquerying / dataretrieving usingmultipledatabasetype

4. Exposure todatabaseadministrationlobs

5. Schedulingtasks,jobs,datamigration

1. Design, deploy & maintain datatablestructures,storedprocedures,reports,andqueriesoptimization.

2. Database configuration, migration& performance monitoring as well asbackup&datarecovery.

3. Writing efficient stored procedurefor other developers working on theBusinessAccessLayer/Service

Layer

4. Configuration and Designing ofReportingServicesReports.

5. Conduct research and makerecommendations on databaseproducts, services, protocols, andstandards

insupportofprocurementanddevelopmentefforts.

6. Coordinate and work with othertechnical staff to develop relationaldatabases and secondary databasesidentify inefficiencies in currentdatabasesandinvestigatesolutions.

7. Develop, implement, and maintainchange control and testing processesformodificationsto databases.

8. Ensurealldatabasesystemsmeetbusiness and performancerequirements.

9. Diagnoseandresolvedatabaseaccessandperformanceissues.

10.  Plan and coordinate datamigrationsbetweensystems.

11.  Develop, implement, andmaintainchangecontrolandtestingprocesses for modifications todatabases. Ensure all databasesystems meet business andperformancerequirements.

12.  Produce ad-hoc queries anddevelopreportstosupportbusinessneeds.

13.  Creation and maintenance oftechnicaldocumentation.

DevelopmentandmaintenanceofDatawarehouse.

14.  implementation of datadashboardstodisplaydatainvariousformats.

15.  Writing PostGres Jobs inPostGres-PostGIS

16.  WritingPostGresJobs