Responsibilities
- Write and optimize in-application SQL statements, Procedures, Views Etc.
- Ensure performance, security, and availability of databases.
- Prepare documentations and specifications.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Profile server resource usage and optimize and tweak as necessary.
- Collaborate with other team members and stakeholders.
- Prepare & optimize SSIS package & schedule them.
- Prepare SSRS reports.
- Work on SSAS
- Critical Success factors:
- Strong proficiency with SQL and its variation among popular databases
- Experience with some of the modern relational databases
- Skilled at optimizing large, complicated SQL statements.
- Knowledge of best practices when dealing with relational databases
- Capable of configuring popular database engines and orchestrating clusters as necessary
- Ability to plan resource requirements from high level specifications.
- Capable of troubleshooting common database issues
- Familiar with tools that can aid with profiling server resource usage and optimizing it
Agile principles.
Scrum practices.
Well versed with Scrum ceremonies (like Sprint planning, Daily Scrum, Backlog refinement, Sprint Review and Sprint retrospective).
Having worked on projects in Scrum is an advantage.