SQL Senior Developer
- Company
- Global Retail Company
- Description
Purpose
Responsible for designing databases and ensuring their stability, reliability, and performance.
Tasks and Responsibilities:
- 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
Specialization knowledge / experience:
- Strong proficiency with SQL and its variation among popular databases
- Strong experience with MS SQL versions 2014 upwards
- 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
- Capable of troubleshooting common database issues
- Familiar with tools that can aid with profiling server resource usage and optimizing it
- Proficient understanding of code versioning tools