Sql DBA

We have following urgent role with our DIRECT client

Duration: 6+ Months

Rate:
Market Microsoft SQL Server DBA

• 3 to 5 years experience with Microsoft SQL Server RDBMS platform – SQL Versions: 2008R2, 2012, 2014, 2016, 2017 migrations.
• 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 Power Shell 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, Always On, 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.
• The first / preferred option is to migrate to Azure Cloud. We'll request app team for Sherpa consultation using this link to determine a roadmap for Azure IaaS/PaaS.
• If app team can't proceed with Cloud deployments, they will need the Sherpa team to approve that decision.
• If Cloud is supported/approved, DBA team will assist on deploying SQL Servers (IaaS) via Managed Services.
• If direction is approved for on-premise, app team will coordinate with Windows team on getting VMs and DBA team will install/configure SQL Server on on-premise VMs.
• After SQL Database engine is installed, the databases will need to be migrated to the (new) destination servers.
• For Point-In-Time data, mirroring will need to be setup and 'failed over' during the switch.
• For 2 or more node clusters, database(s) will be added to the Availability Group (i.e. Always On Availability Group). For Azure Production servers, we will configure Distributed Availability Groups (DAG) for Disaster Recovery.
• SQL Logins, Jobs will be migrated as well.
• Verify and migrate other services were used i.e. Integration Services, Full Text Indexes (if necessary)
• Also, verify and other dependencies that need to be moved / re-created on the destination server.
• Ensure connections have been pointed to the new server and rename databases on the old server.
• Decommission the old servers.