Database Administrator GIS

Full–time
Job Description

Designation: Database Administrator (GIS)
Department: MPSeDC
Place: Bhopal
Job Type: Fixed term (upto 2 years). Extendable based on performance
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 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 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:
Essential Criteria:
Qualification:
B.E./B.Tech in (in any stream) / or equivalent or MCA/equivalent
Experience:
• Minimum 8 years of experience in database administration preferably on Postgres or PostGIS or SQL Server or Oracle server.
Desirable Skills & 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.

Found this job inappropriate? Report to us