JobDescription

Designation

Database Administrator(GIS)

Department

MPSeDC

Place

Bhopal

Job Type

Fixed term(upto2years).Extendable based on performance

JobDescription

- 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/SQLscripts,Store Procedures and execute the same on desired database.
- Write Scripts to repare 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 Database and 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.




- Ensure proper functioning of storage andar hiving procedures.
- Involve inCapacity/Scalability planning ensuring optimum usage of resources towards database architecture.
- Prepare Data Models,ERDiagrams.
- 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.
- Positive understanding of complete SDLC(Software Development Life Cycle).
- Valuable understanding of spatial database,systems and software.

Qualification,Skilland Experience:

Profile

Essential Criteria

Qualification:

B.E./B.Techin(in any stream)

or

PG Degree in IT/ CS or Equivalent

Experience:

- Minimum 4 years of experience in database administration preferably on Postgres or PostGIS.

DesirableSkills& Experience

- Experience of working on Geospatial database will be preferred.
- Certification in database administration will be preferred.
- Experience in providing support towards integration with external software system/third party software/ database will be preferred.

📌 Database Administrator-GIS (Bhopal)
🏢 M P STATE ELECTRONICS DEVELOPMENT CORPORATION
📍 Bhopal