Junior Database Administrator

Job Title: Jr. DBA
Location: Delhi (Field)
Shift: General Shift
¢ Experience Required: 2 to 5 Years
¢ Educational Qualification: BE/ B. TECH/BCA/BSC-IT
Roles:

1. Database Monitoring
   ¢
   ¢
   ¢
   ¢
   Monitor database availability and performance.
   Check database health using monitoring tools.
   Track CPU, memory, disk space, and database utilization.
   Identify and escalate alerts and incidents.
2. User Management
   ¢
   ¢
   ¢
   Create, modify, and delete database users.
   Reset passwords and manage access permissions.
   Implement role-based security policies.
3. Backup Monitoring
   ¢
   ¢
   ¢
   Monitor scheduled database backups.
   Verify backup completion and report failures.
   Escalate backup-related issues to higher-level DBAs.
4. Incident Management
   ¢
   ¢
   ¢
   Respond to database alerts and tickets.
   Perform initial troubleshooting.
   Escalate complex issues to L2/L3 DBAs.
5. Database Maintenance Support
   ¢
   ¢
   ¢
   Assist with database patching activities.
   Monitor maintenance jobs and scheduled tasks.
   Validate database services after maintenance.
6. Documentation
   ¢
   ¢
   ¢
   Update operational procedures and runbooks.
   Record incident resolutions and troubleshooting steps.
   Maintain inventory of database servers and instances.
7. Service Request Fulfillment
   ¢
   Handle user requests related to:
   o User creation
   o Access permissions
   o Database connectivity
   o Password resets
8. Batch Job Monitoring
   ¢
   ¢
   Monitor ETL, replication, and scheduled database jobs.
   Restart failed jobs as per standard operating procedures.

Skills:
¢ Knowledge of at least one database platform:
o Oracle Database
o Microsoft SQL Server
o MySQL / PostgreSQL
o MongoDB (basic)
¢ SQL Knowledge
o Basic SQL queries
o SELECT, INSERT, UPDATE, DELETE
o Joins
o Views
o Index basics