Senior SQL Database Administrator - project migration to Cloud- 74228
S.i. Systems
Toronto, ON-
Number of positions available : 1
- Salary To be discussed
-
Contract job
- Published on April 16th, 2024
-
Starting date : 1 position to fill as soon as possible
Description
Job Description:
• Proactive Performance and Capacity review
• Serve as SME (subject matter expert) for Microsoft SQL Server and Azure
• Perform database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always-On.
• Accountable for day-to-day activities regarding the upkeep and availability of all Prod-Non Prod database servers
• SQL code-review for the application teams to enforce SQL coding standards and tune
• Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.
• Assist in the technical analysis and design for current and future projects.
• Migrate the database from On-Prem to Azure
Must Have Requirement:
- 5+ Years' of SQL experience including T-SQL
- 3+ years' of Azure database experience *Azure is priority although willing to consider other cloud experience
- Experience with large database and heavy transactions
- Knowledge of API
Nice to Have:
- Banking experience is a strong nice to have
- KeyVault experience would be great
- CDC experience also nice to have
Requirements
undetermined
undetermined
undetermined
undetermined
Other S.i. Systems's offers that may interest you