Database Administrator

Job Title: Database Administrator (DBA)
Department: CACOSA / DoS
Experience: 1 to 3 Years

Job Summary:
The Database Administrator is responsible for managing Oracle-based databases across Production, Test, and Training environments. The role includes performance monitoring, data extraction, backup and recovery, database tuning, user access management, and regular integration of international codification data into the NCORE-NG system.

Key Responsibilities:

1. Database Maintenance & Administration:

• Manage Oracle DBMS on Production, Test, and Training servers.
• Perform schema updates, tablespace management, index rebuilding, patch implementation, and backup management.
• Regularly apply patches and updates from Oracle.

2. Backup & Disaster Recovery:

• Execute daily, weekly, and monthly backups of application and database servers both locally (DoS) and remotely (NIC Cloud).
• Ensure quick restoration of services during crashes or failures.

3. Performance Monitoring & Tuning:

• Monitor database health, TEMP/UNDO spaces, and disk usage.
• Tune database configurations and rebuild indexes for performance optimization.
• Generate Oracle stats, trace slow queries, and identify performance bottlenecks.

4. Data Analytics & Reporting:

• Design SQL queries for custom reports, data mining, and analytics as per user requests.
• Perform data refining to identify and rectify data gaps or quality issues.
• Handle bulk data updation in the production database using optimized SQL scripts.

5. Import & Integration of International Data:

• Import and manage global codification datasets like KHN, H4, NMCRL, H2/H6, MRD, FIIGS, and IIGXML into NCORE-NG across all environments.
• Ensure weekly, biannual, and annual global data updates as received from NATO/NSPA.

6. User Access & Permission Management:

• Create, update, and revoke internal database user roles (system, SAP, ncore72p, report, etc.).
• Manage data migration between systems during version upgrades.
• Clean obsolete logs and data to enhance DB performance.

7. Documentation & Compliance:

• Maintain up-to-date documentation of IPs, DB versions, application versions, user credentials, and password expiry.
• Ensure compliance with security protocols and conduct quarterly audits of user accounts.

8. User Management & Grid Card Support:

• Manage over 400 user IDs across India for accessing NCORE-NG.
• Handle creation, role mapping, reset/block/unblock of user credentials.
• Implement two-factor authentication using grid cards and resolve user access issues.

9. Issue Resolution & Support:

• Address login problems, module access errors, and system deadlocks.
• Liaise with users and teams to resolve database-level application issues promptly.

Qualification:

1. Education-: Graduate BE/B.Tech in IT/Computer Science and Postgraduate - MCA/MTech with specialization in computers /electronics /IT or M.Sc.in CS/IT

2. Certificate-: Oracle Database Oracle OCA

Job Type: Contractual / Temporary
Contract length: 12 months

Pay: ₹20,000.00 - ₹25,000.00 per month

Benefits:

• Provident Fund

Work Location: In person