Database Admin

Digital India Corporation

Digital India Corporation is focused on promoting the use of technology for the benefit of citizens. As part of the Government of India’s Digital India programme, the organisation leads various ICT projects across sectors such as e-Governance, e-Health, e-Agriculture, and more. The organisation is committed to empowering citizens and ensuring security in India’s cashless economy.

Position Details

Job Title: Database Admin
Number of Positions: 01
Job Type: Contract/Consolidated basis
Project: NHAI Datalake3.0
Last Date to Apply: 30th October 2024

Roles and Responsibilities

Design and Implementation: Create and manage database objects (tables, views, indexes) using Redis and PostgreSQL. Ensure data integrity and implement database triggers.
Advanced PL/SQL Programming: Use Redis or PostgreSQL for complex PL/SQL programming (records, collections, dynamic SQL). Write optimized code that meets business needs.
Performance Tuning: Optimize PostgreSQL RDBMS performance using tools like explain plan. Identify and resolve bottlenecks for better responsiveness.
Collaboration: Work closely with the web development team to ensure smooth integration between frontend and backend systems.
Quality Control: Conduct source code quality checks, ensure database-related code aligns with organisational standards and policies.
Database Management: Manage databases using AWS RDS and PostgreSQL, ensuring security, consistency, and policy adherence.