We will rely on you to:
- install and implement ms sql server on virtual machines.
- experience with migration of databases from on-premise to cloud-based destination servers.
- migrate sql databases and related objects (ie. Sql logins, database users, sql agent jobs and configure dr log shipping solutions).
- experience in implementing database backups (full, differential, and transaction log backups).
- execute the planned migrations following and adhering to documented runbooks which will be created and maintained for each server that is migrated.
- provide timely feedback between the project manager and dba team to ensure on-time high-quality builds.
- follow ams best practices and automation processes for performing sql installations and custom audit procedures.
- provide ongoing post-build support (hypercare support), identifying and fixing problems as they arise post-migration.
What you need to have:
- 5+ years of database experience or other related computer science experience
- bachelor's degree preferred or equivalent work experience.
- sound knowledge of microsoft sql server ( managed sql 2014 and higher versions)
- familiar with some cloud computing environments (ie. Aws or azure).
What makes you stand out?
- experience in microsoft sql database and azure arm template creation.