Hiring - Database Administrator (DBA) - Remote US

However, another opportunity that dropped is wide open with zero candidates. It’s a Senior DBA Opportunity. They need a Database Administrator who administrates Tableau Server and the Azure cloud. We need an experienced DBA SR that can work independently. This DBA needs to be experienced with Data Marts performance tuning and data flow. This DBA also must have experience with Tableau Server, upgrades, troubleshooting and project work. Azure DevOps is required. On Prem SQL Server upgrades, patching, maintenance, Azure DBs is required. 

1st Job Role: Data Governance Specialist 

12-month contract

Job Type: W2 Contract

Great communication 

100% Remote

 Top Skills' Details

What are the top three required technical skills for this role?

We need an experienced DBA SR that can work independently. This DBA needs to be experienced with Business Intelligence Data Marts performance tuning and data flow. This DBA also must have experience with Tableau Server, upgrades, troubleshooting and project work. Azure DevOps is required. On Prem SQL Server upgrades, patching, maintenance, Azure DBs . . .

Job Description

The Development, Data and Analytics Team provides the development platforms and the enterprise data in our Data Warehouses. We are focused on the successful adoption of Business Intelligence tools throughout the county. The officially supported BI tools are: SQL Server Reporting Services (SSRS), Tableau, and Power BI. We have On-Prem servers as well as databases in the Azure Cloud and in Snowflake.

This BI DBA SR will be assigned production support and new projects.

Scope of Work: This BI DBA Sr contractor position provides analysis, design, development, installation, maintenance and troubleshooting for our BI databases and servers (On-Prem, Azure Cloud, and Snowflake). This position also must be able to do Tableau Server Admin and PBIRS Server Admin. This will be a mix of production support work, standard maintenance, as well as small to large projects.

Required Skills and Abilities: 

● Seven (7) years of IT DBA experience.

● This position must pass a criminal history records check.

● Azure Cloud experience (Azure SQL Managed Instance, Azure Synapse, Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure DevOps, Azure Boards, Azure Blob Storage, etc)

● Snowflake on Azure Commercial experience preferred

The skills:

* Advanced experience with Azure, Azure DevOps, Azure Data Lake, Azure Blob Storage, and Azure SQL Server

* Advanced experience doing DBA work both On-Prem and Azure Cloud

* Advanced experience in data warehousing design, BI concepts and best practices

* Advanced experience working with developers to build ETLs for loading data for reporting

* Advanced experience in Tableau server administration, upgrades, and support

* Advanced experience in PBIRS server administration, upgrades, and support

The work:

* Develop large-scale databases and data warehousing

* Perform database architecture and develop technical standards for large-scale databases for our data warehouse (SQL Server and Azure) on countywide or multi-department platforms.

* Troubleshoot problems and provide technical assistance to developers and database users.

* Provide project management and work with other departments or outside agencies to integrate data from multiple database platforms and data providers.

* Formulate scope and objectives for database projects; define outcomes; develop and recommend solutions; problem solve and build consensus with management, customers, and vendors to negotiate project priorities and outcomes.

* Maintain integrity and security of databases; coordinate and perform database software installations, upgrades, and patches.

* Design, implement, and schedule physical and logical database backups; plan and perform database restoration and recovery.

* Develop database scripts and triggers; migrate data between database environments (development, testing, and production).

* Monitor, adjust, and optimize space utilization and database performance.

* Act as an expert in database architecture and technical standards for large-scale databases and data warehousing

Experience that provides a plus:

* Snowflake experience

* Power BI experience

Additional Skills & Qualifications

Notes from Manager:

• What project is this for? Production support and all BI projects.

• Is this backfilling anyone or a net new position? Yes backfill

• What are the top three required technical skills for this role? We need an experienced DBA SR that can work independently. This DBA needs to be experienced with Business Intelligence Data Marts performance tuning and data flow. This DBA also must have experience with Tableau Server, upgrades, troubleshooting and project work. Azure DevOps is required. On Prem SQL Server upgrades, patching, maintenance, Azure DBs . . .

• How much Administration vs Development would this person be doing? This is a DBA so not a development position. Does need coding skills as it relates to DBA work.

• Would they be installing/standing up any new environments or mainly supporting existing ones? Yes both

• Would this person be responsible for setting up all of the security for each Software? Yes

• Would this person be responsible for any Dashboard Development? No

What are they doing day to day with SQL? DBA work

Why is advanced experience with Azure, Azure DevOps, Azure Data Lake, and Azure SQL Server important? AND are all of these skills within azure required or just azure devops? Azure DevOps required. DBA work associated with Azure DBs required.

What scripting language will this person being using daily and what are they scripting for? Powershell

Will this candidate actually be building ETLs for loading data for reporting? No this is a Database Administrator not a developer position.

Opportunity #2

Job Role: Senior SQL Server DBA With GCP Migration Experience

Duration:  12-18 Months to start likely at least 2 years of work

Location: 100% Remote 

Job Type: W2 Contract 

Interview process: 1 Step

Start Date: ASAP

Duties:

2 X DBAs supporting Microsoft SQL server migrations to GCP / Managed SQL