Interested IN this Job?
Yes NoDatabase (DB2/PostgreSQL/MySQL/MongoDB/MSSQL) Administration: L2
Essential: BE / MCA / B. IT / Graduate
Minimum: 4+ years’ Experience
Key Skills:
- IBM DB2 Database, PostgreSQL, MySQL, MongoDB, MSSQL Administration
- Health Check of database
- Highlight discrepancy in database threshold
- Monitor and resolve tickets as per SLA
- Daily Handover
- Performance monitoring and tuning
- Backup verification of all projects
- Tablespace health check and reports
- Manual check for all file systems related to databases
- Replication Monitoring
- Monthly Restoration Activity
- Quarterly Billing Activity
- Hardening of databases
- Providing data for audit
- Basic shell scripting for automation
- Reorg and run stats on all projects
- Tablespace monitoring and container spreading
- Restoration of backup images on Test environment
- Troubleshooting and L2 level support
- Database Performance Tuning and Optimization
- Backup and Recovery Strategies
- Database Security and Access Control
- High Availability and Disaster Recovery
- SQL Query Optimization
- Capacity Planning and Resource Management
- Shell Scripting (Bash, PowerShell)
- Monitoring and Alerting Tools (e.g., I, DB2 Performance Monitor)
- Project Planning and Management
- Budgeting and Cost Control
- Risk Management and Mitigation
- DR readiness and drills.
- VAPT, CIS Hardening, Patches management
- High availability, Sync and Async logs-based replication, etc.
Responsibility –
1. Monitor the database buffer cache, hit ratio, CPU utilization, and memory utilization.
2. Identify bad performing queries and give it to the Application team for tuning.
3. Responsible for routine database maintenance tasks such as index rebuilds, statistics updates, and table reorganizations to improve performance
4. capacity planning and resource forecasting to support future growth and scalability needs.
5. Responsible to achieve maximum uptime for production Database server and reduce unplanned downtime.
6. Monitoring the database for capacity availability w.r.t. Disk capacity, tablespace capacity etc.
7. Implementation of service packs and hot fixes for security and performance improvement.
8. Performance monitoring and tuning
9. Hardening of databases
10.DB object creation/modification/deletion/updating and Data Sync
11.Review SRs and Incidents
12.Review of database activities done on daily basis
13.Review reports for backups/health/resources
14.Improvement plan for performance
15.Performance analysis and reporting
16.Preparing and review SOPs for all activities
17.Patch Management
18.DR shifting activity
19.SLA Compliance
20.Replication Setup and Configuration
Salary : Upto 7.5 LPA