JOB DESCRIPTIONS
• 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
REQUIREMENTS
• Strong proficiency with SQL and its variation among popular databases
• Database design and develop
• Data warehousing, data modelling and Microsoft BI tools (SSAS, SSRS, SSIS, MDX), delivering dimensional models and BI applications
• Expertise in at least T-SQL and SQL development using stored procedure, developing and supporting ETL processes using MS SQL Server Integrated Services (SSIS) and Azure Data Factory (Azure tools)
• Experience with SQL Server 2008, 2012, 2016 and ideally 2017.
• 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
• Exposure to the Azure platform would be useful.
• 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
• Proficient understanding of code versioning tools such as VS TFS