Steer and own overall product database. Ensure the adherence to database engineering best practices across entire database environment; develop and implement needed checks and processes.
Understand big picture and client needs by engaging with Product owners and build right database designs.
Support development organization from all aspects associated with database.
Build designs that satisfy both functional and non-functional needs of the product and client needs.
Lead client data base upgrade & migration activities
Keep / Optimize database for operational and performance efficiency. Identify any existing deficiencies and rectify.
Database management, Maintenance and Troubleshooting activities.
Handle deadlock, performance and other complex issues.
Improve overall team s knowledge and skills.
Recommended Skills :
Engage in client upgrade projects and drive requirements.
Plan and drive migration/upgrade projects
Troubleshoot and perform RCA on incidents
Optimize database platforms
Perform health checks and right size environments
Carry performance tuning activities
Drive database automation
Hands on with writing Queries
Read execution plans - infer and advise changes based on the plans
Index monitoring/maintenance
Query Statistics monitoring/maintenance
Use Database Engine Tuning Advisor
Read through the Query Store reports, advise/suggest based on the observations
Use of Extended Event - logging, understand the reports and work/suggest on next steps