Requirements:
- Strong proficiency with SQL and its variation among popular databases preferably SQL server
- Experience with some of the modern relational databases
- Skilled at optimizing large complicated SQL statements
- Strong skills in writing SQL server stored procedures
- Hands on experience in SSIS or any other ETL tools
- Knowledge of best practices when dealing with relational databases
- Capable of troubleshooting common database issues
- Familiar with tools that can aid with profiling server resource usage and optimizing it
- Help write and optimize in-application SQL server stored procedures
Good to have:
- Troubleshoot, test and maintain the core product software and database to ensure strong optimization and functionality
- 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