Help write and optimize in-application SQL statements
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.
Strong proficiency with MS SQL and its variation among popular databases
4-6 years of 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