Database Administrator

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.

Thanks & Regards ,

Janhavi Gupta

9322332576

janhavi.gupta@cbtinfotech.com