Redolent, Inc

Sql DBA

Redolent, Inc  •  Bentonville, AR / Reston, VA (Onsite)  •  3 hours ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

Job Description

We have following urgent role with our  DIRECT client

Title:  Sql DBA
Location: Bentonville , AR

Duration: 6+ Months

Rate: Market
Microsoft SQL Server DBA 

Required:
  • 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 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.
  • 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. AlwaysOn 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.
 
Redolent, Inc

About Redolent, Inc

Redolent, Inc is a leading engineering and software solution company focusing on enterprise solutions enabling its customers to realize best value on its investments.

We provide world-class solutions in Talent Management, Managed workforce, Automation Engineering, Digital and Cloud transformation, Managed Infrastructure, Google Cloud and more.

Our customized solutions of Onshore, offshore and hybrid model for Talent management and engineering solutions can fit need and budget of any client.

We are "Team Redolent", "Reaching Beyond" excellence and accelerating business transformation.

Industry
IT & Software
Company Size
11-50 employees
Headquarters
Fremont, California
Year Founded
2008
Website
redolentech.com
Social Media