- Data & Reporting
- Fulfilment of data and reporting requests as per approved formats.
- Executing reviewed and approved SQL queries/updates.
- Generating data extracts for business or application teams.
- Incident Response & Operational Support
- Responding to and resolving database-related incidents within SLA.
- Investigating job failures, blocked processes, and alert-driven issues.
- Coordinating with Storage/Infrastructure teams if I/O thresholds are breached.
- Providing fixes for database issues escalated from L1 teams.
- Release & Deployment Support
- Supporting application releases as a DB partner.
- Applying vendor/internal DB scripts during releases.
- Performing post-release validation.
- Supporting deployments, object changes, schema modifications, and data migrations.
- Remote Troubleshooting & Performance Support
- Troubleshooting:
- Database errors
- SQL connectivity issues
- Performance bottlenecks
- Conducting basic performance tuning.
- Optimizing SQL queries for better performance.
- Routine Database Operations
- Backup & restore execution as per approved policies.
- User, role, and permission management.
- Monitoring and maintaining database health using tools like:
- Dynatrace
- OEM / custom monitoring
- Alerting dashboards
- Managing scheduled jobs and validating outcomes.
- Documentation & Governance
- Maintaining:
- Runbooks
- SOPs
- Operational guides
- Knowledge Based articles
- Updating documentation after releases or incident learnings.
Database,MSSQL,runbooks,Sql queries
