We are seeking a highly motivated and skilled SQL Developer to build and maintain highly scalable databases. Ideal candidates are developers who "code to live and live to code"; they must be passionate about software development. As an SQL Developer, you will develop MS-SQL queries and procedures. You will also be responsible for designing databases and ensuring their stability, reliability, and performance.
Key responsibilities
- Setup & Maintain the databases at all different environments.
- This person will work with a team of experienced analysts, developers and business resources to build highly-scalable software.
- Discuss and understand the business needs and architect the database according to it without effecting the performance.
Desired Skills and Responsibilities
- Use T-SQL to develop and implement procedures and functions.
- Maintain and back up databases regularly.
- Perform SQL database sharding and indexing procedures as required to handle heavy traffic loads.
- Use database analytical tools to analyze performance and generate reports.
- Analyze existing SQL queries for performance improvements.
- Skilled at optimizing large complicated SQL statements.
- Develop procedures and scripts for data migration.
- 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.
- Proficient understanding of code versioning tools such as Git / SVN.
- Prepare documentations and specifications.
- A high degree of integrity and responsibility is a MUST!
Required Experience
- 4+ year experience in MS SQL Database administration.
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Experience with backups, restores and recovery models.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Knowledge of NOSQL databases like Cosmos, Mongo DB.
- Experience working with Windows server, including Active Directory.
- Ability to organize and plan work independently.
- Ability to work in a rapidly changing environment.
Outlier
WSP in Canada
Kin + Carta Europe
LiveKit
Outlier