Sql DBA
On-siteBentonville, Arkansas, United States
Bentonville, Arkansas, United StatesOn-siteContract
Contract
Job Summary
Manage SQL Server migrations from on-premise to Azure IaaS/PaaS or configure on-premise VMs via Managed Services. Execute database backups, recovery, and failover procedures using AlwaysOn Availability Groups and Distributed Availability Groups. Migrate SQL Logins, jobs, Integration Services, and Full Text Indexes while verifying dependencies. Coordinate with application owners to outline migration steps, pros, and cons, then decommission old servers after pointing connections to new destinations.
Required Qualifications
- 3 to 5 years experience with Microsoft SQL Server RDBMS platform
- Knowledge of structured query language (SQL); i.e. Transact-SQL
- Knowledge of SQL Server Installation and upgrades (in-place vs side-by-side upgrades)
- General knowledge of the Azure portal
- Ability to navigate the portal effectively
- Knowledge on PowerShell and how to use SQL Server and Azure modules
- General understanding of the Windows operating system
- In-depth Knowledge about SQL High Availability features like mirroring, AlwaysOn, Distributed Availability Groups (DAG)
- Understanding of database backups, recovery, and handling failover of a database
- General understanding of routine database maintenance
- General understanding of distributed computing i.e. Client–server model
- Ability to effectively communicate with application owner for obtaining information driving migration success
- Identifying SQL Server 2008/R2 from SQL DBA Inventory and obtaining the owner information
- Communicate w/ App team owners including necessary detail on migrations outlining steps and pros/cons for using a new version of SQL Server
Desired Qualifications
- The first / preferred option is to migrate to Azure Cloud
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.