Recruitment of Database Administrator (GIS)

Madhya Pradesh Agency for Promotion of Information Technology

Job Description
Designation Database Administrator (GIS)
Department MAPIT
Place Bhopal
Job Code
Job Type Contractual ( 2 Years)

Job Description

Review of Software requirements and prepare a conceptual design for a planned database

Design Database, Define Data types and build essential relationship between different entities of a RDBMS

Write Database Scripts/SQL scripts, Store Procedures and execute the same on desired database

Write Scripts to prepare different Database Views as per requirement

Support Integration of software systems with external software system/third party software

Maintain the data standards adherence to the Databaseand Data security Norms

Install and test new/required versions of the DBMS

Develop, manage and test database back-up and recovery plans

Refine the logical as well as physical design of the Database to meet system software requirements as well as storage requirements

Maintain/keep log of Database and Database Scripts Versions

Administer and maintain different Database as well as Database user activities

Administer and manage database users access and security, Control database access permissions and privileges

Monitor and Optimize Database Performance and manage critical parameters enabling fast responses from Database server to end users

Ensureproper functioning of storage and archiving procedures

Involve in Capacity/Scalability planning ensuring optimum usage of resources towards database architecture

Prepare Data Models, ER Diagrams

Prepare database documentation, including data standards, procedures and definitions for the data dictionary (metadata)

Work closely with project team and regularly coordinate with technical, applications and operational teams to ensure database integrity and security.

Skills:

Good written and verbal communication including documentation skills Good understanding of complete SDLC (Software Development Life Cycle). Good understanding of spatial database, systems and software.

Qualification / Skill and Experience

Profile
Essential Criteria Desirable Skills& Experience
Qualification: B.E./B.Tech in Computer Science/ IT / or equivalent OR MCA/equivalent Experience: Minimum 4 years of experience in database administration preferably on Postgres or PostGIS or SQL Server. Academic 60% or above throughout from Class 10thand onwards Experience of working on Geospatial database will be preferred. Certification in database administration will be preferred. Experience in providing support towards intergration with external software system/third party software/ database will be preferred.


Important Dates



Notification Issued By

  • Organization : Madhya Pradesh Agency for Promotion of Information Technology
  • Organization City, State : bhopal, madhya pradesh
  • Organization Website : http://www.mapit.gov.in
View Jobs

  • Notification
  • General Information
  • Important Dates
  • How To Apply
  • Applications
  • Exam Fees
  • Eligibility
  • Educational Qualifications
  • Age Limits
  • Reservations
  • Posts / Positions / Services
  • Job Vacancies List
  • Examination Centres
  • Plan Of Examination
  • Exam Syllabus
  • Exam Instructions
  • Previous Question Papers
  • Interview Questions
  • Interview Experience
  • Results



Notifications by